budgeted production april: 3250 units

budgeted production may: 4400 units

budgeted production june: 4300 units

budgeted production july: 4500 units

sales forecast april: 3220 units

sales forecast may: 3600 units

sales forecast june: 4100 units

sales forecast july: 3500 units

ending direct materials inventory: 5632 lbs

direct labor rate: $18 per hour

direct materials cost: $3 per pound

variable overhead rate: $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. 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 6,000- Sales Forecast 5,000 4,000- 3,000 2,000 1,000 April March April May June May June Ending Direct Materials Inventory by Month Solve for this value July Solve for this value Solve for this value 1,000 2,000 3,000 4,000 5,000 Direct labor rate Direct materials cost 6,000 Variable overhead rate 7,000 8,000 +tableau