{"product_id":"product-line-plan-and-bom-sheet","title":"Product Line Plan and BOM Sheet","description":"\u003cp\u003e\u003cstrong\u003eLanded cost, not factory cost, is your real cost.\u003c\/strong\u003e 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.\u003c\/p\u003e\n\u003ch3\u003eWhat's inside\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eBOM tab:\u003c\/strong\u003e every component of every product, with quantity and cost\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eLanded Cost tab:\u003c\/strong\u003e adds freight, duty, packaging and inspection to give the true cost per unit, by SKU\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eLine Plan tab:\u003c\/strong\u003e 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\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eSuppliers tab:\u003c\/strong\u003e minimum orders, lead times, payment terms and quality ratings in one place\u003c\/li\u003e\n\u003cli\u003eSample data for three products, so you can see the whole flow\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch3\u003eWhy it works\u003c\/h3\u003e\n\u003cp\u003eThe SKU links every tab. Change a component cost or a duty rate and you see the effect on margin and line profit immediately.\u003c\/p\u003e\n\u003cp\u003e\u003cem\u003eFormat: Excel (.xlsx), works in Google Sheets. Instant download.\u003c\/em\u003e\u003c\/p\u003e","brand":"Tanner \u0026 Wright","offers":[{"title":"Default Title","offer_id":50919171129442,"sku":"TW-T-BOM","price":69.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0669\/1569\/6738\/files\/product-line-plan-and-bom-sheet.png?v=1794197937","url":"https:\/\/tannerandwright.com\/products\/product-line-plan-and-bom-sheet","provider":"Tanner \u0026 Wright","version":"1.0","type":"link"}