Plant Mass Balance & Cost Model

How the 13 tabs connect

1. Cement Silo Balance \u2014 measured stock + sales \u2212 initial stock = the truth, independent of what was booked.
2. Mill Delta Allocation \u2014 splits that truth across the mills that ran each product, in proportion to booked tonnage.
3. Cement Oxide Matrix \u2014 reverse-engineers the actual mill recipe from lab oxide analysis (least-squares).
4. Cement Material Wet/Dry \u2014 dry tons from the recipe, wet tons for what quarries/subcontractors are paid on.
5. Raw Mill Silo Balance & Delta Allocation \u2014 same logic, one stage upstream of the kiln.
6. Raw Meal Oxide Matrix \u2014 solves the actual raw mix (limestone/clay/iron/correctives) from chemistry.
7. Raw Material Wet/Dry \u2014 wet/dry conversion for raw materials.
8. Clinker / Kiln Factor Check \u2014 cross-checks inferred clinker production against the independently balanced raw meal.
9. Purchased & Quarry Materials Reconciliation \u2014 period stock reconciliation against balanced consumption.
10. Bulk Density \u2014 actual, derived density per material \u2014 replacing a single fixed assumption.
11. Power Consumption \u2014 kWh/t at raw grinding, pyroprocessing and cement grinding, on balanced (not booked) tonnage.
12. Cost Breakdown \u2014 raw meal $/t \u2192 clinker $/t \u2192 cement $/t per product, cascaded from the same balanced tonnages.
13. Dashboard \u2014 one-page read-out linking into every tab above.

Built to be edited, not just read