Production Planning

Weekly Schedule

Sequence

Step-by-step run order for each press, including every mold change.

Reschedule

Log what happened during the week. Work before the event stays exactly as it ran; the rest of the week is re-optimized automatically.

Schedule output

Edit customer demand, cycle time, starting stock, stock target or days on hand, then press Update Schedule. Stock target = days on hand × daily demand (weekly demand ÷ 5).

SQLite Workbook

Every input, the latest optimized schedule and this glossary live in one SQLite database: data/production_planning.db.

Download SQLite code & workbook Download schedule (CSV)

The zip holds production_planning.db (the SQLite database), production_planning.sql (schema, data and example queries), production_planning.xlsx (every table as a sheet) and schedule.csv.

sqlite3 production_planning.db
sqlite> SELECT * FROM v_output;                -- the Schedule output table
sqlite> SELECT * FROM v_schedule;              -- every block of the latest schedule
sqlite> UPDATE weekly_demand SET customer_demand = 6000 WHERE part_id = 1;

Tables

Browse the database. Views start with v_.

CREATE statement

Query (read-only)

Run any SELECT against the database.

Glossary of formulas and variables

The schedule is a mixed-integer linear program (MILP) written with PuLP in app/model.py and solved with HiGHS. Each entry says what the symbol is, its formula and how it was used.