Costing Engine
Julia NguyenProduct Director
JN

Costing Engine

Build, compare, and approve product cost scenarios for the upcoming season.

📋
↗ 8%

1,246

Total Cost Sheets · SS27

↗ 6%

68%

Target Cost Met · SS27

⚠️
↘ 14%

112

At Risk Styles · SS27

📑
↘ 11%

89

Pending Approvals · SS27

Summit Explorer Jacket

In DevelopmentCost Sheet v3.2

ELEV-27045 · Category: Outerwear · Gender: Men · Size Range: S - 3XL · Season: SS27 · Supplier: Apex Manufacturing Ltd.

Target Retail

USD 199.00

Target FOB

USD 58.00

Approval Status

In Review

Cost Sheet Summary (USD)

Cost Sheet v3.2
Cost ComponentTargetQuotedApprovedVarianceVariance %
Material Cost
$23.80$24.25$24.10$0.30+1.26%
Trim & Components
$5.76$5.90$5.85$0.09+1.74%
Labor Cost
$12.50$12.30$12.30-$0.20-1.60%
Overhead
$4.75$4.70$4.70-$0.05-1.05%
Total Cost (FOB)$51.70$52.25$52.05$0.35+0.68%
Margin$6.30$6.45$6.45$0.15+2.38%
Total Cost (Landed)
$58.95$59.85$59.65$0.70+1.19%

Recent Costing Activity

AN

Aimee Nguyen updated Labor Cost

Cost Sheet v3.2 · May 20, 2024 10:30 AM

JL

Jordan Lee updated Material Cost

Cost Sheet v3.1 · May 20, 2024 09:15 AM

JN

Julia Nguyen created Cost Sheet v3.0

Cost Sheet v3.0 · May 19, 2024 04:45 PM

Cost Version History

VersionDateLandedStatus
v3.2CurrentMay 20, 2024 $59.65In Review
v3.1May 20, 2024$59.45Superseded
v3.0May 19, 2024$60.05Superseded

Margin Simulation ⓘ

32.4%

Target Retail

$199.00

Projected Margin

32.4% (-2.4%)

Simulate Margin %

0%
30.0%50%

FOB vs Landed Cost

FOB Cost (Approved)

$52.05

Landed Cost (Approved)

$59.65

+$7.60 (14.6%)
FOB Cost 87.2%Duties 6.1%Taxes 3.8%Inland Freight 2.9%

Approval Workflow

Costing Analyst

Aimee Nguyen · May 20, 2024 10:30 AM

Approved

Costing Manager

Next Approver: Jordan Lee

In Review
⏸️

Director, Commercial

Pending
⏸️

VP, Sourcing

Pending

Scenario Comparison Matrix

Scenario 1

Target Efficiency

FOB Cost$51.70
Landed Cost$58.95
Margin %30.0%
vs Target0.0%

Scenario 2

Value Engineering

FOB Cost$51.90
Landed Cost$57.35
Margin %22.8%
vs Target+2.8%

Scenario 3

Alt Supplier (BR)

FOB Cost$52.80
Landed Cost$60.05
Margin %28.0%
vs Target-1.0%

Scenario 4

Sustainability Premium

FOB Cost$55
Landed Cost$61
Margin %25%
vs Target-4%