Question

On January 1, 2020, the Hardin Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2020.

Sales units:		First quarter 5,400; second quarter 7,000; third quarter 7,600.
Ending raw materials inventory:		40% of the next quarter’s production requirements.
Ending finished goods inventory:		25% of the next quarter’s expected sales units.
Third-quarter production:		7,840 units.

The ending raw materials and finished goods inventories at December 31, 2019, follow the same percentage relationships to production and sales that occur in 2020. 4 pounds of raw materials are required to make each unit of finished goods. Raw materials purchased are expected to cost $6 per pound.

Prepare a production budget by quarters for the 6-month period ended June 30, 2020.

HARDIN COMPANY Production Budget                                                                       For the Six Months Ending June 30, 2020June 30, 2020For the Quarter Ending June 30, 2020
	Quarter
		1		2		Six Months
Desired Ending Direct MaterialsTotal Materials RequiredDirect Materials PurchasesBeginning Finished Goods UnitDirect Materials Per UnitBeginning Direct MaterialsRequired Production UnitsTotal Required UnitsExpected Unit SalesDesired Ending Finished Goods Unit
AddLess:                                                                       Expected Unit SalesDirect Materials Per UnitTotal Required UnitsDirect Materials PurchasesDesired Ending Finished Goods UnitTotal Materials RequiredRequired Production UnitsBeginning Direct MaterialsDesired Ending Direct MaterialsBeginning Finished Goods Unit
Direct Materials Per UnitDesired Ending Direct MaterialsTotal Materials RequiredRequired Production UnitsBeginning Direct MaterialsExpected Unit SalesDirect Materials PurchasesTotal Required UnitsBeginning Finished Goods UnitDesired Ending Finished Goods Unit
AddLess:                                                                       Total Required UnitsExpected Unit SalesDesired Ending Finished Goods UnitTotal Materials RequiredDesired Ending Direct MaterialsBeginning Direct MaterialsDirect Materials PurchasesBeginning Finished Goods UnitDirect Materials Per UnitRequired Production Units
Desired Ending Finished Goods UnitDesired Ending Direct MaterialsExpected Unit SalesRequired Production UnitsBeginning Direct MaterialsTotal Materials RequiredDirect Materials PurchasesDirect Materials Per UnitBeginning Finished Goods UnitTotal Required Units

  

  

Prepare a direct materials budget by quarters for the 6-month period ended June 30

HARDIN COMPANY Direct Materials Budget                                                                       June 30, 2020For the Six Months Ending June 30 For the Quarter Ending June 30
		Quarter
		1		2		Six Months
		$		$
		$		$		$

Answer 1

	*Working Notes:
	*Calculations for materials needed for production:
	Particulars	Quarter 3
	Units to be produced	7840
	(X) Direct materials per unit	4
	Total pounds needed for production	31360
	*Beginning materials inventory for first quarter (2020) = Ending materials inventory of previous quarter (2019) = 40% of current quarter's pounds needed for production
	23,200 * 40%
	9280
	*Calculations for Ending inventory:			*Calculations for Beginning inventory:
Months				Months
Q 1	28,600 * 40%	11440		Q 1	(calculated as above)	9280
Q 2	31,360 * 40%	12544		Q 2	Ending inventory of Q 1	11440