What is a production plan format?
A production plan format turns open orders into a work plan. It says what to make, how many, where and by when. It also checks machine hours and raw material first.
The owner uses it to promise dates. The planner or production head builds it. Stores issues material from it.
- Daily plan: jobs on each machine, shift by shift.
- Weekly plan: this week's orders, machines and dates. Our file uses this.
- Monthly plan: rough capacity and raw-material buying.
Weekly is long enough to plan material and short enough to stay accurate. For the bigger picture, see our guide to the master production schedule.
Is there a free production planning template in Excel?
Yes. The download on this page has a blank weekly plan and the filled example below.
What each column in the production plan format means
A production schedule includes the order, item, quantity, machine hours, dates, material status and actual output.
| Column | What to enter | Formula |
|---|---|---|
| SO no. | Customer order this job is for | — |
| Item | Finished product, named as in your BOM | — |
| Due date | Date the customer expects dispatch | — |
| Qty ordered | Quantity on the sales order | — |
| Finished stock | Ready stock of this item | — |
| Qty to produce | What you still need to make | Qty ordered − Finished stock |
| Output/hr | Good pieces this machine makes per hour | From past records |
| Hours needed | Machine time for this job, including changeover | Qty to produce ÷ Output/hr + Changeover hours |
| Planned dates | Dates the job starts and ends | Finish on or before the due date |
| Material status | OK, or what is short and when it arrives | From the material check |
| Good qty | Good pieces made, filled at day end | — |
| Rejects | Pieces scrapped or sent for rework | — |
At the top, fill plan number, week, machine or line, prepared by and revision. Use one sheet per machine or cell. Raise the revision with every change, so everyone knows which copy is current.
How to fill the production plan, step by step
- List open orders. Write each pending order with item, quantity and due date.
- Subtract finished stock. Qty to produce = Qty ordered − Finished stock.
- Turn pieces into hours. Divide qty to produce by output per hour. Add the changeover time.
- Check capacity. Compare the machine's total hours with its free hours this week, after maintenance.
- Check material. Multiply each BOM quantity by qty to produce. Note any shortage against stock.
- Set priority and dates. Put the earliest due date first, unless material is short. Give each job a start and finish date.
- Fill actuals every day. At day end, enter good and rejected quantity. Short pieces carry over to next week's plan.
Step 5 needs a correct BOM. Start with our free bill of materials format, then read our guide to material requirement planning.
[[IMAGE {"type":"checklist","title":"Before you release the plan","items":["Finished stock subtracted","Hours include changeover, maintenance","Bottleneck load at most 100%","Every shortage has a date"]}]]
Worked example: one week in a small fabrication unit
A small fabrication unit plans week 48 (23–28 November 2026) for welding cell W1. W1 is the bottleneck, so the plan is built around it.
Table 1 (Example): weekly plan for welding cell W1
Example, illustrative numbers. Each job includes 1 hour of changeover.
| Order and item | Qty to produce | Hours needed | Due date |
|---|---|---|---|
| SO-1041 Material-handling trolley | 120 − 20 = 100 | 100 ÷ 5 + 1 = 21 | 28 Nov |
| SO-1043 Storage rack frame | 80 − 0 = 80 | 80 ÷ 4 + 1 = 21 | 28 Nov |
| SO-1045 Machine guard panel | 70 − 10 = 60 | 60 ÷ 6 + 1 = 11 | 2 Dec |
| Total | 240 | 53 | — |
Table 2 (Example): capacity check, load 106%
Example, illustrative numbers.
| Line | Hours |
|---|---|
| Shift hours (6 days × 9 hours) | 54 |
| Planned maintenance | − 4 |
| Available hours | 50 |
| Load from Table 1 | 53 |
| Capacity load (53 ÷ 50) | 106% |
The plan is 3 hours over. SO-1045 is not due until 2 December, so it moves to Monday and Tuesday of next week.
New load: 42 ÷ 50 = 84%. The 8 spare hours cover a breakdown or a rush order.
Table 3 (Example): material check for SO-1041, castors short
Example, illustrative numbers.
| Material | Needed for 100 trolleys | In stock | Short |
|---|---|---|---|
| MS square tube 25×25 mm | 3.5 m × 100 = 350 m | 420 m | 0 |
| Castor wheel 100 mm | 4 × 100 = 400 | 260 | 140 |
| MS sheet base | 1 × 100 = 100 | 110 | 0 |
| M8 bolt set | 16 × 100 = 1,600 | 2,000 | 0 |
Welding can start on Monday, because castors only go on at assembly. The planner asks purchase for 140 castors by Wednesday. Material status reads "Castors short 140, ordered".
Table 4 (Example): plan vs actual at week end
Example, illustrative numbers.
| Order | Planned qty | Good qty | Rejected qty |
|---|---|---|---|
| SO-1041 | 100 | 100 | 2 |
| SO-1043 | 80 | 76 | 3 |
| Total | 180 | 176 | 5 |
SO-1041 finished on time. SO-1043 is 4 pieces short, so those 4 become the first job of week 49.
KPIs to track from your production plan
KPIs in production planning are a few numbers that show whether the plan held. Track these four, using the example week.
- Plan adherence % = orders finished on time ÷ orders planned × 100. Example: 1 ÷ 2 = 50%.
- Capacity load % = hours loaded ÷ hours available × 100. Example: 42 ÷ 50 = 84%.
- Output vs plan = good qty ÷ planned qty × 100. Example: 176 ÷ 180 = 97.8%.
- Rejection % = rejected qty ÷ (good qty + rejected qty) × 100. Example: 5 ÷ 181 = 2.8%.
If load sits near 100% week after week, read our guide to capacity requirements planning.
Common production plan mistakes
- Not checking finished stock first. You make pieces already in the store.
- Planning in pieces, never in hours. 100 trolleys still need 21 machine hours.
- Ignoring maintenance and changeovers. No machine is free every shift hour.
- No material check before the start date. The job stops for one missing part.
- Loading the bottleneck above 100%. The plan is late before Monday.
- No actual column. Next week repeats the same errors.
- One file, no version. Three copies float on WhatsApp, and nobody knows which is right.
Where Excel stops and software takes over
This format works for one cell and a handful of orders. Past that, every number is typed by hand, and the sheet does not know today's stock.
The file sits with one person and goes stale when they are busy. That is a limit of the spreadsheet, not of your team.
| Task | Excel format | TranZact |
|---|---|---|
| Finished and raw material stock | Typed in from the store register | From stock in and issue entries |
| Material needed per order | BOM qty × order qty, by hand | MRP engine tells you what to buy and when |
| Machine hours and load | Your own formula per machine | Machine planning (Dominate plan) |
| Accounts in Tally | Order and stock numbers typed again | One-way sync to Tally, no double entry |
How TranZact fills the production plan for you
TranZact AI is manufacturing AI software used by 10,000+ manufacturers.
- Production: multi-level BOM, work orders, process routing, sub-contracting and production costing, on one system.
- Purchase: shortages move through MRP report → indent → RFQ → PO → GRN. Your purchase team raises each PO from the indent.
- Stock: stock in, issue, multi-store, reorder and AI stock alerts, so system stock and physical stock match.
- Accounts: accounting stays in Tally, with one-way sync and no double entry. Busy and Zoho Books sync too.
Plans start with Grow at ₹8,333 a month, billed yearly, for 4 users. Grow already includes planning (MRP + indent), multi-step BOM and production, and Tally, Busy and Zoho integration. There is no Free plan; only this Excel download is free. See pricing for every plan.
TranZact goes live in 2–3 weeks. Read more on production management and purchase management.
Don't be the bottleneck. Become the AI-Run Factory.
Bring one week of real orders and BOMs to a demo. We will run them through TranZact with you.
Born in India. Building for the world.