Required: 1. Complete the flexible budget performance report that shows both revenue and spending variances and activity variances for the pizzeria for November.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question

Please do not give solution in image format thanku 

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:
Cost per
Pizza
$ 4.30
Pizza ingredients
Kitchen staff
Utilities
Delivery person
Delivery vehicle
Equipment
depreciation
Rent
Miscellaneous
Pizzas
Deliveries
Revenue
Pizza ingredients
Kitchen staff
Utilities
Delivery person
Delivery vehicle
Equipment
depreciation
Rent
Miscellaneous
Fixed Cost
per Month
Pizzas
Deliveries
Revenue
Expenses:
In November, the pizzeria budgeted for 1,530 pizzas at an average selling price of $14 per pizza and for
210 deliveries.
Data concerning the pizzeria's actual results in November were as follows:
Pizza ingredients
Kitchen staff
Utilities
$
5,890
$ 600
$ 620
$392
$
$
1,850
$ 720 $0.10
Actual
Results
1,630
190
$
23,360
$
7,030
$
5,830
$ 880
$570
$ 984
$ 392
$
1,850
$ 784
Required:
1. 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.
Actual
Results
$ 0.20
1,630
190
23,360
7,030
5,830
880
Cost per
Delivery
< Prev
$ 3.00
$ 1.40
Milano Pizza
Flexible Budget Performance Report
For the Month Ended November 30
Flexible
Budget
2 of 14
⠀
Next >
Planning
Budget
Transcribed Image Text: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: Cost per Pizza $ 4.30 Pizza ingredients Kitchen staff Utilities Delivery person Delivery vehicle Equipment depreciation Rent Miscellaneous Pizzas Deliveries Revenue Pizza ingredients Kitchen staff Utilities Delivery person Delivery vehicle Equipment depreciation Rent Miscellaneous Fixed Cost per Month Pizzas Deliveries Revenue Expenses: In November, the pizzeria budgeted for 1,530 pizzas at an average selling price of $14 per pizza and for 210 deliveries. Data concerning the pizzeria's actual results in November were as follows: Pizza ingredients Kitchen staff Utilities $ 5,890 $ 600 $ 620 $392 $ $ 1,850 $ 720 $0.10 Actual Results 1,630 190 $ 23,360 $ 7,030 $ 5,830 $ 880 $570 $ 984 $ 392 $ 1,850 $ 784 Required: 1. 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. Actual Results $ 0.20 1,630 190 23,360 7,030 5,830 880 Cost per Delivery < Prev $ 3.00 $ 1.40 Milano Pizza Flexible Budget Performance Report For the Month Ended November 30 Flexible Budget 2 of 14 ⠀ Next > Planning Budget
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Budgeting
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.
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education