Answered step by step
Verified Expert Solution
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 inventories.
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) bok int 1,500 onces Budgeted Production Sales Forecast 1,200 Budgeted Production 900 Sales Forecast 600 300 0 June July April May April May June July Ending Direct Materials Inventory by Month March April Solve for this value May Solve for this value June Solve for this value 0 400 1200 1600 200d 800 Direct Materials (Pounds) Direct labor rate Direct materials cost Variable overhead rate Look + obleau 1. Calculate materials needed (in pounds) for production in each month of April, May, and June. 2. Prepare a direct materials budget for the month of April. rences Complete this question by entering your answers in the tabs below. Required 1 Required 2 Calculate materials needed (in pounds) for production in each month of April, May, and Jone DELRAY MANUFACTURING Direct Materials Needed For April, May, and June April May June 880 Budget production (units) 1.100 1,075 units Materials needed for production (os.) Required 2 > ableau 1 1. Calculate materials needed (in pounds) for production in each month of April, May, anc 2. Prepare a direct materials budget for the month of April. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Prepare a direct materials budget for the month of April. DELRAY MANUFACTURING Direct Materials Budget For April + Budget production (units) 880 units Materials needed for production (lbs.) Total materials requirements (lbs.) Materials to be purchased (lbs.) Materials price per pound Budgeted cost of direct materials purchases
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started