DeWitt Industries has adopted the following production budget for the first 4 months of 2017.

Month	Units	Month	Units
January	10,110	March	5,390
February	8,370	April	4,140

Each unit requires5pounds of raw materials costing $2per pound. On December 31, 2016, the ending raw materials inventory was10,110pounds. Management wants to have a raw materials inventory at the end of the month equal to 20% of next month?s production requirements.

Prepare a direct materials purchases budget by month for the first quarter.

DEWITT INDUSTRIES Direct Materials Purchases Budget

For the Quarter Ending March 31, 2017March 31, 2017For the Month Ending March 31, 2017

January

February

March

Direct Labor Cost Per HourTotal Required Direct Labor HoursDirect Materials PurchasesTotal Pounds Needed for ProductionUnits to be ProducedTotal Direct Labor CostDirect Labor Time Per UnitBeginning Direct MaterialsTotal Materials RequiredDirect Materials Per UnitDesired Ending Direct MaterialsTotal Cost of Direct Materials PurchasesCost Per Pound

Total Direct Labor CostDirect Materials PurchasesCost Per PoundTotal Materials RequiredTotal Pounds Needed for ProductionDirect Materials Per UnitDirect Labor Cost Per HourTotal Cost of Direct Materials PurchasesTotal Required Direct Labor HoursDesired Ending Direct MaterialsUnits to be ProducedBeginning Direct MaterialsDirect Labor Time Per Unit

Total Required Direct Labor HoursCost Per PoundUnits to be ProducedTotal Direct Labor CostBeginning Direct MaterialsDesired Ending Direct MaterialsDirect Labor Cost Per HourDirect Materials Per UnitDirect Labor Time Per UnitTotal Cost of Direct Materials PurchasesDirect Materials PurchasesTotal Materials RequiredTotal Pounds Needed for Production

AddLess

:

Total Required Direct Labor HoursDirect Materials Per UnitDesired Ending Direct MaterialsTotal Cost of Direct Materials PurchasesDirect Materials PurchasesDirect Labor Time Per UnitTotal Direct Labor CostDirect Labor Cost Per HourTotal Materials RequiredCost Per PoundTotal Pounds Needed for ProductionUnits to be ProducedBeginning Direct Materials

Total Required Direct Labor HoursCost Per PoundUnits to be ProducedBeginning Direct MaterialsTotal Cost of Direct Materials PurchasesDirect Labor Time Per UnitTotal Materials RequiredTotal Pounds Needed for ProductionDirect Materials Per UnitDirect Materials PurchasesDesired Ending Direct MaterialsDirect Labor Cost Per HourTotal Direct Labor Cost

AddLess

:

Beginning Direct MaterialsDirect Labor Time Per UnitTotal Materials RequiredTotal Cost of Direct Materials PurchasesDirect Labor Cost Per HourCost Per PoundDesired Ending Direct MaterialsTotal Pounds Needed for ProductionTotal Direct Labor CostDirect Materials PurchasesDirect Materials Per UnitTotal Required Direct Labor HoursUnits to be Produced

Direct Labor Time Per UnitDirect Materials Per UnitDirect Materials PurchasesTotal Materials RequiredTotal Cost of Direct Materials PurchasesTotal Direct Labor CostTotal Pounds Needed for ProductionTotal Required Direct Labor HoursUnits to be ProducedBeginning Direct MaterialsDesired Ending Direct MaterialsCost Per PoundDirect Labor Cost Per Hour

Units to be ProducedTotal Cost of Direct Materials PurchasesTotal Materials RequiredDesired Ending Direct MaterialsDirect Materials PurchasesTotal Direct Labor CostDirect Labor Cost Per HourDirect Labor Time Per UnitBeginning Direct MaterialsTotal Pounds Needed for ProductionCost Per PoundDirect Materials Per UnitTotal Required Direct Labor Hours

$

$

$

Direct Labor Time Per UnitDirect Materials PurchasesDesired Ending Direct MaterialsTotal Materials RequiredDirect Labor Cost Per HourTotal Cost of Direct Materials PurchasesDirect Materials Per UnitTotal Direct Labor CostTotal Pounds Needed for ProductionTotal Required Direct Labor HoursBeginning Direct MaterialsUnits to be ProducedCost Per Pound

$

$

$