{"product_id":"distribution-and-deliveries-tracker","title":"Distribution and Deliveries Tracker","description":"\u003cp\u003e\u003cstrong\u003eThe problem.\u003c\/strong\u003e Stock is counted in one file, deliveries are written on run sheets or sent by message, and delivery problems are remembered rather than recorded. Nobody has one clear view of which deliveries are late, what went wrong and what needs reordering.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat this does.\u003c\/strong\u003e You keep one list of products, one of stock movements, one of delivery runs, one of shipments and one of exceptions. The workbook works out stock on hand, each product's reorder status, whether each delivered shipment was on time, how many days each exception has been open, and counts them on a dashboard.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat you can do with it\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eSee open shipments, overdue shipments and the share of delivered shipments that arrived on time.\u003c\/li\u003e\n\u003cli\u003eSee runs and shipments by route, as a table and a bar chart, and shipments by status.\u003c\/li\u003e\n\u003cli\u003eSee open exceptions by type, and which have been open long enough to chase.\u003c\/li\u003e\n\u003cli\u003eSee stock on hand for every product, with the products at or below the reorder level you typed.\u003c\/li\u003e\n\u003cli\u003eSee stock value at cost, and which delivered shipments have no stock-out recorded.\u003c\/li\u003e\n\u003cli\u003eChoose your industry (food and beverage, building and trade supplies, or retail) to load suitable lists, then edit them to suit you.\u003c\/li\u003e\n\u003cli\u003eKeep your records in a clear structure: a Data Dictionary explains every column, and six export sheets repeat your records under plain field names.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eHow it works\u003c\/strong\u003e\u003c\/p\u003e\u003col\u003e\n\u003cli\u003eEnter your business name, choose your industry, and type your routes, drivers, vehicles and delivery rules.\u003c\/li\u003e\n\u003cli\u003eAdd your products, delivery runs and shipments, and record each stock movement.\u003c\/li\u003e\n\u003cli\u003eCheck the dashboard each day.\u003c\/li\u003e\n\u003c\/ol\u003e\u003cp\u003e\u003cstrong\u003eA shipment is one delivery.\u003c\/strong\u003e What is on it goes in a free-text Items cell. Stock leaves your count through an Out row on the Stock movements sheet, tied to the shipment by typing its reference. A product shows Reorder when its stock on hand is at or below the reorder level you typed.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWho it is for.\u003c\/strong\u003e Sole traders and small teams who stock and deliver goods and want to see late deliveries, delivery problems and low stock at a glance.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWho it is not for.\u003c\/strong\u003e Businesses that need stock-control or delivery-management software that takes orders or sends alerts. This is a spreadsheet: it does not send anything or connect to any other software.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat you need.\u003c\/strong\u003e Microsoft Excel 2016 or later. It was tested in Excel for Windows. No macros, no add-ins and no subscription.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eGood to know\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e400 product rows, 1,500 stock movement rows and 1,000 shipment rows are ready, and you can add more by dragging the last row down.\u003c\/li\u003e\n\u003cli\u003eThe grace days and the days before an open exception is flagged are your own numbers, typed on Settings. Nothing is a built-in rule.\u003c\/li\u003e\n\u003cli\u003eStock on hand counts every movement, whatever its date. Stock value at cost is on hand times the unit cost you typed.\u003c\/li\u003e\n\u003cli\u003eThe dashboard lists show the first eight in sheet order, not the worst eight.\u003c\/li\u003e\n\u003cli\u003eAn example copy with a made-up business shows every sheet working before you start.\u003c\/li\u003e\n\u003cli\u003eNothing is locked or password protected.\u003c\/li\u003e\n\u003cli\u003eUse this template to capture and improve your business data now. In future you can automate with AI.\u003c\/li\u003e\n\u003cli\u003eGeneral information only. It is not accounting, tax, legal or financial advice.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"TeleWorld Online","offers":[{"title":"Default Title","offer_id":48859262189773,"sku":null,"price":34.0,"currency_code":"AUD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0652\/1031\/9053\/files\/01-cover_0409b90f-c7e7-40b2-a985-5f48eceb5827.png?v=1795098539","url":"https:\/\/www.teleworld.online\/ko\/products\/distribution-and-deliveries-tracker","provider":"TeleWorld Online","version":"1.0","type":"link"}