-Save PIZZA RESTAURANT DATA Part 3200 - Grcel Home Insert Page Layout Formulas Data Review View Derick Laman Help Sea 1 - AA == BIA ws PCB General WE 49 0 aboard Merge & Center Allement Font F Conditional Formatas Formatting Table Styles Format Soyles C Sort Find Select ge Numbe Isabella's Pizza Oven Choices & Costs: G H N OVEN TYPE PIZZA OVEN THROUGHPUT TIME 15 MINE ZMIN DIE 4 MINDE Convection Oven Plaza Deck Oven Conveyor Oven 3 VARIABLE EST. OPERATING COST/PIZZA 1.50 1.00 0.20 FIXED COST 3 6,000.00 $ 12.000.00 s 30,000.00 CASE NOTES: At Isabella's current location, she is using the convection oven method as she has lower volume. She is concerned that this method is not cost efficient, especially with the higher volume of business she is expecting at the new location. There are three choices of plzza ovens as outlined to the right. (Note: The production time per pizza has no bearing on the cross-over calculations, but may be important in setting up her kitchen process in Part 4 of the case.) For the analysis complete the following: 10 11 -Graph the data to demonstrate a visual depiction of the cross-over quantity points. Hint: Calculate the average number of pirres for a year from the new locations forecast Set your quantity starting at zero increasing incrementally above the number she sto se -Calculate the mathematical solution for the exact cross over points. Hint: Compare any w choices at a time setting them equal to each other 17 -Determine the correct equipment choice based on the crossover points the expected production 21 72 Laut Dut - -Save PIZZA RESTAURANT DATA Part 3200 - Grcel Home Insert Page Layout Formulas Data Review View Derick Laman Help Sea 1 - AA == BIA ws PCB General WE 49 0 aboard Merge & Center Allement Font F Conditional Formatas Formatting Table Styles Format Soyles C Sort Find Select ge Numbe Isabella's Pizza Oven Choices & Costs: G H N OVEN TYPE PIZZA OVEN THROUGHPUT TIME 15 MINE ZMIN DIE 4 MINDE Convection Oven Plaza Deck Oven Conveyor Oven 3 VARIABLE EST. OPERATING COST/PIZZA 1.50 1.00 0.20 FIXED COST 3 6,000.00 $ 12.000.00 s 30,000.00 CASE NOTES: At Isabella's current location, she is using the convection oven method as she has lower volume. She is concerned that this method is not cost efficient, especially with the higher volume of business she is expecting at the new location. There are three choices of plzza ovens as outlined to the right. (Note: The production time per pizza has no bearing on the cross-over calculations, but may be important in setting up her kitchen process in Part 4 of the case.) For the analysis complete the following: 10 11 -Graph the data to demonstrate a visual depiction of the cross-over quantity points. Hint: Calculate the average number of pirres for a year from the new locations forecast Set your quantity starting at zero increasing incrementally above the number she sto se -Calculate the mathematical solution for the exact cross over points. Hint: Compare any w choices at a time setting them equal to each other 17 -Determine the correct equipment choice based on the crossover points the expected production 21 72 Laut Dut