script monkey: business solutions using digital intelligence 
Stock Management System for Construction
Many construction business have an ever growing stockpile of valuable materials. By integrating ordering and stores, all that dead cashflow can be injected back into your business, increasing profit margins, and reducing rent of costly floor space.
19th October 2026
Script Monkey has implemented stock management systems for companies in the construction and music fields: exactly the same logic!
A well-known construction company had grown over 20 years into a player in the Mechanical Services space. Its processes had evolved with the company as it grew but were starting to fail as turnover exceeded tens of millions with 20-30 concurrent projects varying in size working for 20+ clients. We built them a construction stock management system.
Why do contractors end up with too much stock?
Site managers would order new materials via the purchasing team from suppliers and, because no live inventory existed for the main stores, items would be bought even though they were already sitting in the company warehouse.
At the end of each project, any left-over items would be returned to stores, but nothing would be labelled or marked, preventing the stores manager from correctly identifying the materials to allow the purchasing team to buy less of the items newly requested and supplement the new orders by calling off from stores.
Due to time pressure, purchasing was pushed to order new each time and the value of materials held in stores, mostly returned from finished projects, increased over time until it was worth in excess of a million pounds. Clearly something had to change...
This pattern is common across the industry. Ordering new is always the fastest option for a busy site manager, and without a live view of what is already on the shelves, nobody can challenge it. Every surplus item returned from site quietly turns cash into clutter, and the warehouse needed to hold it costs rent too.
How was the new stock control designed?
After detailed review with all of the concerned roles, a system was specified as follows:
One code for every item
- Every item used by the company was given an item code.
- A mapping tool was created so when site managers ordered from catalogues without providing the correct item codes, the purchasing team could easily assign the correct item codes.
- After mapping, site managers were given their requisition back showing all correct item codes and asked to use these item codes next time.
- An importer automatically linked Excel requisitions to item codes so each new import became easier as site managers adopted the new numbering.
- Up to date supplier catalogues were linked in to ensure site managers were referring to the correct codes from manufacturers.
Stores first, suppliers second
- No new order was given to suppliers until stores confirmed the count for every item on a new requisition.
- Any order for an item would be satisfied from the warehouse first and only balances ordered from suppliers.
Visibility and control on site
- Total quantity previously ordered by each site manager is shown on the manager's ordering form showing total ordered, total delivered and total pending delivery, if any. This prevents site managers from over ordering when materials are still pending from suppliers or stores.
- Total quantity returned from sites to stores is logged to see which managers overestimate their materials during a project.
- Suppliers can be linked to sites and items linked to suppliers, so the 'allowed' materials per site could be controlled to prevent unapproved items being requested by site managers.
Smarter purchasing
- Once new orders reached purchasing, purchase orders were generated using the existing Excel PO template, so no visible change to output occurred, just maximum use of what was already in stores.
- An item could be supplied by multiple suppliers with automatic selection at time of order based on a combination of lowest price, availability and lead time, all configurable.
What were the results?
The net effect of these measures was to reduce the stock in hand by over 50%, releasing tied up cashflow into the business and increasing profitability significantly in the first year.
The benefits went beyond the balance sheet. Fewer surplus materials meant less space needed to store them. Purchasing could see at a glance what was already available, site managers could see exactly what was on its way, and for the first time the directors had reliable data on which projects habitually over ordered. Because purchase orders still came out of the familiar Excel template, suppliers and staff saw no disruption at all.
Could better stock control work for my business?
If your stores are full but your purchasing team is still ordering new, the answer is almost certainly yes. It works for any business holding materials, spares or consumables: give every item an identity, check what you already have before buying more, and make the numbers visible to the people placing orders.
This project combined bespoke database development, integration with existing Excel tools and process automation. For another example from the same industry, read our billing case study. If your warehouse is holding more cash than it should, get in touch.
