Question

Any help is gladly appreciated!

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 The pizzeria's cost formulas appear below Fixed Cost per month Cost per Pizza cost per Delivery Pina ingredients kitchen staff $5, Delivery person Delivery vehicle Equipment depreciation In November, the pizzeria budgeted for 1.530 pizzas at an average selling price of $14 per pizza and for 210 deliveries. Data concerning the pizzeria's actual results in November appear below. Results 1,630 Deliveries $ 23,30 Pin ingredients kitchen start Delivery person Delivery vehicle Equipment depreciation Ron Riscellaneous Required: 1 Complete the texible budget performance report that shows both revenue and spending variances and activity variances for the pizzeria for November indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for effect le, sero varience). Input all amounts as positive values.) Mano Piana Flexible Budget Performance Report For the Month Ended November 30 $ 23,300 Puza ingredients L 7.000 6.8301 380 570T 084 T Delivery person Delivery vehicle Equipment depreciation Rent Miscellaneous Total expense Net opening income S 5.04

Answer 1

milano pizzo flexible Budget performance Report for the month ended November 30 Actic Revenue and Flexible Activity Result spending vani. Budget variance 1630 1630 190 190 Planning Budget 1530 pizzas Deliveries 210 $ 23360 1.540 E22820 1400 F 214200 I Revenue Expense: Pizza Ingredi. kitchen staff UHlites 7030 5830 880 1 2 160 46 Delivery person 570 O Delivery vehical 984 98 0 7009 430 o 65792 E 5890 Ion Nore 5890 F 9261 20 Jul 906 None 570 60 F 630 U 886 E914 Hone 392 Home 392 Hone 1850 Hore 1850 883 Ju 873 F 18406 372 TU 18034 IF 4414 1028 F 3386 Equip-dep 392 Rent 1 850 784 99 misch Torcy Expense Netop Income $ 18320 s 5040 86 626

Explanaton: flexible Budget planning Budgel Pizza: 1630 pelivery : 190 pizza 1530; Delivery 210 Revenue 1630x $ 14 2 2820 1530 x $14 2 1420 Pizza inghe 16308$4.30 7 009 1530X $ 4.30 6579 kitchen staff Given $5890 Given $5890 UHlites I $600 + 10.20x1630) 926 $ 600 +0.20 X 1530) 906 Delivery person (1908 $3) 5700 (210 × $3) 630 pelivery vehical & 620 + (140x190) 886 $ 620 + (1.40X210) 914 Equip dep Griven 392 Given $ 392 Rent Given 1850 Griven 1850 misli s 720+ (0.10 x 160) 1883 115 920+ 0.10x1530) 873