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
Pizza ingredients $
Kitchen staff $
Utilities $
$
Delivery person $
Delivery vehicle $
$
Equipment depreciation $
Rent $
Miscellaneous $
$
In November, the pizzeria budgeted for
pizzas at an average selling price of $
per pizza and for
deliveries
Data concerning the pizzeria
s actual results in November were as follows:
Actual Results
Pizzas
Deliveries
Revenue $
Pizza ingredients $
Kitchen staff $
Utilities $
Delivery person $
Delivery vehicle $
Equipment depreciation $
Rent $
Miscellaneous $
Required:
Complete the flexible budget performance report that shows both revenue and spending variances and activity variances for the pizzeria for November.
Note: 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.
I need BOTH