Question

Problem 9-21 (Algo) More Than One Cost Driver [LO9-2, LO 9-3, LO 9-4, LO9-5] Milano Pizza is a small neighborhood pizzeria thRequired: 1. Complete the flexible budget performance report that shows both revenue and spending variances and activity vari

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer

Actual Results

Revenue & Spending Variance

Flexible Budget

Activity Variances

Planning Budget

Pizzas

                                 1,720

                                 1,720

                                                             1,620

Deliveries

                                     220

                                    220

                                                                 240

Revenues

$                     29,810.00

$                                   570.00

Favourable

$                     29,240.00

$                                          1,700.00

Favourable

$                                                 27,540.00

Expenses:

Pizza Ingrediants

$                        7,570.00

$                                   342.00

Favourable

$                       7,912.00

$                                              460.00

Unfavourable

$                                                    7,452.00

kitchen Staff

$                        5,890.00

$                                     60.00

Favourable

$                       5,950.00

$                                                       -  

None

$                                                    5,950.00

Utilities

$                           895.00

$                                   595.00

Favourable

$                       1,490.00

$                                                50.00

Unfavourable

$                                                    1,440.00

Delivery Person

$                           726.00

$                                            -  

None

$                           726.00

$                                                66.00

Favourable

$                                                       792.00

Delivery Vehicle

$                           990.00

$                                     34.00

Favourable

$                       1,024.00

$                                                34.00

Favourable

$                                                    1,058.00

Equipment Depreciation

$                           416.00

$                                            -  

None

$                           416.00

$                                                       -  

None

$                                                       416.00

Rent

$                        1,910.00

$                                            -  

None

$                       1,910.00

$                                                       -  

None

$                                                    1,910.00

Miscellaneous

$                           802.00

$                                   378.00

Favourable

$                       1,180.00

$                                                25.00

Unfavourable

$                                                   1,155.00

Total Expenses

$                     19,199.00

$                               1,409.00

Favourable

$                     20,608.00

$                                              435.00

Unfavourable

$                                                 20,173.00

Net Operating Income

$                     10,611.00

$                               1,979.00

Favourable

$                       8,632.00

$                                          1,265.00

Favourable

$                                                    7,367.00

--Working

Actual Results

Flexible Budget

Planning Budget

Pizzas

1720

1720

1620

Deliveries

220

220

240

Revenues

29810

=1720*17

=1620*17

Expenses:

Pizza Ingrediants

7570

=1720*4.6

=1620*4.6

kitchen Staff

5890

5950

5950

Utilities

895

=630+(1720*0.5)

=630+(1620*0.5)

Delivery Person

726

=220*3.3

=240*3.3

Delivery Vehicle

990

=650+(220*1.7)

=650+(240*1.7)

Equipment Depreciation

416

416

416

Rent

1910

1910

1910

Miscellaneous

802

=750+(1720*0.25)

=750+(1620*0.25)

Add a comment
Know the answer?
Add Answer to:
Problem 9-21 (Algo) More Than One Cost Driver [LO9-2, LO 9-3, LO 9-4, LO9-5] Milano Pizza...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Milano Pizza is a small neighborhood pizzeria that has a small area for in-store dining as...

    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 Delivery Fixed Cost Cost per per Month Pizza $ 4.60 $5,950 $ 630 $ 0.50 Pizza ingredients Kitchen staff Utilities Delivery person Delivery vehicle...

  • Problem 9-21 (Algo) More Than One Cost Driver (LO9-2, LO 9-3, LO 9-4, LO9-5) Milano Pizza...

    Problem 9-21 (Algo) More Than One Cost Driver (LO9-2, LO 9-3, LO 9-4, LO9-5) 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 per Month Cost per Cost per Pizza Delivery $4.70...

  • Problem 9-21 More Than One Cost Driver (LO9-2, LO 9-3, LO 9-4, LO9-5] Milano Pizza is...

    Problem 9-21 More Than One Cost Driver (LO9-2, LO 9-3, LO 9-4, LO9-5] 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 per Month Cost per Pizza $ 4.20 cost per Delivery $6,090...

  • Problem 9-20 More Than One Cost Driver [LO9-4, LO9-5] Milano Pizza is a small neighborhood pizzeria...

    Problem 9-20 More Than One Cost Driver [LO9-4, LO9-5] Milano Pizza is a small neighborhood pizzeria that has a small area for in-store dining as well as offering ery 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. Data concerning the pizzeria's costs appear below: Pizza ingredients Kitchen staff Utilities Delivery person Delivery vehicle Equipment depreciation Rent Miscellaneous Fixed Cost Cost per Cost per per...

  • Need this performance report filled out please and thank you! 19WF-ACCTG-202-99 Managix Chapter 9 HW - E9-13, P9...

    Need this performance report filled out please and thank you! 19WF-ACCTG-202-99 Managix Chapter 9 HW - E9-13, P9-20 X C Search Textbook Solutions CX + – c e zto.mheducation.com/hm.tpx Question 2 (of 2) 2. value 10.00 points 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...

  • Milano Pizza is a small neighborhood pizzeria that has a small area for in-store dining as...

    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 plzzerla's owner has determined that the shop has two major cost drivers—the number of pizzas sold and the number of deliveries made. points The pizzerla's cost formulas appear below: Fixed Cost per Month Cost per Pizza $ 4.60 cost per Delivery eBook $5.950 $ 630 $ 0.5e $3.30 Pizza ingredients Kitchen staff Utilities Delivery...

  • Milano Pizza is a small neighborhood pizzeria that has a small area for in-store dining as...

    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...

  • Milano Pizza is a small neighborhood pizzeria that has a small area for in-store dining as well as offering take-o...

    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 per Month Cost per Pizza $ 4.30 Cost per Delivery $6,330 $ 820 $ 0.40 Pizza ingredients Kitchen staff Utilities Delivery person Delivery vehicle...

  • Milano Pizza is a small neighborhood pizzeria that has a small area for in-store dining as...

    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 per Month Cost per Pizza $4.40 Cost per Delivery Pizza ingredients Kitchen staff Utilities $5,910 610 $ 0.30 Delivery person Delivery vehicle Equipment depreciation...

  • Milano Pizza is a small neighborhood pizzeria that has a small area for in-store dining as...

    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 Delivery Fixed Cost Cost per per Month Pizza $ 4.90 $6,230 $ 770 $ 0.90 Pizza ingredients Kitchen staff Utilities Delivery person Delivery vehicle...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT