Problem 9-29 Name:
Enter the appropriate numbers/formulas in the shaded (gray) cells.
An asterisk (*) will appear in the column to the right of an incorrect answer.
A.
Requird production (units) 2,100 2,600 2,300 7,000
Requird production (units) 2,450 2,100 2,175 6,725
Requird production (units) 1,450 1,200 1,350 4,000
Direct Labor Budget
June
Instructor
February
January
Total
2nd Quarter
March
Total
1st Quarter
April
May
July
August
Total
3rd Quarter
September
Requird production (units) 7,000 6,725 4,000 5,350 23,075
B.
Budget labor hours 1,050 1,300 1,150 3,500
Budget labor hours 1,225 1,050 1,088 3,363
October
November
Total
4th Quarter
June
4th Quarter
December
3rd Quarter
Total
Manufacturing Overhead Budget
January
February
March
Total
1st Quarter
1st Quarter
2nd Quarter
Total
2nd Quarter
April
May
Requird production (units) 1,750 1,550 2,050 5,350
Budget labor hours 725 600 675 2,000
Budget labor hours 875 775 1,025 2,675
Budget labor hours 3,500 3,363 2,000 2,675 11,538
December
July
August
September
Total
3rd Quarter
Total
Total
4th Quarter
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
October
November