$5($Chapter $6)$ Optional. $2$ points Extra Credit for perfect answer, showing work. $($Hint: Do this on an Excel spreadsheet.$)$ Operating costs of an automobile in Best Semiconductor Inc.$\text{'}$s $($BSI$)$ automotive pool $($for its employees$)$ are as follows for a car in year t of its age $($e$.$g$.,$ year $1,$ year $2,$ etc.$)$: USE AN EXCEL SHEET to answer.

t

$1$

$2$

$3$

$4$

$5$

$6$

$1000$

$1500$

$1500$

$2000$

$3000$

$5000$

Cost of auto replacement is $\backslash (\backslash$$ $30,000\backslash ).$ BSl$\text{'}$s discount rate is $\backslash (10\backslash \%\backslash ).$ Salvage value if a caris, sold at age $\backslash ($ t $\backslash )$ is:

t

$1$

$2$

$3$

$4$

$5$

$6$

$22,000$

$16,000$

$12,000$

$8,500$

$5,000$

$500$

What is the minimum EAC? What is the optimal age of replacement for an auto in BSI's fleet?