Part $2$: As noted in the case in Chapter $1,$ the supply chain worksheets provide cost data associated with lo$-$gistics between existing plants and customers as well as proposed new plants. Ms$.$ Burke wants you to extract the records associated with the unit shipping costs of pro$-$posed plant locations and compare the costs of existing locations against those of the proposed locations using quartiles.Part $3$: Ms$.$ Burke would also like a quantitative sum$-$mary of the average responses for each of the customer at$-$tributes in the worksheet $2014$ Customer Survey for each market region as a cross$-$tabulation $($use PivotTables as ap$-$propriate$),$ along with frequency distributions, histograms, and quartiles of these data.Part $4$: Propose a monthly dashboard of the most important business information that Ms$.$ Burke can use on a routine basis as data are updated. Create one using the most recent data. Your dashboard should not consist of more than $68$ charts, which should fit comfortably on one screen.Write a formal report summarizing your results for all four parts of this case.