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 pizzerias owner has determined that the shop has two major cost driversthe number of pizzas sold and the number of deliveries made.
The pizzerias cost formulas appear below:
Problem 9-21 More Than One Cost Driver LO9-2, LO 9-3, LO 9-4, LO9-5) 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 Cost per Cost Pizza Delivery $ 4.80 $0.80 per Month Pizza ingredients Kitchen staff Utilities Delivery person Delivery vehiclie $6,210 $ 760 $2.60 $1.80 $ 780 Equipment depreciation 520 $2,170 $ 880 Rent Miscellaneous $0.20 In November, the pizzeria budgeted for 2,010 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: Actual Results 2,110 190 Pizzas Deliveries Revenue Pizza ingredients Kitchen staff Utilities Delivery person Delivery vehicle Equipment depreciation Rent Miscellaneous 30,240 $ 9,910 $ 6,150 $ 960 $ 494 1,016 $ 520 $ 2,170 $ 880 Required: 1. Complete the flexible 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 no effect (i.e., zero variance). Input all amounts as positive values.) 1. Complete the flexible 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 no effect (i.e., zero variance). Input all amounts as positive values.) Milano Pizza Flexible Budget Performance Report For the Month Ended November 30 Actual Results Revenue and Spending Variances Flexible Budget Planning Budget Activity Variances Pizzas 2,110 190 Deliveries Revenue $30,240 Expenses Pizza ingredients Kitchen staff Utilities Delivery person Delivery vehicle Equipment depreciation Rent Miscellaneous 9,910 6,150 960 494 1,016 520 2,170 880 22,100 $8,140 Total expense Net operating income
