Ordering PCBs from fabricators in PCB Design - Cell-by-Cell Formula Trace

Sample Data

This table shows three PCB fabricators with their unit cost per PCB and the quantity of PCBs ordered. The goal is to calculate the total cost for each fabricator.

Cell	Value
A1	Fabricator
B1	Unit Cost
C1	Quantity
D1	Total Cost
A2	FabA
B2	5.00
C2	100
D2
A3	FabB
B3	4.50
C3	150
D3
A4	FabC
B4	5.20
C4	120
D4

Formula Trace

=B2*C2

Step 1: B2

Step 2: C2

Step 3: 5.00 * 100

Cell Reference Map

    A       B       C       D
1 |Fabricator|Unit Cost|Quantity|Total Cost
2 |  FabA   |  5.00  |  100   |  =B2*C2 
3 |  FabB   |  4.50  |  150   |  =B3*C3 
4 |  FabC   |  5.20  |  120   |  =B4*C4 

The formula references the unit cost in column B and quantity in column C for each fabricator row to calculate total cost in column D.

Result

    A       B       C       D
1 |Fabricator|Unit Cost|Quantity|Total Cost
2 |  FabA   |  5.00  |  100   |  500.00 
3 |  FabB   |  4.50  |  150   |  675.00 
4 |  FabC   |  5.20  |  120   |  624.00 

The total cost column shows the result of multiplying unit cost by quantity for each fabricator, giving the total price to order PCBs.

Sheet Trace Quiz - 3 Questions

What does the formula =B2*C2 calculate?

A Unit cost per PCB

B Total cost for FabA

C Quantity of PCBs

D Sum of unit cost and quantity

Key Result

Multiply unit cost cell by quantity cell to get total cost for each fabricator row.