{"product_id":"product-mix-analysis-template","title":"Product Mix Analysis Template","description":"\u003ch2\u003eOptimize Your Vending Machine Products With Data, Not Guesswork\u003c\/h2\u003e\n\u003cp\u003e\u003cstrong\u003eProduct Mix Analysis Template\u003c\/strong\u003e\u003cspan\u003e \u003c\/span\u003eis an official companion resource created to support, extend, and enhance the implementation of\u003cspan\u003e \u003c\/span\u003e\u003cstrong\u003eThe Vending Machine Success System\u003c\/strong\u003e. This Excel workbook helps vending machine operators track products, locations, restock visits, sales performance, dead stock, out-of-stock issues, and product mix recommendations from one organized system.\u003c\/p\u003e\n\u003cp\u003eThis workbook is designed for vending operators who want to understand which products are actually selling, which items are underperforming, and how each machine location is contributing to revenue and gross profit. Instead of guessing what to stock, operators can use this template to log product movement, compare performance, and make smarter inventory decisions over reusable analysis periods.\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eIncludes a fast-start guide explaining the full workflow: set products, set locations, log sales and restocks, review winners and losers, adjust product mix, and repeat.\u003c\/li\u003e\n\u003cli\u003eProvides a product catalog for tracking each SKU, category, cost per unit, sale price, gross profit per unit, gross margin percentage, case size, and supplier\/source notes.\u003c\/li\u003e\n\u003cli\u003eIncludes a location setup sheet for tracking location name, machine type, commission percentage, optional flat fee, and audience preference notes.\u003c\/li\u003e\n\u003cli\u003eProvides a sales log for recording each restock visit by period, visit ID, location, product, units stocked, units remaining, units sold, revenue, gross profit, out-of-stock flag, and notes.\u003c\/li\u003e\n\u003cli\u003eUses formulas to calculate units sold, revenue, and gross profit based on product catalog pricing and sales log activity.\u003c\/li\u003e\n\u003cli\u003eIncludes performance analysis for reviewing units sold, revenue, gross profit, velocity, dead-stock alerts, top-selling products, and bottom-selling products.\u003c\/li\u003e\n\u003cli\u003eIncludes editable dead-stock thresholds so operators can flag slow-moving products based on units sold and profit per period.\u003c\/li\u003e\n\u003cli\u003eProvides inventory optimization recommendations such as increasing facings, reducing facings, or keeping the current product mix based on performance.\u003c\/li\u003e\n\u003cli\u003eIncludes a dashboard for quick KPIs such as total revenue, total gross profit, gross margin percentage, net margin estimate, out-of-stock rate, dead stock count, and location comparison.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eUse this workbook to make more confident vending inventory decisions, reduce slow-moving products, spot best sellers faster, and improve product mix performance across your machine locations.\u003c\/p\u003e","brand":"CPI Digital Hub LLC","offers":[{"title":"Default Title","offer_id":62034649940338,"sku":null,"price":19.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0888\/6203\/2242\/files\/ChatGPTImageJul28_2026_03_12_06PM.png?v=1785306706","url":"https:\/\/cpidigitalhub.com\/products\/product-mix-analysis-template","provider":"CPI Digital Hub LLC","version":"1.0","type":"link"}