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
-
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...
-
Repeat Exercise 43 with the matrices A and B from Exercise 42. Then give an explanation for what you discover, assuming that B was constructed as specified.
-
Element Water Sports has 13,000 shares of $1 par value common stock outstanding. Element distributes a 5% stock dividend when the market value of its stock is $15 per share. Requirements 1....
-
According to Colliers International, the median monthly parking rate in the United States for 2012 was \(\$ 164.80\). The data in Table 7 represent a random sample of monthly parking rates in...
-
Equipment replacement, income taxes (continuation of 21-27). Assume the same facts as in Problem 21-27, except that the plant is located in Austin, Texas. Pro Chips has no special waiver on income...
-
= Let p(2) ao+a+ +anz" be an analytic polynomial and let s = 1|2|2 for z C with || 1. Let e, denote the column n x 1 matrix with 1 at the ith place and 0 else. Verify: (1) Consider the (n+1)(n+1)...
-
1 To demonstrate the marginal or incremental cost of borrowing, please consider the following. For the purchase of a $100,000 house, two loans can be considered. One Loan of $80,000 for 25 years at...
-
An organic farming company wanted to ascertain their gross and net profit during the year. The company provided the following income statement. You were required to calculate the Gross Profit and Net...
-
Neelon Corporation has two divisions: Southern Division and Northern Division. The following data are for the most recent operating period: Total Company Southern Division Northern Division Sales $...
-
Cindy owns a 25% capital and profits interest in the calendar-year Rhubarb Partnership. Her adjusted basis for her partnership interest on July 1 of the current year is $200,000. On that date, she...
-
FIN 3 1 4 4 Financial Planning Case Facts Sheldon and Amy Cooper Sheldon and Amy Cooper have come to you, a financial planner, for help in developing a plan to accomplish their financial goals. The...
-
How are biological phenomena such as transcription and translation, alongside evolutionary mechanisms like natural selection, leveraged to enhance the quality of life for individuals globally?
-
What exactly is an antibody? Where does it come from? What are the different ways in which an antibody can prevent infection?
-
$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?
-
Consider a first-order system with a forcing function \(f(t)\) such that input-output differential equation is given by \[\begin{equation*}\dot{y}+3 y=f(t) \text {, } \tag{3.7}\end{equation*}\] where...
-
Find the dynamic system response for the rotational mechanical system shown below. There is a constant input angular speed, \(\omega(t)=\beta\), and zero initial angular speed, \(\omega_{1}(0)=0\)...
-
A dynamic system is described by the following State-Variable Matrix model such that: \(\dot{\mathbf{x}}=\mathbf{A x}\) and \(\mathbf{y}=\mathbf{C x}\), where (a) Obtain the State-Transition Matrix...
Study smarter with the SolutionInn App