
Flexible budget performance report: A flexible budget shows the true difference between the actual cost and revenue and budgeted cost and revenue. The budgeted value is adjusted by preparing a flexible budget which is prepared based on actual level of activity.
1. The preparation of a flexible budget performance report
2. Explain the activity variances.

Answer to Problem 21P
Solution:
1.
Milano Pizza’s
Flexible Budget Performance Report |
|||||
Actual
Results |
Revenue /
Spending Variance |
Flexible
Budget |
Activity
Variance |
Planning
Budget |
|
Pizzas | 1,240 | 1,240 | 1,200 | ||
Deliveries | 174 | 174 | 180 | ||
Revenue | $17,420 | $680 F | $16,740 | $540 F | $16,200 |
Expenses: | |||||
Pizzas ingredients | $4,985 | $273 U | $4,712 | $152 U | $4,560 |
Kitchen staff | $5,281 | $61 U | $5,220 | 0 | $5,220 |
Utilities | $984 | $292 U | $692 | $2 U | $690 |
Delivery person | $609 | 0 | $609 | $21 F | $630 |
Delivery vehicle | $655 | $146 F | $801 | $9 F | $810 |
Equipment |
$275 | 0 | $275 | 0 | $275 |
Rent | $1,830 | 0 | $1,830 | 0 | $1,830 |
Miscellaneous | $954 | $52 F | $1,006 | $6 U | $1,000 |
$15,573 | $428 U | $15,145 | $130 U | $15,015 | |
$1,847 | $252 F | $1,595 | $410 F | $1,185 |
2. The pizzeria has an overall favorable activity variance of $410. The activity variance is caused by the difference in the level of activity variance. The planning budget was prepared using the projected sales and delivery of 1,200 pizzas and 180 deliveries and the flexible budget is prepared based on 1,240 pizzas and 174 deliveries. So the difference of 40 pizzas and 6 deliveries will caused a difference in the revenue and expenses.
Explanation of Solution
The planning budget is prepared by multiplying the budgeted activity with cost formulas and the flexible budget is prepared by multiplying the actual activity with cost formulas according to their relevance. An activity variance is caused by difference between actual activity and budgeted activity while revenue and spending variance is caused by other factors like changes in costs, uncertain events and etc. since the difference in the activity is eliminated.
Given:
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 |
Data concerning the pizzeria’s actual results in November appear below:
Actual Results | |
Pizzas | 1,240 |
Deliveries | 174 |
Revenue | $17,420 |
Pizzas ingredients | $4,985 |
Kitchen staff | $5,281 |
Utilities | $984 |
Delivery person | $609 |
Delivery vehicle | $655 |
Equipment depreciation | $275 |
Rent | $1,830 |
Miscellaneous | $954 |
Hence it is concluded that the Malino Pizza has favorable activity variance of $410 and favorable revenue and spending variance of $252. The favorability of variance is based on whether the variance is improving the net operating income or decreasing it. If the variance is increasing the net operating income, it is a favorable variance and if the variance is decreasing the net operating income, it is an unfavorable variance.
Want to see more full solutions like this?
Chapter 9 Solutions
MANAGERIAL ACCOUNTING W/CONNECT
- Cullumber Company uses a job order cost system and applies overhead to production on the basis of direct labor costs. On January 1, 2025, Job 50 was the only job in process. The costs incurred prior to January 1 on this job were as follows: direct materials $16,800, direct labor $10,080, and manufacturing overhead $13,440. As of January 1, Job 49 had been completed at a cost of $75,600 and was part of finished goods inventory. There was a $12,600 balance in the Raw Materials Inventory account on January 1. During the month of January, Cullumber Company began production on Jobs 51 and 52, and completed Jobs 50 and 51. Jobs 49 and 50 were sold on account during the month for $102,480 and $132,720, respectively. The following additional events occurred during the month. 1. Purchased additional raw materials of $75,600 on account. 2. Incurred factory labor costs of $58,800. 3. Incurred manufacturing overhead costs as follows: depreciation expense on equipment $10,080; and various other…arrow_forwardGeneral Accounting questionarrow_forwardWhat Is the correct answer A B ?? General Accounting questionarrow_forward
- Cullumber Company uses a job order cost system and applies overhead to production on the basis of direct labor costs. On January 1, 2025, Job 50 was the only job in process. The costs incurred prior to January 1 on this job were as follows: direct materials $16,800, direct labor $10,080, and manufacturing overhead $13,440. As of January 1, Job 49 had been completed at a cost of $75,600 and was part of finished goods inventory. There was a $12,600 balance in the Raw Materials Inventory account on January 1. During the month of January, Cullumber Company began production on Jobs 51 and 52, and completed Jobs 50 and 51. Jobs 49 and 50 were sold on account during the month for $102,480 and $132,720, respectively. The following additional events occurred during the month. 1. Purchased additional raw materials of $75,600 on account. 2. Incurred factory labor costs of $58,800. 3. Incurred manufacturing overhead costs as follows: depreciation expense on equipment $10,080; and various other…arrow_forwardAccounting questionarrow_forwardNot need ai solution please correct answer general Accountingarrow_forward
- Accounting questionarrow_forwardMs. Sharon Washton was born 26 years ago in Bahn, Germany. She is the daughter of a Canadian High Commissioner serving in that country. However, Ms. Washton is now working in Prague, Czech Republic. The only income that she earns in the year is from her Prague marketing job, $55,000 annually, and is subject to income tax in Czech Republic. She has never visited Canada. Determine the residency status of Sharon Washtonarrow_forwardAns plzarrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education





