Create a Direct Materials purchase budget

Exercise 13-5 Bridgeport Industries has adopted the following production budget for the first 4 months of 2017. Month January February Units 10,230 March 5,450 4,290 8,200 April Each unit requires 5 pounds of raw materials costing $4 per pound. On December 31, 2016, the ending raw materials inventory was 9,400 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