Check my work 1 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 onts Sales Forecast & Production Budget (in Units) 1,500 Budgeted Production Sale Forecast 1,200 Budgeted Production 900 References Sales Forecast 600 300 0 April May June July Check my work Ending Direct Materials Inventory by Month March April Solve for this value Solve for this value May June Solve for this value 400 800 1200 1600 2000 Direct Materials (Pounds) Direct materials cost Variable overhead rate Direct labor rate tableau 1. Prepare a direct labor budget for each month of April, May, and June 2. Prepare a factory overhead budget for each month of April, May, and June 3. The company is considering hiring more skilled workers. These workers would increase the direct inborrate to $21 per hour and reduce direct labor hours required per finished good to 1.5 hours. Compute the direct labor budget for April assuming the company (a) tableau D 1. Prepare a direct labor budget for each month of April, May, and June 2. Prepare a factory overhead budget for each month of April May, and June 3. 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. Compute the direct labor budget for April assuming the company (a) does not hire more skilled workers and (b) hires more skilled workers. 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. How would this change to more skilled workers impact total budgeted factory overhead (assuming the budgeted variable overhead rate is unchanged? Complete this question by entering your answers in the tabs below. Reg 1 Reg 2 Reg 3A and 3 Reg 4 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) cos DELRAY MANUFACTURING Direct Labor Budget For April, May, and June April May 880 1.100 June Units to produce 1,075 units Dired tabor hours needed Cost of direct labor Reg 2 > 1. Prepare a direct labor budget for each month of April, May, and June 2. Prepare a factory overhead budget for each month of April, May, and June 3. 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. Compute the direct labor budget for April assuming the company (a) does not hire more skilled workers and (b) hires more skilled workers. 4. The company is considering hiring more skilled workers. These workers would increase the direct labor rate to 521 per hour and reduce direct labor hours required per finished good to 1.5 hours. How would this change to more skilled workers impact total budgeted factory overhead (assuming the budgeted variable overhead rate is unchanged? Complete this question by entering your answers in the tabs below. Reg 1 Reg 2 Req 3A and 38 Req 4 Prepare a factory overhead budget for each month of April, May, and June DELRAY MANUFACTURINO Factory Overhead Budget For April, May, and June April May June Direct labor hours needed (part 1) Budgeted variable overhead Buogeled fowed overhead Budgeted total factory overhead Regt Reg 3A and 38 > its 1. Prepare a direct labor budget for each month of April, May, and June 2. Prepare a factory overhead budget for each month of April, May, and June. 3. 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. Compute the direct labor budget for April assuming the company la) does not hire more skilled workers and (b) hires more skilled workers. 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. How would this change to more skilled workers impact total budgeted factory overhead (assuming the budgeted variable overhead rate is unchanged)? AN Complete this question by entering your answers in the tabs below. Print Reg 1 Reg 2 Req3A and 38 Reg4 References 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. Compute the direct labor budget for April assurning the company (a) does not hire more skilled workers and (b) hires more skilled workers. DELRAY MANUFACTURINO Direct Labor Budget for April Does Not Hire Does Hire Units to produce 880 880 units Director hours needed Cost of direct labor Req> Check +ableau 1. Prepare a direct labor budget for each month of April, May, and June. 2. Prepare a factory overhead budget for each month of April, May, and June, 3. The company is considering hiring more skilled workers. These workers would increase the direct labor rote to $21 per hour and reduce direct labor hours required per finished good to 1.5 hours. Compute the direct labor budget for April assuming the company (a) does not hire more skilled workers and (b) hires more skilled workers 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. How would this change to more skilled workers impact total budgeted factory overhead (assuming the budgeted variable overhead rate is unchanged)? Complete this question by entering your answers in the tabs below. Req1 Reg 2 Reg 3A and 38 Req4 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. How would this change to more skilled workers impact total budgeted factory overhead (assuming the budgeted variable overhead rate is unchanged)? How would this change to more skilled workers impact total budgeted factory overhead (assuming the budgeted variable overhead rate is unchanged)?