Google Sheets · Excel · 7 tabs · work orders · schedule · materials & capacity
Factory Production Planner
Factory Production Planner — for small factories and job shops who turn incoming orders into a schedule and need to know what to buy and whether they have the capacity. Most spreadsheets stop at a list of orders. This one follows the order all the way through: work orders generate themselves, hours are estimated from your own standard times, the materials bill multiplies by the quantity ordered, and the capacity view tells you before the week starts whether you are overloaded.
€14.99 · instant download · Excel and Google Sheets · no subscription · use it forever.
What you get
- DEMO workbook: an 8-tab system pre-filled with a worked example (six orders across three products) so you can watch every tab calculate before you touch your own numbers.
- BLANK workbook: the same system with the example rows cleared, ready for your own orders, products, materials and machines.
- Quick-start guide PDF: from order book to schedule in minutes, in plain English.
- Works in Microsoft Excel (.xlsx) and Google Sheets. No macros, so nothing breaks.
The tabs
START HERE
instructions on page one, no spreadsheet knowledge assumed
Orders
order number, product, quantity and due date
Work Orders
generated from orders, with hours estimated from your standard times
Schedule
hours per machine per day, week totals and load % vs capacity
Materials Needed
bill of materials × quantity ordered, shortfalls flagged
Inventory
stock on hand, reorder points, unit cost and value on hand
Capacity
hours required vs available, overload flagged
Dashboard
orders, units, hours, load, materials and stock at a glance
Works with
- Excel and Google Sheets (instructions included)
- Print as PDF for a paper copy
Before you buy: For your own business. A planning aid — confirm schedules and capacity with your team.
Get it
€14.99, instant download from the ChurchillCraft shop on Etsy. No subscription, no account, no macros — the file is yours and it keeps working.