Flexible Budget Variance Analysis and Manufacturing Cost Variance Reconciliation: A Case Study of Morse Inc.
Overview
This case study examines Morse Inc.'s variance analysis using flexible budgeting methodology. The paper demonstrates how flexible budgets provide superior variance communication compared to static budgets, presents detailed variance calculations for materials, labor, and overhead costs, and reconciles spending variances with manufacturing variances to show integrated cost control analysis.
What this case study covers
- Question 1: Justification for flexible budget variance analysis and its advantages over static budgeting
- Question 2: Flexible budget variance statement with actual results, flexible budget, and planning variances
- Question 3: Detailed calculations of materials, labor, and fixed overhead variances with price, quantity, rate, efficiency, budget and volume components
- Question 4: Reconciliation of spending variances from the flexible budget with manufacturing variances to demonstrate internal consistency
Preview
Morse Variance Case Study
Student’s Name
Institutional Affiliation
Question 1
Morse Inc. should consider using a flexible budget in the variance analysis since the flexible variance budget communicates more information than a static budget. It describes the variance between the actual and estimated sales, operating costs, and profits. The flexible budget income statement portrays the actual costs of the company, hence having accuracy. The flexible budget variance allows the business to modify its static budget to ensure the accuracy and comparison of results. Therefore, the flexible budget variance can communicate the changes in the market, hence allowing the organization to adjust accordingly. It enables the organization to identify the exact area of challenge and work on them to improve profitability and reduce the costs of operation.
Question 2
Morse Variance Case Solution
***Amount in thousands ($)
Actual | Revenue & Spending | Flexible | Activity | Planning | ||||
Results | Variances | Budget | Variances | Budget | ||||
Sales | 15,040 | 40(F) | 14,100 | 900(U) | 15,000 | |||
Less V. Costs | ||||||||
DM | 4,606 | 106(U) | 3,948 | 552(F) | 4500 | |||
DL | 1,175 | 325(F) | 1,762.5 | 262.5(U) | 1500 | |||
V-OH | 1,468.75 | 468.75(U) | 1,175 | 175(U) | 1000 | |||
CM | 7,790.25 | 209.75(U) | 7,214.5 | 785.5(U) | 8000 | |||
Less F. Costs | ||||||||
Manufacturing | 2,350 | 350 (U) | 2350 | 350(U) | 2000 | |||
Sell & Admin | 2,360 | 140 (F) | 2,360 | 140(F) | 2500 | |||
Net Op. Income | 3,080.25 | 419.75(U) | 2,504.5 | 995.5(U) | 3500 |
Question 3
Materials Variance
Actual quantity = 1,316,000
Actual price = 3.5
Standard quantity = 1,500,000
Standard price = $3
Price Variance = (Actual quantity*Actual price) - (Actual quantity*Standard price)
(1,316,000*3.