Complete this question by entering your answers in the tabs below. Req 1 Req 2 Req...

Transcribed Image Text:

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 < Req 2 Req 4 > 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 Sales Forecast & Production Budget (in Units) Budgeted Production Year 10 3,000 Sales Forecast 2,500 2,000 1,500- April 1,000 Budgeted Production: 1,760 units 500 March April May June April May T June Ending Direct Materials Inventory by Month Solve for this value July Solve for this value Solve for this value 800 1,600 2,400 3,200 4,000 Direct labor rate Direct materials cost Variable overhead rate 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 500 March April May June April April Sales Forecast: 1,610 units May T June Ending Direct Materials Inventory by Month Solve for this value July Solve for this value Solve for this value 800 1,600 2,400 3,200 4,000 Direct labor rate Direct materials cost Variable overhead rate 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 Sales Forecast & Production Budget (in Units) Budgeted Production Year 10 3,000 Sales Forecast 2,500 2,000 1,500- 1,000 500 March April May June April May. Budgeted Production: 2,200 units May T June Ending Direct Materials Inventory by Month Solve for this value July Solve for this value Solve for this value 800 1,600 2,400 3,200 4,000 Direct labor rate Direct materials cost Variable overhead rate 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 Sales Forecast & Production Budget (in Units) Year 10 Budgeted Production 3,000 Sales Forecast 2,500 2,000 1,500- 1,000 500 March April May June April May Sales Forecast: 1,800 units May T June Ending Direct Materials Inventory by Month Solve for this value July Solve for this value Solve for this value 800 1,600 2,400 3,200 4,000 Direct labor rate Direct materials cost Variable overhead rate 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 500 March April May June April T June Budgeted Production: 2,150 units May June Ending Direct Materials Inventory by Month Solve for this value July Solve for this value Solve for this value 800 1,600 2,400 3,200 4,000 Direct labor rate Direct materials cost Variable overhead rate 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 500 March April May June April June Sales Forecast: 2,050 units May June Ending Direct Materials Inventory by Month Solve for this value July Solve for this value Solve for this value 800 1,600 2,400 3,200 4,000 Direct labor rate Direct materials cost Variable overhead rate 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 500 March April May June April T July Budgeted Production: 2,250 units May June Ending Direct Materials Inventory by Month Solve for this value July Solve for this value Solve for this value 800 1,600 2,400 3,200 4,000 Direct labor rate Direct materials cost Variable overhead rate 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 500 March April May June April May T June Ending Direct Materials Inventory by Month Solve for this value July Sales Forecast: 1,750 units July Solve for this value Solve for this value 800 1,600 2,400 3,200 4,000 Direct labor rate Direct materials cost Variable overhead rate 3,000- 2,500 2,000 1,500 1,000 500 Budgeted Production Sales Forecast + April May June Ending Direct Materials Inventory by Month March April May June Solve for thi March Solve for this Direct Materials (pounds): 2,816 pounds Solve for this value July 800 1,600 2,400 3,200 4,000 Direct labor rate Direct materials cost Variable overhead rate View on Tableau Public DC D Share 3,000- 2,500 2,000 1,500 1,000 500 Budgeted Production Sales Forecast + April May June Ending Direct Materials Inventory by Month March April May June Direct labor rate Solve for this value July Solve for this value Solve for this value 800 1,600 2,400 3,200 4,000 Direct materials cost Variable overhead rate Direct labor rate: $18 per hour View on Tableau Pu DC D Share 3,000- 2,500 2,000 1,500 1,000 500 March April May June Budgeted Production Sales Forecast April May June Ending Direct Materials Inventory by Month Solve for this value July Solve for this value Solve for this value 800 1,600 2,400 3,200 4,000 Direct labor rate Direct materials cost Variable overhead rate View on Tableau Public Direct materials cost: $3 per pound Share 3,000- 2,500 2,000 1,500 1,000 500 March April May June Budgeted Production Sales Forecast April May June Ending Direct Materials Inventory by Month 800 Direct labor rate View on Tableau Public Solve for this value Solve for this value Solve for this value 1,600 2,400 3,200 July 4,000 Variable overhead rate (based on direct labor hours): $25 per direct labor hour DC D Share 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 < Req 2 Req 4 > 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 Sales Forecast & Production Budget (in Units) Budgeted Production Year 10 3,000 Sales Forecast 2,500 2,000 1,500- April 1,000 Budgeted Production: 1,760 units 500 March April May June April May T June Ending Direct Materials Inventory by Month Solve for this value July Solve for this value Solve for this value 800 1,600 2,400 3,200 4,000 Direct labor rate Direct materials cost Variable overhead rate 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 500 March April May June April April Sales Forecast: 1,610 units May T June Ending Direct Materials Inventory by Month Solve for this value July Solve for this value Solve for this value 800 1,600 2,400 3,200 4,000 Direct labor rate Direct materials cost Variable overhead rate 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 Sales Forecast & Production Budget (in Units) Budgeted Production Year 10 3,000 Sales Forecast 2,500 2,000 1,500- 1,000 500 March April May June April May. Budgeted Production: 2,200 units May T June Ending Direct Materials Inventory by Month Solve for this value July Solve for this value Solve for this value 800 1,600 2,400 3,200 4,000 Direct labor rate Direct materials cost Variable overhead rate 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 Sales Forecast & Production Budget (in Units) Year 10 Budgeted Production 3,000 Sales Forecast 2,500 2,000 1,500- 1,000 500 March April May June April May Sales Forecast: 1,800 units May T June Ending Direct Materials Inventory by Month Solve for this value July Solve for this value Solve for this value 800 1,600 2,400 3,200 4,000 Direct labor rate Direct materials cost Variable overhead rate 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 500 March April May June April T June Budgeted Production: 2,150 units May June Ending Direct Materials Inventory by Month Solve for this value July Solve for this value Solve for this value 800 1,600 2,400 3,200 4,000 Direct labor rate Direct materials cost Variable overhead rate 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 500 March April May June April June Sales Forecast: 2,050 units May June Ending Direct Materials Inventory by Month Solve for this value July Solve for this value Solve for this value 800 1,600 2,400 3,200 4,000 Direct labor rate Direct materials cost Variable overhead rate 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 500 March April May June April T July Budgeted Production: 2,250 units May June Ending Direct Materials Inventory by Month Solve for this value July Solve for this value Solve for this value 800 1,600 2,400 3,200 4,000 Direct labor rate Direct materials cost Variable overhead rate 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 500 March April May June April May T June Ending Direct Materials Inventory by Month Solve for this value July Sales Forecast: 1,750 units July Solve for this value Solve for this value 800 1,600 2,400 3,200 4,000 Direct labor rate Direct materials cost Variable overhead rate 3,000- 2,500 2,000 1,500 1,000 500 Budgeted Production Sales Forecast + April May June Ending Direct Materials Inventory by Month March April May June Solve for thi March Solve for this Direct Materials (pounds): 2,816 pounds Solve for this value July 800 1,600 2,400 3,200 4,000 Direct labor rate Direct materials cost Variable overhead rate View on Tableau Public DC D Share 3,000- 2,500 2,000 1,500 1,000 500 Budgeted Production Sales Forecast + April May June Ending Direct Materials Inventory by Month March April May June Direct labor rate Solve for this value July Solve for this value Solve for this value 800 1,600 2,400 3,200 4,000 Direct materials cost Variable overhead rate Direct labor rate: $18 per hour View on Tableau Pu DC D Share 3,000- 2,500 2,000 1,500 1,000 500 March April May June Budgeted Production Sales Forecast April May June Ending Direct Materials Inventory by Month Solve for this value July Solve for this value Solve for this value 800 1,600 2,400 3,200 4,000 Direct labor rate Direct materials cost Variable overhead rate View on Tableau Public Direct materials cost: $3 per pound Share 3,000- 2,500 2,000 1,500 1,000 500 March April May June Budgeted Production Sales Forecast April May June Ending Direct Materials Inventory by Month 800 Direct labor rate View on Tableau Public Solve for this value Solve for this value Solve for this value 1,600 2,400 3,200 July 4,000 Variable overhead rate (based on direct labor hours): $25 per direct labor hour DC D Share