Complete this question by entering your answers in the tabs below. Req 1 Req 2 Req...
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
Random Numbers Random Numbers Row Column Number Number 01-05 06-10 11-15 16-20 58 5gg| 01 13197 41698 57918 43021 02 36861 04987 8 37 13 15874 03 1929 1 10423 15909 79118 04 75608 94 338 73145 626 19...
-
Bookwork code 36 Victoria, James and Lauren each spun the same spinner a number of times and recorded how many times it landed on a section labelled 3. Their results are shown below. a) They each...
-
Suppose a farmer wants to make two pens using 120 ft of fencing. For the first pen, they want the width to be triple the length. For the second pen, they want all the sides to be the same value as...
-
1.3 WANEFMAC7 1.3.007. Find the equation of the given linear function. \[ f(x)= \] WANEFMAC7 1.3.015. Find the slope of the given line, if it is defined. (If an answer is undefined, enter UNDEFINED.)...
-
Melanie is studying for the next accounting examination. She asks your help on two questions: (a) What is salvage value ? (b) How is salvage value used in determining depreciable cost under the...
-
Determine the period and frequency of the simple harmonic motion of a body of mass 0.75 kg on the end of a spring with spring constant 48 N/m.
-
Sunny Valley Resort has owned 80 percent of Mountain Lodging, Inc. since Mountain Lodging's inception. The condensed consolidated balance sheets of Sunny Valley Resort at December 31, 2017 and 2016...
-
The following control procedures are used in Kelton Company for over-the-counter cash receipts. 1. Each store manager is responsible for interviewing applicants for cashier jobs. They are hired if...
-
Rio National Corp. is a U.S. based company and the largest competitor in its industry. Exhibit 1 through 5 present the financial statements, which are prepared according to U.S. Generally Accepted...
-
What characteristics of a property, plant, and equipment item make it different from other assets, such as accounts receivable or inventory?
-
Express the position of an equity holder in terms of put options. An equity holder is long a put on a share of the value of the firm assets with the per share value of debt as the strike price, long...
-
Long-term liabilities Bonds payable $3,600,000 Less: Discount on bonds payable 81,000 $3,519,000 Oriole decides to redeem these bonds at 106 after paying annual interest. Prepare the journal entry to...
-
Based on this case, What ring and wrong things CBA, Count, Court and Arbitration, lawyer or agcenies did and how they can solve or help clients (Aubin - plaintiffs and Unilever) win the case and...
-
Two point charges, separated by 10.0 cm, have charges of +2.00C and -2.00C respectively. What type of force, and how much, exist between the two charges?
-
Esfandairi Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment of $2,430,000. The fixed asset will be depreciated straight-line to zero over...
-
Based solely on the aggregate cash flows over the past three years (i.e. CFO, CFI, and CFF), at what stage of their life cycle does Home Depot appear to be in (Introduction. Growth, Maturity, or...
-
Consolidations Review Problem Due on Monday, April 29, 2024 at 10:00 am on Canvas. All parts must be neatly typed. May purchased 70% of the outstanding common stock of Gardens on 1/1/19 for $18.0...
-
CdF2 (s) Cd+ (aq) + 2 F- (aq) 1. A saturated solution of CdF2 is prepared. The equilibrium in the solution is represented above. In the solution [Cd+] eq = 0.0585 M and [F-] eq = 0.117 M. a....
-
Wesley Parks Pencil Company is considering the purchase of a new machine to make pencils. The cost of the machine is \($248,000\). The pencil machine has an estimated useful life of 10 years and an...
-
Sylvia Heains Catering Service is considering the purchase of new energy-efficient cooking equipment. The cost of the new equipment is \($78,000\). The equipment has an estimated useful life of eight...
-
George Gonzalez Construction Company is considering the purchase of a new road grader. The cost of the road grader is \($68,000\). The road grader has an estimated useful life of seven years and an...
Study smarter with the SolutionInn App