Back to the software solutions

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

Stock ControlRidgeline Laboratory Supplies

Sample data

Purchase suggestions

What usage and lead time argue for — and what has already turned into an order.

Item or supplier
  • All suggestions
  • Below safety stock
  • Long lead time
  • Framework agreement
  • Minimum order applies
  • Being discontinued

Suggestions from the last 30 days of usage

The suggested quantity is rounded up to the supplier's minimum order quantity and pack size.

ItemDescriptionIn stockSafety stockSuggestedSupplierLead timeOrder value
40-118DescriptionBuffer solution pH 7.00, 1 l bottleIn stock84Safety stock120Suggested144SupplierNorthgate ChemicalsLead time12 business daysOrder value$698.40
22-407DescriptionNitrile gloves, size M, box of 100In stock34Safety stock60Suggested60SupplierWestbrook Laboratory TradingLead time5 business daysOrder value$534.00
61-033DescriptionPipette tips 1000 µl, bag of 500In stock0Safety stock30Suggested40SupplierRedstone Plastics EngineeringLead time8 business daysOrder value$856.00
15-902DescriptionCentrifuge tubes 50 ml, case of 500In stock11Safety stock20Suggested24SupplierRedstone Plastics EngineeringLead time15 business daysOrder value$1,116.00
78-214DescriptionStainless steel test tube rack, 12 placesIn stock17Safety stock25Suggested30SupplierThorncroft GlasswareLead time20 business daysOrder value$384.00
33-560DescriptionEthanol 96 %, 5 l canisterIn stock22Safety stock40Suggested36SupplierNorthgate ChemicalsLead time10 business daysOrder value$896.40
90-115DescriptionWeighing pan for LW-220 balanceIn stock3Safety stock10Suggested12SupplierWestbrook Laboratory TradingLead time25 business daysOrder value$924.00

7 suggestions, $5,408.80 altogether. Minimum order quantities are applied and prices come from the last purchase.

Orders by stage

A suggestion only becomes an order once purchasing has released it.

Suggested

7 lines

  • 40-118 — buffer solution pH 7.00

    144 bottles · Northgate Chemicals

    $698.40below safety stock

  • 61-033 — pipette tips 1000 µl

    40 bags · Redstone Plastics Engineering

    $856.00out of stock

With purchasing

5 orders

  • B-24131 — protective equipment

    3 lines · Westbrook Laboratory Trading

    $1,204.00release pending

  • B-24129 — glassware, framework agreement

    5 lines · Thorncroft Glassware

    $2,480.00price being checked

With the supplier

6 orders

  • B-24118 — chemicals

    7 lines · Northgate Chemicals

    order acknowledgedpart delivered

  • B-24127 — plastic consumables

    5 lines · Redstone Plastics Engineering

    shipping 14 Augconfirmed

Delivery booked in

4 orders

  • B-24127 — plastic consumables

    Redstone Plastics Engineering · gate 2

    Fri 15 Aug, 7:30 AM5 lines

  • Transfer from the central store

    Memphis · 2 pallets

    Thu 14 Aug, 3:00 PMno delivery note

Received

3 orders

  • B-24095 — plastic consumables

    LS-88409 · 4 lines

    putaway openchecked

  • B-24071 — glassware

    LS-88398 · 3 lines

    1 line on holdbreakage reported

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.