Tableau DA 7-3: Mini-Case, Prepare direct labor and factory overhead budgets and analyze strategies 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 months 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.

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.)

DELRAY MANUFACTURING
Direct Labor Budget
For April, May, and June
	April	May	June
Units to produce	880	1,100	1,075	units
Direct labor hours needed
Cost of direct labor

Req 1