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 Delivery Cost per per Month Pizza $ 3.80 Pizza ingredients Kitchen staff $ 5,220 Utilities $630 $ 0.05 Delivery person Delivery vehicle Equipment depreciation $ 540 $ 275 $ 1,830 $ 820 $ 3.50 $ 1.50 Rent Miscellaneous $ 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.

Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Chapter13: Nonlinear Optimization Models
Section: Chapter Questions
Problem 5P: Jims Camera shop sells two high-end cameras, the Sky Eagle and Horizon. The demand for these two...
icon
Related questions
Question
C Access to this pag...
9 studymoose.com
... 8b
Erylast
Maps
Translate
Saved
Help
Sa
sp 2022 i
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
per Month
Pizza
Delivery
Pizza ingredients
$ 3.80
$ 5,220
$ 630
Kitchen staff
Utilities
$ 0.05
$ 3.50
$ 1.50
Delivery person
Delivery vehicle
Equipment depreciation
$ 540
$ 275
$ 1,830
$ 820
Rent
Miscellaneous
$ 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 pizzeria's actual results in November were as follows:
Actual
Results
1,240
174
Pizzas
Deliveries
$ 17,420
$ 4,985
$5,281
$984
$609
$ 655
$ 275
$ 1,830
$ 954
Revenue
Pizza ingredients
Kitchen staff
Utilities
Delivery person
Delivery vehicle
Equipment depreciation
Rent
Miscellaneous
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.)
Transcribed Image Text:C Access to this pag... 9 studymoose.com ... 8b Erylast Maps Translate Saved Help Sa sp 2022 i 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 per Month Pizza Delivery Pizza ingredients $ 3.80 $ 5,220 $ 630 Kitchen staff Utilities $ 0.05 $ 3.50 $ 1.50 Delivery person Delivery vehicle Equipment depreciation $ 540 $ 275 $ 1,830 $ 820 Rent Miscellaneous $ 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 pizzeria's actual results in November were as follows: Actual Results 1,240 174 Pizzas Deliveries $ 17,420 $ 4,985 $5,281 $984 $609 $ 655 $ 275 $ 1,830 $ 954 Revenue Pizza ingredients Kitchen staff Utilities Delivery person Delivery vehicle Equipment depreciation Rent Miscellaneous 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.)
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Break-even Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials of Business Analytics (MindTap Course …
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
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
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Entrepreneurial Finance
Entrepreneurial Finance
Finance
ISBN:
9781337635653
Author:
Leach
Publisher:
Cengage