90.2K

Verified Solution

Link Copied!

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 Cost per Cost per Delivery Pizza per Month Pizza ingredients 4.80 $5,990 650 Kitchen staff $ 0.70 Utilities Delivery person Delivery vehic le Equipment depreciation $3.50 $1.90 670 432 $1,950 Rent $ 0.10 Miscellaneous 770 In November, the pizzeria budgeted for 1,680 pizzas at an average selling price of $19 per pizza and for 180 deliveries. Data concerning the pizzeria's actual results in November appear below: Actual Results Pizzas 1,780 Deliveries 160 34,410 $ 7,930 $ 5,930 $ Revenue Pizza ingredients Kitchen staff Utilities 905 Utilities $ $ $ $ $ 905 Delivery person Delivery vehicle Equipment depreciation 560 994 432 1,950 Rent Miscellaneous 814 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.) Milano Pizza Flexible Budget Performance Report For the Month Ended November 30 Actual Flexible Planning Budget Results Budget Pizzas 1,780 Deliveries 160 34,410 Revenue Expenses: Pizza ingredients 7,930 Kitchen staff 5,930 Milano Pizza Flexible Budget Performance Report For the Month Ended November 30 Actual Flexible Planning Budget Budget Results 1,780 Pizzas Deliveries 160 Revenue 34,410 Expenses: Pizza ingredients 7,930 5,930 Kitchen staff Utilities 905 Delivery person 560 Delivery vehicle 994 Equipment depreciation 432 Rent 1,950 Miscellaneous 814 Total expense 19,515 14,895 Net operating income

Answer & Explanation Solved by verified expert

See Answer