Spreadsheet: 706908d1606945802-data-table-same-value-across-columns-and-different-for-each-row-budget_error
Sheet: Business Case - Base

 | Input Assumptions
 | Invest | -3
 | One-time | -0.5
 | Maintenance | -150 | annual
 |  | 2021 | 2022 | 2023 | 2024 | 2025
 | Unit cost | 462.8317958259602 | 346.8133142023297 | 271.4132757868114 | 238.375306133778 | 217.3100997165355
 | Sales cost | 93.88437874849359 | 70.0343452067236 | 58.85872410827908 | 46.55368691117315 | 38.82670886963809
 | Base cost to serve | 39.32685573290767 | 30.74922143835677 | 30.70557133973725 | 28.94789423401641 | 29.86691637057445
 | Multiple | 1.5
 | Adjusted
 | Additional Cost | 0.2360443814045193 | 0.2075132165801864 | 0.1040732777871705 | 0.06010541449211983 | 0.03705699179473319
 | Throughput % | 0.2033125210303959
 | Year | 2021 | 2022 | 2023 | 2024 | 2025
 | Source | Budget | Budget | Budget | Budget | Budget
 | Full/Partial Year | 0.25 | 1 | 1 | 1 | 1
 | Number of production lines | 1 | 2 | 2 | 2 | 2
 | Product life | 2 | 2.5 | 2.75 | 3.5 | 3.75
 | [NAME] | 0.1
 | Phasing of Efficiency | 0.25 | 0.5 | 0.75 | 1 | 1
 | Efficiency Lift
 | Avg Cost | 0 | 0 | 0 | 0 | 0
 | Product Selling Price | 750 | 750 | 750 | 750 | 750
 | Average Margin | 0.19 | 0.19 | 0.19 | 0.19 | 0.19
 | Incremental Margin | 0 | 0 | 0 | 0 | 0
 | Adjusted Margin
 | Outputs:
 | Base production numbers | 173351.536580723 | 326446.8871344436 | 513775.8426439016 | 756667.6121483707 | 1002066.047482364
 | Year | 2021 | 2022 | 2023 | 2024 | 2025
 | Revenue Build:
 | Incremental Units
 | Throughput Units
 | Incremental Revenue
 | Incremental Revenue ($ in M)
 | Cost Build:
 | Initial Investment
 | Annual cost
 | One-time costs
 | Service Costs
 | Acquisition Cost
 | Total Cost
 | Incremental Margin (in-year)
 | Cummulative Margin (2021-2025)
 | Lifetime Product Value:
 | Lifetime Revenue - total
 | Yr. 1
 | Yr. 2
 | Yr. 3
 | Yr. 4
 | Lifetime Costs - total
 | Yr. 1
 | Yr. 2
 | Yr. 3
 | Yr. 4
 | Incremental Margin (product version)
 | Product Margin By year
 | Initial Investment
 | one-time costs production
 | Margin Runoff
 | Total Margin
 | Net Incremental Margin
 | ROI (%)
 | Sensitivity:
 |  |  | 0.05
 |  | -0.25 |  | -20.77168837753123 | -20.74668837753123 | -20.72168837753123 | -20.69668837753122 | -20.67168837753123 | -20.64668837753123
 |  |  | -39.40495890624956 | -39.37995890624956 | -39.35495890624956 | -39.32995890624956 | -39.30495890624957 | -39.27995890624956 | -39.25495890624956
 |  |  | -58.01422067840602 | -57.98922067840602 | -57.96422067840602 | -57.93922067840602 | -57.91422067840602 | -57.88922067840602 | -57.86422067840602
 |  |  | -76.62340905593724 | -76.59840905593724 | -76.57340905593725 | -76.54840905593724 | -76.52340905593724 | -76.49840905593724 | -76.47340905593724
 |  |  | -95.2319405893008 | -95.20694058930081 | -95.18194058930081 | -95.1569405893008 | -95.1319405893008 | -95.1069405893008 | -95.08194058930081
 |  |  | -113.8408679621868 | -113.8158679621868 | -113.7908679621868 | -113.7658679621868 | -113.7408679621868 | -113.7158679621868 | -113.6908679621868
 |  |  | -132.450056339718 | -132.425056339718 | -132.400056339718 | -132.375056339718 | -132.350056339718 | -132.325056339718 | -132.300056339718
 |  |  | -151.0594404531219 | -151.0344404531218 | -151.0094404531218 | -150.9844404531218 | -150.9594404531218 | -150.9344404531219 | -150.9094404531218
 |  |  | -169.6675152459676 | -169.6425152459676 | -169.6175152459676 | -169.5925152459676 | -169.5675152459676 | -169.5425152459676 | -169.5175152459676
 |  |  | -188.2768993593714 | -188.2518993593714 | -188.2268993593714 | -188.2018993593714 | -188.1768993593714 | -188.1518993593714 | -188.1268993593714
 |  |  | -206.8861611315279 | -206.8611611315279 | -206.8361611315279 | -206.8111611315279 | -206.7861611315279 | -206.7611611315279 | -206.7361611315279
 |  |  | -225.4942359243736 | -225.4692359243736 | -225.4442359243736 | -225.4192359243736 | -225.3942359243736 | -225.3692359243736 | -225.3442359243736
 |  |  | -244.1034243019049 | -244.0784243019048 | -244.0534243019048 | -244.0284243019049 | -244.0034243019049 | -243.9784243019049 | -243.9534243019048
 |  |  | -262.7128084153086 | -262.6878084153086 | -262.6628084153086 | -262.6378084153087 | -262.6128084153087 | -262.5878084153086 | -262.5628084153086
 |  |  | -281.3211442127997 | -281.2961442127996 | -281.2711442127996 | -281.2461442127997 | -281.2211442127996 | -281.1961442127997 | -281.1711442127996