Costing tool for estimation in Solidworks - Real Business Scenario

Scenario Mode

👤 Your Role: You are a manufacturing analyst at a company that designs mechanical parts using SolidWorks.

📋 Request: Your manager wants you to create a costing tool that estimates the manufacturing cost of parts based on their design parameters and material choices.

📊 Data: You have access to part design files with dimensions and material types, and a cost database that lists material costs per kilogram and machining costs per hour.

🎯 Deliverable: Build a dashboard that shows estimated cost breakdowns for each part, including material cost, machining cost, and total cost.

Sample Data

Part ID	Material	Weight (kg)	Machining Time (hours)
P001	Aluminum	2.5	1.2
P002	Steel	3.0	1.5
P003	Plastic	1.0	0.8
P004	Aluminum	4.0	2.0
P005	Steel	2.2	1.0
P006	Plastic	1.5	0.5
P007	Aluminum	3.3	1.8
P008	Steel	2.8	1.3

1

Step 1: Create a table for material costs per kilogram.

Material Costs: Aluminum = $5/kg, Steel = $7/kg, Plastic = $2/kg

Expected Result

Material cost values ready for calculation.

2

Step 2: Create a table for machining cost per hour.

Machining Cost = $50 per hour

Expected Result

Machining cost value ready for calculation.

3

Step 3: Calculate material cost for each part by multiplying weight by material cost per kg.

Material Cost = Weight (kg) * Material Cost per kg

Expected Result

For example, Part P001 material cost = 2.5 * 5 = $12.50

4

Step 4: Calculate machining cost for each part by multiplying machining time by machining cost per hour.

Machining Cost = Machining Time (hours) * $50

Expected Result

For example, Part P001 machining cost = 1.2 * 50 = $60.00

5

Step 5: Calculate total cost for each part by adding material cost and machining cost.

Total Cost = Material Cost + Machining Cost

Expected Result

For example, Part P001 total cost = 12.50 + 60.00 = $72.50

6

Step 6: Create a dashboard table showing Part ID, Material, Weight, Machining Time, Material Cost, Machining Cost, and Total Cost.

Configure dashboard with columns: Part ID, Material, Weight (kg), Machining Time (hours), Material Cost ($), Machining Cost ($), Total Cost ($)

Expected Result

Dashboard table displays all parts with their cost breakdowns.

7

Step 7: Add a bar chart to visualize total cost per part for easy comparison.

X-axis: Part ID, Y-axis: Total Cost ($)

Expected Result

Bar chart shows total cost for each part clearly.

Final Result

P006

↓

P003

↓

P005

↓

P001

↓

P008

↓

P002

↓

P007

↓

P004

✓Aluminum parts generally have lower material cost but machining time affects total cost significantly.

✓Plastic parts have the lowest total cost due to low material and machining costs.

✓Steel parts have higher material costs, increasing total cost despite moderate machining times.

✓Part P004 is the most expensive due to high weight and machining time.

✓The dashboard helps quickly identify cost drivers for each part.

Bonus Challenge

Add a feature to estimate cost savings by reducing machining time by 10% for each part.

Show Hint

Create a new column calculating 90% of machining time, then recalculate machining and total costs based on this reduced time.

Practice

1.

What is the main purpose of the SolidWorks costing tool?

easy

A. To create 3D animations of the design

B. To simulate the physical behavior of parts

C. To estimate manufacturing costs from a CAD model

D. To generate marketing materials automatically

Solution

1. Step 1: Understand the costing tool function

   The costing tool analyzes the CAD model to estimate how much it will cost to make the part.

2. Step 2: Compare options

   Other options like animation or simulation are not related to cost estimation.

3. Final Answer:

   To estimate manufacturing costs from a CAD model -> Option C

4. Quick Check:

   Costing tool = cost estimation [OK]

Hint: Costing tool = cost estimation from model [OK]

Common Mistakes:

• Confusing costing with simulation
• Thinking it creates animations
• Assuming it generates marketing content

2.

Which of the following is the correct way to start a costing analysis in SolidWorks?

CostingTool.StartAnalysis()

easy

A. CostingTool.RunEstimate()

B. CostingTool.BeginCosting()

C. CostingTool.InitCost()

D. CostingTool.StartAnalysis()

Solution

1. Step 1: Identify the correct method name

   The method StartAnalysis() is the correct syntax to begin costing analysis in SolidWorks API.

2. Step 2: Check other options

   Other method names like BeginCosting(), InitCost(), and RunEstimate() are incorrect or do not exist.

3. Final Answer:

   CostingTool.StartAnalysis() -> Option D

4. Quick Check:

   Correct method = StartAnalysis() [OK]

Hint: Look for method with 'Start' and 'Analysis' words [OK]

Common Mistakes:

• Using incorrect method names
• Confusing initialization with analysis start
• Assuming similar sounding methods exist

3.

Given the following costing parameters:
MaterialCost = 10
LaborCost = 5
MachineCost = 3
What is the total estimated cost calculated by TotalCost = MaterialCost + LaborCost + MachineCost?

medium

A. 18

B. 15

C. 10

D. 8

Solution

1. Step 1: Add material, labor, and machine costs

   MaterialCost (10) + LaborCost (5) + MachineCost (3) = 10 + 5 + 3 = 18

2. Step 2: Confirm total cost calculation

   The formula sums all costs correctly to get total cost.

3. Final Answer:

   18 -> Option A

4. Quick Check:

   Sum costs = 18 [OK]

Hint: Add all cost components for total [OK]

Common Mistakes:

• Adding only two costs
• Mixing up cost values
• Forgetting to sum machine cost

4.

Identify the error in this costing calculation snippet:

MaterialCost = 12
LaborCost = '5'
TotalCost = MaterialCost + LaborCost

medium

A. TotalCost calculation is correct

B. LaborCost is a string, causing a type error

C. MaterialCost should be a string

D. Missing semicolon after LaborCost

Solution

1. Step 1: Check variable types

   MaterialCost is a number (12), but LaborCost is a string ('5'), which cannot be added directly.

2. Step 2: Identify error in addition

   Adding number and string causes a type error in most languages.

3. Final Answer:

   LaborCost is a string, causing a type error -> Option B

4. Quick Check:

   Type mismatch = error [OK]

Hint: Ensure all costs are numbers before adding [OK]

Common Mistakes:

• Ignoring data types
• Assuming implicit conversion
• Thinking semicolon is required

5.

You want to estimate the cost of a part with variable material thickness. The costing tool allows you to set a parameter Thickness that affects material cost. If material cost per unit thickness is $4, and thickness is 2.5 units, what is the material cost?

hard

A. $10

B. $6.5

C. $8

D. $12

Solution

1. Step 1: Understand cost calculation

   Material cost = cost per unit thickness * thickness = 4 * 2.5

2. Step 2: Calculate total material cost

   4 * 2.5 = 10

3. Final Answer:

   $10 -> Option A

4. Quick Check:

   4 x 2.5 = 10 [OK]

Hint: Multiply unit cost by thickness [OK]

Common Mistakes:

• Adding instead of multiplying
• Using wrong thickness value
• Confusing units and cost