MRP, material requirements planning, turns demand into a build-and-buy plan from three inputs: demand, bills of materials, and current inventory or incoming supply. Small manufacturers need MRP software once open work orders, shared components, and shifting lead times make that math unreliable to track by hand.
Here is the scene that sends many operators looking for MRP in the first place. A work order is due Thursday. The component it needs is also committed to two other builds this week. Nobody finds that out until someone walks the floor, counts a bin, and realizes the part is already spoken for. The order slips a day. Then two. The customer calls. Somebody spends an afternoon re-counting a shelf that a spreadsheet already claimed was full.
Picture a 12-person metal shop running three welded assemblies off the same steel tube. Thursday's order needs 40 feet of it. So does Tuesday's rework order, and so does a prototype run nobody flagged as urgent. The spreadsheet that is supposed to track tube length was last updated Monday morning. By Wednesday afternoon the shop is 40 feet short, and the buyer who could have placed a rush order already left for the day. The build slips, the customer gets the same call they got last quarter, and the shortage gets written into a notebook nobody reads until the next postmortem.
That is not a software problem on day one. It is a timing problem that software should have caught. MRP run against that same tube commitment nets all three orders against what is on hand, flags the shortage Monday morning, and gives someone a Tuesday order date instead of a Wednesday surprise.
Most software shows you the problem and leaves you the work. It will tell you the bin is short. It will not tell you which of three work orders should lose the part, what to order, or when it needs to land. That part still lands on a person with a calculator and a Thursday deadline.
The three inputs MRP actually runs on
A recent manufacturing guide lays out the core inputs plainly: demand, bills of materials, and inventory or supply (OnRamp Solutions, MRP software explained for manufacturers). That is the whole engine. Strip away the dashboards and the engine is still just these three things talking to each other:
- Demand – the sales orders and forecasts that say what has to be ready, and by when.
- Bills of materials – what each finished item is actually built from, at every level, not just the top assembly.
- Inventory and supply – what is on hand right now, what is already committed, and what is already on order from a supplier.
MRP math multiplies demand through the BOM and nets it against what is available. The output is a plan: build this, buy that, move this date up. The value is not the arithmetic. It is catching the shortage before the work order does.
Where the plan breaks down on the shop floor
The same guide points at the usual failure mode: separate spreadsheets, paper quality records, and disconnected systems create manual handoffs and data drift (OnRamp Solutions). None of those systems is wrong by itself. A spreadsheet can hold a multi-level BOM. An accounting system can hold a part number. But none of them were built to run live work-in-process, component dependencies across open orders, lot traceability, and competing production demand at the same time.
Every handoff between those systems is a place where a count goes stale between the morning tally and the afternoon pull. A re-typed number drifts from what the floor actually did. A paper quality record sits in a binder nobody checks until an auditor asks for it. By the time someone notices, the shortage is already a missed ship date.
Do small manufacturers need MRP software, or can a spreadsheet still do it
A shop with a short item list, light assemblies, and one or two work orders open at a time can run this math by hand for a while. Light assembly is still manufacturing work. It is not a problem worth a joke, and it is not automatically a reason to buy more software than the shop needs.
The math stops being hand-trackable once a few of these show up at the same time. Run this check against your own floor:
- More than one open work order is pulling from the same component on the same week.
- Supplier lead times run long enough that an order placed today still risks a late build next month.
- Safety stock levels differ by item, and nobody is tracking them against live demand.
- Demand shifts often enough that last week's plan is already wrong by Wednesday.
- A shortage is usually discovered by someone walking the floor, not by a system flagging it first.
Two or more yes answers is the point where MRP software earns its keep. One yes answer and a short BOM list is still spreadsheet territory, and that is fine.
What that looks like inside Fishbowl
Fishbowl is the platform. Fishbowl Inventory, Fishbowl Advanced Manufacturing, and Fishbowl Advanced Warehouse are purpose-built parts of Fishbowl, matched to how the business runs.
If you buy finished goods and resell them, Fishbowl Inventory handles receiving, stocking, picking, transfers, and fulfillment. Add Fishbowl Channels when those products sell through Shopify, Amazon, Walmart, or other channels. If you manufacture the product and need BOMs, work orders, MRP, production scheduling, or job and labor costing, use Fishbowl Advanced Manufacturing, with Channels added if you also sell online. If you do not manufacture but need deeper warehouse workflows such as 3PL management or EDI-driven fulfillment, use Fishbowl Advanced Warehouse. Multiple storefronts or owned locations alone do not automatically mean you need Advanced.
Fishbowl Advanced Manufacturing runs the BOM, the open work orders, and the supplier lead times against live inventory, then nets a shortage before Thursday arrives instead of after. Data-focused AI sits on top of that same data and states what is happening, what is coming, and what needs attention, so a planner opens the day already pointed at the component that is about to run short instead of finding it on the floor.
Fishbowl Inventory, the cloud finished-goods product, carries a different kind of AI built for a different job. The AI Operations Specialist uses live Fishbowl data to prepare purchase orders, sales orders, transfers, receipts, and adjustments for your approval. Nothing is saved or changed without the operator's approval. That is Ask, Approve, Done, and it is not the same experience as the data-focused AI running inside Advanced Manufacturing. A company reselling finished goods uses the first. A company running BOMs and work orders uses the second. The product-fit paragraph above decides which one, not a coin flip.
Three manufacturers who moved this math off spreadsheets and disconnected systems and into Fishbowl Advanced Manufacturing, with data-focused AI reading the same live data: Hodo Foods cut stockouts by 35%, Koken USA cut sales backorders by 10%, and Cascadia Motion lowered inventory costs by 18%. Full write-ups are on the Fishbowl case studies page.
None of that math replaces QuickBooks or Xero. Fishbowl does the operational work – the BOM, the work order, the MRP plan – and QuickBooks or Xero keeps the books. See how the Fishbowl platform fits the way your shop actually runs, or get a demo on your own BOM and a real work order, not a sample company.
Fishbowl does the work. You make the call.
Frequently asked questions
What is MRP in manufacturing?
MRP, material requirements planning, is a calculation that turns a demand forecast or sales order into a plan for what to build, what to buy, and when. It works from three inputs: demand, the bill of materials for each item, and current inventory or incoming supply.
Do small manufacturers actually need MRP software?
A shop with a handful of SKUs and simple assemblies can run MRP math on a spreadsheet for a while. Once open work orders, shared components, supplier lead times, and shifting demand pile up at the same time, the math gets too big to hold by hand without missed shortages or late builds.
How long does it take to get MRP running?
Training on Fishbowl Advanced Manufacturing is expert-led and typically runs 6 to 8 weeks, built around your BOMs, routings, and existing data. The plant does not wait for a finished rollout; it goes live with real work orders as the data is ready.
What happens when MRP runs on disconnected systems?
Separate spreadsheets, paper quality records, and systems that do not talk to each other create manual handoffs. Each handoff is a place where a number gets re-typed, a count goes stale, or a shortage shows up on the floor before it shows up on a screen.