Product Line Plan and BOM Sheet

Landed cost, not factory cost, is your real cost. Freight, duty and packaging are where product margin quietly disappears. This is the line plan structure consumer brand product teams use, built so a small brand can run it.

What's inside

• BOM tab: every component of every product, with quantity and cost
• Landed Cost tab: adds freight, duty, packaging and inspection to give the true cost per unit, by SKU
• Line Plan tab: retail and wholesale margin for every product, forecast revenue and gross profit, and a blended margin for the whole line. Products under your target margin are flagged red
• Suppliers tab: minimum orders, lead times, payment terms and quality ratings in one place
• Sample data for three products, so you can see the whole flow

Why it works

The SKU links every tab. Change a component cost or a duty rate and you see the effect on margin and line profit immediately.

Format: Excel (.xlsx), works in Google Sheets. Instant download.