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 ses Budgeted Production Sales Forecast 1.200 Budgeted Production 900 Sales Forecast 600 300 0 April MY July Sales Forecast & Production Budget (in Units) -,500 Budgeted Production Sales Forecast 1,200 Budgeted Production 900 July Budgeted Production: 1,125 units Sales Forecast 600 300 O April May June July Sales Forecast & Production Budget (in Units) 1,500 | Budgeted Production Sales Forecast 1,200 Budgeted Production 900 June Sales Forecast: 1,025 units Sales Forecast 600 300 Anril 1 ulu Sales Forecast & Production Budget (in Units) 1,500 Budgeted Production Sales Forecast 1,200 Budgd 900 May Budgeted Production: 1,100 units Sales Forecast 600 300 o April May June July 1,500 Budgeted Production Sales Forecast 1,200 Budgeted Production 900 April Budgeted Production: 880 units ecast 600.. 300 0 April May June July Sales Forecast & Production Budget (in Units) 1,500 Budgeted Production Sales Forecast 1,200 Budgeted Production 900 June Budgeted Production: 1.075 units Sales Forecast 600 300 April May June July Sales Forecast & Production Budget (in Units) 500 Budgeted Production Sales Forecast .200 Budgeted Production 900 May Sales Fore Sales Forecast: 900 units 600 300 0 April May June July Sales Forecast & Production Budget (in Units) 1,500 Budgeted Production Sales Forecast 1,200 Budgeted Production 900 Sales Forecast July Sales Forecast: 875 units 600 300 0 April May June July Sales Forecast & Production Budget (in Units) 1,500 Budgeted Production Sales Forecast 1,200 Budgeted Production 900 Sales Forecast 600 April Sales Forecast: 805 units 300 0 April May June July Sales Forecast & Production Budget (in Units) Led Production orecast Budgeted Production July Budgeted Production: 1,125 units Sales Forecast May June July Budgeted Production Sales Forecast Budgeted Production Sales Forecast June Sales Forecast: 1,025 units 0 0 June July April May 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 2000 Direct Materials (Pounds) Ending Direct Materials Inventory by Month March April March Solve for this value Direct Materials (pounds): 1,408 pounds May Solve for this value June Solve for this value 400 1600 2000 800 1200 Direct Materials (Pounds) Direct labor rate Direct materials cost Variable overhead rate Direct labor rate Direct materials cost Variable overhead rate Hith Direct labor rate: $18 per hour Direct labor rate Direct materials cost Variable overhead rate Hall Direct materials cost: $3 per pound Direct labor rate Direct materials cost Variable overhead rate Variable overhead rate (based on direct labor hours): $25 per direct labor hour 1. Calculate materials needed (in pounds) for production in each month of April, May, and June 2. Prepare a direct materials budget for the month of April. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Calculate materials needed (in pounds) for production in each month of April, May, and June DELRAY MANUFACTURING Direct Materials Needed For April, May, and June April 880 Uuno Budget production (unit) May 1 100 1075 units Materials needed for production (lbs) Required 2 > Complete this question by entering your answers in the tabs below. Required 1 Required 2 Prepare a direct materials budget for the month of April. DELRAY MANUFACTURING Direct Materials Budget For April Budget production (units) 880 units Materials needed for production (lbs.) Total materials requirements (lbs.) Materials to be purchased (lbs.) Materials price per pound Budgeted cost of direct materials purchases