ACCT 2302 - Excel Project #2 Using Formulas, and multiple tabs Milano Pizza is a small neighborhood pizzeria, that has a small area for in-store dining as well as offering take out and free home delivery services. The pizzeria's owner has determined that the shop has two major cost drivers; the number of pizzas sold and the number of deliveries made. 6 You are a friend and accountant. The owner is willing to trade free food for your assisting him with this project 10 Below is the cost information, the owner has developed in the past, for his business. 12 13 14 15 (all amounts are in dollars) Fixed Cost per Month Cost per Pizza Cost per Delivery 3.80 5,220.00 630.00 0.05 Pizza Ingredients Kitchen Staff Usities Delivery Person Delivery Vehicle Equipment Depreciation Rent Miscellaneous Costs 3.50 275.00 1,830.00 820.00 In November, the pizzeria budgeted for 1.200 pizzas, at an average selling price of $13.50 each pizza, and Requirements: 1. On the tab marked static budget, prepare a static budget based on the above data (This will use 1200 pizzas at the above costs) 2. Also on the tab named State Budo, prepare a Flexible Budget based on sales of 1.240 pizzas. This will be needed for step 3 3. On the marked Variance Analysis, compare the Flexible Budget of 1.240 plazas, to the Acu Rosu (Be sure to identify the variances Favorable and Urbora ) Facts Static Budget Variance Analysis Paste BIU A C11 1 Millano Pizza 2 Static Budget for November Based on 1,200 Pizzas sold, and 180 deliveries 7 Income 8 Sales Revenue 10 Expenses 11 Pizza Ingredients Kitchen Staff 14 Delivery Penon Delivery Vehicle Equipment Depreciation Rent Miscellaneous Costs 21 Profit or (Loss) 25 Milano Pizza 26 Flexible Budget for November 27 Based on 1.240 Pizza sold, and 174 deliveries Swes Revenue Delivery Person Equipment Depreciation Miscellaneous Costs Facts Static Budget Variance Analysis + 11 A A = = = hy Paste -12 Arial BI U * fx 5281 - Millano Pizza Variance Analysis for November Based on 1,240 Pizzas sold Actual Results Flexible Budget Variance F= Favorable U = Unfavorable 7 Income 8 Sales Revenue 17,420.00 10 Expenses Pizza Ingredients 12 Kitchen Staff 13 Utilities Delivery Person Delivery Vehicle Equipment Depreciation Rent Miscellaneous Costs 4.985.00 5,281.00 984.00 609.00 655.00 275.00 1.830.00 954.00 Total Expenses 15.573.00 0.00 22 Proftor (LOS) 0.00 1.847.00 0.00 0.00 Facts Static budget Variance Analysis +