USD. Amounts carry their P&L sign: income positive, cost negative. Green = revenue from the KE24 loaded in the Profitability KPI — ; each day counts in its own week, a week that crosses a month end is split by date. Blue = from the entered balances (net difference week to week; revenue from the typed KE24 MTD only where the Profitability KPI has no KE24 for the plant and month); bold = typed on the Enter data page (overrides KE24 and the balance figure for that week). The week shown is the ISO week holding today (a past month: its last week) — pick another in "Week". Week target = the month target ÷ the month's production days × the week's production days in the month; Month to date and MTD target run through the week shown. The Excel download carries every week and every column. Shaded = projected month: revenue from the KE24 trend (blend of the month-to-date run-rate and the prior 4 weeks, on weekday weights learned from the KE24; the error band above is its backtest on the complete months stored), material, scrap, packaging and sales/inventory adjustments as their trailing share of revenue, direct and indirect labor as month to date + the remaining production days × their trailing daily rate, overheads, SG&A and other income as month to date + the rest of the month × the average of the complete prior months (up to 12; on the first day of a month that is the whole forecast) (hover a cell for its source); a line with no history stays at month to date.
Actual vs target
Actual
Target
% to target
Forecast month end
Cost-center drill-down
From the entered balances: each entry carries the plant totals and each cost center's own balances (entered on the Enter data page); all other cost centers = total − the cost centers, so the groupings add back to the total. Revenue (KE24) has no cost center; figures typed on the Enter data page stay at plant level.