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 multiple channels, and costs that need to stay in check. At a certain point, tracking all of that in your head (or across a pile of spreadsheets) stops working.
That’s where a manufacturing dashboard comes in. With the right setup, you can see what’s happening in your business at a glance, catch problems before they become expensive, and make faster decisions without digging through data.
This guide walks you through exactly how to build one, what metrics matter for small-batch makers, and what your options look like depending on your setup.
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 in real time or on a regular schedule.
Think of it as a single screen that answers the questions you find yourself manually checking every few days: Do I have enough materials to run my next batch? Am I filling orders on time? What’s my COGS per unit trending at?
The goal isn’t complexity — it’s visibility. A well-designed dashboard gives you fast answers to the questions that matter most in your production workflow.
How to create a manufacturing dashboard
Creating a manufacturing dashboard doesn’t have to be a big project. Breaking it down into five steps makes it manageable.
Step 1: Identify your key metrics / KPIs
The first step is deciding what you actually need to see. Not every metric is worth tracking. Focus on the ones that directly affect your production decisions.
For small-batch makers, the most useful manufacturing KPIs tend to fall into four categories:
- Production: How many units did I produce this week / month? Am I on track with planned output?
- Materials: What’s my current stock level for key inputs? What’s running low?
- Costs: What’s my COGS per batch? How does it compare to last month?
- Fulfilment: What’s my order fill rate? How many orders are waiting on production?
Start with two or three metrics and build from there. Trying to track everything at once is a common mistake that leads to cluttered dashboards nobody actually looks at.
Read more: 10 Production Planning Metrics and KPIs You Need To Know
Once you’ve identified the metrics, work out how you’ll track them: whether through manual data entry, a spreadsheet, or an automated software solution. Make sure your data sources are accurate and consistent.
Step 2: Choose a dashboard platform
The right tool depends on your volume, complexity, and budget.
Spreadsheet dashboards (Excel, Google Sheets) are a reasonable starting point if you’re running a simple operation. They’re free, flexible, and most makers already know how to use them. The tradeoff is that they require manual data entry, they don’t update automatically, and they break down fast as your order volume grows.
Free Download: Production planning template for Excel and Numbers
DIY dashboard tools like Microsoft Power BI, Tableau, and Google Data Studio let you connect data sources and build visual displays. These are powerful but take time to set up and maintain, and are probably more overhead than most small makers need.
Manufacturing-focused software like Craftybase builds the dashboard for you. Your materials, production runs, orders, and costs are tracked in the system and surfaced automatically. This is the most practical option if your business is growing and you’re spending significant time on manual tracking.
Consider the tradeoff between cost, setup time, and ongoing maintenance when choosing your approach.
Step 3: Design your dashboard layout
If you’re building your own dashboard, layout matters. The goal is to answer your most important questions in the first 10 seconds of looking at it.
A few practical guidelines:
- Lead with status, not detail. Show traffic-light summaries (on track / at risk / critical) at the top, with detail available on drill-down.
- Group by workflow, not by data type. Put production metrics next to fulfilment metrics, not next to financial metrics you only check monthly.
- Use charts sparingly. A bar chart showing batch output by week is useful. A pie chart of material categories is usually not.
- Limit your dashboard to one screen. If you’re scrolling, you have too much. Move the less-critical metrics to a separate report.
You may also want to create role-specific views if you have anyone helping you: a production view focused on batches and materials, and a financial view focused on costs and margins.
Step 4: Keep the dashboard up to date
A manufacturing dashboard is only as useful as the data feeding it. If your inputs are stale, your decisions will be too.
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 keeps everything accurate. If you’re using software, much of this happens automatically as orders sync and manufacture records are created.
Set a regular review cadence: daily is ideal for active production periods, weekly is fine for lighter workflows.
Step 5: Analyse and act on the insights
The point of a dashboard isn’t to collect data — it’s to make better decisions faster. Build a habit of reviewing your dashboard before starting each production run, and asking: what does this tell me I should do differently today?
The most common action triggers are:
- Materials dropping below reorder threshold → place a purchase order
- COGS creeping up → review your recipe costs and supplier prices
- Order fill rate dropping → increase production volume or manage lead times
The dashboard is your early warning system. The sooner you catch a trend, the cheaper it is to fix.
KPIs for small-batch makers
Generic manufacturing metrics don’t always translate well to small-batch production. Here are four KPIs that are particularly useful for maker businesses:
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 run per week. Track it per product line, since cycle times often vary significantly.
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 when you’re making in volume.
Order fulfilment rate: What percentage of orders are shipped on time? For small makers selling on Etsy or Shopify, this directly affects your seller ratings and repeat purchase rate. Fulfilment rate below 95% usually points to a production scheduling or materials availability problem.
COGS per batch: The total cost (materials + labour + overhead) to produce one batch. This is the metric that determines whether your pricing is actually profitable. If it’s trending up but your prices aren’t, your margins are compressing. Craftybase calculates this automatically from your raw material costs and recipes.
Spreadsheet vs. software dashboards
Most makers start with a spreadsheet. That’s completely reasonable: it’s free, familiar, and gets the job done at low volume.
The tradeoff shows 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 event because the spreadsheet was behind
- Tax time requires hours of calculation that a system would handle automatically
Software tools solve 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, because it usually is once you’re past a certain volume. The question is when the time savings and accuracy gains justify the cost. For most makers, that crossover happens somewhere between 50 and 150 orders per month.
Examples of manufacturing dashboards for small-batch makers
To make this concrete, here’s what a manufacturing dashboard looks like for three types of 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 showing which fragrances are selling fastest versus what’s in production, which helps them prioritise which batches to run next.
Their dashboard catches a problem when their wax usage starts running 8% above the recipe, signalling a measuring inconsistency on the production bench. Catching it early saves around $80 in wasted materials per month.
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 oils than others, and without tracking it per-batch, it’s easy to misprice a product. They use their dashboard to identify that one formula’s COGS is running 20% higher than expected, investigate the oil prices, and adjust their pricing accordingly.
The jewellery maker
A jewellery maker selling on both Etsy and Shopify tracks production time per piece, material costs per design, order split by channel, and pending orders versus production capacity.
The most useful view is 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 busy periods.
Using Craftybase as your Manufacturing Dashboard solution
Craftybase is production scheduling software built specifically for small-batch makers. It includes a manufacturing dashboard as part of its core feature set, with no configuration required.
The Craftybase dashboard gives you real-time visibility into production output, inventory levels, material costs, and COGS / COGM. Orders from your connected channels (Etsy, Shopify, Amazon, and more) sync automatically, so your data is always current.
Additional features include batch tracking, material usage tracking, reorder alerts, and profit and loss reporting. Try Craftybase free for 14 days with no credit card required.
Frequently Asked Questions
What is a manufacturing dashboard?
A manufacturing dashboard is a visual display of your key production data, including 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 at a glance.
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), order fulfilment rate (percentage shipped on time), and COGS per batch (total cost to produce one batch, which determines whether your pricing is profitable).
Can I create a manufacturing dashboard in Excel?
Yes. A spreadsheet dashboard is a reasonable starting point for low-volume businesses. The main limitations are that data entry is manual, formulas can break, and reconciling orders from multiple sales channels becomes time-consuming. Most makers find a spreadsheet stops working reliably somewhere around 50-150 orders per month, at which point manufacturing software makes more sense.
What's the difference between a manufacturing dashboard and an ERP system?
A manufacturing dashboard is a visual reporting layer that surfaces key metrics from your operational data so you can see what's happening. An ERP system is an enterprise platform that manages 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. 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). No separate dashboard setup is required.
Conclusion
A manufacturing dashboard is a practical tool for any small-batch maker who wants to stop reacting to problems and start seeing them coming. It doesn’t have to be sophisticated. What matters is that it gives you fast answers to the questions you’re already asking.
Start with the metrics that directly affect your production decisions, keep it simple, and review it consistently. Whether you build it in a spreadsheet or use purpose-built manufacturing software, the habit of checking your numbers regularly is what turns data into better decisions.
