Work a Rolling Model Update
Perform a basic monthly rolling forecast update in the right sequence.
March forecast was $1.20M revenue and $760K cost. Actuals are $1.10M revenue and $790K cost. April demand driver improves by 6 percent, and the forecast must keep a 12-month horizon. Update actuals first, then future drivers, then scenario triggers, then extend the horizon. The shortcut is to lower all future revenue because March missed. That double-counts timing issues and hides which driver changed. Step 1 Replace March forecast with actuals: revenue -$100K variance and cost +$30K variance. Closed period becomes fact and should not remain a live assumption. Step 2 Bridge March: $70K revenue timing slip collected April 3, $30K…
Sign up free — one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in