Create the same three graphs using the Forecast Sheet tool $($line charts$)$ in Excel. Hint: The Forecast Sheet tool is found under the Data tab. Highlight data to analyze, click on Forecast sheet, and click on Options to make the following adjustments.

a$.$ Set the Forecast End to $12/1/2025.$

b$.$ Use an $85\%$ Confidence Interval.

c$.$ Check the Include forecast statistics box.

d$.$ Leave remaining defaults as is$.$

$3.$ Use the trendline graphs to determine: Hint: To help identify the answers, display gridlines. Consider changing vertical axis bounds.

Note: Round your answers to the nearest thousand dollar.

a$.$ Expected unit sales in October $2025$: Answer

$8,747$

b$.$ Expected sales revenue in June $2025$: $Answer

$576,513$

c$.$ Expected net profits in December $2025$: $Answer

$351,882$

$4.$ Use the Forecast sheets to determine:

a$.$ Range of expected unit sales in October $2025($Upper to lower Confidence bounds$).$ Answer

$0$

to Answer

$0$

b$.$ Expected sales revenue in June $2025($Upper to lower Confidence bounds$)$ $Answer

$0$

to $Answer

$0$

c$.$ Range of expected net profits in December $2025($Upper to lower Confidence bounds$)$ $Answer

$0$

to $Answer

$0$

$5.$ To evaluate the Forecast sheets, rerun the forecasts. This time change the Forecast Start date to $1/1/2024$ to see what the model would have predicted for $2024.($Leave the confidence level at $85\%.)$ Compare the forecasted results for $2024$ to the actual results for $2024.$

Were the predictions higher or lower than the actual results?