Back to the software solutions

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

Stock ControlRidgeline Laboratory Supplies

Sample data

Stock list

Every stocked item with its quantity, safety stock, bin location and lead time.

1,284

Items stocked

312 of them batch-tracked

18

Below safety stock

52

Batches expiring within 90 days

9

Items with stock on hold

Item number, description or bin location
  • All product groups
  • Below safety stock
  • Batch-tracked
  • Serial-tracked
  • Hazardous
  • Refrigerated
  • On hold
  • Being discontinued

Items below safety stock

The reorder point triggers the purchase suggestion; the safety stock is the buffer that has to last the lead time.

ItemDescriptionBinIn stockReorder pointSafety stockLead timeStage
40-118DescriptionBuffer solution pH 7.00, 1 l bottleBinC-04-12In stock84Reorder point180Safety stock120Lead time12 business daysStageBelow safety stock
22-407DescriptionNitrile gloves, size M, box of 100BinA-02-05In stock34Reorder point90Safety stock60Lead time5 business daysStageBelow safety stock
61-033DescriptionPipette tips 1000 µl, bag of 500BinB-01-08In stock0Reorder point45Safety stock30Lead time8 business daysStageOut of stock
15-902DescriptionCentrifuge tubes 50 ml, case of 500BinB-03-02In stock11Reorder point30Safety stock20Lead time15 business daysStageOn order
33-560DescriptionEthanol 96 %, 5 l canisterBinG-01-01In stock22Reorder point60Safety stock40Lead time10 business daysStageBelow safety stock
78-214DescriptionStainless steel test tube rack, 12 placesBinD-05-11In stock17Reorder point40Safety stock25Lead time20 business daysStageBelow safety stock
90-115DescriptionWeighing pan for LW-220 balanceBinE-02-03In stock3Reorder point15Safety stock10Lead time25 business daysStageSerial-tracked
55-720DescriptionCulture plates, pack of 20BinK-01-04In stock26Reorder point70Safety stock45Lead time6 business daysStageExpires in 21 days
12-088DescriptionSafety glasses, clear, with side shieldsBinA-04-09In stock9Reorder point40Safety stock25Lead time4 business daysStageBeing discontinued

9 of 18 matches — filtered to stock below the safety level. Sorted by product group.

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.