Using the data in Worksheet "Sales Data", and create the following charts.

$1)$ Use one formula to retrieve information $($total $-$ Column Y in Tab "Sales Data"$)$ for below table and insert sparklines in column H for trend from $2013$ to $2017$

The sparkline should highlight the high point $($red$)$ and the low point $($yellow$)$

Customer Type $20132014201520162017$ Trend

Consumer

Corporate

Home Office

Small Business

$2)$ Using the information in Table of question $(1)$ and calculate the following table. And plot the chart of $2016$ performance vs$.$ Acceptable levels.

Column C is the actual sales of $2016,$ Column D is the Budget, which calculated using the average customer type sales of $2015($average of $2015$ actual of consumer, corporate, home office and small business$)$

Column E $=$ Budget $*1\mathrm{.}2,$ and Column F $=$ Budget $*0\mathrm{.}8$

Customer Type $2016$ Actual Budget Upper Lower Upper$-$Lower

Consumer

Corporate

Home Office

Small Business

$3)$ Using the information $(2016$ Actual and Budget$)$ in Table of question $(2)$ and plot the Thermometer Chart

$4)$ Using the information below to create the waterfall chart.

Year Beginning Inventory $100000$

Jan $-15000$

Feb $25000$

Mar $-100000$

Apr $-50000$

May $25000$

Jun $38000$

Mid year Inventory $23000$

Jul $25000$

Aug $-15000$

Sep $25000$

Oct $50000$

Nov $75000$

Dec $-25000$

Year end inventory $158000$