Milano Pizza has a small area for in-store dining as well as offers take-out and...

60.1K

Verified Solution

Question

Accounting

Milano Pizza has a small area for in-store dining as well as offers take-out and free home delivery services. The pizzerias owner determined the shop has two major cost driversthe number of pizzas sold and the number of deliveries made.
The pizzerias cost formulas appear below:
Fixed Cost per Month Cost per Pizza Cost per Delivery
Pizza ingredients $ 3.80
Kitchen staff $ 5,220
Utilities $ 630 $ 0.05
Delivery person $ 3.50
Delivery vehicle $ 540 $ 1.50
Equipment depreciation $ 275
Rent $ 1,830
Miscellaneous $ 820 $ 0.15
In November, the pizzeria budgeted for 1,200 pizzas at an average selling price of $13.50 per pizza and for 180 deliveries.
Data concerning the pizzerias actual results in November were as follows:
Actual Results
Pizzas 1,240
Deliveries 174
Revenue $ 17,420
Pizza ingredients $ 4,985
Kitchen staff $ 5,281
Utilities $ 984
Delivery person $ 609
Delivery vehicle $ 655
Equipment depreciation $ 275
Rent $ 1,830
Miscellaneous $ 954
Required:
1. Complete the flexible budget performance report for November. Data concerning the pizzeria's actual results in November were as follows:\table[[Milano Pizza],[Flexible Budget Performance Report],[For the Month Ended November 30],[,\table[[Actual],[Results]],\table[[Revenue and Spending],[Variances]],\table[[Flexible],[Budget]],Activity Variances,\table[[Planning],[Budget]]],[Pizzas,1,240,,],[Deliveries,174,,,,],[Revenue,17,420,,,,],[Expenses:],[Pizza ingredients,4,985,,,>,],[Kitchen staff,5,281,,,,],[Utilities,984,,,,],[Delivery person,609,,,,],[Delivery vehicle,655,,,,],[Equipment depreciation,275,,,,],[Rent,1,830,,,,],[Miscellaneous,954,,,,],[Total expenses,15,573,,0,,0],[Net operating income,1,847,,$,,$
image

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students