Active Purchase Orders
5
3 in transit ยท 1 ready to ship
In-Transit Value
$0
Base + freight + tariff
Pending ASNs
2
Ready to push to Control Port
EOM COGS (Jun)
$0
US + UK territories
Shipment Pipeline
All active POs
| PO # | Supplier | Dest. | Units | Status | Landed Cost |
|---|
Landed Cost Breakdown
Active in-transit shipments
Territory Split
In-transit by warehouse
๐บ๐ธ Columbus, USA
$0
0 units in transit
๐ฌ๐ง Northampton, UK
$0
0 units in transit
Workflow Status
Recent activity
โน๏ธ
Purchase Orders are automatically imported from Shopify via GraphQL webhooks. Create a new PO to simulate the ingress event.
| PO # | Supplier | Origin | Destination | SKU(s) | Units | Base Cost | Landed Cost | Status | Actions |
|---|
Allocate Freight Invoice
Landed Cost Calculator
Freight History
๐ Pair Freight Invoice to PO
๐งฎ Tariff Rate Matrix
| Origin Country | ๐บ๐ธ Columbus Rate | ๐ฌ๐ง Northampton Rate |
|---|
๐ Rolling Average Formula
When a shipment is received, the per-SKU shipping average updates automatically:
AvgNew = โ(AvgOld ร QtyExist) + (FreightAllocated ร QtyNew)โ รท (QtyExist + QtyNew)
This ensures precise COGS allocation without static FIFO batching.
๐ข Manual Landed Cost Calculator
Base Cost (total)โ
Freight Costโ
Tariff Rateโ
Tariff Amountโ
๐ฐ Total Landed Valueโ
Per Unit Breakdown
Base Cost/unitโ
Freight/unitโ
Tariff/unitโ
Landed Cost/unitโ
๐ Cost Component Visual
| Date | PO # | Invoice Ref | Carrier | Total Freight | Allocated To | Territory | Avg Landed/Unit |
|---|
๐
ASNs are auto-generated when a PO reaches "Ready to Ship" status. Push to Control Port to populate their incoming dashboard. The warehouse will confirm receipt via webhook callback.
Pending ASN Queue
| ASN # | PO Ref | Warehouse | SKUs | Units | Est. Delivery | Download |
|---|
Sent ASNs
Sent
| ASN # | PO Ref | Downloaded | Warehouse | Status |
|---|
Integration Event Log
| Timestamp | Event | Direction | Payload | Status |
|---|
In-Transit Valuation
In Production
EOM COGS Report
โ
In-Transit Value = ฮฃ [ QtyShipped ร (Base Cost + Allocated Shipping + Estimated Tariff) ]
Total In-Transit Value
$0
All active shipments
Columbus In-Transit
$0
North American territory
Northampton In-Transit
$0
UK/EU territory
In-Transit Shipment Detail
| PO # | SKU | Supplier | Dest. | Qty Shipped | Base Cost | Freight Alloc. | Est. Tariff | Total Value |
|---|
๐ญ
In-Production Value = ฮฃ [ Qty Ordered ร Base Cost ] for all Pending POs
Total In Production
ยฃ0
All pending orders
Columbus โ On Order
ยฃ0
North American territory
Northampton โ On Order
ยฃ0
UK/EU territory
In-Production PO Detail
| PO # | SKU | Supplier | Origin | Dest. | Qty Ordered | Unit Cost | Line Value | Completion Date |
|---|
๐บ๐ธ Columbus, USA โ COGS Breakdown
$0
Base Factory + US Freight Rolling Avg + US Customs Tariff
| Component | Value |
|---|
๐ฌ๐ง Northampton, UK โ COGS Breakdown
$0
Base Factory + UK Freight Rolling Avg + Post-Brexit HMRC Tariff
| Component | Value |
|---|
Per-SKU COGS by Territory
| SKU | Description | Territory | Base Cost | Freight Avg | Tariff | Total Landed COGS | Units Received | Total COGS |
|---|
๐
Rolling averages are updated automatically when a PO is marked as received. These values feed directly into the COGS calculation engine.
SKU Shipping Rolling Averages โ All Territories
| SKU | Description | ๐บ๐ธ US Freight Avg/Unit | ๐บ๐ธ US Qty | ๐ฌ๐ง UK Freight Avg/Unit | ๐ฌ๐ง UK Qty | Last Updated |
|---|
๐
Rate changes apply to new POs only. Any PO already marked as Received has its tariff rates permanently locked at the rates in effect at receipt โ editing here will not change historical valuations.
๐บ๐ธ US Tariff Schedule (Columbus)
HTS Codes
| Origin Country | Duty Rate | Authority |
|---|
๐ฌ๐ง UK Tariff Schedule (Northampton)
HMRC / UK Global Tariff
| Origin Country | Duty Rate | Authority |
|---|
๐ Rate Change History
| Date | Change | Before โ After | Note |
|---|
Formula Reference
Tariff Cost per Line Item:
Tariff Cost = Base Cost ร Tariff Rate
In-Transit Inventory Valuation:
In-Transit Value = ฮฃ [ QtyShipped ร (Base Cost + Allocated Shipping + Estimated Tariff) ]
Rolling Average Shipping Update (on receipt):
AvgShippingNew = โ(AvgShippingOld ร QtyExist) + (AllocatedFreight ร QtyNew)โ รท (QtyExist + QtyNew)
All SKUs โ Live from Google Sheets
Loadingโฆ
| SKU | Description | Type | Collection | Product Cost | UK LC Avg | US LC Avg |
|---|