Question

Mattison manufactures two products: A and B. The company predicts a sales volume of 20,000 units for product A and desired ending finished-goods inventory of 1,000 units. These numbers for product B are 25,000 and 3,000, respectively. Mattison currently has 7,000 units of A in inventory and 9,000 units of B. The unit selling price for A and B are $250 and $200 respectively.
The following raw materials are required to manufacture these products:

Raw Material	Cost Per Pound	Required for Product A	Required for Product B	Desired ending direct materials	Beginning direct materials
X	$2.00	3 pounds	1 pound	1,800	5,000
Y	$4.50	2 pound	5 pounds	1,200	7,000

Product A requires 4 hours of labor; B requires 3 hours. The direct labor rate is $12 per hour.

An accounting assistant has prepared the detailed production overhead budget and the selling and administrative budget. The production overhead budget shows:

Variable cost of $2 per unit produced for both products

Fixed cost of $40,000 for product A and $50,000 for product B

Production overhead is applied on the basis of direct labor.

The selling and administrative budget shows:

Variable cost of $3 per unit sold for both products

Fixed cost of $50,000 for product A and $70,000 for product B

Prepare a raw material budget for materials X, and Y for product A and B

Answer 1

Number of units need to be produced of Product A and B
Product	A	B
Opening inventory (A)	7,000	9,000
Budgeted Sales (B)	20,000	25,000
Closing desired (C)	1,000	3,000
Production requires (B+C-A)	14,000	19,000
Number of Raw material X need to be purchased
	A	B
Opening (A)			5,000
Used for Production (B)	42,000	19,000	61,000
	(14000*3)	(19,000*1)
Closing desired (C)			1,800
Purchase required = (B+C-A)			57,800
Number of Raw material Y need to be purchased
	A	B
Opening (A)			7,000
Used for Production (B)	28,000	95,000	1,23,000
	(14000*2)	(19,000*5)
Closing desired (C)			1,200
Purchase required = (B+C-A)			1,17,200
Raw Material Budget
	Units purchased	Costs	Total Cost
Material X	57,800	2	1,15,600
Material Y	1,17,200	4.5	5,27,400