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

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

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

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

MARIGOLD COMPANY Direct Materials Budget For the Quarter Ending June 30, 2017June 30, 2017For the Six Months Ending June 30, 2017
		Quarter
		1		2		Six Months
Beginning Direct MaterialsTotal Direct Labor CostUnits to be ProducedDirect Labor Cost Per HourCost Per PoundTotal Materials RequiredTotal Cost of Direct Materials PurchasesTotal Required Direct Labor HoursDirect Materials Per UnitDirect Materials PurchasesDirect Labor Time Per UnitDesired Ending Direct MaterialsTotal Pounds Needed for Production
Total Pounds Needed for ProductionCost Per PoundBeginning Direct MaterialsDesired Ending Direct MaterialsUnits to be ProducedDirect Labor Cost Per HourTotal Cost of Direct Materials PurchasesTotal Direct Labor CostTotal Materials RequiredDirect Materials PurchasesTotal Required Direct Labor HoursDirect Materials Per UnitDirect Labor Time Per Unit
Cost Per PoundDirect Labor Cost Per HourBeginning Direct MaterialsTotal Materials RequiredTotal Cost of Direct Materials PurchasesTotal Direct Labor CostTotal Required Direct Labor HoursDirect Materials Per UnitDesired Ending Direct MaterialsDirect Labor Time Per UnitUnits to be ProducedTotal Pounds Needed for ProductionDirect Materials Purchases
AddLess: Direct Materials Per UnitTotal Cost of Direct Materials PurchasesCost Per PoundUnits to be ProducedBeginning Direct MaterialsTotal Required Direct Labor HoursDesired Ending Direct MaterialsDirect Labor Time Per UnitTotal Pounds Needed for ProductionDirect Materials PurchasesDirect Labor Cost Per HourTotal Materials RequiredTotal Direct Labor Cost
Direct Labor Cost Per HourTotal Direct Labor CostDesired Ending Direct MaterialsBeginning Direct MaterialsDirect Labor Time Per UnitTotal Pounds Needed for ProductionTotal Cost of Direct Materials PurchasesCost Per PoundTotal Materials RequiredTotal Required Direct Labor HoursDirect Materials Per UnitUnits to be ProducedDirect Materials Purchases
AddLess: Cost Per PoundTotal Pounds Needed for ProductionTotal Direct Labor CostDesired Ending Direct MaterialsDirect Labor Cost Per HourDirect Materials Per UnitDirect Materials PurchasesTotal Materials RequiredUnits to be ProducedDirect Labor Time Per UnitTotal Cost of Direct Materials PurchasesTotal Required Direct Labor HoursBeginning Direct Materials
Direct Materials PurchasesTotal Required Direct Labor HoursTotal Materials RequiredDirect Materials Per UnitTotal Cost of Direct Materials PurchasesUnits to be ProducedBeginning Direct MaterialsDesired Ending Direct MaterialsDirect Labor Time Per UnitCost Per PoundTotal Pounds Needed for ProductionTotal Direct Labor CostDirect Labor Cost Per Hour
Direct Materials Per UnitTotal Direct Labor CostDirect Labor Time Per UnitDirect Materials PurchasesTotal Materials RequiredCost Per PoundDirect Labor Cost Per HourTotal Required Direct Labor HoursUnits to be ProducedBeginning Direct MaterialsTotal Pounds Needed for ProductionTotal Cost of Direct Materials PurchasesDesired Ending Direct Materials		$		$
Direct Labor Time Per UnitTotal Cost of Direct Materials PurchasesTotal Required Direct Labor HoursCost Per PoundDirect Materials Per UnitDesired Ending Direct MaterialsTotal Pounds Needed for ProductionBeginning Direct MaterialsTotal Direct Labor CostUnits to be ProducedTotal Materials RequiredDirect Labor Cost Per HourDirect Materials Purchases		$		$		$