Question

Question 4 For Wildhorse Company, units to be produced are 5,520 in quarter 1 and 6,500 in quarter 2. It takes 1.5 hours to make a finished unit, and the expected hourly wage rate is $15 per hour. Prepare a direct labor budget by quarters for the 6 months ending June 30, 2020. WILDHORSE COMPANY Direct Labor Budget For the Six Months Ending June 30, 2020For the Quarter Ending June 30, 2020June 30, 2020 Quarter 1 2 Six Months Total Pounds Required for ProductionDirect Labor Time (Hours) Per UnitDirect Materials Per UnitTotal Direct Labor CostTotal Materials RequiredTotal Required Direct Labor HoursCost Per PoundDirect Materials PurchasesDirect Labor Cost Per HourDesired Ending InventoryTotal Cost of Direct Materials PurchasesUnits to be ProducedBeginning Materials Inventory Direct Materials PurchasesDirect Labor Time (Hours) Per UnitDirect Materials Per UnitBeginning Materials InventoryTotal Cost of Direct Materials PurchasesTotal Required Direct Labor HoursTotal Direct Labor CostTotal Materials RequiredUnits to be ProducedDirect Labor Cost Per HourTotal Pounds Required for ProductionCost Per PoundDesired Ending Inventory Total Pounds Required for ProductionDirect Materials Per UnitDirect Labor Time (Hours) Per UnitTotal Materials RequiredTotal Required Direct Labor HoursDirect Labor Cost Per HourTotal Cost of Direct Materials PurchasesDesired Ending InventoryTotal Direct Labor CostDirect Materials PurchasesUnits to be ProducedBeginning Materials InventoryCost Per Pound Cost Per PoundDesired Ending InventoryTotal Materials RequiredDirect Labor Cost Per HourDirect Labor Time (Hours) Per UnitDirect Materials Per UnitTotal Required Direct Labor HoursUnits to be ProducedDirect Materials PurchasesTotal Cost of Direct Materials PurchasesBeginning Materials InventoryTotal Direct Labor CostTotal Pounds Required for Production $ $ Beginning Materials InventoryDirect Labor Cost Per HourDirect Labor Time (Hours) Per UnitDirect Materials Per UnitTotal Required Direct Labor HoursUnits to be ProducedTotal Direct Labor CostTotal Materials RequiredDirect Materials PurchasesCost Per PoundTotal Cost of Direct Materials PurchasesDesired Ending InventoryTotal Pounds Required for Production $ $ $ Click if you would like to Show Work for this question: Open Show Work

Answer 1

Solution

WILDHORSE COMPANY
Direct Labor Budget
For the Six Months Ending June 30
	March	April
Units to be Produced	5520	6500
Direct Labor Time (Hours) Per Unit	1.5	1.5
Required Direct Labor Hours	8280	9750
Cost Per Hour	$        15.00	$         15.00
Total Direct Labor Cost	$124,200.00	$ 146,250.00