Question

DeWitt Industries has adopted the following production budget for the first 4 months of 2017. Month Units Month Units January 10,440 March 5,190 February 8,240 April 4,120 Each unit requires 3 pounds of raw materials costing $2 per pound. On December 31, 2016, the ending raw materials inventory was 9,500 pounds. 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.

Answer 1

Answer:

DeWitt Industries

Materials Purchase Budget for the first quarter:

                                   January      February     March

Ending inventory          1,648            1,038           824

Production

requirements            31,320         24,720       15,570

Beginning inventory   9,500            1,648         1,038

Purchases (pounds)  21,820         23,072       14,532

Explanation:

a) Data and Calculations:

Production Budget

Month        Units

January    10,440

February   8,240

March        5,190

April          4,120

                               January      February     March       April

Production Units     10,440          8,240        5,190      4,120

Production

requirements        31,320        24,720       15,570   12,360

Materials Purchase Budget

                                   January      February     March       April

Ending inventory          1,648            1,038           824

Production

requirements            31,320         24,720       15,570      12,360

Beginning inventory   9,500            1,648         1,038           824

Purchases (pounds)  21,820         23,072       14,532       11,536