Production Planning + Daily + Delivery System (Sec 1–12)

1. Production Quantity

Total Order (Key in any ONE unit)

Opening Balance (Factory Stock) (Key in any ONE unit)

FCLBAGPCS
Total Order
Covered (Stock + Delivered)
Net Production Required

Up-To-Date Summary

FCLBAGPCS
Factory Balance (On Hand)
Produced (UTD)
Delivered (UTD)
Order Balance to Deliver
Logic: Factory Balance = Opening + Produced − Delivered; Order Balance = Total − Delivered; Net Production = Order Balance − Factory Balance (min 0).

2. Daily Production (Up To Date)

DateMachineFCLBAGPCSAction
Total Produced 0 0 0

3. Delivery Order (Up To Date)

DateFCLBAGPCSAction
Total Delivered 0 0 0

4. Product Specification

5. Material Formulation

Material%Cost / kgStock (kg)

6. Material Requirement Summary

MaterialGross (kg)Stock Used (kg) Net Required (kg)25kg BagsCost
TOTAL0.00

7. Planned Production Time

MachineCycle (sec)CavityEfficiency %

8. Planned vs Actual

PlannedActualVariance
Quantity (PCS)
Time
Status

9. Shift + Machine EPF

DateMachineShiftPlanActualEPF %

10. Delivery Suggestion & Gantt Plan

Suggested Completion

Daily Delivery Plan

Date Lorry PCS Order Balance After

Delivery Gantt (Calendar View)

11. AI What-If Simulation (Production + Stock + Delivery)

Result

Daily Simulation Table

Date Produced (PCS) Delivered (PCS) Stock On Hand (PCS) Order Balance (PCS) Lorry

Delivery Gantt (PCS)

Notes: Delivery is only scheduled on Mon–Fri (and Sat if allowed). Sunday = no delivery. Production runs every day in this simulation.

12. AI Optimizer (Earliest Completion)

Search Range

Best Result

Best Plan (Daily)

Date Produced (PCS) Delivered (PCS) Stock On Hand (PCS) Order Balance (PCS) Lorry

Best Delivery Gantt (PCS)

Optimizer goal: Earliest completion date only (ignores cost). It searches over production/day and max lorry/day ranges you set.