Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Delray Manufacturing needs to better budget and analyze costs. While Delray has experienced high sales growth, it has struggled to effectively manage costs and

image text in transcribedimage text in transcribedimage text in transcribed

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. Sales Forecast & Production Budget (in Units) 1,500- 1,200 Budgeted Production Sales Forecast 900 Budgeted Production Sales Forecast 600 300 0 April March April May June May June Ending Direct Materials Inventory by Month Solve for this value Solve for this value Solve for this value July p 400 800 1200 1600 2000 Direct Materials (Pounds) Direct labor rate Direct materials cost Variable overhead rate *+ableau 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. K L PO 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)? Complete this question by entering your answers in the tabs below. Req 1 Req 2 Req 3A and 3B Req 4 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.) Units to produce Direct labor hours required per unit (hrs.) Direct labor hours needed Direct labor cost per hour Cost direct labor DELRAY MANUFACTURING Direct Labor Budget For April, May, and June April May June 880 2.00 1,100 2.00 1,075 units 1,760 2,200 2.00 hours per unit 2,150 hours $ 7 $ 12,320

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Government and Not for Profit Accounting Concepts and Practices

Authors: Michael H. Granof, Saleha B. Khumawala

6th edition

978-1-119-4958, 9781118473047, 1118155971, 1118473043, 978-1118155974

More Books

Students also viewed these Accounting questions