Sad Farthe With Heide w Var LUM TAR ACCOUNT 19 Intro to Managerial Accounting Chapter 9 Canvas Homework - SHOW YOUR WORK FOR CREDIT Multiple Cost Drivers were to me winner The She's Gert B Pages SE00 Kitchen cam $1,000 Utes SED 5100 DIY pero 3 Oy 570 4 Bet 120 SO 302 ELIO TA Dewas S2 Divery E we E" SO + UH Top 13 Tata concentrate close to het 110 De 100 SMO Puig 40 55 Devet Delwy $1,000 con 5450 Here $ 2010 Viscal 5812 Required: 1. Complete the budget performance report below them to Perspending activity variance, and so for November Besked the way nust in for and Delivery vece Indicate the effect of each are force, for foreact Input al amount de vous Note: The table below che avancorum Town combination of the warances It is the debuteen the page and the results --- 30.000 Gengine + A 21 2 Chapter 9 Canvas Homework - SHOW YOUR WORK FOR CREDIT Multiple Cost Drivers: Salamone's Pizza is a neighborhood pizzeria that has an 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 driversthe number of pizzas sold and the number of deliveries made. The pizzeria's cost formulas appear below: Fixed Cost per Month Cost per Pizza Cost per Delivery Pizza ingredients $ 4.00 Kitchen staff $ 6,050 Utilities $ 680 $1.00 Delivery person $ 2.80 Delivery vehicle $ 700 $ 2.20 Equipment depreciation $ 456 Rent $ 2,010 Miscellaneous $ 800 $ 0.20 In November, the pizzeria budgeted for 1,770 pizzas at an average selling price of $14 per pizza and for 210 deliveries. Data concerning the pizzeria's actual results in November were as follows: Actual Results Pizzas 1,870 Deliveries 190 Revenue $ 26,800 Pizza ingredients $ 8,470 Kitchen staff $ 5,990 Utilities $ 920 Delivery person $ 532 Delivery vehicle $ 1.000 Equipment depreciation $ 456 Rent $ 2,010 $ 832 Miscellaneous Required: 1. Complete the flexible budget performance report below (fill in the missing blanks). It shows revenue/spending variances, activity variances, and total variances for November Besides the variances, you must fill in costs for Utilities and Delivery Vehicle Indicate the effect of each variance using "F" for favorable, "U" for unfavorable, and "N" for none or no effect. Input all amounts as positive values Note: The table below includes a total variance" column Total Variance is a combination of the other 2 variances. It is the difference between the planning budget and the actual results Salamone's Pizza For the Month Ending Nov 30 Actual Results Revenue & Spending Variance Flexible Budget Activity Variance Planning Budget Total Variance Pizzas 1,870 1,870 1,770 Deliveries 190 190 210 Revenue 26,800 620 F 26,180 24,780 Expenses: Pizza ingredients 8,470 990 u 7,480 7,080 Kitchen staff 5,990 60 F 6,050 6,050 Utilities 1630 F Delivery person 532 0 n/a 532 588 Delivery vehicle 118 F F Equipment depreciation 456 0 n/a 456 456 Rent 2,010 0 n/a 2,010 2,010 Miscellaneous 832 342 F 1,174 1,154 Total Expense 20,210 1160 F 21,370 20,950 Operating income 6,590 1780 F 4,810 3,830 2,760 F