You work for an engineering consulting company and a convenience store chain, which has approximately 100 stores in the surrounding area, has come to you with 2 problems they would like you and your team to solve. As a service to their customers, this convenience store chain produces hot and ready items for purchase (i.e. Bacon Egg and Cheese Biscuits, Chicken Sandwiches, etc.). Each item that is produced can only sit in the heat racks for a specific amount of time before they spoil and must be thrown away. Recently, the convenience store feels like they have been wasting an excessive amount of food. They would like to minimize the amount of waste they dispose of while at the same time, ensuring that there is always items on hand for purchase. In addition, the convenience store feels like their scheduling of when to cook items is wasteful because the worker(s) are constantly having to be interrupted to cook new items. Thus, the convenience store would like a new schedule created for their employee(s) to follow that minimizes the amount of time the employees spend in the kitchen cooking items but at the same time ensuring that they meet the requirement that there are always items stocked to be sold.

The following are the data that received from the stores.

demand table

Thank you..

Store 1 1 1 1 item_id itemdescription 20140120_Total 0 2 3 4 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 160 139721 SEC BISCUIT 24 NULL NULL NULL NULL NULL 3 2 3 6 9 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 160 139722 BEC BISCUIT 31 NULL NULL NULL NULL 2 3 8 8 5 3 1 NULL NULL O NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 160 139723 SAUSAGE BISCUIT 17 NULL NULL NULL NULL 1 NULL 4 4 3 4 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 160 139725 BREAKFAST BURRITO 41 NULL NULL NULL NULL NULL 7 6 14 7 5 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 160 139726 HASHBROWN 7 NULL NULL NULL NULL NULL NULL 3 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 160 139727 PRETZEL CINN SUGAR 6 NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL NULL NULL 1 NULL 1 1 2 NULL NULL NULL NULL NULL NULL NULL NULL 160 139728 PRETZEL SALT 19 NULL NULL NULL NULL NULL NULL NULL NULL NULL 2 2 3 1 4 1 2 1 NULL NULL NULL NULL NULL 160 139729 PRETZEL CHEESEBURG 18 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2 NULL 1 2 5 3 1 1 1 2 NULL NULL NULL NULL NULL 160 139730 GRILLED CHICKEN 18 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL 1 6 4 2 NULL 1 NULL 3 NULL NULL NULL NULL NULL 160 139731 CRISPY CHICKEN NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 160 139732 BUFFALO CHICK BURR 10 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 1 3 3 1 NULL 1 NULL NULL NULL NULL NULL NULL 21 139721 SEC BISCUIT 30 NULL NULL NULL NULL 2 2 2 7 2 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 21 139722 BEC BISCUIT 25 NULL NULL NULL NULL 4 4 6 6 4 NULL NULL NULL NULL O NULL NULL O NULL NULL NULL NULL NULL NULL NULL 21 139723 SAUSAGE BISCUIT 13 NULL NULL NULL NULL NULL 2 0 2 2 8 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 21 139725 BREAKFAST BURRITO 45 NULL NULL NULL NULL NULL 4 6 13 14 5 1 1 NULL NULL NULL NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL 21 139726 HASHBROWN 6 NULL NULL NULL NULL NULL 1 NULL 2 2 2 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 21 139727 PRETZEL CINN SUGAR 3 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL NULL NULL 2 NULL NULL NULL NULL NULL NULL NULL 21 139728 PRETZEL SALT 16 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 3 NULL 1 NULL 6 5 1 NULL NULL NULL NULL NULL NULL 21 139729 PRETZEL CHEESEBURG 13 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2 1 NULL 2 2 2 NULL 3 NULL NULL NULL NULL NULL 21 139730 GRILLED CHICKEN 8 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 1 2 NULL 1 1 1 1 NULL 1 NULL NULL NULL NULL NULL 21 139731 CRISPY CHICKEN NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 21 139732 BUFFALO CHICK BURR 8 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 4 1 NULL NULL 1 1 NULL NULL NULL 1 5 1 1 1 line tray & total tray to total handling variable batch size batch time 8 bacon egg & cheese biscuit breakfast burrito buffalo chicken wrap burger grilled chicken sandwich cinnamon pretzel hash brown large crisp roller grill non crisp roller grill salted pretzel sausage biscuit sausage egg & cheese biscuit small crisp roller grill max cook time assembly & label tray item time time fixed oven time assumes all components of a time it takes to time it takes to line all assembly and menu item can cook at the assembling all place all of the trays the menu item label time + max cook same time, and the cook ingredients of a menu item's uses and to put all tray item time + time + line time will be the cook time of menu item from off ingredients from a trays in the oven and line tray and tray & total the ingredient with the the trays and also box or cambro to to take all trays out of total tray to tray to oven longest cook time packaging it a baking tray the oven oven time time 5:30 0:45 0:11 1:02 1:58 6:32 10:00 1:13 0:09 1:23 2:45 11:23 10:00 1:09 0:33 1:02 2:44 11:02 5:15 0:32 0:20 0:41 1:33 5:56 6:00 0:25 0:10 0:41 1:16 6:41 4:30 0:41 0:05 0:21 1:07 4:51 10:00 0:19 0:02 0:21 0:42 10:21 16:30 0:14 0:06 0:21 0:41 16:51 11:00 0:17 0:07 0:21 0:45 11:21 4:30 0:43 0:05 0:21 1:09 4:51 5:30 0:36 0:05 0:41 1:22 6:11 5:30 0:43 0:08 1:02 1:53 6:32 15:00 0:14 0:02 0:21 0:37 15:21 Fixed + (Variable X Batch assembly size): Time it takes to & label make a typical batch from time + tray typical start to finish, including item time batch size "Max cook time 0:56 14:00 1:22 8 22:19 1:42 6 21:14 0:52 6 11:08 0:35 6 10:11 0:46 4 7:55 0:21 10 13:51 0:20 8 19:31 0:24 8 14:33 0:48 4 8:03 0:41 8 11:39 0:51 8 13:20 0:16 8 17-29 Time until Expiration Hot / Assembled Item or Component Breakfast Sausage Biscuit Sausage, Egg and Cheese Biscuit Bacon, Egg and Cheese Biscuit Breakfast Burrito Hashbrown 1.5 hours 1.5 hours 1.5 hours 2 hours 30 minutes Lunch Cheeseburger on Pretzel Bun Grilled Chicken Sandwich Crispy Chicken Sandwich Buffalo Chicken Burrito 2 hours 2 hours 1.5 hours 2 hours Snacks Cinnamon Sugar Pretzel Salted Pretzel 1 hours 1.5 hours 2 Ovens 3 Trays per Oven TIME & TEMPERATURE 2/17/2014 Recipe Name Oven Mode Temp Time COOKIES H/A; RE FAN 300 16:00 PRETZEL (ANY OTHER) COMBI 340 4:30 HASH BROWNS COMBI 340 11:00 PLAIN BUN COMBI 340 1:30 PRETZEL BUNS COMBI 340 12:00 EGG PATTIES COMBI 340 2:45 FOLDED EGG PATTIES COMBI 340 2:45 CHICKEN STRIPS COMBI 340 3:30 FINISH BURRITO COMBI 340 4:00 CROISSANTS COMBI 340 4:30 SAUSAGE PATTIES COMBI 340 4:30 HAMBURGERS COMBI 340 5:15 BISCUITS COMBI 340 5:30 GRILLED CHICKEN COMBI 340 16:00 BACON COMBI 340 3:30 CRISPY CHICKEN COMBI 340 10:00 1 1 Ingredients Biscuit Bacon Folded Egg Patties American Cheese Flour Tortilla Shredded Cheese Fried Egg Patties Hasbrown Patties Sausage Patties Flour Tortilla Shredded Cheese Hot Sauce Blue Cheese Dressing Hasbrown Patties Fajita Chicken Strips Pretzel Cinnamon Sugar Mixture Chocolate Chip Cookie Dough Breaded Chicken Strips Dill Pickles Bun Hashbrown Patties Hamburger Patties Pretzel bun American Cheese Pretzel Salt Sausage Patties Biscuit Biscuit Sausage Patties Quantity Batch Size Per Tray Time to Cook (m:ss) Cook Temp Final Cook Time Cook Temp Final Batch Time (mm:ss) Shelf Life (hh:mm) 1 4 or 8 5:30 340 4 16 or 32 3:30 340 N/A 1 4 or 8 N/A 14:00 2:45 1:30 340 1 4 or 8 N/A N/A 1 6 N/A N/A 1 6 NA 1 6 2:45 340 4:00 340 22:19 2:00 1 6 10:00 340 1 6 4:30 340 6 N/A N/A 6 N/A N/A 1 6 NA N/A 4:00 340 21:14 6 N/A N/A 2:00 1 6 10:00 340 1 6 3:30 340 1 5 4:30 340 7:55 1 5 N/A N/A 1:00 1 6 9:00 300 N/A N/A 3:00 1 4 or 6 6:00 340 1 4 or 6 N/A N/A N/A 10:11 1:30 1 4 or 6 1:30 340 1 4 or 8 10:00 340 N/A 13:51 0:30 1 4 or 6 5:15 340 1 4 or 6 2:00 340 N/A N/A 11:08 2:00 1 4 or 6 N/A N/A 1 5 4:30 340 1 N/A 8:03 5 1:30 N/A N/A 1 4 or 8 4:30 340 1 N/A NA 11:39 4 or 8 1:30 5:30 340 1 4 or 8 5:30 340 1 4 or 8 4-30 340 Store 1 1 1 1 item_id itemdescription 20140120_Total 0 2 3 4 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 160 139721 SEC BISCUIT 24 NULL NULL NULL NULL NULL 3 2 3 6 9 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 160 139722 BEC BISCUIT 31 NULL NULL NULL NULL 2 3 8 8 5 3 1 NULL NULL O NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 160 139723 SAUSAGE BISCUIT 17 NULL NULL NULL NULL 1 NULL 4 4 3 4 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 160 139725 BREAKFAST BURRITO 41 NULL NULL NULL NULL NULL 7 6 14 7 5 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 160 139726 HASHBROWN 7 NULL NULL NULL NULL NULL NULL 3 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 160 139727 PRETZEL CINN SUGAR 6 NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL NULL NULL 1 NULL 1 1 2 NULL NULL NULL NULL NULL NULL NULL NULL 160 139728 PRETZEL SALT 19 NULL NULL NULL NULL NULL NULL NULL NULL NULL 2 2 3 1 4 1 2 1 NULL NULL NULL NULL NULL 160 139729 PRETZEL CHEESEBURG 18 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2 NULL 1 2 5 3 1 1 1 2 NULL NULL NULL NULL NULL 160 139730 GRILLED CHICKEN 18 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL 1 6 4 2 NULL 1 NULL 3 NULL NULL NULL NULL NULL 160 139731 CRISPY CHICKEN NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 160 139732 BUFFALO CHICK BURR 10 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 1 3 3 1 NULL 1 NULL NULL NULL NULL NULL NULL 21 139721 SEC BISCUIT 30 NULL NULL NULL NULL 2 2 2 7 2 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 21 139722 BEC BISCUIT 25 NULL NULL NULL NULL 4 4 6 6 4 NULL NULL NULL NULL O NULL NULL O NULL NULL NULL NULL NULL NULL NULL 21 139723 SAUSAGE BISCUIT 13 NULL NULL NULL NULL NULL 2 0 2 2 8 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 21 139725 BREAKFAST BURRITO 45 NULL NULL NULL NULL NULL 4 6 13 14 5 1 1 NULL NULL NULL NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL 21 139726 HASHBROWN 6 NULL NULL NULL NULL NULL 1 NULL 2 2 2 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 21 139727 PRETZEL CINN SUGAR 3 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL NULL NULL 2 NULL NULL NULL NULL NULL NULL NULL 21 139728 PRETZEL SALT 16 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 3 NULL 1 NULL 6 5 1 NULL NULL NULL NULL NULL NULL 21 139729 PRETZEL CHEESEBURG 13 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2 1 NULL 2 2 2 NULL 3 NULL NULL NULL NULL NULL 21 139730 GRILLED CHICKEN 8 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 1 2 NULL 1 1 1 1 NULL 1 NULL NULL NULL NULL NULL 21 139731 CRISPY CHICKEN NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 21 139732 BUFFALO CHICK BURR 8 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 4 1 NULL NULL 1 1 NULL NULL NULL 1 5 1 1 1 line tray & total tray to total handling variable batch size batch time 8 bacon egg & cheese biscuit breakfast burrito buffalo chicken wrap burger grilled chicken sandwich cinnamon pretzel hash brown large crisp roller grill non crisp roller grill salted pretzel sausage biscuit sausage egg & cheese biscuit small crisp roller grill max cook time assembly & label tray item time time fixed oven time assumes all components of a time it takes to time it takes to line all assembly and menu item can cook at the assembling all place all of the trays the menu item label time + max cook same time, and the cook ingredients of a menu item's uses and to put all tray item time + time + line time will be the cook time of menu item from off ingredients from a trays in the oven and line tray and tray & total the ingredient with the the trays and also box or cambro to to take all trays out of total tray to tray to oven longest cook time packaging it a baking tray the oven oven time time 5:30 0:45 0:11 1:02 1:58 6:32 10:00 1:13 0:09 1:23 2:45 11:23 10:00 1:09 0:33 1:02 2:44 11:02 5:15 0:32 0:20 0:41 1:33 5:56 6:00 0:25 0:10 0:41 1:16 6:41 4:30 0:41 0:05 0:21 1:07 4:51 10:00 0:19 0:02 0:21 0:42 10:21 16:30 0:14 0:06 0:21 0:41 16:51 11:00 0:17 0:07 0:21 0:45 11:21 4:30 0:43 0:05 0:21 1:09 4:51 5:30 0:36 0:05 0:41 1:22 6:11 5:30 0:43 0:08 1:02 1:53 6:32 15:00 0:14 0:02 0:21 0:37 15:21 Fixed + (Variable X Batch assembly size): Time it takes to & label make a typical batch from time + tray typical start to finish, including item time batch size "Max cook time 0:56 14:00 1:22 8 22:19 1:42 6 21:14 0:52 6 11:08 0:35 6 10:11 0:46 4 7:55 0:21 10 13:51 0:20 8 19:31 0:24 8 14:33 0:48 4 8:03 0:41 8 11:39 0:51 8 13:20 0:16 8 17-29 Time until Expiration Hot / Assembled Item or Component Breakfast Sausage Biscuit Sausage, Egg and Cheese Biscuit Bacon, Egg and Cheese Biscuit Breakfast Burrito Hashbrown 1.5 hours 1.5 hours 1.5 hours 2 hours 30 minutes Lunch Cheeseburger on Pretzel Bun Grilled Chicken Sandwich Crispy Chicken Sandwich Buffalo Chicken Burrito 2 hours 2 hours 1.5 hours 2 hours Snacks Cinnamon Sugar Pretzel Salted Pretzel 1 hours 1.5 hours 2 Ovens 3 Trays per Oven TIME & TEMPERATURE 2/17/2014 Recipe Name Oven Mode Temp Time COOKIES H/A; RE FAN 300 16:00 PRETZEL (ANY OTHER) COMBI 340 4:30 HASH BROWNS COMBI 340 11:00 PLAIN BUN COMBI 340 1:30 PRETZEL BUNS COMBI 340 12:00 EGG PATTIES COMBI 340 2:45 FOLDED EGG PATTIES COMBI 340 2:45 CHICKEN STRIPS COMBI 340 3:30 FINISH BURRITO COMBI 340 4:00 CROISSANTS COMBI 340 4:30 SAUSAGE PATTIES COMBI 340 4:30 HAMBURGERS COMBI 340 5:15 BISCUITS COMBI 340 5:30 GRILLED CHICKEN COMBI 340 16:00 BACON COMBI 340 3:30 CRISPY CHICKEN COMBI 340 10:00 1 1 Ingredients Biscuit Bacon Folded Egg Patties American Cheese Flour Tortilla Shredded Cheese Fried Egg Patties Hasbrown Patties Sausage Patties Flour Tortilla Shredded Cheese Hot Sauce Blue Cheese Dressing Hasbrown Patties Fajita Chicken Strips Pretzel Cinnamon Sugar Mixture Chocolate Chip Cookie Dough Breaded Chicken Strips Dill Pickles Bun Hashbrown Patties Hamburger Patties Pretzel bun American Cheese Pretzel Salt Sausage Patties Biscuit Biscuit Sausage Patties Quantity Batch Size Per Tray Time to Cook (m:ss) Cook Temp Final Cook Time Cook Temp Final Batch Time (mm:ss) Shelf Life (hh:mm) 1 4 or 8 5:30 340 4 16 or 32 3:30 340 N/A 1 4 or 8 N/A 14:00 2:45 1:30 340 1 4 or 8 N/A N/A 1 6 N/A N/A 1 6 NA 1 6 2:45 340 4:00 340 22:19 2:00 1 6 10:00 340 1 6 4:30 340 6 N/A N/A 6 N/A N/A 1 6 NA N/A 4:00 340 21:14 6 N/A N/A 2:00 1 6 10:00 340 1 6 3:30 340 1 5 4:30 340 7:55 1 5 N/A N/A 1:00 1 6 9:00 300 N/A N/A 3:00 1 4 or 6 6:00 340 1 4 or 6 N/A N/A N/A 10:11 1:30 1 4 or 6 1:30 340 1 4 or 8 10:00 340 N/A 13:51 0:30 1 4 or 6 5:15 340 1 4 or 6 2:00 340 N/A N/A 11:08 2:00 1 4 or 6 N/A N/A 1 5 4:30 340 1 N/A 8:03 5 1:30 N/A N/A 1 4 or 8 4:30 340 1 N/A NA 11:39 4 or 8 1:30 5:30 340 1 4 or 8 5:30 340 1 4 or 8 4-30 340