O Q- Search in Sheet C.02. 2G100 11 - BIVES $ % Layout Tables Charts SmartArt Formulas Data Review 0. A. Home -11 A- A = R . Clear Arial BIV . A = S Wrap Text Merge - General 9 % Paste E insertB e fore Themes I J K L M N O P o R S T U V W TEI E G H 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 t o and free home delivery services. The planeria's owner has doned that the shop has two major cost drivers the number of p as sold and the number of deliveries made You are a trend, and accountant. The owner is willing to trade free food for your assisting him with this project Below is the cost information, the owner has developed in the past, for his business Tudose 5220.00 600.00 Puma ingredients 10 when Delivery Person 22 Delivery Vehicle 23 Equipment Depreciation Miscellaneous Coats 275.00 a in November, the prera budget for 200 pas naverage selling price of $13.50 each puz, and Requirements 1. On the tab marked static budget prepare a static budget based on the above data (This will use 1,200 piezas at the above costs) 6 2. Ale on the tab aed State Budget, prepare a flexible Budget based ons of 1240 p . This will be needed for step 3 On the tab m ed Variance Analysis come the Flexible of 1,240p , to the Actuale s (Be sure to del e variances as favorable and Undevorable) You will provide data formating for the worksheet Mark Butt Variance Analysis Facts Ready Normal View Arial 11 Layout BI U Tables Charts $ % , Formulas Home SmartArt Data Revie Edit Alignment A = = abc 11 S A - A Wrap T. Mer FL Arial Paste Clear BI U fx ACCT 2302 - Excel Project #2 Using Formulas, and multiple tabs Milano Pizza is a smal 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 Below is the cost information, the owner has developed in the past, for his business. Fixed Cost per Month Month Cost per Pizza Cost per Delivery (all amounts are in dollars) 1 17 18 3.80 5 220.00 630.00 0.05 21 22 23 Pizza Ingredients Kitchen Staff Utilities Delivery Person Delivery Vehicle Equipment Depreciation Rent Miscellaneous Costs 24 25 275.00 1.830.00 820.00 26 27 28 29 In November, the pizzeria budgeted for 1,200 pizzas, at an average selling price of $13.50 each pizza, and. 30 Requirements: 1. On the tab marked static budget, prepare a static budget based on the above data. (This will use 1.200 pizzas at the above costs.) 35 36 37 2. Also on the tab named Static Budget, prepare a Flexible Budget based on sales of 1.240 pizzas. This will be needed for step 3. 38 3. On the tab marked Variance Analysis, compare the Flexible Budget of 1,240 pizzas, to the Actual Results. (Be sure to identify the variances as Favorable, and, Unfavorable) 40 42 You will provide the data formatting for the worksheets. Static Budget Variance Analysis + Facts Ready Normal View Arial 11 Layout B I U Tables Z Charts $ % ja Formulas Data Home SmartArt Re Edit Font Alignment Fill Arial 11 A- A = = abc Wra = E Clear A Paste J13 B IV H fx : 1 2 3 Milano Puzza Static Budget for November Based on 1.200 Pizzas sold, and 180 deliveries 7 Income Sales Revenue 10 Expenses Pizza Ingredients Kitchen Start Delivery Person Delivery Vehicle Equipment Depreciation Miscellaneous Costs 21 Profit or(Loss) 25 Milano Pizza 26 Flexible Budget for November 27 Based on 1,240 Pizzas sold, and 174 deliveries 31 Income 12 Sales Revenue 35 Pizza ingredients Kitchen Start Uits Delivery Person De very Vehicle Equipment Depreciation ment Miscellaneous Costs 46 Port of LOS) Static Budget Variance Analysis + Facts R eady Normal View 5 Review Arial 11 BI USA $ % Home Layout Tables Charts SmartArt Formulas Edit Fill - Arial - 11-AA- Paste Clear BI U B A E Font Data Alignment abc Wrap Text Merge C D E F N20 Millano Pizza Variance Analysis for November Based on 1,240 Pizzas sold 2 3 Variance Actual Results Flexible Budget F = Favorable U = Unfavorable Income Sales Revenue 17,420.00 10 Expenses Pizza Ingredients Kitchen Staff Utilities Delivery Person Delivery Vehicle Equipment Depreciation Rent Miscellaneous Costs 19 20 Total Expenses 4,985.00 5.281.00 984.00 609.00 655.00 275.00 1.830.00 954.00 15,573.00 0.00 21 22 Profit or (Loss) 1,847.00 0.00 wwwwwwwww WNMNMN 00 OWN 600 NOW S tatic Budget Variance Analysis + Facts R eady Normal View