Melton Manufacturing opened in January $2019.$ Sales have increased significantly in the first two years of operations, and management is now looking to expand production capacity. To finance the purchase of a new factory, they would need to either raise capital or borrow funds. $1.$ Create three line graphs in Excel $($one for units sold, one for sales revenue, and one for net operating income$).$ Add trendlines to all graphs.

a$.$ Extend the trendline out for $12$ months.

b$.$ Use the Polynomial $($Order $2)$ trendline option for all charts

c$.$ To see how closely the trendline matches the data, check the Display R$-$squared value on chart box. The closer the R$-$square value is to $1,$ the better the match.

$2.$ Create the same three graphs using the Forecast Sheet tool $($line charts$)$ in Excel.

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

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

c$.$ Check the Include forecast statistics box.

d$.$ Leave remaining defaults as is