I have a tech project and report that needs to be done. It has to do with excel

I have a tech project and report that needs to be done. It has to do with excel data and making pivot tables and including charts and graphs in a reportThere is no requirement for a length, but considering ti needs to include 3 charts and 3 graphs along with words, I would say anywhere from 6-8 pagesI will attach all of the info needed and in detail what is needed. Everything is is in detail in the requirements for the tech project and reportI have attached all files needed. The instructions for the project are going to be under the tech project html link. The other links are to assist with the process of creating pivot tables and making them into 3 charts and 3 graphs. All instructions are included in these linksA memo template is to be used for the report in word.Whoever is assigned this will need to thoroughly read the instructions in order to maximize grade potentialBUD6800Tech Project #1 Data Analysis with Pivot Tables50 Points PossibleForthisassignmentyouwilldemonstrateyourabilitytouseExcelPivottablestoanalyzedataandproducecharts/graphstoaidyouinpresentingyouranalysisandsupportingyourrecommendations.CaseBackground::HooverMedicalSupplies,Inc,isalargemanufacturingcompanylocatedinColumbus,Ohio.Thecompanyiscurrentlyseekingtogainoperationalefficienciesinitssupplychainbyreducingthenumberoftransportationcarriersthatitisusingfromfivetothree.BrianHoover,theCEOofHooverMedicalSupplieshashiredyoutoanalyzeitsdataandmakeaclearrecommendationabouthowtoreducetransportationcostswhileretainingahighlevelofservicefromitsbestcarriers.HooverhascustomersinMichigan,WestVirginia,Virginia,Pennsylvania,Indiana,KentuckyandOhio.DataAvailable:TheHooverData_2021.xlsfilecontainsalltheshippinginvoicessubmittedbyitscurrentcarriersandpaidbyHoover.Shippingisbilledbythepoundataratethatconsidersfuelcosts,drivercostsandtruckcosts.Thefilealsoincludesdatacollectedbytrackingthedeliveryscheduleoftheshipments-reflectedinthecolumnofDaysOverdue.LatedeliveriesarenottoleratedbyHooverscustomersandneedtobeminimizedwithinitscarrierpool.ProjectFocus:Carrierselectionshouldbebasedontheassumptionsthatallenvironmentalfactorsareequalandthathistoricalcosttrendswillcontinue.ReviewthehistoricaldatafromthepastseveralyearstodetermineyourrecommendationforthetopthreecarriersthatHoovershouldcontinuetouse.Besurethatthethreecarriersrecommendedwillprovideadequatecoverageofallstatescurrentlyserviced.(Dontassumecarrierswillexpandtheirservicestostatesnotcurrentlyserved.)Analyzethelast24monthsofHooverscarriertransactionsfoundinthedatafile:HooverData_2021.xls..ApplywhatyoulearnedabouttheuseofExcelPivotTablesanddoathoroughanalysisofthedatatodeterminewhichcarriersprovidethebestserviceatthebestpricetothestatesthatHooverservices.Considerwhetheryoushouldlookattotalsoraveragesinyouranalysis.SliceandDice(pivot)thedataanumberofdifferentwaystohelpyouinyouranalysis.Lookateachfactorservice,priceandquality.Spendsometimethinkingabouttheproblemandhowbesttoanalyzethedata.Reviewyouranalysisanddeterminethetopthreecarriersthatyourecommendtoberetained.PrepareamemotoMr.BrianHooverinwhichyoudetailyourrecommendationforthetopthreecarrierswithwhichHoovershouldcontinuetodobusiness.Organizeyourmemotobesuccinctbutinformative.Besuretosupportyourrecommendationwiththefactsandresultsofyouranalysisbecausetherearesomebiasesamongstyourco-workersthatmaydistorttheirviewofthecarriers.Tobettermakeyourargument,yourreportmustsupportyourrecommendationbypresentingthedatausingvisualizationtechniques.Chartsandgraphsshouldbewelldesignedandlabeled,andincludelegends,titles,andvalueswhereappropriate.ApplyExcelPivotTablesanddoathoroughanalysisofthedata.ProjectDeliverables:Youmustdemonstrateyourabilitytocreateandusepivottablestocompletethisassignment.SaveeachcreatedPivotTablesinyourExcelworkbookunderaseparateworksheet(tab).CreateChartsonthedataelementsthatyouwillusetojustifyyourrecommendationintheworddocument.WriteaMemoinMS-wordwithyourrecommendationofwhichthreecarriersHoovershouldcontinuetodobusinesswith.Besuretosupportyourrecommendationwithfactsandnumbersfromthedatabecausetherearesomebiasesamongstyourco-workersthatmaydistorttheirviewofthecarriers.Tobettermakeyourargument,yourreportmustincludeatleastthreechartsandthreegraphs(designedinExcelandcopyandpastedintoWord)thatsupportyourrecommendation.Useaformalandprofessionalwritingstyleandtoneinyourreport.UseaMemotemplate(foundinMicrosoftWord).AddressthememotomeuseyournameintheFromsection.Checkyourgrammarandspelling.Usecompletesentencesandbulletliststosuccinctlybutthoroughlystatetheresultsofyouranalysisandyourrecommendation.UploadyourupdatedExcelfile(withallyourPivottablesthatyoucreatedtoperformyouranalysis)andMS-WordreporttotheBlackboardassignmentpage.Justbesuretoanalyzethedatafromallangles.Iwouldliketoremindyouthatthishomeworkassignmentmustbecompletedandsubmittedindividually.Pointbreakdown:Total50point15pointsforExceldocumentdemonstratingthecorrectuseofPivotTablesandathoroughanalysisofthedata(filemustbepostedtoBlackboardtoreceivecredit).Idefinethoroughas5ormorepointsofanalysis.5pointsforProperAnalysisProperanalysisusestherightvariables,intherightform15pointsforyourWordDocumentusingaMemotemplateandaformal,professionaltonewithattentiontowritingandstyle(alsopostedtoBlackboard)10pointsforthegraphics(tablesandcharts)insertedintoyourWordDocumenttoillustrateandsupportyourrecommendation10pointsforclearlyandconciselymakingarecommendationof3carrierstokeep-50PointsfornotusinggivenExceldataBUD6800Tech Project #1 Data Analysis with Pivot Tables50 Points PossibleForthisassignmentyouwilldemonstrateyourabilitytouseExcelPivottablestoanalyzedataandproducecharts/graphstoaidyouinpresentingyouranalysisandsupportingyourrecommendations.CaseBackground::HooverMedicalSupplies,Inc,isalargemanufacturingcompanylocatedinColumbus,Ohio.Thecompanyiscurrentlyseekingtogainoperationalefficienciesinitssupplychainbyreducingthenumberoftransportationcarriersthatitisusingfromfivetothree.BrianHoover,theCEOofHooverMedicalSupplieshashiredyoutoanalyzeitsdataandmakeaclearrecommendationabouthowtoreducetransportationcostswhileretainingahighlevelofservicefromitsbestcarriers.HooverhascustomersinMichigan,WestVirginia,Virginia,Pennsylvania,Indiana,KentuckyandOhio.DataAvailable:TheHooverData_2021.xlsfilecontainsalltheshippinginvoicessubmittedbyitscurrentcarriersandpaidbyHoover.Shippingisbilledbythepoundataratethatconsidersfuelcosts,drivercostsandtruckcosts.Thefilealsoincludesdatacollectedbytrackingthedeliveryscheduleoftheshipments-reflectedinthecolumnofDaysOverdue.LatedeliveriesarenottoleratedbyHooverscustomersandneedtobeminimizedwithinitscarrierpool.ProjectFocus:Carrierselectionshouldbebasedontheassumptionsthatallenvironmentalfactorsareequalandthathistoricalcosttrendswillcontinue.ReviewthehistoricaldatafromthepastseveralyearstodetermineyourrecommendationforthetopthreecarriersthatHoovershouldcontinuetouse.Besurethatthethreecarriersrecommendedwillprovideadequatecoverageofallstatescurrentlyserviced.(Dontassumecarrierswillexpandtheirservicestostatesnotcurrentlyserved.)Analyzethelast24monthsofHooverscarriertransactionsfoundinthedatafile:HooverData_2021.xls..ApplywhatyoulearnedabouttheuseofExcelPivotTablesanddoathoroughanalysisofthedatatodeterminewhichcarriersprovidethebestserviceatthebestpricetothestatesthatHooverservices.Considerwhetheryoushouldlookattotalsoraveragesinyouranalysis.SliceandDice(pivot)thedataanumberofdifferentwaystohelpyouinyouranalysis.Lookateachfactorservice,priceandquality.Spendsometimethinkingabouttheproblemandhowbesttoanalyzethedata.Reviewyouranalysisanddeterminethetopthreecarriersthatyourecommendtoberetained.PrepareamemotoMr.BrianHooverinwhichyoudetailyourrecommendationforthetopthreecarrierswithwhichHoovershouldcontinuetodobusiness.Organizeyourmemotobesuccinctbutinformative.Besuretosupportyourrecommendationwiththefactsandresultsofyouranalysisbecausetherearesomebiasesamongstyourco-workersthatmaydistorttheirviewofthecarriers.Tobettermakeyourargument,yourreportmustsupportyourrecommendationbypresentingthedatausingvisualizationtechniques.Chartsandgraphsshouldbewelldesignedandlabeled,andincludelegends,titles,andvalueswhereappropriate.ApplyExcelPivotTablesanddoathoroughanalysisofthedata.ProjectDeliverables:Youmustdemonstrateyourabilitytocreateandusepivottablestocompletethisassignment.SaveeachcreatedPivotTablesinyourExcelworkbookunderaseparateworksheet(tab).CreateChartsonthedataelementsthatyouwillusetojustifyyourrecommendationintheworddocument.WriteaMemoinMS-wordwithyourrecommendationofwhichthreecarriersHoovershouldcontinuetodobusinesswith.Besuretosupportyourrecommendationwithfactsandnumbersfromthedatabecausetherearesomebiasesamongstyourco-workersthatmaydistorttheirviewofthecarriers.Tobettermakeyourargument,yourreportmustincludeatleastthreechartsandthreegraphs(designedinExcelandcopyandpastedintoWord)thatsupportyourrecommendation.Useaformalandprofessionalwritingstyleandtoneinyourreport.UseaMemotemplate(foundinMicrosoftWord).AddressthememotomeuseyournameintheFromsection.Checkyourgrammarandspelling.Usecompletesentencesandbulletliststosuccinctlybutthoroughlystatetheresultsofyouranalysisandyourrecommendation.UploadyourupdatedExcelfile(withallyourPivottablesthatyoucreatedtoperformyouranalysis)andMS-WordreporttotheBlackboardassignmentpage.Justbesuretoanalyzethedatafromallangles.Iwouldliketoremindyouthatthishomeworkassignmentmustbecompletedandsubmittedindividually.Pointbreakdown:Total50point15pointsforExceldocumentdemonstratingthecorrectuseofPivotTablesandathoroughanalysisofthedata(filemustbepostedtoBlackboardtoreceivecredit).Idefinethoroughas5ormorepointsofanalysis.5pointsforProperAnalysisProperanalysisusestherightvariables,intherightform15pointsforyourWordDocumentusingaMemotemplateandaformal,professionaltonewithattentiontowritingandstyle(alsopostedtoBlackboard)10pointsforthegraphics(tablesandcharts)insertedintoyourWordDocumenttoillustrateandsupportyourrecommendation10pointsforclearlyandconciselymakingarecommendationof3carrierstokeep-50PointsfornotusinggivenExceldataBUD6800Tech Project #1 Data Analysis with Pivot Tables50 Points PossibleForthisassignmentyouwilldemonstrateyourabilitytouseExcelPivottablestoanalyzedataandproducecharts/graphstoaidyouinpresentingyouranalysisandsupportingyourrecommendations.CaseBackground::HooverMedicalSupplies,Inc,isalargemanufacturingcompanylocatedinColumbus,Ohio.Thecompanyiscurrentlyseekingtogainoperationalefficienciesinitssupplychainbyreducingthenumberoftransportationcarriersthatitisusingfromfivetothree.BrianHoover,theCEOofHooverMedicalSupplieshashiredyoutoanalyzeitsdataandmakeaclearrecommendationabouthowtoreducetransportationcostswhileretainingahighlevelofservicefromitsbestcarriers.HooverhascustomersinMichigan,WestVirginia,Virginia,Pennsylvania,Indiana,KentuckyandOhio.DataAvailable:TheHooverData_2021.xlsfilecontainsalltheshippinginvoicessubmittedbyitscurrentcarriersandpaidbyHoover.Shippingisbilledbythepoundataratethatconsidersfuelcosts,drivercostsandtruckcosts.Thefilealsoincludesdatacollectedbytrackingthedeliveryscheduleoftheshipments-reflectedinthecolumnofDaysOverdue.LatedeliveriesarenottoleratedbyHooverscustomersandneedtobeminimizedwithinitscarrierpool.ProjectFocus:Carrierselectionshouldbebasedontheassumptionsthatallenvironmentalfactorsareequalandthathistoricalcosttrendswillcontinue.ReviewthehistoricaldatafromthepastseveralyearstodetermineyourrecommendationforthetopthreecarriersthatHoovershouldcontinuetouse.Besurethatthethreecarriersrecommendedwillprovideadequatecoverageofallstatescurrentlyserviced.(Dontassumecarrierswillexpandtheirservicestostatesnotcurrentlyserved.)Analyzethelast24monthsofHooverscarriertransactionsfoundinthedatafile:HooverData_2021.xls..ApplywhatyoulearnedabouttheuseofExcelPivotTablesanddoathoroughanalysisofthedatatodeterminewhichcarriersprovidethebestserviceatthebestpricetothestatesthatHooverservices.Considerwhetheryoushouldlookattotalsoraveragesinyouranalysis.SliceandDice(pivot)thedataanumberofdifferentwaystohelpyouinyouranalysis.Lookateachfactorservice,priceandquality.Spendsometimethinkingabouttheproblemandhowbesttoanalyzethedata.Reviewyouranalysisanddeterminethetopthreecarriersthatyourecommendtoberetained.PrepareamemotoMr.BrianHooverinwhichyoudetailyourrecommendationforthetopthreecarrierswithwhichHoovershouldcontinuetodobusiness.Organizeyourmemotobesuccinctbutinformative.Besuretosupportyourrecommendationwiththefactsandresultsofyouranalysisbecausetherearesomebiasesamongstyourco-workersthatmaydistorttheirviewofthecarriers.Tobettermakeyourargument,yourreportmustsupportyourrecommendationbypresentingthedatausingvisualizationtechniques.Chartsandgraphsshouldbewelldesignedandlabeled,andincludelegends,titles,andvalueswhereappropriate.ApplyExcelPivotTablesanddoathoroughanalysisofthedata.ProjectDeliverables:Youmustdemonstrateyourabilitytocreateandusepivottablestocompletethisassignment.SaveeachcreatedPivotTablesinyourExcelworkbookunderaseparateworksheet(tab).CreateChartsonthedataelementsthatyouwillusetojustifyyourrecommendationintheworddocument.WriteaMemoinMS-wordwithyourrecommendationofwhichthreecarriersHoovershouldcontinuetodobusinesswith.Besuretosupportyourrecommendationwithfactsandnumbersfromthedatabecausetherearesomebiasesamongstyourco-workersthatmaydistorttheirviewofthecarriers.Tobettermakeyourargument,yourreportmustincludeatleastthreechartsandthreegraphs(designedinExcelandcopyandpastedintoWord)thatsupportyourrecommendation.Useaformalandprofessionalwritingstyleandtoneinyourreport.UseaMemotemplate(foundinMicrosoftWord).AddressthememotomeuseyournameintheFromsection.Checkyourgrammarandspelling.Usecompletesentencesandbulletliststosuccinctlybutthoroughlystatetheresultsofyouranalysisandyourrecommendation.UploadyourupdatedExcelfile(withallyourPivottablesthatyoucreatedtoperformyouranalysis)andMS-WordreporttotheBlackboardassignmentpage.Justbesuretoanalyzethedatafromallangles.Iwouldliketoremindyouthatthishomeworkassignmentmustbecompletedandsubmittedindividually.Pointbreakdown:Total50point15pointsforExceldocumentdemonstratingthecorrectuseofPivotTablesandathoroughanalysisofthedata(filemustbepostedtoBlackboardtoreceivecredit).Idefinethoroughas5ormorepointsofanalysis.5pointsforProperAnalysisProperanalysisusestherightvariables,intherightform15pointsforyourWordDocumentusingaMemotemplateandaformal,professionaltonewithattentiontowritingandstyle(alsopostedtoBlackboard)10pointsforthegraphics(tablesandcharts)insertedintoyourWordDocumenttoillustrateandsupportyourrecommendation10pointsforclearlyandconciselymakingarecommendationof3carrierstokeep-50PointsfornotusinggivenExceldata