Question: For the garage-band model you developed in Problem, define and run some reasonable scenarios using the Scenario Manager to evaluate profitability for the following scenarios:
Problem: Thomas wants to predict the sales figures of his company for the upcoming year. On the basis of historical data, he concludes that a linear function passes through the observed data points for the first and sixth years. The sales figure for the first year is $24,000, and for the sixth year is $2,000. Develop a spreadsheet model to find intercept and slope of the linear function and predict sales for the seventh year.