Free Excel template
Production schedule template for cosmetics and chemical manufacturers
A free Excel production schedule built for batch manufacturing. Plan batches by line or vessel, check raw materials and packaging are ready, and see which customer orders are at risk before they slip.
Free download
Download the production schedule template
Excel file with a batch schedule, line capacity sheet and instructions. Works in Excel and Google Sheets.
Looking for software for this? See Worldover's chemical MRP software and cosmetic MRP software.
What's in the template
Batch schedule
One row per batch: lot number, product, formula version, order, line, batch size, planned start and end.
Readiness checks
Raw materials and packaging marked Yes, No or Partial. Anything not ready turns red.
Late-order warning
Days of slack between planned end and customer due date, amber at two days or less, red when late.
Status tracking
Planned, weighing, in process, filling, awaiting QC, released or on hold, as a dropdown.
Line capacity
Minimum and maximum batch size, batches per day and changeover time for every line or vessel.
How to use it
- List every line, vessel or blend tank on the capacity sheet.
- Add one row per batch, starting with orders due soonest.
- Check raw materials and packaging for each batch, then fix the red cells first.
- Leave room for QC release time before the customer due date.
- Update status daily so everyone sees the same plan.
Where the spreadsheet stops
A spreadsheet only knows what someone types into it. Worldover's MRP builds the schedule from live stock, open orders, formulas and QC status, so shortages show up before the batch is due.
Questions
What should a production schedule include?
For batch manufacturing, at least: batch or lot number, product and formula version, the order it's for, line or vessel, batch size, planned start and end, material and packaging readiness, QC release timing and the customer due date.
Does this work for chemical blending as well as cosmetics?
Yes. The columns are the same for emulsions, fills and blends. Use the line capacity sheet for vessels and blend tanks, and record batch size in kg.
Can I use it in Google Sheets?
Yes. Upload the file to Google Drive and open it with Google Sheets. Dropdowns and colour warnings carry across.
When does a spreadsheet schedule stop working?
Usually when stock, purchase orders, QC results and formula changes live elsewhere and someone has to re-key them. That's when an MRP that plans from live data pays for itself.
