Concept explainers
Videos
Refer to the information in Problem 8-1B. Tohono Company’s actual income statement for 2015 follows.
Required
- Prepare a flexible budget performance report for 2015.
Analysis Component
- Analyze and interpret both the (a) sales variance and (b) direct materials cost variance.
Concept introduction:
Flexible Budget:
A flexible budget, also known as variation budget adjusts to changes in volume or activity. Flexible budgets are prepared for comparing actual to budgeted performances at many levels of activity during the previous year. In order to accurately predict the changes in costs, management identifies them into fixed or variable costs.
Requirement 1:
Flexible budget performance report for 2015 of the company.
Answer to Problem 2PSB
Flexible budget performance report for the year ended December 31, 2015 (Amount in $):
| Particulars | Flexible budget | Actual Results | Variances | Favorable/ Unfavorable |
| Sales (24, 000 units) | 36, 00, 000 | 36, 48, 000 | 48, 000 | F |
| Variable costs: | ||||
| Direct materials | 14, 40, 000 | 14, 00, 000 | 40, 000 | F |
| Direct labor | 3, 12, 000 | 3, 60, 000 | 48, 000 | U |
| Machinery repairs | 68, 400 | 60, 000 | 8, 400 | F |
| Utilities | 60, 000 | 64, 000 | 4, 000 | U |
| Packaging | 96, 000 | 90, 000 | 6, 000 | F |
| Shipping | 1, 39, 200 | 1, 24, 000 | 15, 200 | F |
| Total variable costs | 21, 15, 600 | 20, 98, 000 | 17, 600 | F |
| Contribution margin | 14, 84, 400 | 15, 50, 000 | 65, 600 | F |
| Fixed costs: | ||||
| Depreciation- machinery | 2, 50, 000 | 2, 50, 000 | 0 | |
| Utilities | 1, 50, 000 | 1, 54, 000 | 4, 000 | U |
| Plant manager salaries | 1, 40, 000 | 1, 55, 000 | 15, 000 | U |
| Sales salary | 1, 60, 000 | 1, 62, 000 | 2, 000 | U |
| Advertising expense | 81, 000 | 1, 04, 000 | 23, 000 | U |
| Salaries | 2, 41, 000 | 2, 32, 000 | 9, 000 | F |
| Entertainment expense | 90, 000 | 1, 00, 000 | 10, 000 | U |
| Total fixed costs | 11, 12, 000 | 11, 57, 000 | 36, 000 | U |
| Income from operations | 3, 72, 400 | 3, 93, 000 | 20, 600 | F |
Explanation of Solution
For preparation of flexible budget of the company, following formulas would be used:
As per information in problem 8-1B, it is given that sales are $30, 00, 000 and sales volume is 20, 000 units. Flexible budget has to be prepared at sales volume of 24, 000 units. Now, required calculations have been made in the following manner:
| Particulars | Amount per unit | Amount |
| Sales (24, 000 units) | $30, 00, 000/ 20, 000 units = $150 | $150*24, 000 units = $36, 00, 000 |
| Variable costs: | ||
| Direct materials | $12, 00, 000/ 20, 000 units = $60 | $60*24, 000 units = $14, 40, 000 |
| Direct labor | $2, 60, 000/ 20, 000 units = $13 | $13*24, 000 units = $3, 12, 000 |
| Machinery repairs | $57, 000/ 20, 000 units = $2.85 | $2.85*24, 000 units = $68, 400 |
| Utilities | $50, 000/ 20, 000 units = $2.5 | $2.5*24, 000 units=$60, 000 |
| Packaging | $80, 000/ 20, 000 units = $4 | $4*24, 000 units = $96, 000 |
| Shipping | $1, 16, 000/ 20, 000 units = $5.8 | $5.8*24, 000 units = $1, 39, 200 |
| Total variable costs | $88.15 | 21, 15, 600 |
Further, contribution margin can be calculated using the below- mentioned formulas:
Thus, contribution margin would be:
Fixed costs would remain same irrespective of the changes in sales volume. Also, Income from operations can be computed using the following formula:
Further, variances can be calculated using the following formula:
Therefore, flexible budget performance report as asked in the given problem is given below:
Flexible budget performance report for the year ended December 31, 2015 (Amount in $):
| Particulars | Flexible budget | Actual Results | Variances | Favorable/ Unfavorable |
| Sales (24, 000 units) | 36, 00, 000 | 36, 48, 000 | 48, 000 | F |
| Variable costs: | ||||
| Direct materials | 14, 40, 000 | 14, 00, 000 | 40, 000 | F |
| Direct labor | 3, 12, 000 | 3, 60, 000 | 48, 000 | U |
| Machinery repairs | 68, 400 | 60, 000 | 8, 400 | F |
| Utilities | 60, 000 | 64, 000 | 4, 000 | U |
| Packaging | 96, 000 | 90, 000 | 6, 000 | F |
| Shipping | 1, 39, 200 | 1, 24, 000 | 15, 200 | F |
| Total variable costs | 21, 15, 600 | 20, 98, 000 | 17, 600 | F |
| Contribution margin | 14, 84, 400 | 15, 50, 000 | 65, 600 | F |
| Fixed costs: | ||||
| Depreciation- machinery | 2, 50, 000 | 2, 50, 000 | 0 | |
| Utilities | 1, 50, 000 | 1, 54, 000 | 4, 000 | U |
| Plant manager salaries | 1, 40, 000 | 1, 55, 000 | 15, 000 | U |
| Sales salary | 1, 60, 000 | 1, 62, 000 | 2, 000 | U |
| Advertising expense | 81, 000 | 1, 04, 000 | 23, 000 | U |
| Salaries | 2, 41, 000 | 2, 32, 000 | 9, 000 | F |
| Entertainment expense | 90, 000 | 1, 00, 000 | 10, 000 | U |
| Total fixed costs | 11, 12, 000 | 11, 57, 000 | 36, 000 | U |
| Income from operations | 3, 72, 400 | 3, 93, 000 | 20, 600 | F |
Thus, income from operations of the company at flexible budget is coming out to be $3, 72, 400.
Concept introduction:
Sales variance:
It is the monetary difference between actual and budgeted sales. It is used to analyze changes in sales level over time. It can be calculated using the following formula:
Direct material cost variance:
It is the difference between standard cost of direct materials specified for the output achieved and the actual cost of direct materials used and can be calculated as under:
Requirement 2:
Analyze and interpret (a) sales variance and (b) direct materials cost variance.
Answer to Problem 2PSB
Sales variance of the company is favorable because the budgeted sales figure is less than that of actual sales during the period.
Direct material cost variance of the company is favorable due to the reason that the actual materials used were less than that of budgeted materials.
Explanation of Solution
Sales variance can be calculated using the following formula:
The calculation for same has been tabulated below:
| Particulars | Amount (In $) | Amount per unit (In $) |
| Budgeted sales (A) | 36, 00, 000 | 150 |
| Actual sales (B) | 36, 48, 000 | $36, 48, 000/ 24, 000 units = $152 |
| Sales variance (B-A) (Favorable) | 48, 000 | 2 |
Also, direct material cost variance can be computed using the below- mentioned formula:
The calculation for same has been tabulated below:
| Particulars | Amount (In $) | Amount per unit (In $) |
| Budgeted materials (A) | 14, 40, 000 | 60 |
| Actual materials used (B) | 14, 00, 000 | $14, 00, 000/ 24, 000 units = $58.33 |
| Direct materials cost variance (A-B) (Favorable) | 40, 000 | 1.67 |
Analysis of sales and direct materials cost variance:
Sales variance of the company is favorable because the budgeted sales figure is less than that of actual sales during the period. Also, per unit cost of actual sales is higher than that of budgeted sales.
Further, direct material cost variance of the company is favorable due to the reason that the actual materials used were less than that of budgeted materials. Also, per unit cost of actual materials is paid less than that estimated for budgeted materials.
Want to see more full solutions like this?
Chapter 8 Solutions
Managerial Accounting
- The industrial enterprise "HUANG S.A." purchased a sorting and packaging machine from a foreign company on 1/4/2017 at a cost of €500,000. The useful life of the machine was estimated by the Management at ten (10) years, while the residual value was estimated at zero. For the transportation of the machine from abroad to the company's factory, the amount of €20,000 was paid on 15/4/2017. As the insurance coverage of the machine during transportation was the responsibility of the selling company, HUANG S.A. proceeded to insure the machine from 16/4/2017 to 15/4/2018, paying the amount of €1,200. The delivery took place on 15/4/2017. As adequate ventilation of the multifunction device is essential for its proper operation, the company fitted an air duct on the multifunction device. The cost of the air duct amounted to €2,000 and was paid on 20/4/2017. On 25/4/2017, an external electrician was paid €5,000 for the electrical connection of the device. The company also paid €5,000 to an…arrow_forwardThe industrial enterprise "HUANG S.A." purchased a sorting and packaging machine from a foreign company on 1/4/2017 at a cost of €500,000. The useful life of the machine was estimated by the Management at ten (10) years, while the residual value was estimated at zero. For the transportation of the machine from abroad to the company's factory, the amount of €20,000 was paid on 15/4/2017. As the insurance coverage of the machine during transportation was the responsibility of the selling company, HUANG S.A. proceeded to insure the machine from 16/4/2017 to 15/4/2018, paying the amount of €1,200. The delivery took place on 15/4/2017. As adequate ventilation of the multifunction device is essential for its proper operation, the company fitted an air duct on the multifunction device. The cost of the air duct amounted to €2,000 and was paid on 20/4/2017. On 25/4/2017, an external electrician was paid €5,000 for the electrical connection of the device. The company also paid €5,000 to an…arrow_forwardI need answer typing clear urjent no chatgpt used pls i will give 5 Upvotes.only typing .arrow_forward
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning