This database is being built for “Slim’s Bagels and Bialys”.The bagel shop is a privately owned company that makes its own bagels and pastries. Benjamin Izrailov is our business expert, providing first hand information from working at the Bagel shop.There is currently no system in place for logging goods inventory in/out by batch and specifically to the batch maker. The bagel shop knows how many bagels and pastries are being made and how many are sold when the store closes,but there is no cataloging of what happens to the bagels throughout the day from when they are made or if resources are wasted. The main issue afflicting Slim's Bagels and Bialys is the products wasted by employees, that can reduce revenues. Our database is designed to provide a solution to that by:
- Creating a system to analyze spoilage and wasted products.
- Provide information on utilization of products and the revenue generated
- Identify employees' performance and the extent of work they can provide