Class Assignment ABC company is doing the budget for month November 2021. The following data are provided. The company manufactures tables for schools Sales in units Estimated overhead cost Estimated activity (DLH] Targeted EI Beginning Inventory (production) Hourly Rate for Direct Labour 12,250 $11000 5000 hours 2100 units 800 units $11.20 For each table produced, they need 4 square feet of wood that cost $8.00 per square foot. The company started the month with 450 tables in stock and it has decided to keep 100 tables as ending inventory The company uses 3.5 hours of direct labour to make one table. ABC uses DLH as the cost driver to allocate manufacturing overhead At the end of production it charges 35% margin over the unit cost REQUIRED 1. Make a production budget in units 2. Prepare a budget for the raw materials needed 3. Prepare a direct labour budget for the month 4. Allocate cost to manufacturing overhead using direct labour hours as the activity (company uses Plant wide Predetermined Rate 5. What is the budgeted total product cost? Calculate the unit cost. 6. Using the margin provided, make a sales budget for the month