{"product_id":"patch-inventory-reorder-planner","title":"Patch Inventory \u0026 Reorder Planner – 6 Patch Designs, On-Hand Stock, Event Use, Lead Times, Pack Sizes \u0026 Reorder Costs","description":"\u003cstyle\u003e.p{max-width:800px;margin:auto;padding:36px 24px;font:15px Poppins,sans-serif;color:#302c2c;line-height:1.7}.h{text-align:center}.pill{background:#2d5f3f;color:#fff;padding:5px 14px;border-radius:20px;font-size:11px;font-weight:700;text-transform:uppercase}.h1{font-size:30px}.h1 span{color:#2d5f3f}.bar,.call{background:#fff8ed;border:2px solid #f7931e;border-radius:12px;padding:15px 20px;margin:24px 0;font-size:13px}.bar span{color:#2d5f3f}.g{display:grid;grid-template-columns:repeat(3,1fr);gap:12px;margin:24px 0}.c,.s{background:#f9f9f9;border:1px solid #e5e7eb;border-radius:12px;padding:15px;text-align:center;font-size:12px}.c b,.s b{display:block;font-size:13px}.calc{background:#2d5f3f;color:#fff;border-radius:12px;padding:22px;margin:28px 0}.calc ul{columns:2;font-size:13px}.big{font-size:20px;color:#2d5f3f;font-weight:800}.vault{background:#f0f7f2;border:2px solid #2d5f3f;border-radius:12px;padding:15px 20px;margin:24px 0;font-size:13px}.vault a{color:#2d5f3f;font-weight:700}h2.cc-title{display:block;border-bottom:0;padding-bottom:0}\u003c\/style\u003e\u003cdiv class=\"p\"\u003e\n\u003cdiv class=\"h\"\u003e\n\u003cspan class=\"pill\"\u003eTrucker Hat Bar Calculators · Instant Download\u003c\/span\u003e\u003ch2 class=\"h1 cc-title\"\u003eKeep Patch Stock Ready for Events — \u003cspan\u003ePatch Designs, On-Hand Stock, Event Use, Lead Times, Pack Sizes, and Reorder Costs\u003c\/span\u003e\n\u003c\/h2\u003e\n\u003cp\u003eA patch inventory and reorder planner. Enter events per month and safety stock, then up to 6 patch designs with on-hand quantity, use per event, lead time, cost per patch, and supplier pack size to see monthly use, events left, reorder points, suggested order quantities, order costs, and which designs need reordering.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"bar\"\u003eRunning low before an event can leave a design unavailable. Track use and lead time to plan orders before stock runs out. \u003cspan\u003eOne download. Use it forever.\u003c\/span\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"g\"\u003e\n\u003cdiv class=\"c\"\u003e\n\u003cb\u003eEditable Spreadsheet\u003c\/b\u003eGoogle Sheets and Excel\u003c\/div\u003e\n\u003cdiv class=\"c\"\u003e\n\u003cb\u003e6 Designs\u003c\/b\u003eSide by side\u003c\/div\u003e\n\u003cdiv class=\"c\"\u003e\n\u003cb\u003eReorder Point\u003c\/b\u003eLead time stock\u003c\/div\u003e\n\u003cdiv class=\"c\"\u003e\n\u003cb\u003eOrder Cost\u003c\/b\u003ePack size included\u003c\/div\u003e\n\u003cdiv class=\"c\"\u003e\n\u003cb\u003eStatus Line\u003c\/b\u003eChecks your numbers\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"calc\"\u003e\n\u003ch2\u003eWhat This Spreadsheet Calculates\u003c\/h2\u003e\n\u003cul\u003e\n\u003cli\u003eUsed per month\u003c\/li\u003e\n\u003cli\u003eEvents left\u003c\/li\u003e\n\u003cli\u003eReorder point\u003c\/li\u003e\n\u003cli\u003eReorder status\u003c\/li\u003e\n\u003cli\u003eSuggested order qty\u003c\/li\u003e\n\u003cli\u003eOrder cost\u003c\/li\u003e\n\u003cli\u003eDesigns to reorder\u003c\/li\u003e\n\u003cli\u003eTotal order cost\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"g\"\u003e\n\u003cdiv class=\"s\"\u003e\n\u003cb\u003e1. Enter Plan\u003c\/b\u003eEvents and safety\u003c\/div\u003e\n\u003cdiv class=\"s\"\u003e\n\u003cb\u003e2. Add Stock\u003c\/b\u003eOn-hand quantity\u003c\/div\u003e\n\u003cdiv class=\"s\"\u003e\n\u003cb\u003e3. List Patches\u003c\/b\u003eUsage and lead time\u003c\/div\u003e\n\u003cdiv class=\"s\"\u003e\n\u003cb\u003e4. Review Orders\u003c\/b\u003eQuantity and cost\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"vault\"\u003e\n\u003cb\u003eIncluded in the Lifetime Spreadsheet Vault.\u003c\/b\u003e Get this calculator plus every other Craft Calculators spreadsheet, and every new one we add, for one price. \u003ca href=\"\/products\/lifetime-access\"\u003eSee the Vault →\u003c\/a\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"call\"\u003e\n\u003cb\u003eWHY THIS MATTERS\u003c\/b\u003e\u003cp\u003ePatch stock needs to cover use during supplier lead time as well as the safety events you want to keep on hand.\u003c\/p\u003e\n\u003cp class=\"big\"\u003eReorder before events.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\u003c!-- split --\u003e\u003cdiv\u003e✔ Unlimited downloads with free future updates\u003c\/div\u003e\u003cdiv\u003e✔ Editable in Google Sheets and Excel\u003c\/div\u003e\u003cdiv\u003e✔ Includes a step-by-step Instructions tab\u003c\/div\u003e","brand":"Craft Calculators","offers":[{"title":"Default Title","offer_id":67981593411894,"sku":null,"price":9.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0893\/3569\/3622\/files\/patch-inventory-reorder-planner-main.jpg?v=1794363351","url":"https:\/\/craftcalculators.com\/products\/patch-inventory-reorder-planner","provider":"Craft Calculators","version":"1.0","type":"link"}