Tableau DA $20-1($Algo$)$: Quick Study, Prepare direct materials budget LO P$1$

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.

Ending Direct Materials Inventory by Month

April : $6440$ units $7040$ units

May : $7200$ units $8800$ units

June : $8200$ units $8600$ units

July : $7000$ units $9000$ units

March direct materials $11264$ pounds

Complete this question by entering your answers in the tabs below.

For Year $8,$ calculate materials needed $($in pounds$)$ for production in each month of April, May, and June. Important! Be sure to click the correct Year at the top of the dashboard.

Required $1$

Required $2$

For Year $8,$ prepare a direct materials budget for the month of April.

Important! Be sure to click the correct Year at the top of the dashboard.