SOLUTION
(A) Production Budget-
|
January |
February |
March |
Total |
Expected unit sales |
10,000 |
8,000 |
9,000 |
|
Add: Desired ending finished goods units |
1,600 |
1,800 |
2,200 |
|
Total required units |
11,600 |
9,800 |
11,200 |
|
Less: Beginning finished goods units |
2,000 |
1,600 |
1,800 |
|
Required production units |
9,600 |
8,200 |
9,400 |
27,200 |
*April units: 11,000 * 20% = 2,200
Desired ending finished goods units = 20% * Next months
sales
January = 8,000*20% = 1,600
February = 9,000*20%= 1,800
March = 11,000*20% =2,200
(B) Direct Materials Budget-
|
January |
February |
March |
Total |
Units to be produced |
9,600 |
8,200 |
9,400 |
|
Direct materials per unit |
3 |
3 |
3 |
|
Total pounds needed for production |
28,800 |
24,600 |
28,200 |
|
Desired ending direct materials (pounds) |
7,380 |
8,460 |
10,620 |
|
Total materials required |
36,180 |
33,060 |
38,820 |
|
Less: Beginning direct materials (pounds) |
8,640 |
7,380 |
8,460 |
|
Direct materials purchases |
27,540 |
25,680 |
30,360 |
|
Cost per pound |
$4 |
$4 |
$4 |
|
Total cost of direct materials purchases |
110,160 |
102,720 |
121,440 |
334,320 |
**April units: 11,800 * 3 = 35,400 * 30% =
10,620