| ← Back to Cover |
|
|
|
|
|
| |
ERROR CHECKS & MODEL INTEGRITY |
|
| |
|
|
| |
Overall Model Status: |
ALL CHECKS PASSED |
|
|
|
| |
|
|
|
|
|
|
| |
Check # |
Validation Check |
Expected |
Status |
Details |
|
| |
1 |
Allocation % sums to 100% per zone |
All zones = 100% |
PASS |
All zone allocations valid |
|
| |
2 |
Total demand within plant capacity (2026) |
Demand < Capacity |
PASS |
Sufficient plant capacity |
|
| |
3 |
Total demand within DC capacity (2026) |
Demand < DC Capacity |
PASS |
Sufficient DC capacity |
|
| |
4 |
No plant utilization exceeds 100% |
All util. < 100% |
PASS |
All plants within capacity |
|
| |
5 |
All TLC components are non-negative |
All values >= 0 |
PASS |
No negative cost components |
|
| |
6 |
Inflation rates within reasonable range (0-15%) |
0% to 15% |
PASS |
All inflation rates within range |
|
| |
7 |
FX rates are positive |
All FX > 0 |
PASS |
All FX rates valid |
|
| |
8 |
Demand growth rates reasonable (-10% to +20%) |
-10% to +20% |
PASS |
Growth rates within
expected range |
| |
9 |
5-Year NPV calculation is valid |
NPV > 0 |
PASS |
NPV: $582.1mm |
|
| |
10 |
Regional demand sums match total demand |
Sum = Total |
PASS |
Regional totals reconcile |
|
| |
11 |
Transport rates within range ($0.50-$50/unit) |
$0.50 to $50 |
PASS |
All freight rates within range |
|
| |
12 |
WACC / Discount rate is positive and < 25% |
0% < WACC < 25% |
PASS |
WACC: 10.0% |
|
| |
13 |
Landed Cost lane ranking valid (no ties) |
All ranks unique |
PASS |
All lanes have unique ranking |
|
| |
14 |
All key model outputs populated |
No blanks in outputs |
PASS |
All key outputs are populated |
|
| |
|
|
|
|
|
|
| |
SUMMARY |
|
|
|
|
| |
Total Checks: |
14 |
|
|
|
|
| |
Passed: |
14 |
|
|
|
|
| |
Failed: |
0 |
|
|
|
|
| |
Warnings: |
0 |
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
Note: Error checks run
automatically when model inputs are updated. PASS = check validated, FAIL =
requires attention, WARN = review recommended. Address all FAIL items before
using model for decisions. |
|
|
|
|
|
|
|
|