how do i do 4 usinf the data above?

Direct labor budget. (Round per unit values to 2 decimal places.) ZIGBY MANUFACTURING Direct Labor Budget April, May, and June 2019 April May 18,320 20,940 0.50 0.50 9,160 10,470 June Total 22,940 0.50 Budgeted production (units) Labor requirements per unit (hours) Total labor hours needed Direct labor rate (per hour) Budgeted direct labor cost 11,470 31,100 13 13 13 Is 13 s 119,080 $ 136,110 $ 149,110 $ 404,300 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 520 per pound Calculate the Discount for each month and calculate the "net" purchase amount I Project 4: Page 2 of 11 Total June 44,840 .50 ZIGBY MANUFACTURING Revised Raw Materials Budget April May Production budget (units) 26,320 38,040 Materials requirements per unit .50 .50 (unchanged from connect) Materials needed for production 13,160 19,020 Budgeted ending inventory 5,706 6,726 Total materials requirements (units 18,866 25,746 Beginning inventory (4,580) (5,706) Materials to be purchased 14,286 20,040 Material price per unit $20.00 $20.00 Raw Material purchases before $285,720 $400,800 Discount Discount (5% of purchases exceeding $4.286 $10,040 10.000 Budgeted raw material purchases $281.434 $390,760 22,420 5,700 28,120 (6 726) 21,394 55,720 $20.00 $20.00 $427,880 $1,114,400 $11.394 $25 720,00 $416,486 $1,088,680 4) To maintain moral among their employees, Zigby has agreed to pay employees a wage premium of $3 an hour for excess overtime. Excess overtime has been defined as any hours in excess of 13,000 hours in a month. The Direct Labor Budget will need to be updated for the changes to the production budget and the wage premium added for each month. This table is completed similarly to the budget table in connect. ZIGBY MANUFACTURING Revised Direct Labor Budget April May update June Total Budgeted production (units) Labor requirements per unit (hours) Total labor hours needed Direct labor rate (per hour) Base direct labor cost Wage premium (3xhours over 13,000) Total Budgeted direct labor costs