Question

In: Accounting

The production department of Zan Corporation has submitted the following forecast of units to be produced...

The production department of Zan Corporation has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year:

1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
Units to be produced 21,000 24,000 23,000 22,000

In addition, 21,000 grams of raw materials inventory is on hand at the start of the 1st Quarter and the beginning accounts payable for the 1st Quarter is $8,000.

Each unit requires 4 grams of raw material that costs $1.20 per gram. Management desires to end each quarter with an inventory of raw materials equal to 25% of the following quarter’s production needs. The desired ending inventory for the 4th Quarter is 8,000 grams. Management plans to pay for 60% of raw material purchases in the quarter acquired and 40% in the following quarter. Each unit requires 0.20 direct labor-hours and direct laborers are paid $12.50 per hour.

Required:

1.&2. Calculate the estimated grams of raw material that need to be purchased and the cost of raw material purchases for each quarter and for the year as a whole.

3. Calculate the expected cash disbursements for purchases of materials for each quarter and for the year as a whole.

4. Calculate the estimated direct labor cost for each quarter and for the year as a whole.

Solutions

Expert Solution

Requirement 1.

Direct Materials Budget
Quarter
1st 2nd 3rd 4th Year
Requried production in units 21,000 24,000 23,000 22,000 90,000
Grams of raw materials needed per unit 4 4 4 4 4
Gram of raw materials needed to meet production 84,000 96,000 92,000 88,000 360,000
Add: Desired gram of ending raw materials inventory 24,000 23,000 22,000 8,000 8,000
Total grams of raw materials needed 108,000 119,000 114,000 96,000 368,000
Less: Beginning raw materials inventory 21,000* 24,000 23,000 22,000 21,000*
Grams of raw materials to be purchased 87,000 95,000 91,000 74,000 347,000
Cost of raw materials per gram $1.20 $1.20 $1.20 $1.20 $1.20
Cost of raw materials to be purchased $104,400 $114,000 $109,200 $88,800 $416,400

25% of the next quarter's production needs. For example, the second-quarter production needs are 96,000 grams. Therefore, the desired ending inventory for the first quarter would be 24,000 grams (96,000 25%).

Requirement 2.

Schedule of Expected Cash Disbursements for purchases of Materials
1st 2nd 3rd 4th Year
Beginning accounts payable $8,000 $8,000
First quarter purchases 62,640 $41,760 104,400
Second quarter purchases 68,400 $45,600 114,000
Third quarter purchases 65,520 $43,680 109,200
Fourth quarter purchases 53,280 53,280
Total cash disbursements for materials $70,640 $110,160 $111,120 $96,960 388,880

Beginning accounts payable $8000, cash payments for the last year's fourth-quarter purchases.

$62,640 ($104,400 60%); $41,760 ($104,400 40%)

$68,400 ($114,000 60%); $45,600 ($114,000 40%)

$65,520 ($109,200 60%); $43,680 ($109,200 40%)

$53,280 ($88,800 60%)

Requirement 3.

Direct Labor Budget
1st 2nd 3rd 4th Year
Required production 21,000 24,000 23,000 22,000 90,000
Direct labor hours per unit 0.20 0.20 0.20 0.20 0.20
Total direct labor-hours needed 4,200 4,800 4,600 4,400 18,000
Direct labor cost per hour $12.50 $12.50 $12.50 $12.50 $12.50
Total direct labor cost $52,500 $60,000 $57,500 $55,000 225,000

Related Solutions

The production department of Zan Corporation has submitted the following forecast of units to be produced...
The production department of Zan Corporation has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Units to be produced 12,000 15,000 14,000 13,000 In addition, 15,000 grams of raw materials inventory is on hand at the start of the 1st Quarter and the beginning accounts payable for the 1st Quarter is $6,200. Each unit requires 5 grams of raw material that costs $1.80 per...
The production department of Zan Corporation has submitted the following forecast of units to be produced...
The production department of Zan Corporation has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: 1st Quarter2nd Quarter3rd Quarter4th Quarter Units to be produced24,00027,00026,00025,000 In addition, 42,000 grams of raw materials inventory is on hand at the start of the 1st Quarter and the beginning accounts payable for the 1st Quarter is $8,600. Each unit requires 7 grams of raw material that costs $1.80 per gram. Management desires to end each quarter...
The production department of Zan Corporation has submitted the following forecast of units to be produced...
The production department of Zan Corporation has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Units to be produced 5,000 8,000 7,000 6,000 In addition, 6,000 grams of raw materials inventory is on hand at the start of the 1st Quarter and the beginning accounts payable for the 1st Quarter is $2,880. Each unit requires 8 grams of raw material that costs $1.20 per...
The production department of Zan Corporation has submitted the following forecast of units to be produced...
The production department of Zan Corporation has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Units to be produced 12,000 15,000 14,000 13,000 In addition, 15,000 grams of raw materials inventory is on hand at the start of the 1st Quarter and the beginning accounts payable for the 1st Quarter is $6,200. Each unit requires 5 grams of raw material that costs $1.80 per...
The production department of Zan Corporation has submitted the following forecast of units to be produced...
The production department of Zan Corporation has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Units to be produced 5,600 8,600 7,600 6,600 In addition, 6,600 grams of raw materials inventory is on hand at the start of the 1st quarter and the beginning accounts payable for the 1st quarter is $3,480. Each unit requires 8.60 grams of raw material that costs $1.20 per...
The production department of Zan Corporation has submitted the following forecast of units to be produced...
The production department of Zan Corporation has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Units to be produced 25,000 28,000 27,000 26,000 In addition, 50,000 grams of raw materials inventory is on hand at the start of the 1st Quarter and the beginning accounts payable for the 1st Quarter is $8,800. Each unit requires 8 grams of raw material that costs $1.20 per...
The production department of Zan Corporation has submitted the following forecast of units to be produced...
The production department of Zan Corporation has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Units to be produced 17,000 20,000 19,000 18,000 In addition, 21,250 grams of raw materials inventory is on hand at the start of the 1st Quarter and the beginning accounts payable for the 1st Quarter is $7,200. Each unit requires 5 grams of raw material that costs $1.20 per...
The production department of Zan Corporation has submitted the following forecast of units to be produced...
The production department of Zan Corporation has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Units to be produced 24,000 27,000 26,000 25,000 In addition, 42,000 grams of raw materials inventory is on hand at the start of the 1st Quarter and the beginning accounts payable for the 1st Quarter is $8,600. Each unit requires 7 grams of raw material that costs $1.80 per...
The production department of Zan Corporation has submitted the following forecast of units to be produced...
The production department of Zan Corporation has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Units to be produced 12,000 15,000 14,000 13,000 In addition, 15,000 grams of raw materials inventory is on hand at the start of the 1st Quarter and the beginning accounts payable for the 1st Quarter is $6,200. Each unit requires 5 grams of raw material that costs $1.80 per...
The production department of Zan Corporation has submitted the following forecast of units to be produced...
The production department of Zan Corporation has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Units to be produced 24,000 27,000 26,000 25,000 In addition, 42,000 grams of raw materials inventory is on hand at the start of the 1st Quarter and the beginning accounts payable for the 1st Quarter is $8,600. Each unit requires 7 grams of raw material that costs $1.80 per...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT