Problem 09-43 Student Name:
Class:
FreshPak Corporaton
Master Budget
1. Sales Budget:
Box C Box P Total
Sales (in units) #REF! ###
Sales price per unit #REF! ###
Sales revenue #REF!
2. Production Budget (in units):
Box C Box P
Sales #REF! ###
Add: Desired ending inventory #REF! ###
Total units needed #REF! ###
Deduct: Beginning inventory #REF! ###
Production requirements #REF! ###
3. Raw material budget:
PAPERBOARD
Box C Box P Total
Production requirements (number of boxes) #REF! ###
Raw material required per box (pounds) #REF! ###
Raw material required for production (pounds) #REF! ###
Add: Desired ending raw-material inventory
Total raw-material needs
Deduct: Beginning raw-material inventory
Raw material to be purchased
Price (per pound)
Cost of purchases (paperboard)
CORRUGATING MEDIUM
Box C Box P Total
Production requirements (number of boxes) #REF! ###
Raw material required per box (pounds) #REF! ###
Raw material required for production (pounds) #REF! ###
Add: Desired ending raw-material inventory
Total raw-material needs
Deduct: Beginning raw-material inventory
Raw material to be purchased
Price (per pound)
Cost of purchases (corrugating medium)
Total cost of raw-material purchases
4. Direct labor budget:
Box C Box P Total
Production requirements (number of boxes) #REF! ###
Direct labor required per box (hours) #REF! ###
Direct labor required for production (hours) #REF! ###
Direct-labor rate
Total direct-labor cost
5. Manufacturing overhead budget:
Indirect material #REF!
Indirect labor #REF!
Utilities #REF!
Property taxes #REF!
Insurance #REF!
Depreciation #REF!
Total overhead #REF!
6. Selling and administrative expense budget:
Salaries and fringe benefits of sales personnel #REF!
Advertising #REF!
Management salaries and fringe benefits #REF!
Clerical wages and fringe benefits #REF!
Miscellaneous administrative expenses #REF!
Total selling and administrative expenses #REF!
7. Budgeted income statement:
Sales revenue ###
Less: Cost of goods sold:*
Box C #REF!
Box P #REF! ###
Gross margin ###
Selling and administrative expenses ###
Income before taxes ###
Income tax expense ###
Net income ###
*Calculation of cost of goods sold:
(a) Predetermined overhead rate
Budgeted manufacturing overhead rate #REF!
Volume of direct-labor hours #REF!
Rate per hour #REF!
(b) Calculation of manufacturing cost per unit:
Box C Box P
Direct material
Paperboard #REF! ###
Corrugating medium #REF! ###
Direct labor #REF! ###
Applied manufacturing overhead #REF! ###
Manufacturing cost per unit #REF! ###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
Problem 09-43 Student Name: Instructor
Class: McGraw-Hill/Irwin
FreshPak Corporaton
Master Budget
1. Sales Budget:
Box C Box P
Sales (in units) 500,000 500,000
Sales price per unit $ 0.90 $ 1.30
Sales revenue $450,000 $ 650,000
2. Production Budget (in units):
Box C Box P
Sales 500,000 500,000
Add: Desired ending inventory 5,000 15,000
Total units needed 505,000 515,000
Deduct: Beginning inventory 10,000 20,000
Production requirements 495,000 495,000
3. Raw material budget:
PAPERBOARD
Box C Box P
Production requirements (number of boxes) 495,000 495,000
Raw material required per box (pounds) 0.30 0.70
Raw material required for production (pounds) 148,500 346,500
Add: Desired ending raw-material inventory
Total raw-material needs
Deduct: Beginning raw-material inventory
Raw material to be purchased
Price (per pound)
Cost of purchases (paperboard)
CORRUGATING MEDIUM
Box C Box P
Production requirements (number of boxes) 495,000 495,000
Raw material required per box (pounds) 0.20 0.30
Raw material required for production (pounds) 99,000 148,500
Add: Desired ending raw-material inventory
Total raw-material needs
Deduct: Beginning raw-material inventory
Raw material to be purchased
Price (per pound)
Cost of purchases (corrugating medium)
Total cost of raw-material purchases
4. Direct labor budget:
Box C Box P
Production requirements (number of boxes) 495,000 495,000
Direct labor required per box (hours) 0.0025 0.0050
Direct labor required for production (hours) 1,237.5 2,475.0
Direct-labor rate
Total direct-labor cost
5. Manufacturing overhead budget:
Indirect material $ 10,500
Indirect labor 50,000
Utilities 25,000
Property taxes 18,000
Insurance 16,000
Depreciation 29,000
Total overhead $148,500
6. Selling and administrative expense budget:
Salaries and fringe benefits of sales personnel $ 75,000
Advertising 15,000
Management salaries and fringe benefits 90,000
Clerical wages and fringe benefits 26,000
Miscellaneous administrative expenses 4,000
Total selling and administrative expenses $210,000
7. Budgeted income statement:
Sales revenue $1,100,000
Less: Cost of goods sold:*
Box C 105,000
Box P 215,000 320,000
Gross margin $ 780,000
Selling and administrative expenses 210,000
Income before taxes $ 570,000
Income tax expense 228,000
Net income $ 342,000
*Calculation of cost of goods sold:
(a) Predetermined overhead rate
Budgeted manufacturing overhead rate $148,500
Volume of direct-labor hours 3,712.50
Rate per hour $ 40
(b) Calculation of manufacturing cost per unit:
Box C Box P
Direct material
Paperboard $0.06 $0.14
Corrugating medium 0.02 0.03
Direct labor 0.03 0.06
Applied manufacturing overhead 0.10 0.20
Manufacturing cost per unit $0.21 $0.43
ructor
Graw-Hill/Irwin
Total
$1,100,000
Total
495,000
5,000
500,000
15,000
485,000
$ 0.20
$ 97,000
Total
247,500
10,000
257,500
5,000
252,500
$ 0.10
$ 25,250
$ 122,250
Total
3,712.5
$ 12
$ 44,550