AutoSave OF APvc ... PIZZA RESTAURANT DATA PART 4 2022 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Aharoni v 11 ~ Al A a Wras Text General X LE v ' . Insert 49.0 DX Delete Paste Y A - Merge & Center $% Conditional Format Cell Formatting as Table Styles Sensitivity Format v Sort & v Filter Find & Select Analyze Data BIU fx Total Time 117 . T R 0 F 0 R 5 T 11 w Y 2 > Isabella's Precedent Chart to Prepare 1 Pizza Ple TIME TASKID 3 TASK (Minutes) A Order Recared tym by 6.5 PRECEDENT TASK NONI CASE NOTES: kabela has studied her current restaurant procex & created a precocent diart with the order of task completion & time required except for the over time. (See Case P43 to type in the over time chosen by your Crasywe Point 4 Anas) hour INITIAL PRODUCTION PROCES DATA CALCULATION OR DATA UNITS Available Work Time for Oct Minutes Pizzas Production Goal for month Narrh od Pozas Round to whale of Oct. 2021 number 3 C 1 2.5 1.5 Prebennut 48 7 A Isabela knows her current process is inefficient She tends to staf up to 8 employees per shift. She is not sure of the In ou.put per hour & snows it could very greatly, therefore she would like to tase it on the highest sales month proiected for 2022. Generally that is October, where the stores open for 12 hours per day & 20 days in October for a total of 240 hours of avalable work time 3 C 0.3 1.25 3 D.E TAKT TIME- . 1D 1 1 Pere Tape E Cawer Dout a F Akvarah hentet H BwLaTeritate 1 ces bed & Tral rapedion of K PS TRW F G Minutes to Prod One Plzza (Round 2 decimal place) MINUTES MNUTES 12 12 H 13 1.25 0.5 2 Task Bottleneck Time Throughout Work Station 1 NOVE I For the analysis complete the following: -Determine the available work time in minutes for Oct. -Goto Case Por 1 & determine the number of pipes that would be sold in October 2002. Enter this number in the chart -Gata Case Par:#3 ta determine the pizza oven baking time & enter this for Taa Hin the precedent dat. -Calculate the remaining data for the Production Process Cakubations - Create the process flow draseng the circles & setting up the arrows as per Precedent Chart. Assign the Work Stations by color coding the tacks. -Fill in the Worl Station Chart (cu may or may not need all of the row providec.) -Determine the process Work Station Bottleneck Time, Efficiency, & Total de Time. 14 14 16 Work Station IdTreord Aseged Take Terele Talal Tine Station | 13 18 13 20 FINAL LINE RALANCED PROCESS DATA Work Station Hoteck Time - Erficie Percentage Total de Timeal Minutes 31 3 20 31 24 21 ED 53 Process Dala + Ready HE 75% AutoSave OF APvc ... PIZZA RESTAURANT DATA PART 4 2022 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Aharoni v 11 ~ Al A a Wras Text General X LE v ' . Insert 49.0 DX Delete Paste Y A - Merge & Center $% Conditional Format Cell Formatting as Table Styles Sensitivity Format v Sort & v Filter Find & Select Analyze Data BIU fx Total Time 117 . T R 0 F 0 R 5 T 11 w Y 2 > Isabella's Precedent Chart to Prepare 1 Pizza Ple TIME TASKID 3 TASK (Minutes) A Order Recared tym by 6.5 PRECEDENT TASK NONI CASE NOTES: kabela has studied her current restaurant procex & created a precocent diart with the order of task completion & time required except for the over time. (See Case P43 to type in the over time chosen by your Crasywe Point 4 Anas) hour INITIAL PRODUCTION PROCES DATA CALCULATION OR DATA UNITS Available Work Time for Oct Minutes Pizzas Production Goal for month Narrh od Pozas Round to whale of Oct. 2021 number 3 C 1 2.5 1.5 Prebennut 48 7 A Isabela knows her current process is inefficient She tends to staf up to 8 employees per shift. She is not sure of the In ou.put per hour & snows it could very greatly, therefore she would like to tase it on the highest sales month proiected for 2022. Generally that is October, where the stores open for 12 hours per day & 20 days in October for a total of 240 hours of avalable work time 3 C 0.3 1.25 3 D.E TAKT TIME- . 1D 1 1 Pere Tape E Cawer Dout a F Akvarah hentet H BwLaTeritate 1 ces bed & Tral rapedion of K PS TRW F G Minutes to Prod One Plzza (Round 2 decimal place) MINUTES MNUTES 12 12 H 13 1.25 0.5 2 Task Bottleneck Time Throughout Work Station 1 NOVE I For the analysis complete the following: -Determine the available work time in minutes for Oct. -Goto Case Por 1 & determine the number of pipes that would be sold in October 2002. Enter this number in the chart -Gata Case Par:#3 ta determine the pizza oven baking time & enter this for Taa Hin the precedent dat. -Calculate the remaining data for the Production Process Cakubations - Create the process flow draseng the circles & setting up the arrows as per Precedent Chart. Assign the Work Stations by color coding the tacks. -Fill in the Worl Station Chart (cu may or may not need all of the row providec.) -Determine the process Work Station Bottleneck Time, Efficiency, & Total de Time. 14 14 16 Work Station IdTreord Aseged Take Terele Talal Tine Station | 13 18 13 20 FINAL LINE RALANCED PROCESS DATA Work Station Hoteck Time - Erficie Percentage Total de Timeal Minutes 31 3 20 31 24 21 ED 53 Process Dala + Ready HE 75%