Delray Manufacturing needs to better budget and analyze costs. While Delray has experienced high sales growth, it has struggled to effectively manage costs and inventories. Delray aims to end each month with direct materials inventory equal to 40% of next month's production needs. Each finished unit requires 4 pounds of direct materials and 2 hours of direct labor. Delray budgets $12,000 of fixed overhead costs per month. A Tableau Dashboard is provided to aid our analysis. Sales Forecast & Production Budget (in Units) 1,500 Budgeted Production Sales Forecast 1,200 Budgeted Production 900 Sales Forecast 600 300 0 April May June July Ending Direct Materials Inventory by Month March Ending Direct Materials Inventory by Month March April Solve for this value May Solve for this value June Solve for this value 400 800 1200 1600 200d Direct Materials (Pounds) Direct labor rate Direct materials cost Variable overhead rate Hub # tableau T- O 1. Prepare a direct materials budget for each month of April, May, and June. 2. Assume the company decides to end each month with direct materials inventory equal to 35% of next month's production needs, instead of 40%. How will this decision impact the budgeted cost of direct materials for April? Required 1 Required 2 Prepare a direct materials budget for each month of April, May, and June. DELRAY MANUFACTURING Direct Materials Budget For April, May, and June April May June Units to produce 880 1,100 1,075 units Materials needed for production (lbs.) Total materials required (lbs.) 0 0 0 0 Materials to purchase (lbs.) Materials cost per pound Cost of direct materials purchases Required 1 Required 2 Assume the company decides to end each month with direct materials inventory equal to 35% of next month's production needs, instead of 40%. How will this decision impact the budgeted cost of direct materials for April? How will this decision impact the budgeted cost of direct materials for April