SA 1 ACCT 2302 - Excel Project 2 2 Using Formulas, and multiple tabs 4 5 6 7 Milano Puzza is a small neighborhood puzzeria that has a small area for in-store dining as well as offering take-out and free home delivery services The puzzena's owner has determined that the shop has two major cost drivers the number of puzas sold and the number of deliveres made. 9 10 You are a friend and a accountant. The owner is willing to trade free food for your assisting him with this project 12 Below is the cost information, the owner has developed in the past, for his business Foxed Cost per Month Cost per P orza Cost per Delivery 5220 00 53000 005 18 Paza ingredients Kitchen St 20 Us 21 Delivery Person 22 Delivery Vehicle 23 Equipment Depreciation * Rent 35 Miscellaneous Costs 27500 1830.00 82000 2 In November, the pizzeria budgeted for 1 200 pezzas a rrage selling price of $13.50 each pizza and 32 Requirements 1 On the tab marked state budget prepare a state budget based on the above data This is 1.200 paras at the above costs) 2. Also on the tab med State Budget prepare a flexible Budget based on sales of 1240 pzas This ended for step 3 3 Othmand Vance Analysis compare the Flexible Budget of 1240 puzza to the Act Rats Be sure to identity the ancesas Favorable and, Unavorable) You proude the data formatting for the worksheets Da Copy * Format Painter Clipboard BIU-DO-A- Ez Font Alignmer J13 4 A C D 1. Millano Pizza 2 Static Budget for November 3 Based on 1,200 Pizzas sold, and 180 deliveries 7 Income 8 Sales Revenue 10 Expenses 11 Pizza Ingredients 12 Kitchen Stat 131 Uites 14 Delivery Person 15 Delivery Vehicle 16 Equipment Depreciation 17 Rent 18 Miscellaneous Costs 21 Pront or (Loss) 25 Milano Pizza 26 Flexible Budget for November 27 Based on 1240 Pizzas sold, and 174 deliveries 31 Income Sales Revenue 34 Expenses Pa Ingredients 36 Kitchen St 35 39 4 41 Devery person Dery Vehicle Equipment Depreciation Rent Miscellaneous Costs Protoros 2836 D E F G H C 1 Millano Pizza 2 Variance Analysis for November 3 Based on 1 240 Pizzas sold Variance Actual Results Flexible Budget F = Favorable U = Unfavorable 7 Income Sales Revenue 17.420.00 10 Expenses 11 Pizza Ingredients 12 Kitchen Staff 13 Utilities 14 Delivery Person 15 Delivery Vehicle 16 Equipment Depreciation 17 Rent Miscellaneous Costs 4.985.00 5,281.00 984.00 609.00 655.00 275,00 1830.00 954.00 Total Expenses 15.573.00 0.00 22 Profit or (Loss) 1.847.00 0 00 0.00 Facts Static Budget Variance Analysis 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
