inventory management
Manufacturing Dashboards: How to Create + Examples
Learn how to create a manufacturing dashboard that shows you exactly what's happening in your small-batch business, from batch output to materials on hand.
Running a small-batch business means keeping a lot of plates spinning at once. Raw materials coming in, batches going out, orders arriving from Etsy and Shopify at the same time, and costs that need to stay in check (or at least visible).
At a certain point, tracking all of that in your head (or across a pile of spreadsheets) stops working. Not because you’re not good at it. Because there’s too much to hold.
That’s where a manufacturing dashboard helps. Not a fancy tool, not an enterprise system. Just a single place that answers the questions you’re already manually checking every few days. Here’s how to build one that actually gets used.
Ensure your production planning and scheduling is on point!
Try Craftybase - the inventory and manufacturing solution for small-batch makers. Track raw materials and product stock levels (in real time!), COGS, shop floor assignment and much more.
It's your new production central.
What is a manufacturing dashboard?
A manufacturing dashboard is a visual display of your key operational data: production output, materials on hand, order fulfilment, and costs. Updated on a regular schedule or in real time.
Think of it as one screen that answers the questions you’re already asking: Do I have enough wax or oil to run my next batch? Am I shipping orders on time? What’s my cost per unit trending at this month?
The goal isn’t complexity. It’s clarity. A good dashboard gives you fast answers so you can make decisions without digging through notebooks and spreadsheets first.
How to create a manufacturing dashboard
You don’t need to build this all at once. Five steps, done in order, keeps it from becoming a project that never actually gets finished.
Step 1 — Identify your key metrics
Start with the metrics that directly affect what you do next week. Not everything worth knowing, just the things that change your decisions.
For most small-batch makers, that tends to fall into four areas:
- Production: How many units did I produce this week or month? Am I on track?
- Materials: What’s my stock level for key inputs? What’s running dangerously low?
- Costs: What’s my COGS per batch? Is it moving in the wrong direction?
- Fulfilment: What’s my on-time ship rate? How many orders are waiting on production?
Start with two or three. Trying to track everything at once is how dashboards get abandoned. Nobody looks at them because they’re too dense to parse quickly.
Read more: 10 Production Planning Metrics and KPIs You Need To Know
Once you know what you need to see, work out how you’ll actually capture it: manual entry, a spreadsheet, or software that does it automatically.
Step 2 — Choose a platform
The right tool depends on your volume and how much time you want to spend on setup and maintenance.
Spreadsheets (Excel, Google Sheets) are a reasonable starting point if you’re running a simple operation. They’re free, most makers already know how to use them, and they get the job done at low volume. The tradeoff is manual data entry, no automatic updates, and formulas that break at exactly the wrong moment.
Free download: Production planning template for Excel and Numbers
BI tools like Google Data Studio or Power BI let you connect data sources and build visual displays. Powerful, yes, but also a fair amount of overhead to set up and maintain. Probably more than most small makers actually need.
Purpose-built manufacturing software like Craftybase tracks everything inside the system and surfaces it automatically. Materials, production runs, orders, and costs are all connected. This is the most practical option once you’re growing and spending significant time on manual tracking.
The honest tradeoff: the more manual your setup, the more discipline it takes to keep current. Most makers find that around 50–150 orders a month is where manual tracking stops feeling manageable.
Step 3 — Design the layout
If you’re building your own dashboard rather than using software, layout matters more than you’d think. The question to design around: can you answer your most important questions in the first 10 seconds of looking at it?
A few things that help:
- Lead with status, not detail. A traffic-light summary (on track / at risk / critical) at the top is more useful than a table of raw numbers. You can drill down when something needs attention.
- Group by workflow. Production metrics belong next to fulfilment metrics. Financial metrics you check monthly can live separately.
- Limit charts. A bar chart of batch output by week? Genuinely useful. A pie chart of material categories? Usually not.
- One screen. If you’re scrolling, you have too much on it. Move less-critical items to a separate report.
If you have someone helping you on production, consider role-specific views: one focused on batches and materials for the production side, another focused on costs and margins for the financial side.
Step 4 — Keep it up to date
A dashboard is only as useful as the data feeding it. Stale inputs lead to stale decisions.
The simplest way to stay current: build data entry into your production routine. Updating materials used and units completed at the end of each production run takes a few minutes, and it keeps everything accurate. If you’re using manufacturing software, much of this happens automatically as orders sync and manufacture records are created.
Set a review cadence and stick to it. Daily is ideal during busy periods; weekly works fine for lighter workflows.
Step 5 — Act on what you’re seeing
This is the step most makers skip. The point of a dashboard isn’t data collection. It’s catching things before they become expensive problems.
The most common triggers:
- Materials dropping below reorder point → place a purchase order now, not when you run out
- COGS drifting up → review your recipe costs and recent supplier prices
- Order fill rate dropping → either increase production volume or be more realistic about lead times
Check your dashboard before each production run. Ask: what does this tell me I should do differently today? That habit is what makes the whole thing worthwhile.
KPIs for small-batch makers
Generic manufacturing metrics don’t always translate to small-batch production. These four tend to be the most useful:
Production cycle time. How long does it take to complete a batch from start to finish? For makers, this affects how quickly you can respond to demand spikes and how many batches you can realistically run per week. Track it per product line, because cycle times often vary more than you’d expect.
Material usage vs. plan. How much of each material did you actually use versus what your recipe called for? Variance here signals waste, measurement inconsistency, or recipe drift. Even small variances add up quickly at volume. A candle maker running 8% above the recipe on wax is losing roughly $80 a month on a moderate batch schedule. Easy to fix once you spot it.
Order fulfilment rate. What percentage of orders shipped on time? For makers selling on Etsy or Shopify, this directly affects seller ratings and repeat purchases. Below 95% usually points to a production scheduling problem or materials running out unexpectedly.
COGS per batch. Total cost (materials + labour + overhead) to produce one batch. This is the metric that shows whether your pricing is actually profitable. If it’s trending up while your prices haven’t moved, your margins are getting squeezed. Craftybase calculates this automatically from your raw material costs and recipes, so no spreadsheet required.
Spreadsheet vs. software dashboards
Most makers start with a spreadsheet, and that’s completely reasonable. It’s free, it’s familiar, and it works at low volume.
The tradeoff starts showing up when:
- You’re selling on multiple channels and manually reconciling orders
- Your product count is high enough that recipe costing in a spreadsheet takes hours
- You’ve had a stockout or over-order because the spreadsheet was behind
- Tax time requires hours of calculation that a system would handle automatically
Software solves these problems by connecting your order channels, tracking materials automatically, and calculating COGS vs. COGM without manual formulas. The question isn’t whether software is better in theory (it usually is). The question is when the time savings and accuracy improvements justify the cost. For most makers, that crossover lands somewhere around 50–150 orders per month.
Examples of manufacturing dashboards for small-batch makers
Here’s what a manufacturing dashboard looks like in practice for three different maker businesses:
The candle maker
A candle maker running 20–30 batches per month tracks batch output by fragrance, wax usage vs. plan, order fill rate, and COGS per candle. The most useful view is a weekly snapshot: which fragrances are selling fastest, and what’s currently in production? That comparison drives which batches to run next.
The dashboard flags a problem when wax usage starts running 8% above recipe. A measuring inconsistency on the production bench that was costing around $80/month in wasted materials. Spotted early, fixed quickly.
The soap maker
A soap maker with 15 SKUs tracks batch records by formula, waste percentage per run, materials on hand versus reorder points, and COGS per bar by product line.
Their key metric is COGS per bar. Some formulas use significantly more oil than others, and without tracking it per-batch, it’s genuinely easy to misprice a product and not know for months. Their dashboard identifies one formula running 20% above expected COGS, they trace it to oil prices, and adjust pricing accordingly.
The jewellery maker
A jewellery maker on both Etsy and Shopify tracks production time per piece, material costs per design, order split by channel, and pending orders versus current production capacity.
The most useful view: a two-week production forecast. Given open orders on both channels and current production rate, when will everything ship? This prevents the common problem of overpromising lead times during a busy stretch, then scrambling to catch up.
Using Craftybase as your manufacturing dashboard solution
Craftybase is production scheduling software built for small-batch makers. It includes a manufacturing dashboard as part of its core feature set, with no separate configuration required.
The dashboard gives you real-time visibility into production output, inventory levels, material costs, and COGS / COGM. Orders from connected channels (Etsy, Shopify, Amazon, and more) sync automatically, so your data reflects what’s actually happening.
Additional features include batch tracking, material usage tracking, reorder alerts, and profit and loss reporting. Try Craftybase free for 14 days, no credit card required.
Frequently Asked Questions
What is a manufacturing dashboard?
A manufacturing dashboard is a visual display of your key production data: materials on hand, batch output, order fulfilment rate, and costs. Updated in real time or on a regular schedule so you can see what's happening in your business without digging through spreadsheets.
What KPIs should a small-batch maker track on a manufacturing dashboard?
The four most useful KPIs for small-batch makers are production cycle time (how long each batch takes), material usage vs. plan (actual vs. recipe amounts to catch waste early), order fulfilment rate (percentage shipped on time), and COGS per batch (total cost to produce one batch, which tells you whether your pricing is actually profitable).
Can I create a manufacturing dashboard in Excel?
Yes, and it's a reasonable starting point at low volume. The main limitations are manual data entry, formulas that break, and the time it takes to reconcile orders from multiple sales channels. Most makers find a spreadsheet stops working reliably somewhere around 50–150 orders per month. At that point manufacturing software is usually worth the switch.
What's the difference between a manufacturing dashboard and an ERP system?
A manufacturing dashboard is a reporting layer that surfaces key metrics so you can see what's happening at a glance. An ERP system is an enterprise platform managing all business processes (finance, HR, procurement, production) in one integrated system. ERP systems are built for large manufacturers with complex operations and typically cost tens of thousands of dollars. For small-batch makers, purpose-built tools like Craftybase give you the visibility you need without the enterprise overhead.
Does Craftybase include a manufacturing dashboard?
Yes. Craftybase includes a built-in manufacturing dashboard as part of its core feature set, with no separate setup required. It gives you real-time visibility into production output, materials on hand, order fulfilment, and COGS, with data syncing automatically from your connected sales channels (Etsy, Shopify, Amazon, and more).
Running a manufacturing dashboard well is mostly about keeping it simple and checking it consistently. You don’t need the most sophisticated tool. You need a setup that answers your real questions fast enough that you actually use it before making production decisions.
Start with two or three metrics that directly affect what you do next week. Build from there once you know what’s actually useful.
