Conclusion
The job was to give management a forecast to 2029 that reconciled and showed where the limit was. It did. The workbook closes to zero on conservation, each well is allocated once, and the three scenarios differ only by dated switches. The finding that water, not transfer capacity, binds at three of four facilities changed the order of the operator's project list.
| Success criterion | Met | How it was achieved |
|---|
| iOil, water and gas conserved across every transfer, checked to zero on the validation sheet | Met | All four checks pass on the issued workbook; the validation sheet is part of the deliverable |
| iiEvery well allocated to one facility in every month of every scenario | Met | Home and current facility carried on every well; the double-counting check on the validation sheet returns zero in every month of all three scenarios |
| iiiScenarios differ only by the declared switches, each with a date and a source | Met | Switch register issued with a date and a source for each facility limit, line capacity and availability date; the three scenarios share one base case |
| ivThe binding limit at each facility readable by year without opening the model | Met | Scenario tables to 2029 name the binding limit at each facility for each year, with capacities labelled as planning inputs dated September 2026 |