I included the answer I got previously which is not complete please give me an proper table with answer

View Policies Current Attempt In Progress Pronghorn Manufacturing manufactures two products. (1) Regular and (2) Deluxe. The budgeted units to be produced are as follows: Units of Product 2022 Regular Deluxe Total July 11.400 15,700 27.100 August 5.900 11.400 17.300 September 8.900 14.200 23.100 October 8,400 12,600 21.000 It takes 2 pounds of direct materials to produce the Regular product and 5 pounds of direct materials to produce the Deluxe product. It is the company's policy to maintain an inventory of direct materials at the end of each month equal to 30% of the next month's production needs for the Regular product and 20% of the next month's production needs for the Deluxe product. Direct materials inventory on hand at June 30were 6.840 pounds for the Regular product and 15.700 pounds for the Deluxe product. The cost per pound of materials is $6 for the Regular product and $9 for the Deluxe Prepare separate direct materials budgets for each product for the third quarter of 2022 PRONGHORNMANUFACTURING Direct Materials Budget-Regular July August 400 BUS PRONGHORNMANUFACTURING Direct Materials Budget -Regular July August 11400 Budgeted direct materials purchases Direct materials per unit 22800 6840 Beginning direct materials Inventory > 6840 3940 > > -14 E PRONGHORNMANUFACTURING Direct Materials Budget-Deluxe July August September Total TE 5 $ $ $ $ D e Textbook and Media Attempts:0 of 2 used in 32 RE GIH STAR BAN Answer 1 of 1 Done Product Regular - Direct material budget July August Budgeted production (units) 11.400 5.900 Direct material required (lbs) 22800 11500 September 8.900 17800 Beginning inventory (lbs) Ending inventory (15) Purchase of direct materialis Purchase cost 6.540 3540 19.500 1540 5340 13.600 50 5040 17.500 $ 117,000 $ 81,600 $ 105,000 Working Notes Direct material required (ibs) Budgeted production units material required per unit (lbs) Purchase of direct material (ibs) Direct material required. ending inventory beginning inventory Purchase cost Purchase of direct material (lbscost per pound 150 Product Deluxe - Direct material budget July August September Budgeted production (units) 15,700 11.400 24,200 Direct material requiredibs) 78500 57000 71000 Beginning inventory (lbs) Ending inventory (lbs) Purchase of direct material (lbs) 15,700 11400 74,200 15400 34900 59,800 34200 12,600 69.400 Purchase cost $ 667,800 $ 538,200 S 634,600 Working Notes Direct material required (lbs) = Budgeted production units material required per unit 5 lbs) Purchase of direct material (lbs) = Direct material required ending inventory beginning inventory Purchase cost = Purchase of direct material (lbs) * cost per pound (59