Milano Pizza has a small area for in-store dining as well as offers take-out and free home delivery services. The pizzeria's owner determined 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 Der Cost ner

Cornerstones of Cost Management (Cornerstones Series)
4th Edition
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Don R. Hansen, Maryanne M. Mowen
Chapter18: Pricing And Profitability Analysis
Section: Chapter Questions
Problem 1CE: Ventana Window and Wall Treatments Company provides draperies, shades, and various window...
icon
Related questions
Question
Do not give image format
Milano Pizza has a small area for in-store dining as well as offers take-out and free home delivery services. The pizzeria's owner
determined 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:
Pizza ingredients
Kitchen staff
Utilities
Delivery person
Delivery vehicle
Equipment depreciation
Rent
Miscellaneous
Fixed Cost
per Month
Pizzas
Deliveries
Revenue
Pizza ingredients
Kitchen staff
Utilities
Delivery person
Delivery vehicle
Equipment depreciation
Rent
Miscellaneous
$6,030
$ 670
Actual
Results
1,840
180
Cost per
Pizza
$5.00
$0.90
$ 690
$448
$ 1,990
$790
In November, the pizzeria budgeted for 1,740 pizzas at an average selling price of $13 per pizza and for 200 deliveries.
Data concerning the pizzeria's actual results in November were as follows:
$ 24,530
$ 8,290
$5,970
$915
$486
$998
$448
$ 1,990
$ 826
Cost per
Delivery
$ 0.15
$2.70
$ 2.10
Transcribed Image Text:Milano Pizza has a small area for in-store dining as well as offers take-out and free home delivery services. The pizzeria's owner determined 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: Pizza ingredients Kitchen staff Utilities Delivery person Delivery vehicle Equipment depreciation Rent Miscellaneous Fixed Cost per Month Pizzas Deliveries Revenue Pizza ingredients Kitchen staff Utilities Delivery person Delivery vehicle Equipment depreciation Rent Miscellaneous $6,030 $ 670 Actual Results 1,840 180 Cost per Pizza $5.00 $0.90 $ 690 $448 $ 1,990 $790 In November, the pizzeria budgeted for 1,740 pizzas at an average selling price of $13 per pizza and for 200 deliveries. Data concerning the pizzeria's actual results in November were as follows: $ 24,530 $ 8,290 $5,970 $915 $486 $998 $448 $ 1,990 $ 826 Cost per Delivery $ 0.15 $2.70 $ 2.10
Required:
1. Complete the flexible budget performance report for November.
Note: Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e
variance). Input all amounts as positive values.
Pizzas
Deliveries
Revenue
Expenses:
Pizza ingredients
Kitchen staff
Utilities
Delivery person
Delivery vehicle
Equipment depreciation
Rent
Miscellaneous
Total expenses
Net operating income
Actual
Results
1,840
180
$ 24,530
$
8,290
5,970
915
486
998
448
1,990
826
19,923
4,607
Milano Pizza
Flexible Budget Performance Report
For the Month Ended November 30
Flexible
Budget
$
0
0
Planning
Budget
$
0
0
Transcribed Image Text:Required: 1. Complete the flexible budget performance report for November. Note: Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e variance). Input all amounts as positive values. Pizzas Deliveries Revenue Expenses: Pizza ingredients Kitchen staff Utilities Delivery person Delivery vehicle Equipment depreciation Rent Miscellaneous Total expenses Net operating income Actual Results 1,840 180 $ 24,530 $ 8,290 5,970 915 486 998 448 1,990 826 19,923 4,607 Milano Pizza Flexible Budget Performance Report For the Month Ended November 30 Flexible Budget $ 0 0 Planning Budget $ 0 0
Expert Solution
steps

Step by step

Solved in 4 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning