MMDSolutions

Solutions documentation · Version 1.0.0

Inventory Reorder Calculator: how it works

Turn stock and sales files into an explainable replenishment plan.

Open Inventory Reorder CalculatorTry the example

One-off local software. No Hub account or subscription required. Check the tool page for purchase availability.

One clear goal

Produce a replenishment plan from your own stock snapshot and sales totals, with visible calculations and validation issues.

Prepare your CSV files

Extract the ZIP and open index.html in a current browser. Load the fictional example to see the format. You can paste CSV text or choose files. Use comma-separated UTF-8 CSV with these headers:

Use whole, non-negative units for all stock and sales values; pack size must be at least 1. Lead time and observation/review periods use whole days. Values and aggregated sales per SKU are limited to 1 billion. Use zero for no orders, backorders, safety stock or minimum order quantity. SKU values are case-sensitive and outer whitespace is trimmed. Stock must have one row per SKU. Multiple sales rows are summed.

Calculate and review

  1. Ensure sales include only the stated observation period; the tool does not filter dates. Remove cancelled orders and handle returns according to your own consistent sales definition before importing.
  2. Enter the observation period (for example, 30 days) and review period (for example, 7 days between purchasing reviews).
  3. Choose Calculate replenishment. Review the plan and validation issues. The screen previews the first 100 SKUs/issues; downloads include all.
  4. Download the plan CSV and audit JSON. Keep the original files and assumptions with the report.

Inventory replenishment example with visible assumptions

The calculations

The suggested quantity is a periodic top-up; it can be positive even when the reorder-now flag is No. The flag is a separate lead-time warning. Decide when to place the order using your purchasing policy.

For the sample MUG-NAVY, 60 units / 30 days = 2 per day. Position is 12. Reorder point is 2 × 7 + 5 = 19; target is 2 × 14 + 5 = 33. The shortfall is 21; MOQ 12 and pack size 6 give a suggested order of 24. Coverage is 6 days.

Validation and limits

Duplicate stock SKUs are excluded entirely; invalid stock rows and sales with no valid stock match are reported. Any malformed sales row blocks the whole plan, avoiding silently understated demand. Correct every issue before relying on the result. Unknown extra columns are ignored; the specified headers remain required.

Full download: 5 MB and 50,000 nonblank data rows per CSV. Hub demo: 20 rows per CSV. CSV/text only; no XLSX, live inventory, currency valuation, fractional units, warehouses, seasonal forecasting or supplier integration. Demand averages do not account for stockouts, trends or abnormal events. Confirm cash, storage and supplier constraints yourself.

CSV exports prefix formula-like values (=, +, -, @) with an apostrophe, including negative positions, for spreadsheet safety. JSON retains numeric values. No files are uploaded, saved in browser storage or sent to suppliers.

Purchase and support

£39 once includes version 1.0.0, editable source, tests, fictional samples, guide, internal-business-use licence and 90 days of installation support. Future versions and bespoke forecasts are not promised. Support: support@mmd-solutions.co.uk.

Source and current version

This documentation is generated from the tool’s own versioned guide. See the current Hub guide and tool page for availability and release details.

Contact us

Tell us what you need help with. We’ll reply by email to discuss the next step.

We’ll use your details to reply. This won’t subscribe you to marketing.

How we handle your details

Your enquiry is stored securely and may be emailed to our support inbox. Only authorised staff and our hosting and email providers have access. We keep it only as long as needed to respond and meet record-keeping obligations. To ask about access, correction or deletion, email support@mmd-solutions.co.uk. This form does not subscribe you to marketing.

Or email support@mmd-solutions.co.uk

Help shape MMD

Start with a free 15-minute conversation about the admin taking up your evenings. If there is a fit, choose Callback alone or add enquiry, quote and payment follow-up.

Discuss a paid pilot

From £49 for 30 days + £49 standard setup (£98 first payment), before any applicable VAT. Starts on activation. Continuing after day 30 needs your explicit agreement. No obligation to buy or join a mailing list.

Read the pilot details and allowances

Optional analytics

Privacy and offer details

With your analytics permission, MMD also counts completed admin-estimator calculations by day and broad weekly time-saving range. The estimator does not send entered figures, contact details or a visitor identifier. These aggregate counts describe tool use and assumptions, not verified savings. Our hosting provider still processes ordinary request metadata; hashed network counters are used briefly for rate limiting. Google receives the named calculation event. Rejecting analytics keeps this optional measurement off; the calculator still works.

This website is provided by MMD Solutions Ltd, company 17265591, 15 Neptune Court, Vanguard Way, Cardiff CF24 5PJ. Guides are general information. The phone demo is a live, short-lived demonstration. CRM connections require separate setup and are not enabled by the public demo. Browsing or sending an enquiry creates no paid subscription. Prices, service scope and subscription terms must be agreed before purchase. Nothing here limits statutory consumer rights.

Analytics is optional and separate from the research conversation and paid pilot. Using this website or reading these terms does not subscribe you to email marketing. Contact support@mmd-solutions.co.uk with privacy questions.

If you accept, Google Analytics receives information about visits, device and browser types, traffic sources and interactions. We don’t send your name, email address, phone number or enquiry message to analytics. Advertising features are disabled.

GA4 user and event data is retained for up to 14 months; aggregated reports may be kept longer. We remember your choice on this device for six months. You can change it at any time using Pilot & cookies in the footer. Rejecting stops future analytics collection and removes our Google Analytics cookies; it does not erase data already collected.

MMD Solutions Ltd is responsible for this website’s analytics. Google may process data outside the UK. See how Google uses information from this site and Google’s privacy policy. To ask about your data or your privacy rights, email support@mmd-solutions.co.uk. You can also raise a concern with the Information Commissioner’s Office.

The paid pilot lasts 30 days from activation. Callback costs £49; Callback with either Enquiry & quote follow-up or Invoice & payment reminders costs £68; Callback with both additions costs £87. There is one £49 standard setup fee, making the first payment £98, £117 or £136 respectively. Prices are before any applicable VAT. Standard setup covers compatibility checks, standard configuration, message templates, testing and a handover, with up to one hour of setup time. We confirm availability, compatibility, scope and costs before you agree to start. Each addition includes 50 outgoing SMS segments per service month and normal customer replies. Long texts can use more than one segment. We notify you before the limit and pause additional automated messages at the cap. A £10 prepaid top-up for 100 outgoing segments needs your approval; no automatic overage charges. At day 30 you explicitly choose whether to continue at the same monthly price, held for your first three months. After that agreement, the service renews monthly; you can cancel the next renewal through the billing portal or by contacting us. If you do not continue, we agree how to return call handling to its previous setup. Existing customers pay £19/month per addition and one £49 setup fee to configure one or both additions. Custom integrations are scoped and quoted separately, with third-party fees and any maintenance agreed before work starts. Research participation, marketing and analytics are separate choices. Honest feedback is welcome; no positive review is required and the initial conversation carries no obligation to buy. Callback includes up to 20 voicemail messages or 20 processing minutes per service month, whichever is reached first, for one business number. Each message is counted separately and its duration is rounded up to a whole processing minute: a 20-second message uses 1 minute; a 61-second message uses 2. Messages are limited to 2 minutes. Unused allowance does not roll over. We confirm activation and reset dates, and how calls are handled at the limit, before activation. Extra callback usage must be agreed separately; there are no automatic paid top-ups.

 Chat on WhatsApp