Can you please help me fill out the two tables, also please let me know what formulas and rules were used **Activity-Based Costing**Steampunk Corporation has the following predicted indirect costs and cost drivers for the year for the given activity cost pools:| | Fabrication Department | Finishing Department | Cost Driver ||-----------------------------------|-------------------------|----------------------|------------------|| **Maintenance** | $24,000 | $12,000 | Machine hours || **Materials handling** | $36,000 | $18,000 | Material moves || **Machine** | $84,000 | $6,000 | Machine setups || **Inspections** | - | $30,000 | Inspection hours || **Total** | $144,000 | $66,000 | |The following activity predictions were also made for the year:| | Fabrication Department | Finishing Department ||----------------------------------|------------------------|----------------------|| **Machine hours** | 5,000 | 2,500 || **Material moves** | 1,500 | 750 || **Machine setups** | 350 | 25 || **Inspection hours** | - | 500 |It is assumed that the cost per unit of activity for a given activity does not vary between departments. Steampunk's president, Abner Punk, is trying to evaluate the company's product mix strategy regarding two of its product models, SW100 and SG150. The company has been using a company-wide overhead rate based on machine hours but is considering switching to either department rates of activity-based rates. The production manager has provided the following data for the production of a batch of 100 units for each of these models:| | SW100 | SG150 ||-----------------------|--------|--------|| **Direct materials cost** | $8,000 | $12,000 || **Direct labor cost** | $3,200 | $2,400 || **Machine hours (Fabrication)** | 250 | 350 || **Machine hours (Finishing)** | 100 | 50 || **Materials moves** | 20 | 40 || **Machine setups** | 5 | 10 || **Inspection hours** | 15 | 30 |Determine the cost of one ### Educational Website Transcript#### Cost Analysis Instructions:Use the rounded overhead rate calculated above for the calculations below. Round cost answers to the nearest whole number. Round cost per unit to two decimal places.#### Product Costs per Unit| Category | SW100 | SG150 ||---------------------------|-------|-------|| Direct materials | $0 | $0 || Direct labor | 0 | 0 || Manufacturing overhead | 0 | 0 || **Total cost per batch** | $0 | $0 || **Number of units per batch** | 0 | 0 || **Cost per unit** | $0.00 | $0.00 |#### Additional Task:b. Determine the cost of one unit of SW100 and SG150, assuming department overhead rates are used. Overhead is assigned based on machine hours in both departments. Round to two decimal places, if applicable.- Overhead rate based on machine hours for Fabrication Dept.: $0 per machine hour.- Overhead rate based on machine hours for Finishing Dept.: $0 per machine hour.#### Second Round Calculation:Use the rounded overhead rate calculated above for calculations below. Round cost answers to the nearest whole number when needed. Round cost per unit to two decimal places, if needed.#### Updated Product Costs per Unit| Category | SW100 | SG150 ||---------------------------|-------|-------|| Direct materials | $0 | $0 || Direct labor | 0 | 0 || Manufacturing overhead: | | || Fabrication Dept. | 0 | 0 || Finishing Dept. | 0 | 0 || **Total cost per batch** | $0 | $0 || **Number of units per batch** | 0 | 0 || **Cost per unit** | $0.00 | $0.00 |

Name: Can you please help me fill out the two tables, also please let me kno
Uploaded: 2024-03-20T06:32:49.000Z
Channel: Bartleby
Description: Can you please help me fill out the two tables, also please let me know what formulas and rules were used **Activity-Based Costing**Steampunk Corporation has the following predicted indirect costs and cost drivers for the year for the given activity