There are three models with sales as in Table 1 that are returned and remanufactured into utility models The demand for 2020 is for 150K units Table 1 Sales in 000 Year M1 M2 M3 2019 100 75 50 2018 120 89 51 2017 90 100 47 2016 80 90 45 The EoL EoU time frames and rates are the same for all models ...

Incentive Units Returned Incentive Reman N ...

There are three models with sales as in Table 1 that are returned and remanufactured into utility

Fantastic news! We've Found the answer you've been seeking!

Question:

There are three models with sales as in Table 1 that are returned and remanufactured into utility models. The demand for 2020 is for 150K units.

Table 1. Sales in 000

Year	M1	M2	M3
2019	100	75	50
2018	120	89	51
2017	90	100	47
2016	80	90	45

The EoL/EoU time frames and rates are the same for all models. After 1 year 5% are returned, 2 years: 35%, 3 years: 40%, and 4 years 20%. The overall return rates are based on the incentives. The incentives is the same for all models and four levels are considered.

Incentive	M1	M2	M3
none	15%	15%	15%
$10	30%	35%	40%
$20	45%	50%	55%
$30	50%	55%	60%

Remanufacturing costs are $25 per unit regardless of the model. New units are $70 each.

Develop a tool in Excel that will calculate the forecast and costs under the 4 incentive levels. The Excel file should have a results table in this format: