Transcript View our PowerPoint here!

Lou Lou’s Ice Cream
Jordyn Gabriele
Alexis Smith
Mike Flynn
Stephan Ross
Brian Wong
Overview

Lou Lou’s History

Old Work Order System

Problems

Proposed New System

Database Trial

Backup Strategy

Conclusion
Lou Lou’s History

Local Liverpool business

Family owned


Serves a variety of soft and hard ice cream
Opened in 2008 and closed in February 2011
Old Work Order System

Paper System

All orders written out by hand

One copy for customer, one copy for records

Inventory sheets created weekly

No customer information recorded
Problems
1.
Unorganized
2.
No customer records
3.
Lost receipts
4.
Length of time handwriting orders
5.
Difficult to access old records
6.
Constantly run out of popular products
7.
Over scheduling of staff
Proposed New Work Order System

Keeps track of customer information

Allows for feedback on most popular items

Provides an easy way to access information

Allocates staff appropriately
Here’s Our Database!
Backup Strategy

The database is backed up each week on a cloud drive

Data is also saved and stored in an excel file
Conclusion

Able to serve customers faster

Cut down on unnecessary expenses

Access information for


Most popular products

Customers

Employees
Innovative ideas
Questions