the formulas for excel are a requirement.

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 You are a friend, and a accountant. The owner is willing to trade free food for your assisting him with this project 1 10 12 13 Below is the cost information, the owner has developed in the past. for his business. 15 (all amounts are in dollars) Fixed Cost e Month Cost per Pizza | L Cost per Delivery 3.80 5.220.00 630.00 0.06 Pizza Ingredients Kitchen Staff U ties 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 Static Budo prepare a Flexible Budge based on sales of 1.240 pizzas. This will be needed for step 3 3. On the tab marked Variance Analysis, compare the Flexible Budolf 1.240 plazas, to the Acu Rosu (Be sure to identify the variances Favorable and Urbora ) Facts Static Budget Variance Analysis A A == = 11 A X Arial Paste BI U -12 x fx 5281 C - Millano Pizza Variance Analysis for November 3 Based on 1,240 Pizzas sold D E F G Actual Results Flexible Budget Variance F= Favorable U = Unfavorable 7 Income 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 +