Material assignment in Solidworks - Real Business Scenario

Scenario Mode

👤 Your Role: You are a product design analyst at a manufacturing company.

📋 Request: Your manager wants a report showing the distribution of materials assigned to different parts in the latest product assembly to optimize cost and performance.

📊 Data: You have data listing each part in the assembly, its assigned material, and the quantity of each part used.

🎯 Deliverable: Create a dashboard report that summarizes total quantity of parts by material and visualizes the material distribution with a bar chart.

Sample Data

Part ID	Part Name	Material	Quantity
P001	Bracket	Aluminum	10
P002	Screw	Steel	50
P003	Cover	Plastic	20
P004	Frame	Aluminum	5
P005	Pin	Steel	30
P006	Seal	Rubber	15
P007	Handle	Plastic	8
P008	Plate	Steel	12

1

Step 1: Import the parts data into your BI tool.

Load the table with columns: Part ID, Part Name, Material, Quantity.

Expected Result

Data table with 8 rows and 4 columns loaded.

2

Step 2: Create a summary table that groups parts by Material and sums their Quantity.

Use a group by Material and sum Quantity aggregation.

Expected Result

Summary table with materials: Aluminum (15), Steel (92), Plastic (28), Rubber (15).

3

Step 3: Create a bar chart visualization with Material on the X-axis and total Quantity on the Y-axis.

Configure bar chart: X-axis = Material, Y-axis = SUM(Quantity).

Expected Result

Bar chart showing Steel highest, then Plastic, Aluminum, and Rubber.

4

Step 4: Add labels to each bar showing the total quantity for clarity.

Enable data labels on the bar chart with SUM(Quantity) values.

Expected Result

Bars labeled with quantities: Steel=92, Plastic=28, Aluminum=15, Rubber=15.

5

Step 5: Format the dashboard for readability: use clear colors, title 'Material Quantity Distribution', and ensure axis labels are visible.

Set chart title, axis titles, and choose contrasting colors for bars.

Expected Result

Clean, easy-to-read dashboard ready for presentation.

Final Result

Material Quantity Distribution

Material | Quantity
---------------------
Steel    | ██████████████████████████████████████████████████ 92
Plastic  | ████████████████ 28
Aluminum | ████████ 15
Rubber   | ████████ 15

✓Steel is the most used material by quantity in the assembly.

✓Plastic and Aluminum have moderate usage.

✓Rubber is used the least among the materials.

Bonus Challenge

Add a cost analysis by assigning a cost per unit quantity for each material and calculate total material cost in the dashboard.

Show Hint

Create a new column with cost per unit for each material, then multiply by total quantity and sum to get total cost.

Practice

1. What is the main purpose of Material Assignment in SolidWorks?

easy

A. To define what the part is made of, affecting weight and strength

B. To change the color of the part only

C. To create a new sketch on the part

D. To export the part to another file format

Solution

1. Step 1: Understand material assignment role

   Material assignment tells SolidWorks what material the part uses, which affects physical properties like weight and strength.

2. Step 2: Identify correct purpose

   Changing color or exporting files are unrelated to material assignment's main function.

3. Final Answer:

   To define what the part is made of, affecting weight and strength -> Option A

4. Quick Check:

   Material assignment = defines material properties [OK]

Hint: Material assignment sets physical properties, not just appearance [OK]

Common Mistakes:

• Thinking material only changes color
• Confusing material assignment with sketching
• Assuming material affects file export

2. Which of the following is the correct way to assign a material to a part in SolidWorks?

easy

A. Go to File > Save As and choose material

B. Double-click the sketch and type the material name

C. Right-click the part in the FeatureManager and select 'Edit Material'

D. Use the Measure tool to assign material

Solution

1. Step 1: Locate material assignment method

   In SolidWorks, you assign material by right-clicking the part in the FeatureManager and choosing 'Edit Material'.

2. Step 2: Eliminate incorrect options

   Double-clicking sketches, saving files, or using the Measure tool do not assign materials.

3. Final Answer:

   Right-click the part in the FeatureManager and select 'Edit Material' -> Option C

4. Quick Check:

   Material assigned via FeatureManager right-click [OK]

Hint: Right-click part in FeatureManager to assign material quickly [OK]

Common Mistakes:

• Trying to assign material inside sketches
• Looking for material in File menu
• Using unrelated tools like Measure

3. If you assign Aluminum 6061-T6 as the material to a part, what will happen to the part's weight compared to no material assigned?

medium

A. The weight will be calculated based on Aluminum's density

B. The weight will remain zero because material doesn't affect weight

C. The weight will double automatically

D. The weight will be set to a default value of 1 kg

Solution

1. Step 1: Understand effect of material on weight

   Assigning Aluminum 6061-T6 sets the density, so SolidWorks calculates weight using volume x density.

2. Step 2: Compare to no material assigned

   Without material, weight is zero or undefined; assigning material updates weight correctly.

3. Final Answer:

   The weight will be calculated based on Aluminum's density -> Option A

4. Quick Check:

   Material assignment updates weight using density [OK]

Hint: Material sets density; weight = volume x density [OK]

Common Mistakes:

• Assuming weight stays zero without material
• Thinking weight doubles automatically
• Believing weight defaults to 1 kg

4. You assigned a material to a part, but the weight still shows zero. What is the most likely cause?

medium

A. You assigned the material to the sketch instead of the part

B. You forgot to save the file

C. The material library is corrupted

D. The part has zero volume or no geometry

Solution

1. Step 1: Check part geometry

   If the part has zero volume (no 3D shape), weight will be zero even if material is assigned.

2. Step 2: Rule out other causes

   Assigning material to sketches is not possible; corrupted library or unsaved file won't cause zero weight directly.

3. Final Answer:

   The part has zero volume or no geometry -> Option D

4. Quick Check:

   Zero volume means zero weight despite material [OK]

Hint: Check part volume if weight stays zero after material assignment [OK]

Common Mistakes:

• Trying to assign material to sketches
• Blaming file save status
• Assuming material library corruption causes zero weight

5. You want to analyze the stress on a part made of Steel AISI 1020. Which step should you do first to get accurate simulation results?

hard

A. Export the part to a different CAD software

B. Assign Steel AISI 1020 as the material before running the simulation

C. Change the part color to gray to represent steel

D. Run the simulation without assigning any material

Solution

1. Step 1: Understand simulation requirements

   Accurate stress analysis needs correct material properties like Young's modulus and yield strength.

2. Step 2: Assign correct material

   Assigning Steel AISI 1020 sets these properties, enabling accurate simulation results.

3. Step 3: Avoid unrelated steps

   Changing color or exporting files does not affect simulation accuracy; running simulation without material gives wrong results.

4. Final Answer:

   Assign Steel AISI 1020 as the material before running the simulation -> Option B

5. Quick Check:

   Material assignment before simulation ensures accuracy [OK]

Hint: Assign material before simulation for correct physical properties [OK]

Common Mistakes:

• Running simulation without material assigned
• Thinking color affects simulation
• Exporting instead of assigning material