Workshop & business documents
Workshop Inventory And Stock Reorder Planner
This is a free stock register for a fabrication workshop that runs entirely in your browser. Add items such as steel pipe, aluminium profiles, glass sheets, hardware, welding rods and paint, record what comes in and what goes out, and it keeps the closing stock, flags anything at or below its reorder level, suggests how much to order and totals the stock value.
- Free, no sign-up
- Runs in your browser
- Built for Islamabad & Rawalpindi
This free calculator runs in your browser and needs JavaScript. If it does not load, call or WhatsApp us on +92 304 2435577 and we will do the calculation for you.
Most small workshops track stock in a notebook or not at all, and find out they are out of rollers or electrodes when a job is half done. A simple register with reorder levels prevents most of that without buying inventory software. Nothing is sent to Ramzan Steel Works or any server: the records live on your device, and you can download a backup file whenever you like.
What This Tool Does
It keeps an item list with category, unit, location, unit cost, reorder level and order-up-to quantity, and a movement log of opening stock, purchases, returns, issues to jobs and adjustments. Closing stock is calculated from the movements. It blocks issuing more than is in stock, highlights reorder items, and exports the stock register, the reorder list and the movement history as CSV.
Who It Is For
- Small fabrication workshops without inventory software.
- Aluminium and glass shops tracking profiles, sheets and hardware.
- Site stores issuing material to jobs.
How To Use It
- Add each stock item with its unit, cost, reorder level and order-up-to quantity. Enter today’s stock as opening stock.
- Record each delivery as a purchase, with the PO or challan number as the reference. Entering a unit cost updates the item’s cost.
- Record material taken to a job as an issue, with the job number.
- Use adjustments for damage, loss or a stock count correction.
- Tick “Show reorder items only” to see what to order, and download the reorder list for your supplier.
- Download a backup regularly. Restore it on another device or after clearing the browser.
Inputs And Units Explained
- Reorder level — when closing stock falls to this, the item is flagged.
- Order up to — the quantity you want after ordering. Suggested order = order up to − closing stock.
- Unit cost — used for stock value. Updated by the latest purchase cost you enter.
How The Calculation Works
Closing stock = opening + purchases + returns to store + positive adjustments − issues − returns to supplier − negative adjustments. Reorder flag when closing stock ≤ reorder level. Suggested order = order-up-to − closing (never negative). Stock value = closing × unit cost, using the latest purchase cost.
Worked Example
An item with opening stock 8, reorder level 5, order up to 20 and unit cost PKR 100 (demonstration figure). 4 are issued to a job.
| Input or result | Value |
|---|---|
| Closing stock | 8 − 4 = 4 |
| Reorder flag | 4 ≤ 5, so flagged |
| Suggested order | 20 − 4 = 16 |
| Stock value | 4 × 100 = PKR 400 |
Trying to issue 50 more is refused, because only 4 are in stock.
Features And Benefits
- No account and no subscription; it works offline once loaded.
- Reorder list ready for the supplier.
- Movement history with job and PO references.
- CSV exports and full JSON backup and restore.
Assumptions And Accuracy Limits
- Records stay on one browser on one device. They do not sync between devices.
- Clearing browser data deletes them. Keep backups.
- It values stock at the latest cost, not FIFO or weighted average.
- Up to 500 items and 5,000 movements per register.
Frequently Asked Questions
How do I manage inventory in a small workshop?
Give every item a unit and a reorder level, record every receipt and issue with a reference, and check the reorder list before each supplier order.
What is a reorder level?
The stock quantity at which you place a new order, set high enough to cover the time the supplier takes to deliver.
Is my stock data uploaded anywhere?
No. It is stored in your browser on this device only.
Can I move my records to another computer?
Yes. Download a backup file and restore it on the other device.
Can I export to Excel?
Yes. The CSV files open in Excel and Google Sheets.
Related Free Tools
- Free Purchase Order Format & GeneratorFill in a purchase order with items, rates, discount and tax, then print or save it as a PDF.
- Free Delivery Challan Format & GeneratorMake a delivery challan with vehicle details, items and quantities and a received-by signature block.
- Steel Purchasing & Material BOM DeskCombine sections, sheets and rates into one bill of materials and supplier shopping list.
- Weld Volume, Filler & Consumables EstimatorEstimate deposited weld metal and electrode purchase from weld size, length and efficiency.
Get A Measured Quotation
If you are stocking up for a job you would rather hand over, Ramzan Steel Works takes on fabrication, aluminium and glass work in Islamabad and Rawalpindi.
