Complete this question by entering your answers in the tabs below. Req 1 Req 2 Req 3A and 3B Req 4 For Year 2, prepare a direct labor budget for each month of April, May, and June. (Enter your direct labor hours (hrs.) per unit in two decimal places.) Important! Be sure to click the correct Year at the top of the dashboard. DELRAY MANUFACTURING Direct Labor Budget For April, May, and June Units to produce Direct labor hours needed Cost of direct labor April May June 1,760 2,200 2,150 units Complete this question by entering your answers in the tabs below. Req 1 Req 2 Req 3A and 3B Req 4 For Year 2, prepare a factory overhead budget for each month of April, May, and June. Important! Be sure to click the correct Year at the top of the dashboard. DELRAY MANUFACTURING Factory Overhead Budget Direct labor hours needed (part 1) Budgeted variable overhead Budgeted fixed overhead Budgeted total factory overhead For April, May, and June April May June Complete this question by entering your answers in the tabs below. Req 1 Req 2 Req 3A and 3B: Req 4 The company is considering hiring more skilled workers. These workers would increase the direct labor rate to $21 per hour and reduce direct labor hours required per finished good to 1.5 hours. For Year 2, compute the direct labor budget for April assuming the company (a) does not hire more skilled workers and (b) hires more skilled workers. Important! Be sure to click the correct Year at the top of the dashboard. Units to produce Direct labor hours needed Cost of direct labor DELRAY MANUFACTURING Direct Labor Budget for April Does Not Hire 1,760 Does Hire 1,760 units Show less 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. Select Year Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Sales Forecast & Production Budget (in Units) Budgeted Production 3,000- Sales Forecast 2,500- 2,000 1,500 1,000- April Budgeted Production: 1,760 units 500 April May June July Sales Forecast & Production Budget (in Units) Budgeted Production 3,000- Sales Forecast 2,500- 2,000- 1,500 1,000- 500 April April Sales Forecast: 1,610 units May June Ending Direct Materials Inventory by Month July Select Year Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 3,000 2,500 2,000- 1,500- 1,000 500 Sales Forecast & Production Budget (in Units) Budgeted Production Sales Forecast April May May Budgeted Production: 2,200 units June July Select Year Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Sales Forecast & Production Budget (in Units) Budgeted Production 3,000- Sales Forecast 2,500- 2,000- 1,500- 1,000- 500 April May May Sales Forecast: 1,800 units June July Select Year Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Sales Forecast & Production Budget (in Units) Budgeted Production 3,000 Sales Forecast 2,500 2,000 1,500 1,000 500 April May June June Budgeted Production: 2,150 units July Select Year Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Sales Forecast & Production Budget (in Units) Budgeted Production 3,000- Sales Forecast 2,500- 2,000- 1,500- 1,000 500 T April May June June Sales Forecast: 2,050 units July Select Year Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Sales Forecast & Production Budget (in Units) Budgeted Production 3,000 Sales Forecast 2,500 2,000. 1,500 1,000 500 T T April May June July Budgeted Production: 2,250 units July Sales Forecast & Production Budget (in Units) Budgeted Production 3,000- Sales Forecast 2,500- 2,000- 1,500 1,000 500 April May June July Sales Forecast: 1,750 units July March April May June Ending Direct Materials Inventory by Month 800 Solve for this value Solve for this value March Direct Materials (pounds): 2,816 pounds Solve for this value 1,600 2,400 3,200 4,000 Direct labor rate Direct materials cost Direct labor rate: $18 per hour +ableau Variable overhead rate K- G 0 Direct labor rate Direct materials cost Variable overhead rate +ableau Direct materials cost: $3 per pound Direct labor rate +ableau Direct materials cost Variable overhead rate Variable overhead rate (based on direct labor hours): $25 per direct labor hour 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.