how do i do question 3 using the date above?

Places: ZIGBY MANUFACTURING Raw Materials Budget April, May, and June 2019 May April June Total 18,320 20,940 22,940 0.50 0.50 0.50 9,160 11.470 5,235 Production budget (units) Materials requirements per unit Materials needed for production Budgeted ending inventory Total materials requirements (units) Beginning inventory Materials to be purchased Material price per unit Budgeted raw material purchases 14,395 10,470 5,735 16,205 (5,235) 10,970 20 > (4,580) 9,815 20 5,700 17,170 (5,735) 11,435 20 32,220 20 $ $ $ $ $ 196,300 $ 219,400 228,700 $ 644,400 3) To conserve cash, the purchasing manager has asked to reduce April and May's ending raw materials inventory to equal 30% (down from 50%) of next month's materials requirements, June ending raw materials inventory will remain unchanged (same as on connect). Note - This % changes the calculation of required ENDING INVENTORY of raw material (row 4 of the table) and DOES NOT change the raw material required per unit of production (row 2). This table is completed similarly to the budget table in connect. Additionally, the purchase department has negotiated a 5% discount on raw material if they purchases exceed 10,000 pounds in any given month. The 5% will be only for the pounds purchased over 10,000. (Pounds of material purchased 10,000 pounds x $20 per pound 5% Calculate the Discount for each month and calculate the "net" purchase amount Project 4: Page 2 of 11 Double-click to hide white space Total June 44,840 .50 .50 22,420 ZIGBY MANUFACTURING Revised Raw Materials Budget April May Production budget (units) 26,320 38,040 Materials requirements per unit .50 (unchanged from connect) Materials needed for production 13,160 19,020 Budgeted ending inventory Total materials requirements (units) Beginning inventory Materials to be purchased Material price per unit 20 Raw Material purchases before Discount Discount (5% of purchases exceeding 10,000 lbs) Budgeted raw material purchases