Apparel Cost Sheet Template

Apparel Cost Sheet Template

A costing engine, not a calculator grid. Set country of origin, HTS chapter, and currency in the header and the sheet runs the rest: duty pulls from a built-in tariff table, vendor-currency costs convert to USD automatically, and the full FOB → LDP → wholesale → MSRP waterfall builds as you enter costs.

• Complete cost waterfall: fabrics, trims, CMT, pack & ship, and overhead through FOB, LDP, wholesale, and MSRP
• Duty engine — country of origin plus HTS chapter auto-applies the rate at landed cost
• Multi-currency: enter costs in the currency you pay your vendor; the USD reporting column converts automatically
• Color-coded margin analysis against your wholesale and retail targets
• Seasonal Cost Roll-Up dashboard — one row per style, every figure pulls in by tab name
• Three overhead modes (percentage, dollar, off) and adjustable margin targets in settings

Excel 2016+ (desktop) · Mac + Windows · Instant Download