Package every drawing.
Engineering drawings are gathered, compressed, and distributed to a fictional supplier list in one controlled action.
Sourcing automation · Case study 02
RFQ to PO.
Zero handoffs.
DRAWINGS→QUOTES→BEST PRICE→PREDICTION→PO
One automated sourcing loop transforms engineering documents into an issued purchase order with every decision traceable.
DWG-101.pdfDWG-102.stepDWG-103.pdfDWG-104.dxfDWG-105.pdf
RFQ
PACKAGE5 files · ZIP
PACKAGE5 files · ZIP
↗
TO bids@orion.example
quotes@summit.example
rfq@vertex.example
quotes@summit.example
rfq@vertex.example
XCONSOLIDATED_QUOTES.xlsx3 supplier files aligned
| Part number | Rev | Description | Qty / BOM | Orion #210 | Summit #1038 | Vertex #8250 | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Qty | Unit price | Lead time | Qty | Unit price | Lead time | Qty | Unit price | Lead time | ||||
| PRT-210-1002 | 1 | Support plate | 2 | 2 | $118.40 | 3 wk | 4 | $112.10 | 4 wk | 2 | $121.80 | 3 wk |
| PRT-210-1003 | 1 | Cross bar | 2 | 2 | $111.28 | 3 wk | 4 | $69.57 | 3 wk | 2 | $116.20 | 4 wk |
| PRT-210-1004 | 1 | Removable plate A | 1 | 1 | $262.80 | 3 wk | 3 | $199.20 | 3 wk | 1 | $258.40 | 5 wk |
| PRT-210-1005 | 1 | Removable plate B | 1 | 1 | $262.80 | 3 wk | 5 | $190.00 | 3 wk | 1 | $255.10 | 5 wk |
48 normalized price points READY FOR COMPARISON ✓
PRICE ENGINEBest quoted price per piece
4 / 4 MATCHED| Part number | Qty / BOM | Orion #210 | Summit #1038 | MetroFab #8250 | Nova #4402 |
|---|---|---|---|---|---|
| PRT-210-1002 | 2 | $118.40 | BEST$109.80 | $115.90 | $112.25 |
| PRT-210-1003 | 2 | $111.28 | BEST$105.00 | $120.00 | $108.40 |
| PRT-210-1004 | 1 | BEST$262.80 | $631.50 | $635.00 | $450.00 |
| PRT-210-1005 | 1 | BEST$262.80 | $631.50 | $635.00 | $450.00 |
| Supplier total | $984.96 | $1,692.60 | $1,741.80 | $1,341.30 | |
| Delivery lead time | 3 weeks | 6 weeks | 4 weeks | 5 weeks | |
Orion$35.93/ unit
- Risk
- ±$2.30
- Confidence
- 94%
Summit$36.40/ unit
- Risk
- ±$2.81
- Confidence
- 87%
Vertex$35.87/ unit
- Risk
- ±$1.90
- Confidence
- 97%
Best predicted price at 500 pieces · Vertex Supply
POPURCHASE ORDER
# PO-260814
# PO-260814
- Supplier
- Vertex Supply
- Item
- Precision Housing A7
- Quantity
- 500 units
- Unit price
- $35.87
- Delivery
- September 18
TOTAL $17,935.00
AUTOAPPROVED
SENT TO SUPPLIER ✓
Normalize every return.
Every supplier workbooks arrive once, then settle into a single standardized sheet that keeps every quoted quantity, unit price and lead time comparable.
Find the lowest quote per piece.
The system checks every returned quote line by line and immediately identifies the best price per piece, while retaining supplier totals and delivery lead times.
Predict the exact order price.
I reverse engineered supplier quotes at their given quantities to build intersecting price curves. This provides an accurate unit price prediction for the exact quantity ordered each time, with dollar risk and confidence kept visible.
Issue the purchase order.
The winning bid flows directly into a completed PO, ready for digital approval and dispatch.
01 / DRAWING EXTRACTION
Package every drawing.
Engineering drawings are gathered, compressed, and distributed to a fictional supplier list in one controlled action.
DWG-101.pdfDWG-102.stepDWG-103.pdfDWG-104.dxfDWG-105.pdf
RFQ
PACKAGE5 files · ZIP
PACKAGE5 files · ZIP
↗
TO bids@orion.example
quotes@summit.example
rfq@vertex.example
quotes@summit.example
rfq@vertex.example
02 / QUOTE AGGREGATION
Normalize every return.
Every supplier workbooks arrive once, then settle into a single standardized sheet that keeps every quoted quantity, unit price and lead time comparable.
XCONSOLIDATED_QUOTES.xlsx3 supplier files aligned
| Part number | Rev | Description | Qty / BOM | Orion #210 | Summit #1038 | Vertex #8250 | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Qty | Unit price | Lead time | Qty | Unit price | Lead time | Qty | Unit price | Lead time | ||||
| PRT-210-1002 | 1 | Support plate | 2 | 2 | $118.40 | 3 wk | 4 | $112.10 | 4 wk | 2 | $121.80 | 3 wk |
| PRT-210-1003 | 1 | Cross bar | 2 | 2 | $111.28 | 3 wk | 4 | $69.57 | 3 wk | 2 | $116.20 | 4 wk |
| PRT-210-1004 | 1 | Removable plate A | 1 | 1 | $262.80 | 3 wk | 3 | $199.20 | 3 wk | 1 | $258.40 | 5 wk |
| PRT-210-1005 | 1 | Removable plate B | 1 | 1 | $262.80 | 3 wk | 5 | $190.00 | 3 wk | 1 | $255.10 | 5 wk |
48 normalized price points READY FOR COMPARISON ✓
03 / BEST QUOTED PRICE
Find the lowest quote per piece.
The system checks every returned quote line by line and immediately identifies the best price per piece, while retaining supplier totals and delivery lead times.
PRICE ENGINEBest quoted price per piece
4 / 4 MATCHED| Part number | Qty / BOM | Orion #210 | Summit #1038 | MetroFab #8250 | Nova #4402 |
|---|---|---|---|---|---|
| PRT-210-1002 | 2 | $118.40 | BEST$109.80 | $115.90 | $112.25 |
| PRT-210-1003 | 2 | $111.28 | BEST$105.00 | $120.00 | $108.40 |
| PRT-210-1004 | 1 | BEST$262.80 | $631.50 | $635.00 | $450.00 |
| PRT-210-1005 | 1 | BEST$262.80 | $631.50 | $635.00 | $450.00 |
| Supplier total | $984.96 | $1,692.60 | $1,741.80 | $1,341.30 | |
| Delivery lead time | 3 weeks | 6 weeks | 4 weeks | 5 weeks | |
04 / PRICE CURVE ANALYSIS
Predict the exact order price.
I reverse engineered supplier quotes at their given quantities to build intersecting price curves. This provides an accurate unit price prediction for the exact quantity ordered each time, with dollar risk and confidence kept visible.
Orion$35.93/ unit
- Risk
- ±$2.30
- Confidence
- 94%
Summit$36.40/ unit
- Risk
- ±$2.81
- Confidence
- 87%
Vertex$35.87/ unit
- Risk
- ±$1.90
- Confidence
- 97%
Best predicted price at 500 pieces · Vertex Supply
05 / PO ISSUANCE
Issue the purchase order.
The winning bid flows directly into a completed PO, ready for digital approval and dispatch.
POPURCHASE ORDER
# PO-260814
# PO-260814
- Supplier
- Vertex Supply
- Item
- Precision Housing A7
- Quantity
- 500 units
- Unit price
- $35.87
- Delivery
- September 18
TOTAL $17,935.00
AUTOAPPROVED
SENT TO SUPPLIER ✓
Sourcing outcome
RFQ to PO.
Fully automated.
0Manual steps
across the pipeline
across the pipeline