Question: please answer fast . in excel doc lla's Pizza Oven Choices & Costs: 2022 Projected Numer of Pirmas Sold: 1.58471 CASE NOTES: At Isabella's current

please answer fast . in excel doc please answer fast . in excel doc lla's Pizza
lla's Pizza Oven Choices & Costs: 2022 Projected Numer of Pirmas Sold: 1.58471 CASE NOTES: At Isabella's current location, she has been using two convection ovens. She is concerned that this metho is not cost efficient, especially with the higher volume of business she is expecting at the new location There are three choices of pizza ovens as outlined to the right. (Note: The production time per pizza has bearing on the cross over calculations, but may be important in setting up her kitchen process in Part 4 the case OVEN TYPE PIZZA OVEN THROUGHPUT TIME 20 MIN/ A MINIPLE S MIN/PIE Convection Oven Pen Deck Oven Conveyor Oven VARIABLE EST OPERATING COST/PEZA 1.75 O.RS 045 s ES $ FEED COST 1,500.00 $ 6,000.00 12,500.00 For the analysis complete the following Go back to Part 1 of the case. Determine the number of pizza's she can expect to sell in 2022. (Average cost per piata of $38) -Calculate the exact Crossover points mathematically for the three oven options Compare two ovens at a time. -Set the cost formula's equal to each other & solve for X number of paras -Graph the data to demonstrate a visual depiction of the cross-over quantity points. Set up the pizza quantity starting with zero & increasing incrementally above the number she expects to sell HINT: Try increments of 2.500 pizzas sold Determine the correct equipment choice based on the crossover points & the expected 2022 pitras solo -Transfer the Throughput Oven time you chose to Part 4 of the case. (Excel Block 11 for Task H)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!