Production Planning + Daily + Delivery + AI (Section 1

1. Order / Stock Summary

Total Order (Key in any ONE unit)

Total Order (FCL)

Total Order (BAG)

Total Order (PCS)

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

Opening Balance (FCL)

Opening Balance (BAG)

Opening Balance (PCS)

PCS per FCL

PCS per Bag

	FCL	BAG	PCS
Total Order
Covered (Stock + Produced − Delivered)
Net Production Required

Up-To-Date Summary

	FCL	BAG	PCS
Factory Balance (On Hand)
Produced (UTD)
Delivered (UTD)
Order Balance to Deliver

Core Logic (PCS): Stock = Opening + Produced − Delivered; Order Balance = Total − Delivered; Net Production = max(Order Balance − Stock, 0).

2. Daily Production (Up To Date)

Date

Machine

Mode

Quantity

Date	Machine	FCL	BAG	PCS	Action
Total Produced		0	0	0

3. Delivery Order (Up To Date)

Date

Mode

Quantity

Guards: Delivery cannot exceed remaining Order Balance. (Stock can go down; system will keep Stock >= 0.)

Date	FCL	BAG	PCS	Action
Total Delivered	0	0	0

4. Product Specification

Weight per Piece (kg)

Waste (%)

5. Material Formulation

Material	%	Cost / kg	Stock (kg)

Note: % total can exceed 100% (e.g., regrind + additive). Only rows with Material + % will be calculated.

6. Material Requirement Summary

Material	Gross (kg)	Stock Used (kg)	Net Required (kg)	25kg Bags	Cost
TOTAL					0.00

7. Planned Production Time & Capacity

Planned Start Date & Time

Machine	Cycle (sec)	Cavity	Efficiency %

Run Hours (per day)

Downtime %

Capacity Period

Total Planned Duration (to finish Net Production)

Planned End

Capacity Output (Auto from Cycle Time)

	PCS	BAG	FCL
Total Capacity

Capacity Breakdown (Per Machine)

Machine	Cycle	Cavity	Eff%	PCS	BAG	FCL
TOTAL				0	0	0

Capacity uses FLOOR (conservative). Planned duration uses Net PCS from Section 1.

8. Planned vs Actual

	Planned	Actual	Variance
Quantity (PCS)
Time
Status

9. Shift + Machine EPF

Date

Machine

Shift

Planned Qty (PCS)

Actual Qty (PCS)

Date	Machine	Shift	Plan	Actual	EPF %

10. Delivery Suggestion (Calendar Based)

Start Date

Max Lorry / Day

Production PCS / Day (If empty, uses Section 7 Capacity/day)

Lorry Capacity (BAG)

Lorry Capacity (PCS) (optional override)

Loading Window (info)

Allow Saturday Delivery

Allow Sunday Delivery

Note

Explanation
Standard lorry capacity refers to the maximum loading capacity per lorry under normal operating conditions.
Full lorry trips are loaded to standard capacity.
The last lorry may be loaded with:

Remaining production quantity
Customer-required balance
Partial load due to delivery scheduling or space constraints

Total Load Capacity = (Standard Lorry Capacity × Full Lorry Trips) + Last Lorry Balance Quantity

Date	Produced (PCS)	Delivered (PCS)	Stock End (PCS)	Order Bal End (PCS)	Lorry Used	Gantt

11. What-If Simulation (Production & Delivery Constraints)

Start Date

Assumed Production (PCS/day) (If empty, use Section 7 Capacity/day)

Max Lorry / Day

Allow Saturday Delivery

Allow Sunday Delivery

Limit Days (safety)

Date	Produced	Delivered	Stock End	Order Bal End	Lorry Used

12. AI Optimizer (Earliest Completion)

Start Date

Production PCS/day (min)

Production PCS/day (max)

Step (PCS/day)

Max Lorry/day (min)

Max Lorry/day (max)

Allow Saturday Delivery

Allow Sunday Delivery

Search Limit Days

Best Completion Date

Best Production (PCS/day)

Best Lorry/day

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

1. Order / Stock Summary

Total Order (Key in any ONE unit)

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

Up-To-Date Summary

2. Daily Production (Up To Date)

3. Delivery Order (Up To Date)

4. Product Specification

5. Material Formulation

6. Material Requirement Summary

7. Planned Production Time & Capacity

Capacity Output (Auto from Cycle Time)

Capacity Breakdown (Per Machine)

8. Planned vs Actual

9. Shift + Machine EPF

10. Delivery Suggestion (Calendar Based)

11. What-If Simulation (Production & Delivery Constraints)

12. AI Optimizer (Earliest Completion)