Accounting case study Accounting, Finance, SPSS Case Study
What to do is that morse case
Morse Variance Case
ACBU 2223
Spring 2020
Instructions for Students
Students should work in teams of up to 3 members. Students should not discuss the case with anyone except their teammates. The solution to all questions must be typed and submitted to the link available on the Blackboard website by the end of Due date. A team is to upload only one copy of the solution with each member’s name listed alphabetically. Calculations should be rounded off to two decimal points if necessary.
Morse Variance Case
Morse Inc. manufactures a single product, LWL. Morse uses budgets and standards in its planning and control functions. Morse makes use of its standards in order to derive their budgeted costs per unit. For example, Exhibit A provides information on the budgeted costs per unit. When determining direct material costs for the planning budget income statement, the $9 budgeted direct material cost per unit of LWL would be used in the calculation.
Exhibit A
|
Budgeted (Standard) Costs Per Unit of LWL |
|
|
Direct materials: 3 pounds at $3 per pound |
$9 |
Direct labor: 0.2 direct labor hours at $15 per hour |
3 |
Variable overhead: 0.2 direct labor hours at $10 per hour |
2 |
Fixed overhead: 0.2 direct labor hours at $20 per hour |
4 |
Total budgeted (standard) cost per unit of LWL |
$18 |
__________________________________________________________________
The budgeted (standard) fixed manufacturing overhead cost per hour is calculated based on a denominator level of activity of 100,000 direct labor hours.
The planning budget income statement is based on the expectation of selling 500,000 units of LWL. The budgeted sales price is $30 per unit, and total budgeted fixed selling and administrative costs are $2,500,000. There are no variable selling and administrative costs in this firm.
The company actually produced and sold 470,000 units this year. The company never has a beginning or ending raw materials inventory, because it uses all raw materials purchased. Also, the company never has a beginning or ending finished goods inventory. Everything produced in the year is sold in that same year.
The actual income statement for the year is provided in Exhibit B.
Exhibit B
__________________________________________________________________
Morse Inc.
Actual Income Statement
Sales: |
|
470,000 units produced and sold at $32 |
$15,040,000 |
Less Variable Costs: |
|
Direct materials (1,316,000 pounds at $3.5 per pound) |
4,606,000 |
Direct labor (117,500 direct labor hours at $10/hr.) |
1,175,000 |
Variable manufacturing overhead |
1,468,750 |
Contribution margin |
7,790,250 |
Less Fixed Costs: |
|
Fixed manufacturing overhead costs |
2,350,000 |
Fixed selling and administrative costs |
2,360,000 |
Net operating income |
$ 3,080,250 |
Required:
1. Could you explain to your boss why the company should use the flexible budget income statement in the variance analysis? Your explanation should not be more than 1/2 page double spaced with a 12 font size. (15 points)
2. Prepare a detailed income statement variance analysis using the contribution approach income statement (i.e., variable costing basis) for the year (i.e., compare the actual income statement with the flexible budget income statement and compare the flexible budget income statement with the planning budget income statement). Show all the revenue, spending, and activity variances appearing in the income statement analysis. A template for answering this question is given below. All variances should be marked with either an “F” for favorable or “U” for unfavorable. (35 points)
Morse Variance Case Solution Template for Part 1
|
|
|
|
|
|
|
|
|
|
Actual |
|
Revenue & Spending |
|
Flexible |
Activity |
|
Planning |
|
Results |
|
Variances |
|
Budget |
Variances |
|
Budget |
Sales |
$$$ |
|
$$$ |
|
$$$ |
$$$ |
|
$$$ |
Less V.C. |
|
|
|
|
|
|
|
|
DM |
$$$ |
|
$$$ |
|
$$$ |
$$$ |
|
$$$ |
DL |
$$$ |
|
$$$ |
|
$$$ |
$$$ |
|
$$$ |
V-OH |
$$$ |
|
$$$ |
|
$$$ |
$$$ |
|
$$$ |
CM |
$$$ |
|
$$$ |
|
$$$ |
$$$ |
|
$$$ |
Less FC |
|
|
|
|
|
|
|
|
Manufacturing |
$$$ |
|
$$$ |
|
$$$ |
$$$ |
|
$$$ |
Sell & Admin |
$$$ |
|
$$$ |
|
$$$ |
$$$ |
|
$$$ |
NOI |
$$$ |
|
$$$ |
|
$$$ |
$$$ |
|
$$$ |
3. Prepare a very detailed manufacturing cost variance analysis (e.g., calculate the material price variance and quantity variance; the labor rate variance and efficiency variance; the variable overhead rate variance and efficiency variance; and the fixed manufacturing overhead budget variance and volume variance). All variances should be marked with either an “F” for favorable or “U” for unfavorable. Show your calculations. (40 points)
4. Could you reconcile spending variances in Part 2 with manufacturing cost variances in Part 3? For example, how is the amount of spending variance for direct materials in Part 2 explained by the amounts of direct material variances in Part 3? Excluding your quantitative analysis if any, your explanation should not be more than 1/3 page double spaced with a 12 font size. (10 points)
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)
<...
👀 Other Visitors are Viewing These Other Case Study Samples:
- Analysis of the Cash Conversion Cycle of JC Penney2 pages/≈550 words | Other | Accounting, Finance, SPSS | Case Study |
- How Much Should Orville Pay For Wilbur’s Share Of The Business?4 pages/≈1100 words | No Sources | Other | Accounting, Finance, SPSS | Case Study |
- Go-Figure and Accounting4 pages/≈1100 words | No Sources | Other | Accounting, Finance, SPSS | Case Study |
- Metapath Software Corporation2 pages/≈550 words | Other | Accounting, Finance, SPSS | Case Study |
- Gobi Partners and DMG in Internet Technology2 pages/≈550 words | Other | Accounting, Finance, SPSS | Case Study |
- Taxable Income and Tax Liability1 page/≈275 words | Other | Accounting, Finance, SPSS | Case Study |
- Federal Income Taxation 1 page/≈275 words | Other | Accounting, Finance, SPSS | Case Study |