Husky Industrial Products (HIP) is a manufacturer of industrial components supplied to original equipment manufacturers in various buyer (e.g., Government) and geographic segments. It's been an exciting day at HIP. Financial reports for your most recent fiscal year are complete and the results appear to be extraordinary. You are VP of Analytics and your CEO has just informed you that the Board of Directors has scheduled a teleconference over the next week to discuss the year's results. Your job is to review the recent performance data (in the attached file) and to use Excel PivotTables to evaluate those cesults. Your CEO has told you that while the Board is very pleased with the results, they want to identify areas where the company is performing exceptionally well and where it appears to be underperforming. Your CEO also shared that the Board wants this mix of "the good and the bad" because it is considering a sale of the company and it wants to be ready if and when a prospective buyer raises detailed questions about the company's performance. Specifically, you are asked to: a. Create at least one PivotTable from the dataset that provides a more focused assessment of a portion of the company's performance. b. Tell a brief story to accompany the data you generate. Husky Industrial Products (HIP) is a manufacturer of industrial components supplied to original equipment manufacturers in various buyer (e.g., Government) and geographic segments. It's been an exciting day at HIP. Financial reports for your most recent fiscal year are complete and the results appear to be extraordinary. You are VP of Analytics and your CEO has just informed you that the Board of Directors has scheduled a teleconference over the next week to discuss the year's results. Your job is to review the recent performance data (in the attached file) and to use Excel PivotTables to evaluate those cesults. Your CEO has told you that while the Board is very pleased with the results, they want to identify areas where the company is performing exceptionally well and where it appears to be underperforming. Your CEO also shared that the Board wants this mix of "the good and the bad" because it is considering a sale of the company and it wants to be ready if and when a prospective buyer raises detailed questions about the company's performance. Specifically, you are asked to: a. Create at least one PivotTable from the dataset that provides a more focused assessment of a portion of the company's performance. b. Tell a brief story to accompany the data you generate
