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 ACCT W/CONNECT >IC<
- Do fast answer of this accounting questionsarrow_forwardWhich of the following is the most appropriate way to display liabilities on the balance sheet? a. alphabetically by payee b. relative likelihood of payment c. nearness to maturity d. All of these answer choices are correct.arrow_forwardCan you help me with accounting questionsarrow_forward
- For which of the following would year-end accrual of a current liability be optional? a. Current portion of a long-term lease obligation that comes due next year b. A declared property dividend c. Sick pay benefits that accumulate but do not vest d. Short-term debt that is being refinanced on a long-term basisarrow_forwardQuick answer of this accounting questionsarrow_forwardSwifty Supply Co. has the following transactions related to notes receivable during the last 2 months of 2027. The company does not make entries to accrue interest except at December 31. Nov. 1 Loaned $30,000 cash to Manny Lopez on a 12 month, 10% note. Dec. 11 Sold goods to Ralph Kremer, Inc., receiving a $85,500, 90-day, 8% note. 16 Received a $87,840, 180 day. 10% note to settle an open account from Joe Fernetti. 31 Accrued interest revenue on all notes receivable. (a) Journalize the transactions for Swifty Supply Co. (Ignore entries for cost of goods sold.) (Credit account titles are automatically indented when amount is entered. Do not indent manually. Use 360 days for cal in the order presented in the problem. List all debit entries before credit entries.) Date Account Titles and Explanation Debit Creditarrow_forward
- Hi expert please give me answer general accounting questionarrow_forwardHoward James started a business in 2011 in Jamaica and has been operating in the wholesale/retail industries, where he buys and sells household items to the local market. In 2012, he expanded his business operations and opened two other businesses in Trinidad and Tobago and Antigua and Barbuda, respectively. The annual sales of the respective businesses in 2015 are: Jamaica: J$3,000.00 Trinidad and Tobago: TT$251,000.00 Antigua and Barbuda: $299.00 Mr. James failed to register his business for VAT/GCT as specified by the respective Sales Tax Acts and Regulations. He stated that there is no need for his businesses to be registered because their sales are under the VAT thresholds and thus not required to be registered. a) You are to advise Mr. James if his decision not to register his businesses is justifiable. b) Search the respective VAT Acts for the 3 countries and advise Mr. James of the benefits of being a registered taxpayer; also the penalties for not registering for VAT/GCT.arrow_forwardGet correct answer general accounting questionarrow_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





