Production & Material Planning Calculator

0. Item Information

1. Production Quantity Calculation

2. Product Specification

3. Material Formulation & Cost

Material Name Formulation Ratio (%) Material Cost (per kg) Usable Stock on Hand (kg)

4. Material Requirement Summary

Material Gross Material Requirement (kg) Stock Deduction (kg) Net Purchase Requirement (kg) Rounded Purchase (25kg bags) Estimated Purchase Value
TOTAL PURCHASE COST 0.00

5. Production Time Estimation

Machine Cycle Time (sec) Cavity (pcs / cycle) Efficiency (%)
Machine 1
Machine 2
Machine 3
Machine 4
Machine 5