Chapter 10 – Strategy and the Master Budget
10-51 Spring Manufacturing Company—Comprehensive Profit Plan (90 Minutes, but
much less if used in conjunction with 10-50 and completed with an Excel
spreadsheet)
1. Sales Budget
Spring Manufacturing Company
Sales Budget
2016
C12 D57 Total
Sales (in units) 12,000 18,000 30,000
× Selling Price per Unit $160 $180
2. Production Budget
Spring Manufacturing Company
Production Budget
2016
C12 D57
Budgeted Sales (in units) 12,000 18,000
Plus: Desired finished goods ending inventory 300 200
10-60
Chapter 10 – Strategy and the Master Budget
10-51 (Continued-1)
3. Direct Materials Purchases Budget (units and dollars)
Spring Manufacturing Company
Direct Materials Purchases Budget (units and dollars)
2016
C12 D57 Total
Raw Material (RM) 1:
Budgeted Production 11,900 18,050
Pounds per Unit × 10 × 8
RM 1 needed for production 119,000 144,400 263,400
Plus: Desired Ending Inventory (lbs.) 4,000
Raw Material (RM) 2:
Budgeted Production 11,900 18,050
Pounds per Unit × 0 × 4
RM 2 needed for production 0 72,200 72,200
Plus: Desired Ending Inventory (lbs.) 1,000
Raw Material 3:
Budgeted Production 11,900 18,050
Pounds per Unit × 2 × 1
RM 3 needed for production 23,800 18,050 41,850
Plus: Desired Ending Inventory (lbs.) 1,500
Total RM 3 needed (lbs.) 43,350
10-61
Chapter 10 – Strategy and the Master Budget
10-51 (Continued-2)
4. Direct Manufacturing Labor Budget
Spring Manufacturing Company
Direct Labor Budget
2016
C12 D57 Total
Budgeted production 11,900 18,050
Direct labor hours (DLH) per unit × 2 × 3
5. Factory Overhead Budget
Variable OH per DLH (from Pr. 10-50):
Total budgeted variable overhead (Pr. 10-50, and above) $326,080
Spring Manufacturing Company
Factory Overhead Budget
2016
Variable Factory Overhead ($6.40/DLH × 77,950 DLHs) $498,880
Fixed Factory Overhead:
Supervision $120,000
Maintenance costs 20,000
Heat, light, and power 43,420
Total Cash Fixed Factory Overhead $183,420
10-62
Education.
Chapter 10 – Strategy and the Master Budget
10-51 (Continued-3)
6. Budgeted CGS and Ending Finished Goods Inventory Budget
Spring Manufacturing Company
Ending Finished Goods Inventory and Budgeted CGS
2016
C12 D57 Total
Sales volume 12,000 18,000 30,000
Cost per unit (Schedule 1 and 2) $90.33624 $130.50436
Schedule 1: Cost per Unit—Product C12:
Inputs Cost
Cost Element Unit Input Cost Quantity Per Unit
RM-1 $2.00 10 $20.00
RM-3 $0.50 2 $1.00
Direct labor $25.00 2 $50.00
Schedule 2: Cost per Unit—Product D57:
_______ Inputs___ Cost
Cost Element Unit Input Cost Quantity Per Unit
RM-1 $2.00 8 $16.00
RM-2 $2.50 4 $10.00
RM-3 $0.50 1 $0.50
Direct labor $25.00 3 $75.00
10-63
Education.
Chapter 10 – Strategy and the Master Budget
10-51 (Continued-4)
7. Selling and Administrative Expense Budget
Spring Manufacturing Company
Selling and Administrative Expense Budget
2016
Selling Expenses:
Advertising $60,000
Sales salaries 200,000
Travel and entertainment 60,000
Depreciation 5,000 $325,000
Administrative expenses:
Offices salaries $60,000
Executive salaries 250,000
8. Budgeted Income Statement
Spring Manufacturing Company
Budget Income Statement
For the Year 2016
C12 D57 Total
Sales (part 1) $1,920,000 $3,240,000 $5,160,000
Cost of goods sold (part 6) 1,084,035 2,349,079 3,433,114
Gross profit $835,965 $890,921 $1,726,886
Selling and administrative expenses (part 7) $645,000
10-64
Education.
Chapter 10 – Strategy and the Master Budget
10-51 (Continued-5)
Answers:
1. The projected increase in after-tax operating income =
2. While the changes are projected to increase after-tax operating income, the
company should examine the decision more closely. Although the company
increases its after-tax operating income by 37% ($176,272 ÷ $472,860), it requires a
doubling of units of D57 to achieve this. In fact, a 100% increase in units sold of D57
Further, the price increase in C12 has no effect on the units sold. This may be an
indication that C12 may have a higher potential than the firm perceived.
Note to Instructor: An Excel spreadsheet solution file is embedded in this document.
You can open the spreadsheet “object” that follows by doing the following:
1. Right click anywhere in the worksheet area below.
2. Select “Worksheet Object,” then “Open.”
3. To return to the Word document, select “File” and then “Close and
return to…” while you are in the spreadsheet mode.
Pr. 10–51 7e.xlsx
Chapter 10 – Strategy and the Master Budget
10-52 Comprehensive Profit Plan with Kaizen (90 minutes, but much less if assigned in
conjunction with 10-50 and completed with an Excel spreadsheet)
1. Sales Budget
Spring Manufacturing Company
Sales Budget
2016
C12 D57 Total
Sales (in units) 12,000 9,000 21,000
2. Production Budget
Spring Manufacturing Company
Production Budget
2016
C12 D57
Budgeted Sales (in units) 12,000 9,000
Plus: Desired finished goods ending inventory 300 200
Total units needed
12,300
9,200
10-66
Education.
Chapter 10 – Strategy and the Master Budget
10-52 (Continued-1)
3. Direct Materials Purchases Budget (units and dollars)
Spring Manufacturing Company
Direct Materials Purchases Budget (units and dollars)
2016
C12 D57 Total
Raw Material (RM) 1:
Budgeted Production 11,900 9,050
Pounds per Unit × 9 × 7
RM 1 needed for production 107,100 63,350 170,450
Plus: Desired Ending Inventory (lbs.) 4,000
Total RM 1 needed (lbs.) 174,450
Raw Material (RM) 2:
Budgeted Production 11,900 9,050
Pounds per Unit × 0 × 3.6
RM 2 needed for production 0 32,580 32,580
Plus: Desired Ending Inventory (lbs.) 1,000
Total RM 2 needed (lbs.) 33,580
Less: Beginning inventory (lbs.) 1,500
Raw Material 3:
Budgeted Production 11,900 9,050
Pounds per Unit × 1.8 × 0.8
RM 3 needed for production 21,420 7,240 28,660
Plus: Desired Ending Inventory (lbs.) 1,500
Total RM 3 needed (lbs.) 30,160
10-67
Chapter 10 – Strategy and the Master Budget
10-52 (Continued-2)
4. Direct Manufacturing Labor Budget
Spring Manufacturing Company
Direct Labor Budget
2016
C12 D57 Total
Budgeted production 11,900 9,050
Direct labor hours per unit × 1.5 × 2
5. Factory Overhead Budget
Spring Manufacturing Company
Factory Overhead Budget
2016
Original Variable OH Budget:
Indirect materials $10,000
Miscellaneous supplies and tools 5,000
Indirect labor 40,000
Payroll taxes and fringe benefits 250,000
Maintenance costs 10,080
Heat, light, and power 11,000
Total Variable Factory Overhead $326,080
Reduction Rate for Variable OH Costs 10.00%
Original Fixed OH, Excluding Depreciation:
Supervision $120,000
10-68
Education.
Chapter 10 – Strategy and the Master Budget
10-52 (Continued-3)
Budgeted Variable OH:
($326,080 × (1 − 0.10)) = $293,472
Budgeted Fixed OH:
6. Budgeted CGS and Ending Finished Goods Inventory Budget
Spring Manufacturing Company
Ending Finished Goods Inventory and Budgeted CGS
2016
C12 D57 Total
Sales volume 12,000 9,000 21,000
Cost per unit (Schedule 1 and 2) $86.39170 $113.38893
Finished goods ending inventory 300 200
Schedule 1: Cost per Unit—Product C12:
Inputs __ Cost
Cost Element Unit Input Cos Quantity Per Unit
RM-1 $2.00 9 $18.00
RM-3 $0.50 1.8 $0.90
Direct labor $30.00 1.5 $45.00
10-69
Education.