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 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. 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.
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
Please-please help with answering the following question, here is a link to the full question...
-
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...
-
Automatic Enrollment is a 401(k) practice whereby: A. Plan administrators are required to post credits to participants' accounts within three business days of when payroll deductions were taken. B....
-
The balance sheet of Lamont Bros. follow: (a) What portions of Lamont's assets were provided by debt, contributed capital, and earned capital? Reduce contributed capital by the cost of the treasury...
-
With A and B as in Exercise 41, select a column v of A that was not used in the construction of B and determine if v is in the set spanned by the columns of B. (Describe your calculations.) 45-5 7124...
-
Solve the problem using Lagrange multiplier method Minimize $f=3 x_{1}^{2}+4 x_{2}^{2}+x_{1} x_{3}+x_{2} x_{3}$ subject to \[\begin{aligned}& x_{1}+3 x_{2}=3 \\& 2 x_{1}+x_{3}=7\end{aligned}\]
-
The first volume of the Accountant's Index listed forensic-type articles under which categories?
-
Auditing standards require the auditor to obtain an understanding of the entity and its environment as a basis for assessing the risks of material misstatements. Business models differ across...
-
Please help with requirement # 5. I attached my answers to requirement 1-4.. Requirement 3 Assuming that the bond is classified as AC: 20x7 entries: Accounts Debit Credit May 1 Investment in debt...
-
An article in Knee Surgery, Sports Traumatology, Arthroscopy (2005, Vol. 13, pp. 273-279), considered arthroscopic meniscal repair with an absorbable screw. Results showed that for tears greater than...
-
Please compare the YTM for Ford and General Motors. Why are they different given both have the same bond rating? Please list a minimum of two reasons that might have caused this difference. Ford YTM...
-
Q3. Do you consider yourself a Type A or a Type B Person? Why? Write Short Notes giving examples on the following: Q4 i) ii) Cognitive Dissonance Self-Monitoring
-
Explain the concept of renewable resource valorization, particularly in the context of waste-to-energy technologies and the circular economy, focusing on how waste streams can be converted into...
-
please solve it fast All of CAB Ltd's sales are on credit. which they normally settle according to the following pattern: 20% in the month of the sale 50% in the month following the sale 30% in the...
-
Discuss the role of advanced energy storage technologies, such as lithium-ion batteries and solid-state batteries, in enhancing the reliability and integration of renewable energy sources like solar...
-
Consider Kodak's core competency before Fisher's arrival. As the market shifted from film to digital, did the company's historical core competency still qualify as a core competency? Did it pass the...
-
$10,000 was borrowed at 3.5% on July 17. The borrower repaid $5000 on August 12, and $2000 on September 18. What final payment is required on November 12 to fully repay the loan?
-
You will compute the (Fourier) convolution of two box functions of the same width. Recall that the box function is given by \[f_{a}(x)= \begin{cases}1, & |x| \leq a \\ 0, & |x|>a\end{cases}\]...
-
Define the integrals \(I_{n}=\int_{-\infty}^{\infty} x^{2 n} e^{-x^{2}} d x\). Noting that \(I_{0}=\sqrt{\pi}\), a. Find a recursive relation between \(I_{n}\) and \(I_{n-1}\). b. Use this relation...
-
Find the Laplace transform of the following functions: a. \(f(t)=9 t^{2}-7\). b. \(f(t)=e^{5 t-3}\). c. \(f(t)=\cos 7 t\) d. \(f(t)=e^{4 t} \sin 2 t\). e. \(f(t)=e^{2 t}(t+\cosh t)\). f. \(f(t)=t^{2}...
Study smarter with the SolutionInn App