Question

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 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 5,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.40 direct labor-hours and direct laborers are paid $13.50 per hour.

Required: (SHOW ALL WORK)

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. Assume that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the estimated number of units produced.

Answer 1

	1&2	Raw Material Budget:
			1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	Year
		Units to be produced	12,000	15,000	14,000	13,000	54,000
		Raw Material Required PU	5	5	5	5	5
		Raw Material Required for Production	60000	75000	70000	65000	270000
		Add: Desired Closing Inventory for RM	18750	17500	16250	5000	5000	(25% of Next Qtr Requirement)
		Total Required RM	78750	92500	86250	70000	275000
		Less: Opening Inventory of RM	15000	18750	17500	16250	15000
	a	Net Raw Material to be Purchased	63750	73750	68750	53750	260000
	b	Raw Material Cost Per Gram	1.80	1.80	1.80	1.80	1.80
	a*b	Raw Material Cost	114750	132750	123750	96750	468000
	3	Cash Disbursement for Purchases:	1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	Year
		For the Quarter Puchases(60%)	68850	79650	74250	58050	280800
		In the Next Quarter for Previous Qtr(40%)	6200	45900	53100	49500	154700
		Total Payments	75050	125550	127350	107550	435500
	4	Direct Labor Budget:	1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	Year
		Units to be produced	12,000	15,000	14,000	13,000	54,000
		Labor Required PU	0.40	0.40	0.40	0.40	0.40
		Required DLHs	4800	6000	5600	5200	21600
		Rate Per DLH	13.50	13.50	13.50	13.50	13.50
		Direct Labor Cost	64800	81000	75600	70200	291600