Worldover, AI operating system for substance-based businesses

    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

    How to use it

    1. List every line, vessel or blend tank on the capacity sheet.
    2. Add one row per batch, starting with orders due soonest.
    3. Check raw materials and packaging for each batch, then fix the red cells first.
    4. Leave room for QC release time before the customer due date.
    5. 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.