Return On Investment Analysis (Apply changes to green cells).
| Metric | Unit | Current State | Financial Impact |
|---|---|---|---|
| Revenue | $ | $0 | |
| Under forecast (% of time) | % | $0 | |
| Over forecast (% of time) | % | $0 | |
| Profit margin | % | $0 | |
| Production cost | $ | ||
| Shipment cost | $ | ||
| Inventory cost | $ |
| Metric | Unit | Current State | Drivers | Financial Impact |
|---|---|---|---|---|
| Total sales | $0 | |||
| Under-forecast amount | % | 0 | $0 | |
| Lost sales | % | $0 | ||
| Loss gross profit | $0 | |||
| Lost companion sales | % | $0 | ||
| Gross profit of lost companion sales | $0 | |||
| Increase in production cost | % | $0 | ||
| Increase in shipment cost | % | $0 | ||
| Lost gross profit from under forecasting | $0 |
| Metric | Unit | Current State | Drivers | Financial Impact |
|---|---|---|---|---|
| Total sales | $0 | |||
| Over-forecast amount | % | 0 | $0 | |
| Wrong products produced | % | $0 | ||
| Discounted sales (% sold at discount) | % | $0 | ||
| Lost revenue due to discounting | % | $0 | ||
| Transshipment cost | % | $0 | ||
| Product costs | $ | |||
| Cost of disposing obsolete product (scrap) | % | $0 | ||
| Investment cost (interest rate) | % | |||
| Inventory turns | ||||
| Investment in inventory | $0 | |||
| Lost gross profit from over forecasting | $0 |
| Cost of under forecasting | $0 |
| Cost of over forecasting | $0 |
| Total impact of forecasting errors | $0 |
| Impact relative to gross profit | NaN% |
| Metric | Year 1 | Year 5 |
|---|---|---|
| Impact of forecasting errors | $0 | $0 |
| Reduction in forecasting error | % | % |
| Investments | $0 | $0 |
| Total cost of solution | $0 | |
| Total net benefit | $0 | $0 |