Back to the software solutions

Example site for an entirely fictional business — not a real company.

Stock ControlRidgeline Laboratory Supplies

Sample data

Item 40-118

One item with its batches, expiry dates, movements and procurement data.

40-118 — buffer solution pH 7.00, 1 l bottle

Below safety stock

Chemicals group · batch-tracked · not classified as hazardous under GHS

Stock

Total in stock
84 bottles across 5 batches
Reserved for orders
26 bottles
On quarantine hold
12 bottles, batch B-2409-77
Freely available
46 bottles

Thresholds and usage

Safety stock
120 bottles
Reorder point
180 bottles
Used in the last 30 days
96 bottles
Cover at that rate
roughly 14 days until free stock reaches zero

Procurement

Supplier
Northgate Chemicals, St. Louis
Supplier's item number
CN-4471
Lead time
12 business days
Minimum order quantity
48 bottles, in multiples of 12
Last purchase price
$4.85 per bottle

Storage

Bin locations
C-04-12 to C-04-14, quarantine bay Q-01
Storage conditions
15 to 25 °C, kept dark
Batch tracking
yes, picked by earliest expiry
Last count
9 Aug, sample count, 3 bottles short

Batches in stock

When picking, the system proposes the batch with the earliest expiry date.

BatchQuantityBinReceivedExpiresStage
B-2409-77Quantity12BinQ-01 quarantineReceived4 Mar 2025Expires30 Sep 2026StageOn hold
B-2501-19Quantity9BinC-04-12Received22 Apr 2025Expires31 Dec 2026StageAvailable
B-2503-08Quantity15BinC-04-13Received3 Jun 2025Expires28 Feb 2027StageAvailable
B-2506-11Quantity26BinC-04-13Received9 Jul 2025Expires31 May 2027StageFully reserved
B-2507-02Quantity22BinC-04-14Received28 Jul 2025Expires31 Jul 2027StageAvailable

84 bottles across 5 batches — 12 on hold, 26 reserved, 46 freely available.

Stock movements

  1. Picked for order A-9042

    14 Aug, 7:10 AM

    18 bottles taken from batch B-2506-11 at bin C-04-13. The remainder of the batch stays reserved.

    Cole, picking

  2. Moved between bins

    13 Aug, 3:20 PM

    8 bottles pulled from C-04-14 to C-04-13 so the older batch sits at the front.

    Cole, picking

  3. Purchase suggestion created

    12 Aug, 11:45 AM

    Stock fell below the reorder point of 180 bottles. Suggestion of 144 bottles from Northgate Chemicals, minimum order quantity applied.

    Stock control

  4. Stocktake discrepancy posted

    9 Aug, 4:00 PM

    A sample count at C-04-12 found 3 bottles fewer than the system held. The difference is posted, the cause is still open.

    Warehouse management

  5. Batch B-2409-77 put on hold

    5 Aug, 9:15 AM

    Two bottles in the carton had leaking caps. The whole batch sits in quarantine bay Q-01 until the supplier responds.

    Goods inspection

  6. Batch B-2507-02 received

    28 Jul, 8:40 AM

    24 bottles from delivery note LS-88203 checked and put away at C-04-14. Expiry date 31 Jul 2027 recorded.

    Goods inspection

The project frame

How Awelior would approach this project

Ridgeline Laboratory Supplies is invented — the way it is built is not. None of this is work delivered for a client. It is the shape we would give such a project — with the same depth, but without a client who would have to answer for it.

Where it starts

Cavendish Laboratory Supplies carries items that expire and belong to batches. The stock list is a spreadsheet, delivery notes sit in a binder, and at stocktake people walk the warehouse with clipboards. As long as nothing gets recalled that works; one batch recall reveals that nobody can say where the goods went.

Decisions

  • Batch and expiry are mandatory fields, not remarks

    Both are captured at goods receipt and travel with the line. In the old spreadsheet they were free-text columns — and a free-text field three people fill in three ways is worthless in a recall.

  • Purchase suggestions from consumption, not from a reorder point alone

    A fixed reorder point over-orders in summer and under-orders in autumn. The suggestion factors in actual consumption — and it stays a suggestion; a person places the order.

  • An item record with history

    Every item has a view of its own with movements. That is the screen that answers “where did this go” — and the one a spreadsheet cannot structurally have.

Deliberately left outNo bin location management and no handheld picking. Both only pay off above a warehouse size this business does not have — and building them because they impress is exactly the kind of effort nobody uses later.

What is in it

Screens
5
Content blocks
17
Languages
4

Five screens, in all four languages, with sidebar, header and stated role. Navigation works; tables, filters, calendar, history, board and forms are rendered and inert. Item numbers, batches and stock figures are invented.

How it would go on

  • Goods receipt with a scanner

    Reading a delivery note instead of typing it — that is where a stock system really saves time, and it depends on hardware.

  • Suppliers and pricing

    Purchase suggestions need supplier terms, minimum order quantities and lead times, or they propose quantities nobody would actually order.

  • Stocktake

    Count sheets, discrepancies, valuation and the handover to accounts — once a year, but under time pressure when it comes.

Talk through your project

Sample data

An application like this for your business?

Stock Control is invented — the way it is cut is not. Applications like this come out of the processes a business already runs.

Talk about a solutionBack to the software solutionsThe service page: Business software

Sample application by Awelior. Invented business, invented data, nothing stored.