Plan Collision
Find the first week your plans exceed shared time or cash, then compare delays and removals.
Your numbers
First collision week
A planning simulation, not a prediction. Weekly income and capacity are constant; upfront costs occur at each plan’s start. Plans outside the horizon are excluded. Time cannot be borrowed from another week; cash carries forward.
Scenario comparison
Up to three snapshots in this tab. Loading one replaces the current inputs.
Formula
Each week, update cash with C = C+I−E−A−U and free hours with H = T−F−P. I is income, E is essential spending, A is active-plan recurring costs, and U is newly starting plans' upfront costs. T is available hours, F is fixed hours, and P is active-plan hours.
Find the first week your plans exceed shared time or cash, then compare delays and removals.
Worked example
- First planning week starts (YYYY-MM-DD)
- 2026-11-02
- Planning horizon (weeks)
- 8
- Total available hours each week
- 40
- Existing fixed hours each week
- 30
- Starting available cash
- 1000
- Cash income each week
- 600
- Essential cash spending each week
- 500
- Delay each plan for comparison (weeks)
- 2
- First collision week
- 3
- Weeks with a time or cash shortfall
- 2 weeks
- Largest weekly time shortfall
- 4 hours
- Largest cumulative cash shortfall
- 0
- Cash at horizon end
- 1,140
Plans to fit together
- Course
Hours/week: 8
Cost/week: 60
Upfront cost: 200
Start week: 1
End week: 4
- Side project
Hours/week: 6
Cost/week: 30
Upfront cost: 100
Start week: 3
End week: 6
Scope and limitations
A planning simulation, not a prediction. Weekly income and capacity are constant; upfront costs occur at each plan’s start. Plans outside the horizon are excluded. Time cannot be borrowed from another week; cash carries forward.
Inputs are checked for missing values and allowed ranges. A result outside the finite numeric range is not displayed. Rounding affects display, while the calculation uses the model’s numeric precision.
Check your units and assumptions before relying on a result. Changing a label does not convert a currency or physical unit.
Formula version: a140f2c19668 · Example checked: