Ch 7 Homework O 5 Help Save & Exit Submit Check my work Layout More Tableau DA 7-1: Quick Study, Prepare direct materials budget LO P1 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 1,200- Sales Forecast 900- 600 300- Budgeted Production Sales Forecast April May June July w Roman Styles None cing Text Layout Morm 5 LO March way Ending Direct Materials Inventory by Month Book April May References June Solve for this value Solve for this value Solve for this value 400 800 1200 1600 2000 Direct Materials (Pounds) Direct labor rate Direct materials cost Variable overhead rate 69 Check my work Layout More w Roman Styles None cing Text +ableau 1. Calculate materials needed (in pounds) for production in each month of April, May, and June. 2. Prepare direct materials budget for the month of April Layout New Roman More points P +ableau More w Roman < P 12 pm U - Styles None 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 21 Caculate materials needed (in pounds) for production in each month of April, May, and June Units to produce DELRAY MANUFACTURING Direct Materials Needed For April, May, and J Ap May ing 880 1,100 1.075 uns Materials needed for production() Required 2 > Text Layout More New Roman 0 12 pt 2 +ableau 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. book - Required 1 Required 2 References Prepare a direct materials budget for the month of April. Units to produce DELRAY MANUFACTURING Direct Materials Budget For April Materials needed for production (b) Total matinals required (b) Materials to purchase (b) Materials cost per pound Cost of direct materials purchases Required 1 830 PE w Roman U 9 Styles None Fal Text Layout New Roman