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 2PSA
Flexible budget performance report for the year ended December 31, 2015 (Amount in $):
Particulars | Flexible budget | Actual Results | Variances | Favorable/ Unfavorable |
Sales (18, 000 units) | 36, 00, 000 | 36, 48, 000 | 48, 000 | F |
Variable costs: | ||||
Direct materials | 11, 70, 000 | 11, 85, 000 | 15, 000 | U |
Direct labor | 2, 70, 000 | 2, 78, 000 | 8, 000 | U |
Machinery repairs | 72, 000 | 63, 000 | 9, 000 | F |
Utilities | 54, 000 | 53, 000 | 1, 000 | F |
Packaging | 90, 000 | 87, 500 | 2, 500 | F |
Shipping | 1, 26, 000 | 1, 18, 500 | 7, 500 | F |
Total variable costs | 17, 82, 000 | 17, 85, 000 | 3, 000 | U |
Contribution margin | 18, 18, 000 | 18, 63, 000 | 45, 000 | F |
Fixed costs: | ||||
Depreciation- plant equipment | 3, 00, 000 | 3, 00, 000 | 0 | |
Utilities | 1, 50, 000 | 1, 47, 500 | 2, 500 | F |
Plant management salaries | 2, 00, 000 | 2, 10, 000 | 10, 000 | U |
Sales salary | 2, 50, 000 | 2, 68, 000 | 18, 000 | U |
Advertising expense | 1, 25, 000 | 1, 32, 000 | 7, 000 | U |
Salaries | 2, 41, 000 | 2, 41, 000 | 0 | |
Entertainment expense | 90, 000 | 93, 500 | 3, 500 | U |
Total fixed costs | 13, 56, 000 | 13, 92, 000 | 36, 000 | U |
Income from operations | 4, 62, 000 | 4, 71, 000 | 9, 000 | F |
Explanation of Solution
For preparation of flexible budget of the company, following formulas would be used:
As per information in problem 8-1A, it is given that sales are $30, 00, 000 and sales volume is 15, 000 units. Flexible budget has to be prepared at sales volume of 18, 000 units. Now, required calculations have been made in the following manner:
Particulars | Amount per unit | Amount |
Sales (18, 000 units) | $30, 00, 000/ 15, 000 units = $200 | $200*18, 000 units = $36, 00, 000 |
Variable costs: | ||
Direct materials | $9, 75, 000/ 15, 000 units = $65 | $65*18, 000 units = $11, 70, 000 |
Direct labor | $2, 25, 000/ 15, 000 units = $15 | $15*18, 000 units = $2, 70, 000 |
Machinery repairs | $60, 000/ 15, 000 units = $4 | $4*18, 000 units = $72, 000 |
Utilities | $45, 000/ 15, 000 units = $3 | $3 *18, 000 units=$54, 000 |
Packaging | $75, 000/ 15, 000 units = $5 | $5*18, 000 units = $90, 000 |
Shipping | $1, 05, 000/ 15, 000 units = $7 | $7*18, 000 units = $1, 26, 000 |
Total variable costs | $99 | 17, 82, 000 |
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 (18, 000 units) | 36, 00, 000 | 36, 48, 000 | 48, 000 | F |
Variable costs: | ||||
Direct materials | 11, 70, 000 | 11, 85, 000 | 15, 000 | U |
Direct labor | 2, 70, 000 | 2, 78, 000 | 8, 000 | U |
Machinery repairs | 72, 000 | 63, 000 | 9, 000 | F |
Utilities | 54, 000 | 53, 000 | 1, 000 | F |
Packaging | 90, 000 | 87, 500 | 2, 500 | F |
Shipping | 1, 26, 000 | 1, 18, 500 | 7, 500 | F |
Total variable costs | 17, 82, 000 | 17, 85, 000 | 3, 000 | U |
Contribution margin | 18, 18, 000 | 18, 63, 000 | 45, 000 | F |
Fixed costs: | ||||
Depreciation- plant equipment | 3, 00, 000 | 3, 00, 000 | 0 | |
Utilities | 1, 50, 000 | 1, 47, 500 | 2, 500 | F |
Plant management salaries | 2, 00, 000 | 2, 10, 000 | 10, 000 | U |
Sales salary | 2, 50, 000 | 2, 68, 000 | 18, 000 | U |
Advertising expense | 1, 25, 000 | 1, 32, 000 | 7, 000 | U |
Salaries | 2, 41, 000 | 2, 41, 000 | 0 | |
Entertainment expense | 90, 000 | 93, 500 | 3, 500 | U |
Total fixed costs | 13, 56, 000 | 13, 92, 000 | 36, 000 | U |
Income from operations | 4, 62, 000 | 4, 71, 000 | 9, 000 | F |
Thus, income from operations of the company at flexible budget is coming out to be $4, 62, 000.
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
Requirement 2:
Analyze and interpret (a) sales variance and (b) direct materials cost variance.
Answer to Problem 2PSA
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 unfavorable due to the reason that the actual materials used were more 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 | 200 |
Actual sales (B) | 36, 48, 000 | $36, 48, 000/ 18, 000 units = $202.67 |
Sales variance (B-A) (Favorable) | 48, 000 | 2.67 |
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) | 11, 70, 000 | 65 |
Actual materials used (B) | 11, 85, 000 | $11, 85, 000/ 18, 000 units = $65.83 |
Direct materials cost variance (A-B) (Unfavorable) | 15, 000 | 0.83 |
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 unfavorable due to the reason that the actual materials used were more than that of budgeted materials. Also, per unit cost of actual materials is paid more than that estimated for budgeted materials.
Want to see more full solutions like this?
Chapter 8 Solutions
MANAGERIAL ACCOUNTING FUND. W/CONNECT
- 1. Prepare a performance report that compares static budget and actual costs for the period just ended (i.e., the report that Kellerman likely used when assessing his performancearrow_forwardThe following data were drawn from the records of Fanning Corporation. Planned volume for year (static budget) Standard direct materials cost per unit Standard direct labor cost per unit Total expected fixed overhead costs. Actual volume for the year (flexible budget) Actual direct materials cost per unit Actual direct labor cost per unit Total actual fixed overhead costs Required a. Prepare a materials variance information table showing the standard price, the actual price, the standard quantity, and the actual quantity. b. Calculate the materials price and usage variances. Indicate whether the variances are favorable (F) or unfavorable (U). c. Prepare a labor variance information table showing the standard price, the actual price, the standard hours, and the actual hours. d. Calculate the labor price and usage variances. Indicate whether the variances are favorable (F) or unfavorable (U). e. Calculate the predetermined overhead rate, assuming that Fanning uses the number of units as…arrow_forwardRequired:a) Prepare a flexed budget and calculate the total variances b) Using the data, analyse each of the cost variances: Materials; Labour;Variable Overheads and; Fixed Overheads c) Using data, calculate the Sales price variance and the Sales volume variancearrow_forward
- A) Calculate the following variances using the budgets in (a) and the actual performance for November. i. Sales volume ii. Sales price iii. Direct labour efficiency iv. Direct labour rate v. Direct material usage vi. Direct material rate vii. Fixed overheads B) Produce a reconciliation statement comparing the original budgeted and actual profits for the product for the month of November. Clearly explain the variances in the reconciliation.arrow_forwardA company that wants to report both spending and efficiency variances for 1 point overhead must compute budget allowances for both the actual amount of activity that occurred and the standard level of activity allowed for the level of output achieved. True O Falsearrow_forwardWhich of the following is true? a. The Flexible Budget Variance for operating income is calculated by taking the actual operating income minus the static budget operating income. b. The Flexible Budget Variance for operating income is calculated by taking the actual operating income minus the flexible budget operating income. c. The Flexible Budget Variance for operating income is calculated by taking the flexible budget operating income minus the actual operating income. Which of the following elements are used in calculating Costs in a Flexible Budget? a. Budgeted unit costs times actual quantities of output b. Actual unit costs times budgeted quantities of output c. Budgeted unit costs times budgeted quantities of output d. Actual unit costs times actual quantities of output A Favorable Variance results when (check all that apply) a. Actual costs exceed Budgeted costs b. Budgeted costs exceed…arrow_forward
- Required:(i) Prepare a standard costing profit statement, and a profit statement based on actual figures for the month of May. (ii) Prepare a statement of the variances which reconciles the actual with the standard profit or loss figure.arrow_forward1. What raw materials cost would be included in the company’s planning budget for March? 2. What raw materials cost would be included in the company’s flexible budget for March? 3. What is the materials price variance for March? (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.)arrow_forwardUsing a flexible budgeting approach how do I prepare a performance report for the passion department for April 2016, compare an actual overhead cost for 4600 hours. Separate overhead cost into variable and fixed components and show the amounts of any variances between actual budgeted amounts.arrow_forward
- Q.Prepare an analysis of variances for the third quarter of 2017 along the lines of Exhibit 7-2; identify the sales volume and flexible budget variances for operating income.arrow_forwardCalculate the following variances for November 2021 and indicate whether each of itis favorable (F) or adverse (A). 1. Direct material price.2. Direct material usage3. Direct labour rate4. Direct labour efficiency. Please provide a calculation for each of them.arrow_forwardOverhead variance, missing information. Consider the following two situations—cases A and B— independently. Data refer to operations for April 2017. For each situation, assume standard costing. Also assume the use of a exible budget for control of variable and xed manufacturing overhead based on machine-hours.arrow_forward
- Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage LearningCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeExcel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning