Ordering PCBs from fabricators in PCB Design - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Lead Time Impact on PCB Delivery

You are managing a PCB order with a fabricator. The fabricator states the lead time is 10 business days. If you place the order on a Wednesday, on which day will you expect the PCBs to arrive, assuming no holidays?

A The Wednesday two weeks later

B The following Friday (10 business days later)

C The Monday after 10 calendar days

D The second Friday after the order day

💡 Hint

Count only weekdays, excluding weekends.

Lead time counts business days. Starting Wednesday, 10 business days later lands on the Wednesday two weeks later.

❓ data_modeling

intermediate

Choosing Key Data Fields for PCB Order Tracking

Which set of data fields is most essential to track PCB orders effectively in a BI dashboard?

A Order ID, Fabricator Name, Order Date, Quantity, Delivery Date, Status

B Order ID, Customer Name, Payment Method, Delivery Address, Status

C Fabricator Name, Order Date, PCB Layer Count, Color, Status

D Order Date, Quantity, PCB Thickness, Delivery Address, Payment Method

💡 Hint

Focus on fields that track order progress and delivery.

Order ID, Fabricator Name, Order Date, Quantity, Delivery Date, and Status provide clear tracking of PCB orders and delivery status.

❓ dax_lod_result

advanced

Calculating Average Delivery Delay Using DAX

Given a table 'Orders' with columns 'OrderDate' and 'ActualDeliveryDate', which DAX measure correctly calculates the average delivery delay in days?

Average Delay = AVERAGEX(Orders, DATEDIFF(Orders[OrderDate], Orders[ActualDeliveryDate], DAY))

A Average Delay = AVERAGE(DATEDIFF(Orders[OrderDate], Orders[ActualDeliveryDate], DAY))

B Average Delay = AVERAGEX(Orders, DATEDIFF(Orders[OrderDate], Orders[ActualDeliveryDate], DAY))

C Average Delay = SUMX(Orders, Orders[ActualDeliveryDate] - Orders[OrderDate]) / COUNTROWS(Orders)

D Average Delay = CALCULATE(AVERAGE(Orders[ActualDeliveryDate] - Orders[OrderDate]))

💡 Hint

Use AVERAGEX to iterate row by row and calculate difference.

AVERAGEX iterates over each order calculating the date difference, then averages the results. Other options either misuse functions or produce errors.

❓ visualization

advanced

Best Visualization for PCB Order Status Overview

You want to show the current status distribution of PCB orders (e.g., Pending, In Production, Shipped, Delivered) on a dashboard. Which visualization type is best suited for this?

A Stacked bar chart showing counts per status

B Line chart showing status changes over time

C Pie chart showing percentage of orders per status

D Scatter plot showing order quantity vs. delivery time

💡 Hint

Think about showing parts of a whole clearly.

A pie chart clearly shows the proportion of orders in each status category at a glance, which is ideal for status distribution.

🔧 Formula Fix

expert

Identifying Error in DAX Measure for Total PCB Quantity

Review the following DAX measure intended to calculate total PCB quantity ordered:

Total Quantity = SUM(Orders[QuantityOrdered]) + SUM(Orders[QuantityShipped])

What is the main issue with this measure?

A SUM cannot be used on multiple columns in one expression

B It should use COUNT instead of SUM for quantities

C The measure syntax is invalid due to missing aggregation function

D It double counts quantities because QuantityOrdered and QuantityShipped overlap

💡 Hint

Consider what QuantityOrdered and QuantityShipped represent.

QuantityShipped is part of QuantityOrdered, so adding both sums counts shipped quantities twice.

Practice

1. What is the primary purpose of ordering PCBs from fabricators?

easy

A. To simulate electronic circuits on a computer

B. To turn your design into a physical board for testing or production

C. To create 3D models of the PCB

D. To write software code for the PCB

Solution

1. Step 1: Understand the role of PCB fabrication

   PCB fabrication is the process of making a physical printed circuit board from a design.

2. Step 2: Identify the purpose of ordering PCBs

   Ordering PCBs from fabricators allows you to get a real board for testing or production use.

3. Final Answer:

   To turn your design into a physical board for testing or production -> Option B

4. Quick Check:

   PCB ordering = physical board creation [OK]

Hint: PCB fabrication means making a real board from your design [OK]

Common Mistakes:

• Confusing PCB fabrication with software coding
• Thinking PCB ordering creates simulations
• Assuming it produces 3D models instead of physical boards

2. Which of the following file types is essential to provide when ordering PCBs from fabricators?

easy

A. JPEG images

B. Word documents

C. Gerber files

D. MP3 audio files

Solution

1. Step 1: Identify the standard file format for PCB fabrication

   Gerber files contain the detailed layer information needed by fabricators to produce PCBs.

2. Step 2: Compare with other file types

   JPEG, Word, and MP3 files do not contain PCB manufacturing data and are irrelevant for fabrication.

3. Final Answer:

   Gerber files -> Option C

4. Quick Check:

   Gerber files = PCB manufacturing data [OK]

Hint: Gerber files are the PCB blueprint for fabricators [OK]

Common Mistakes:

• Submitting image files instead of Gerber files
• Confusing documentation files with fabrication files
• Not knowing the correct file format for PCB production

3. You have two fabricators: Fabricator A charges $50 for 10 PCBs with 7 days delivery, Fabricator B charges $40 for 10 PCBs with 14 days delivery. If you need the PCBs urgently, which fabricator should you choose?

medium

A. Fabricator A because of faster delivery

B. Fabricator B because it is cheaper

C. Either one, delivery time does not matter

D. Order from both to compare quality

Solution

1. Step 1: Analyze delivery times

   Fabricator A delivers in 7 days, Fabricator B in 14 days.

2. Step 2: Consider urgency

   If PCBs are needed urgently, faster delivery is more important than cost.

3. Final Answer:

   Fabricator A because of faster delivery -> Option A

4. Quick Check:

   Urgent need = choose faster delivery [OK]

Hint: Urgent orders need faster delivery, not just cheaper price [OK]

Common Mistakes:

• Choosing cheaper option despite urgent need
• Ignoring delivery time importance
• Thinking ordering both is always best

4. You submitted Gerber files to a fabricator but received an error saying files are incomplete. What is the most likely cause?

medium

A. Missing one or more required Gerber layers

B. Files are too large in size

C. You sent JPEG images instead of Gerber files

D. The fabricator does not accept Gerber files

Solution

1. Step 1: Understand Gerber file requirements

   Fabricators require all necessary layers (copper, solder mask, silkscreen, etc.) to produce PCBs.

2. Step 2: Identify common error cause

   An incomplete set of Gerber layers causes errors during file validation.

3. Final Answer:

   Missing one or more required Gerber layers -> Option A

4. Quick Check:

   Incomplete Gerber layers = error [OK]

Hint: Check all required Gerber layers are included before submitting [OK]

Common Mistakes:

• Assuming file size causes error
• Sending wrong file types
• Thinking fabricators reject Gerber files

5. You want to order 50 PCBs with the following specs: 2-layer board, 1.6mm thickness, HASL finish, and 0.8mm minimum trace width. Which step should you take to ensure the fabricator can meet these requirements?

hard

A. Ask the fabricator to decide the specs after receiving the files

B. Send only the Gerber files without any specification details

C. Order the PCBs without confirming specifications to save time

D. Check the fabricator's specification sheet for supported thickness, layers, finish, and trace width

Solution

1. Step 1: Understand importance of specification matching

   Fabricators have limits on board thickness, layers, finishes, and trace widths they can produce.

2. Step 2: Verify fabricator capabilities

   Reviewing the fabricator's specification sheet ensures your requirements are supported before ordering.

3. Final Answer:

   Check the fabricator's specification sheet for supported thickness, layers, finish, and trace width -> Option D

4. Quick Check:

   Confirm specs with fabricator before ordering [OK]

Hint: Always verify fabricator specs match your PCB requirements [OK]

Common Mistakes:

• Assuming fabricator can produce any specs
• Not communicating specs clearly
• Relying on fabricator to guess requirements