Question

In: Accounting

Zimmerman Inc. manufactures a single product, CXW. Zimmerman uses budgets and standards in its planning and...

Zimmerman Inc. manufactures a single product, CXW. Zimmerman uses budgets
and standards in its planning and control functions. Zimmerman makes use of its
standards in order to derive their budgeted cost per unit. For example, Exhibit A
provides information on the budgeted variable costs per unit. When determining
direct material costs for the planning budget income statement, the $12 budgeted
material cost per unit of CXW would be used in the calculation.

Exhibit A

Budgeted
(Standard)
Variable Costs Per
Unit of CXW
Raw material: 3 pounds at $4 per pound $12
Direct labor: 0.75 direct labor hours at $20 per hour 15
Variable overhead: 0.75 direct labor hours at $12 per hour 9
Total variable budgeted (standard) cost per CXW $36
__________________________________________________________________
The standards for fixed manufacturing overhead costs are: 0.75 direct labor hours
at $8 per hour. The standard fixed manufacturing overhead cost per hour is
calculated based on a denominator level of activity of 30,000 direct labor hours.
The planning budget income statement is based on the expectation of selling
40,000 units of CXW. The budgeted sales price is $65 per unit, and total budgeted
fixed selling and administrative costs are $500,000. There are no variable selling
and administrative costs in this firm.
The company actually produced and sold 36,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.

3

The actual income statement for the year is provided in Exhibit B.
Exhibit B
_______________________________________________________________

Zimmerman Inc.
Actual Income Statement

Sales:
36,000 units produced and sold at $68 $2,448,000
Less Variable Costs:
Direct materials (100,000 pounds at $4.25 per pound) 425,000
Direct labor (32,000 direct labor hours at $18/hr.) 576,000
Variable manufacturing overhead 400,000
Contribution margin 1,047,000
Less Fixed Costs:
Fixed manufacturing overhead costs 280,000
Fixed selling and administrative costs 485,000
Net operating income $ 282,000
Required:
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)

Solutions

Expert Solution

2 Actual Revenue & Spending Variances Flexible Budget Activity Variances Planning Budget
Activity -- units 36000 36000 40000
Sales 2448000 108000 F 2340000 -260000 U 2600000
Less Variable Costs:
Direct Material 425000 7000 F 432000 -48000 U 480000
Direct Labor 576000 -36000 U 540000 -60000 U 600000
Variable Overhead 400000 -76000 U 324000 -36000 U 360000
Contribution margin 1047000 3000 F 1044000 -116000 U 1160000
Fixed Costs:
Manufacturing 280000 -100000 U 180000 0 None 180000
Selling and Administrative 485000 15000 F 500000 0 None 500000
Net Operating income 282000 -82000 U 364000 -116000 U 480000
Flexible Budget
Sales 36000*2600000/400000 2340000
Material 36000*12 432000
Labor 36000*15 540000
Variable OH 36000*9 324000
Std Fixed Manufacturing OH .75*8*30000 180000

Related Solutions

Morse Inc. manufactures a single product, LWL. Morse uses budgets and standards in its planning and...
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 its 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...
Murphy Inc. manufactures a single product, DLZ. Murphy uses budgets and standards in its planning and...
Murphy Inc. manufactures a single product, DLZ. Murphy uses budgets and standards in its planning and control functions. Murphy makes use of its standards in order to derive their budgeted cost per unit. For example, Exhibit A provides information on the budgeted variable costs per unit. When determining direct material costs for the planning budget income statement, the $10 budgeted material cost per unit of DLZ would be used in the calculation. Exhibit A Budgeted (Standard) Variable Costs Per Unit...
Jordan Corporation Inc. manufactures a single product and uses a standard cost system for control purposes....
Jordan Corporation Inc. manufactures a single product and uses a standard cost system for control purposes. The standard cost card for the product is as follows: Standard Cost Standard Cost Per Unit ($) Direct materials 2 metres @ $8.45 per metre $16.90 Direct labour 1.4 hours @ $16 per DLH 22.40 Variable overhead 1.4 hours @ $2.50 per DLH 3.50 Fixed overhead 1.4 hours @ $6 per DLH 8.40 Total cost $51.20 * DLH - Direct labour hours Some additional...
Pardoe, Inc., manufactures a single product. The company uses a standard cost system and has established...
Pardoe, Inc., manufactures a single product. The company uses a standard cost system and has established the following standards for one unit of product: Standard Quantity of inputs Standard Price or Rate per input Standard Cost per unit Direct materials 1.5 pounds $3.20 per pound $4.80 Direct labor 0.7 hours $5.00 per hour $3.50 Pardoe's budget for March used estimated production and sales of 2,900 units. During March, the following activity was recorded by the company: The company produced 3,000...
Pureform, Inc., uses the FIFO method in its process costing system. It manufactures a product that...
Pureform, Inc., uses the FIFO method in its process costing system. It manufactures a product that passes through two departments. Data for a recent month for the first department follow: Units Materials Labor Overhead Work in process inventory, beginning 68,000 $ 68,700 $ 22,800 $ 32,900 Units started in process 649,000 Units transferred out 670,000 Work in process inventory, ending 47,000 Cost added during the month $ 804,750 $ 239,590 $ 409,825 The beginning work in process inventory was 80%...
Pureform, Inc., uses the FIFO method in its process costing system. It manufactures a product that...
Pureform, Inc., uses the FIFO method in its process costing system. It manufactures a product that passes through two departments. Data for a recent month for the first department follow: Units Materials Labor Overhead Work in process inventory, beginning 79,000 $ 75,100 $ 36,400 $ 49,100 Units started in process 751,000 Units transferred out 800,000 Work in process inventory, ending 30,000 Cost added during the month $ 1,557,385 $ 612,440 $ 688,995 The beginning work in process inventory was 70%...
Pureform, Inc., uses the FIFO method in its process costing system. It manufactures a product that...
Pureform, Inc., uses the FIFO method in its process costing system. It manufactures a product that passes through two departments. Data for a recent month for the first department follow: Units Materials Labor Overhead Work in process inventory, beginning 5,000 $ 4,320 $ 1,040 $ 1,790 Units started in process 45,000 Units transferred out 42,000 Work in process inventory, ending 8,000 Cost added during the month $ 52,800 $ 21,500 $ 32,250 The beginning work in process inventory was 80%...
Pureform, Inc., uses the FIFO method in its process costing system. It manufactures a product that...
Pureform, Inc., uses the FIFO method in its process costing system. It manufactures a product that passes through two departments. Data for a recent month for the first department follow: Units Materials Labor Overhead Work in process inventory, beginning 65,000 $ 68,500 $ 5,700 $ 21,400 Units started in process 617,000 Units transferred out 610,000 Work in process inventory, ending 72,000 Cost added during the month $ 1,484,100 $ 268,290 $ 327,910 The beginning work in process inventory was 75%...
Empire Ltd. is a company that manufactures and sells a single product called WarStars. For planning...
Empire Ltd. is a company that manufactures and sells a single product called WarStars. For planning and control purposes they utilize a monthly master budget, which is developed in advance of the budget year. Their fiscal year end is March 31. The sales forecast consisted of these few lines: • For the year ended March 31, 2020: 620,000 units at $15.00 each* • For the year ended March 31, 2021: 640,000 units at $16.50 each • For the year ended...
Pureform, Inc., uses the weighted-average method in its process costing system. It manufactures a product that...
Pureform, Inc., uses the weighted-average method in its process costing system. It manufactures a product that passes through two departments. Data for a recent month for the first department follow: Units Materials Labor Overhead Work in process inventory, beginning 65,000 $ 54,200 $ 21,800 $ 32,300 Units started in process 619,000 Units transferred out 640,000 Work in process inventory, ending 44,000 Cost added during the month $ 717,220 $ 269,480 $ 398,000 The beginning work in process inventory was 90%...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT