Garment Costing & FOB Price Calculator – Complete Excel Tool for Apparel Cost Sheets

Description
This Garment Costing & FOB Price Calculator is a formula-driven Excel template built for garment manufacturers, merchandisers, sourcing agents, and exporters who need to price an order accurately before quoting a buyer. Rather than rebuilding a cost sheet from scratch for every style, this template provides a standardized, ready-to-use structure that captures every major cost component in garment production and rolls it up into a defensible FOB price.

The template follows the same logic used in real merchandising cost sheets. It starts with Style & Order Details (style number, buyer, product, quantity), then builds the per-garment cost step by step: Fabric Cost (consumption, wastage allowance, and price per meter/yard), Trims & Accessories Cost (buttons, labels, thread, packaging, and other trims), and CM Cost (cutting, sewing, finishing, and embellishment). These roll into an Overheads & Commission section, where factory overhead and buying/selling commission percentages are applied automatically. The Total Cost & FOB Price section then applies a user-defined profit margin using the standard markup-on-cost method to produce the final FOB price per garment.
From there, the Order-Level Summary multiplies everything by order quantity to show total order value, total cost, and total profit — useful for sanity-checking margins before confirming an order. An optional Buyer's Landed Cost Estimate section adds freight, insurance, and import duty to estimate the CIF price and landed cost the buyer will actually pay, which is useful context when negotiating FOB pricing. Every formula recalculates instantly as inputs change, making this ideal for comparing costing scenarios across multiple styles or buyers.