Question
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+ Budgeted Production Sales Forecast 1.200 Budgeted Production Sales Forec

budgeted production: april 880 units. may 1,100 units. jun 1,075 units. july 1,125 units.
Sales forecast: april 805 units. may 900 units. jun 1025 units. july 875 units.

Ending Direct Materials Inventory by Month March April Solve for this value May Solve for this value June Solve for this valu

March: Direct materiald (pounds): 1,408 pounds.

Direct labor rate Direct materials cost Variable overhead rate tableau 1. Prepare a direct labor budget for each month of Apr
DELRAY MANUFACTURING Direct Labor Budget For April, May, and June April May 880 1 June 1,075 units ,100 Budgeted production (
May June DELRAY MANUFACTURING Factory Overhead Budget For April, May, and June April Total labor hours needed Variable factor
The company is considering hiring more skilled workers. These workers would increase the direct labor rate to $21 per hour, a

direct labor rate $18 per hour. direct materials cost: $3 per pound VOH rate: $25 per direct labor hour
0 0
Add a comment Improve this question Transcribed image text
Answer #1
DELRAY MANUFACTURING
Direct Labor Budget
For April, May, and June
April May June
Budgeted production (units) 880 1100 1075
Direct labor hours per unit (hrs.) 2 2 2
Total labor hours needed 1760 2200 2150
Direct labor rate (per hour) $                    18 $               18 $                 18
Budgeted direct labor cost 31680 39600 38700
DELRAY MANUFACTURING
Factory Overhead Budget
For April, May, and June
April May June
Total labor hours needed 1760 2200 2150
Variable factory overhead rate per direct labor hr. $                    25 $               25 $                 25
Budgeted variable overhead 44000 55000 53750
Budgeted fixed overhead 12000 12000 12000
Total budgeted factory overhead 56000 67000 65750
DELRAY MANUFACTURING
Direct Labor Budget for April
Does Not Hire Does Hire
Budgeted production (units) 880 880
Direct labor hours per unit (hrs.) 2 1.5
Total labor hours needed 1760 1320
Direct labor rate (per hour) $                    18 $               21
Budgeted direct labor cost 31680 27720
Add a comment
Know the answer?
Add Answer to:
Delray Manufacturing needs to better budget and analyze costs. While Delray has experienced high sales growth,...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Sales Forecast & Product Budget table numbers (units) April: Budget (880 units) & Sales (805 units)...

    Sales Forecast & Product Budget table numbers (units) April: Budget (880 units) & Sales (805 units) may: Budget (1,100 units) & Sales (900 units) june: Budget (1075) & Sales (1025 units) july : budget (1125 units) & sales (875 units) 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...

  • please answer all the required ones #1-3b direct labor rate: $18 per hour direct material cost:...

    please answer all the required ones #1-3b direct labor rate: $18 per hour direct material cost: $3 per pound Variable overhead rate (based on direct labor hours): $25 per direct labor hour Check my work 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...

  • Tableau DA 20-1: Quick Study, Direct materials budget LO P1 Delray Manufacturing needs to better budget...

    Tableau DA 20-1: Quick Study, Direct materials budget LO P1 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...

  • please do all of them Check my work Delray Manufacturing needs to better budget and analyze...

    please do all of them Check my work 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...

  • Required information Ramos Co. provides the following sales forecast and production budget for the next four mont...

    Required information Ramos Co. provides the following sales forecast and production budget for the next four months: July April May 670 June Sales (units) Budgeted production (units) 590 620 690 530 660 630 630 The company plans for finished goods inventory of 210 units at the end of June. In addition, each finished unit requires 5 pounds of direct materials and the company wants to end each month with direct materials inventory equal to 30 % of next month's production...

  • Check my work Required information Ramos Co. provides the following sales forecast and production budget for...

    Check my work Required information Ramos Co. provides the following sales forecast and production budget for the next four months. Sales (units) Budgeted production (units) April 560 500 May 640 630 Dune 590 600 660 600 The company plans for finished goods inventory of 180 units at the end of June. In addition, each finished unit requires 6 pounds of direct materials and the company warſts to end each month with direct materials inventory equal to 25% of next month's...

  • The company plans for finished goods inventory of 220 units at the end of June. In...

    The company plans for finished goods inventory of 220 units at the end of June. In addition, each finished unit requires 5 pounds of direct materials and the company wants to end each month with direct materials inventory equal to 20% of next month’s production needs. Beginning direct materials inventory for April was 540 pounds. Direct materials cost $2 per pound. Each finished unit requires 0.60 hours of direct labor at the rate of $12 per hour. The company budgets...

  • Required information Ramos Co. provides the following sales forecast and production budget for the next four...

    Required information Ramos Co. provides the following sales forecast and production budget for the next four months: Sales (units) Budgeted production (units) April May June July 530 610 560 630 470 600 570 570 The company plans for finished goods inventory of 150 units at the end of June. In addition, each finished unit requires 5 pounds of direct materials and the company wants to end each month with direct materials inventory equal to 30% of next month's production needs....

  • Ramos Co. provides the following sales forecast and production budget for the next four months: April...

    Ramos Co. provides the following sales forecast and production budget for the next four months: April May June July Sales (units) 570 650 600 670 Budgeted production (units) 510 640 610 610 The company plans for finished goods inventory of 190 units at the end of June. In addition, each finished unit requires 5 pounds of direct materials and the company wants to end each month with direct materials inventory equal to 30% of next month’s production needs. Beginning direct...

  • Rad Co. provides the following sales forecast and production budget for the next four months: April...

    Rad Co. provides the following sales forecast and production budget for the next four months: April May June July 500 580 530 600 Budgeted production (units) 442 570 544 540 Sales (units) The company plans for finished goods inventory of 120 units at the end of June. In addition, each finished unit requires 5 pounds of raw materials at cost of $2.00 per pound and the company wants to end each month with raw materials inventory equal to 30% of...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT