complete a spend analysis for the freight & transportation (f&t) and packaging materials (pm) categories. (assignment total 30 pts)

Instructions & Answers: Completo a spend analysis for the Freight & Transportation F&T) and Packaging Materials (PM) Categories. (Assignment Total: Prep Data tab is locked so copy & paste data into new worksheet before working with the information Part 1: Please show your work, using formulas, tables, pivots, charts, etc. to answer questions 1-5. (15 pts) When the changespender that the printre 200 de C 2013-2014 2011-2016 2016-2017 F Transportation 3) Train alegery, which lerreted the highest speed in each year that there? AR 2013 2014 2018 2017 HALL FAT. Nan LTE Pagryw many interesi ww medewertery with the stars? Fasteners 2010 2017 4 Whof us revenue de the categories represented Bend 2014 Trapan PS Malerier 2016 2017 24 For the category, show distribution of gender counts for 2015-ieplay in charts.combo, etcand expand the Bonus Credit for a pont there may by spear to the ending wors? Support your www.carta! Part 2: Discussion Questons. (15 pts) - for simplicity, add your answers right into this worksheet We conclusions you can you make out this business and spending thepand try pattern in each of these contri Penyerang pendrier Walther cut would you want to see more thorough analysis wide and eaten why you would want tomaten Instructions & Answers: Completo a spend analysis for the Freight & Transportation F&T) and Packaging Materials (PM) Categories. (Assignment Total: Prep Data tab is locked so copy & paste data into new worksheet before working with the information Part 1: Please show your work, using formulas, tables, pivots, charts, etc. to answer questions 1-5. (15 pts) When the changespender that the printre 200 de C 2013-2014 2011-2016 2016-2017 F Transportation 3) Train alegery, which lerreted the highest speed in each year that there? AR 2013 2014 2018 2017 HALL FAT. Nan LTE Pagryw many interesi ww medewertery with the stars? Fasteners 2010 2017 4 Whof us revenue de the categories represented Bend 2014 Trapan PS Malerier 2016 2017 24 For the category, show distribution of gender counts for 2015-ieplay in charts.combo, etcand expand the Bonus Credit for a pont there may by spear to the ending wors? Support your www.carta! Part 2: Discussion Questons. (15 pts) - for simplicity, add your answers right into this worksheet We conclusions you can you make out this business and spending thepand try pattern in each of these contri Penyerang pendrier Walther cut would you want to see more thorough analysis wide and eaten why you would want tomaten