Ch 07 Tableau-3 Saved Help Save 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. 15 points Skipped Sales Forecast & Production Budget (in Units) 1,500 eBook Budgeted Production Sales Forecast 1,200+ Print Budgeted Production References Sales Forecast April May June July Ending Direct Materials Inventory by Month March Ch 07 Tableau-3 Saved Help Save UL April May June July Ending Direct Materials Inventory by Month 15 points March April Solve for this value eBook May Solve for this value Print June Solve for this value References 400 1600 2000 800 1200 Direct Materials (Pounds) Direct labor rate Direct materials cost Variable overhead rate tableau - TO 1. Prepare a direct labor budget for each month of April, May, and June. Ch 07 Tableau-3 A Saved Help Save * + ableau E 1 2 15 points 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)? eBook Complete this question by entering your answers in the tabs below. Print Req 1 Req 2 Req 3A and 3B Reg 4 References Prepare a factory overhead budget for each month of April, May, and June. DELRAY MANUFACTURING Factory Overhead Budget For April, May, and June April May June Total labor hours needed Budgeted variable overhead Budgeted fixed overhead Total budgeted factory overhead Req1 Req 3A and 3B > Ch 07 Tableau-3 A Saved Help Save * + ableau E 1 2 15 points 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)? eBook Complete this question by entering your answers in the tabs below. Print Req 1 Req 2 Req 3A and 3B Reg 4 References 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.) DELRAY MANUFACTURING Direct Labor Budget For April, May, and June April May 880 1,100 June 1,075 units Budgeted production (units) Beginning inventory (lbs.) Total labor hours needed Budgeted direct labor cost Reg1 Reg 2 > Ch 07 Tableau-3 A Saved Help Save * + ableau E 1 2 15 points 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)? eBook Complete this question by entering your answers in the tabs below. Print Req 1 Reg 2 Req 3A and 3B Reg 4 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 assuming the company (a) does not hire more skilled workers and (b) hires more skilled workers. DELRAY MANUFACTURING Direct Labor Budget for April Does Not Hire Does Hire 880 units Budgeted production (units) 880 Total labor hours needed Budgeted direct labor cost Ch 07 Tableau-3 Saved Help Save 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. 15 points Skipped Sales Forecast & Production Budget (in Units) 1,500 eBook Budgeted Production Sales Forecast 1,200+ Print Budgeted Production References Sales Forecast April May June July Ending Direct Materials Inventory by Month March Ch 07 Tableau-3 Saved Help Save UL April May June July Ending Direct Materials Inventory by Month 15 points March April Solve for this value eBook May Solve for this value Print June Solve for this value References 400 1600 2000 800 1200 Direct Materials (Pounds) Direct labor rate Direct materials cost Variable overhead rate tableau - TO 1. Prepare a direct labor budget for each month of April, May, and June. Ch 07 Tableau-3 A Saved Help Save * + ableau E 1 2 15 points 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)? eBook Complete this question by entering your answers in the tabs below. Print Req 1 Req 2 Req 3A and 3B Reg 4 References Prepare a factory overhead budget for each month of April, May, and June. DELRAY MANUFACTURING Factory Overhead Budget For April, May, and June April May June Total labor hours needed Budgeted variable overhead Budgeted fixed overhead Total budgeted factory overhead Req1 Req 3A and 3B > Ch 07 Tableau-3 A Saved Help Save * + ableau E 1 2 15 points 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)? eBook Complete this question by entering your answers in the tabs below. Print Req 1 Req 2 Req 3A and 3B Reg 4 References 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.) DELRAY MANUFACTURING Direct Labor Budget For April, May, and June April May 880 1,100 June 1,075 units Budgeted production (units) Beginning inventory (lbs.) Total labor hours needed Budgeted direct labor cost Reg1 Reg 2 > Ch 07 Tableau-3 A Saved Help Save * + ableau E 1 2 15 points 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)? eBook Complete this question by entering your answers in the tabs below. Print Req 1 Reg 2 Req 3A and 3B Reg 4 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 assuming the company (a) does not hire more skilled workers and (b) hires more skilled workers. DELRAY MANUFACTURING Direct Labor Budget for April Does Not Hire Does Hire 880 units Budgeted production (units) 880 Total labor hours needed Budgeted direct labor cost