Reconciliation vs in-sheet rollup
4 MISMATCH
15 pass · 4 fail · 2 n/a
(tolerance 0.5%) — daily-recomputed totals checked against the sheet's own “Compound 6-10” monthly rollup.
| Compound | Field | Recomputed | Sheet | Δ% |
|---|---|---|---|---|
| SWR / AGRI F | Batch Weight | 182,241 | 176,418 | 3.3% |
| SWR / AGRI F | Material out | 181,280 | 175,487 | 3.3% |
| SWR / AGRI F | Compound given | 181,100 | 175,050 | 3.46% |
| CPVC F | Batch Weight | 0 | 52,700 | 100.0% |
CPVC F — which figure is right?
Daily detail is authoritative. The sheet's own published closing stock (24,800 kg) reconciles with the daily Mixer-Logbook flows, not with the rollup's own Batch/Material/Given cells (which would leave 14,300 kg) — so the rollup's monthly aggregate is understated and should be corrected in the source sheet.
Given to Pipe
1,781,850 kg
Pipe Output
1,065,334 kg
Conversion
59.8%
Pipe output is net-of-rejection, so a conversion below 100% is expected.
Biggest mover — vs Jul 2026
CPVC
· compound given
▼ -100%
99,450 → 0 kg
Compound Trend — given (kg, bars) & weight-loss % (line)
By Compound — which one is drifting
Tap a compound in the legend to show/hide its line. CPVC F (purchase/issue) has no weight-loss figure.
Compound Mass-Balance (kg)
| Balance | CPVC | UPVC | AGRI | SWR | UPVC F | SWR / AGRI F | CPVC F | FC | TOTAL |
|---|---|---|---|---|---|---|---|---|---|
| Opening Stock | 842 | 1,241 | 1,489 | 1,260 | 772 | 703 | 14,300 | 364 | 20,607 |
| Pulvizer | 48,150 | 44,950 | 25,750 | 140,200 | 0 | 0 | 0 | 14,900 | 259,050 |
| Total Batch Weight | 346,322 | 513,500 | 241,701 | 689,101 | 98,588 | 182,241 | 0 | 19,966 | 2,071,452 |
| Total Material out of Mixer | 343,554 | 510,909 | 240,470 | 685,685 | 98,061 | 181,280 | 80,050 | 19,874 | 2,140,009 |
| Total Compound given | 343,175 | 511,275 | 240,950 | 686,450 | 97,500 | 181,100 | 69,550 | 20,050 | 2,130,000 |
| Total Weight Loss at Mixer | 2,768 | 2,591 | 1,231 | 3,416 | 527 | 961 | 0 | 92 | 11,493 |
| Av. Weight Loss % | 0.80% | 0.50% | 0.51% | 0.50% | 0.53% | 0.53% | — | 0.46% | 0.55% |
| Closing Stock | 1,221 | 875 | 1,009 | 495 | 1,333 | 883 | 24,800 | 188 | 30,616 |
Closing = Opening + Material out − Given (recomputed). CPVC F (CG 122) is purchase/issue.
FC is a separate fitting compound — shown for reference, excluded from TOTAL and reconciliation.
Raw-Material Breakdown (30 items, kg)
| Material | CPVC | UPVC | AGRI | SWR | UPVC F | SWR / AGRI F | CPVC F | TOTAL |
|---|---|---|---|---|---|---|---|---|
| Resin K - 67 | 111 | 361,375 | 178,500 | 424,200 | 964,186 | |||
| Resin K - 57 | 87,400 | 159,700 | 247,100 | |||||
| Resin J - 700 | 244,200 | 244,200 | ||||||
| CACO - 3 | 86,718 | 28,604 | 103,144 | 4,370 | 9,582 | 232,418 | ||
| SUPER PACK | 52,690 | 52,690 | ||||||
| TIO - 2 | 203 | 7,232 | 945 | 2,350 | 1,311 | 1,597 | 13,638 | |
| Cazn - 3210 | 11,212 | 1,686 | 12,898 | |||||
| ONE PACK 305 - B | 2,231 | 8,464 | 10,695 | |||||
| PE - WAX | 2,012 | 882 | 2,138 | 175 | 257 | 5,465 | ||
| FITTING ONE PACK | 4,434 | 4,434 | ||||||
| ONE PACK 305 -B | 3,950 | 3,950 | ||||||
| PA - 20 | 1,746 | 2,145 | 3,891 | |||||
| B - 564 | 222 | 1,748 | 1,716 | 3,686 | ||||
| CPE | 892 | 2,085 | 2,978 | |||||
| DBP | 573 | 1,566 | 2,139 | |||||
| TIN - 502 | 1,716 | 1,716 | ||||||
| MTM | 347 | 1,311 | 1,658 | |||||
| ONE PACK 305-B | 1,421 | 1,421 | ||||||
| SF | 352 | 858 | 1,210 | |||||
| STEARIC ACID | 143 | 569 | 713 | |||||
| WAX - 617 | 198 | 175 | 172 | 545 | ||||
| CARBON | 72 | 168 | 64 | 304 | ||||
| WAX - 629 | 198 | 198 | ||||||
| UPVC CS | 0 | 64 | 64 | |||||
| IMPECT MODIFIER M-505 | 56 | 56 | ||||||
| PROCESING AID PA-101 | 56 | 56 | ||||||
| UPVC - CS | 36 | 36 | ||||||
| IMPECT MODIFIER M - 505 | 28 | 28 | ||||||
| PROCESING AID PA - 101 | 28 | 28 | ||||||
| YELLOW | 1 | 1 |