Huskie Motor (HMC) Corporation: Where do we go from here? Huskie Motor Corporation (HMC) is automobile manufacturing company with production and sales throughout the world. Upper management is concerned that HMC is stretched too thin globally and tasked your team to assist in analyzing their performance and make suggestions to improve their revenue stream and optimize their product line. Automobile manufacturing and sales is a complex and highly competitive business. The automotive industry has a broad global sales reach yet only 15 countries produce 88% of the world's vehicles. HMC is a fairly new and a smaller player in the automotive manufacturing market. However, they have some very popular brands and high customer satisfaction. HMC currently offers four brands: Apechete, Jackson, Special, and Tatra. Each brand has several models and are listed below: Brand Models Available Apechete Chare, Island, Pebble, Rack, Sparro, Stork, Summet, Trido Jackson Baller, Clock, Core, Crux, Elevator, Fraction, Mud, Roof, Salsa, Wood Special Gazelle, Performance, Sprinkles Tatra Advantage, Blooper, Jespie, Mortimer, Rambler Contribution Margin and Sales Volume from January - September 2021 are reflected below: Contribution Margin: Brand Q1 Q2 Q3 Grand Total Apechete $ 1,441,796.25 $ 784,707.25 $ 717,039.95 $ 2,943,543.45 Jackson $ 819,042.25 $ 418,069.85 $ 443,079.90 $ 1,680,192.00 Special $ 183,537.70 $ 95,224.50 $ 90,445.90 $ 369,208.10 Tatra $ 522,609.37 $ 924,124.21 $ 2,185,493.59 738,760.01 Grand Total $ 3,183,136.21 $1,820,610.97 $2,174,689.96 $ 7,178,437.14 Sales Volume: Brand Q1 Q2 Q3 Grand Total Apechete 144 75 72 291 Jackson 120 60 60 240 Special 36 17 16 69 Tatra 123 104 188 415 Grand Total 423 256 336 1015 HMC is concerned that they have spread themselves too thin by selling in 30 countries. In addition, they would like to improve the margin on their current models and be sure they are optimizing their product lines. To assist you with your analysis HMC has provided you with an Excel spreadsheet that reflects their sales and costs from January 2021 to September 2021. The worksheet titled "Information" in the file provides additional background information about the spreadsheet. Refer to Module 4 video, readings and links to concerning data visualization basics. Part I: Prep- Defining the Issues Meet with your team, complete the following and: Review the Excel data file Decide on the following: o What is the key question, problem, or issue your team needs to address the case requirements? What data will be needed to answer the key question/problem/issue? Answer the following questions using the data provided in the Excel file. You will need to use pivot tables to determine the information listed below (follow the instructions in the Module 4 video Using Excel to Make Dashboards) Overall Performance Analytics: How is HMC performing in terms of revenue and profit by region and country? . What are the most and least profitable models and brands? How effective is each sales channels? What model options are the top and bottom sellers? Days each model sits on the lot. Why is this metric important? What is the story you want to present in your dashboard and which metrics and charts are most effective to make your Bl dashboard? Submit a brief written report summarizing your analysis of the above. Huskie Motor (HMC) Corporation: Where do we go from here? Huskie Motor Corporation (HMC) is automobile manufacturing company with production and sales throughout the world. Upper management is concerned that HMC is stretched too thin globally and tasked your team to assist in analyzing their performance and make suggestions to improve their revenue stream and optimize their product line. Automobile manufacturing and sales is a complex and highly competitive business. The automotive industry has a broad global sales reach yet only 15 countries produce 88% of the world's vehicles. HMC is a fairly new and a smaller player in the automotive manufacturing market. However, they have some very popular brands and high customer satisfaction. HMC currently offers four brands: Apechete, Jackson, Special, and Tatra. Each brand has several models and are listed below: Brand Models Available Apechete Chare, Island, Pebble, Rack, Sparro, Stork, Summet, Trido Jackson Baller, Clock, Core, Crux, Elevator, Fraction, Mud, Roof, Salsa, Wood Special Gazelle, Performance, Sprinkles Tatra Advantage, Blooper, Jespie, Mortimer, Rambler Contribution Margin and Sales Volume from January - September 2021 are reflected below: Contribution Margin: Brand Q1 Q2 Q3 Grand Total Apechete $ 1,441,796.25 $ 784,707.25 $ 717,039.95 $ 2,943,543.45 Jackson $ 819,042.25 $ 418,069.85 $ 443,079.90 $ 1,680,192.00 Special $ 183,537.70 $ 95,224.50 $ 90,445.90 $ 369,208.10 Tatra $ 522,609.37 $ 924,124.21 $ 2,185,493.59 738,760.01 Grand Total $ 3,183,136.21 $1,820,610.97 $2,174,689.96 $ 7,178,437.14 Sales Volume: Brand Q1 Q2 Q3 Grand Total Apechete 144 75 72 291 Jackson 120 60 60 240 Special 36 17 16 69 Tatra 123 104 188 415 Grand Total 423 256 336 1015 HMC is concerned that they have spread themselves too thin by selling in 30 countries. In addition, they would like to improve the margin on their current models and be sure they are optimizing their product lines. To assist you with your analysis HMC has provided you with an Excel spreadsheet that reflects their sales and costs from January 2021 to September 2021. The worksheet titled "Information" in the file provides additional background information about the spreadsheet. Refer to Module 4 video, readings and links to concerning data visualization basics. Part I: Prep- Defining the Issues Meet with your team, complete the following and: Review the Excel data file Decide on the following: o What is the key question, problem, or issue your team needs to address the case requirements? What data will be needed to answer the key question/problem/issue? Answer the following questions using the data provided in the Excel file. You will need to use pivot tables to determine the information listed below (follow the instructions in the Module 4 video Using Excel to Make Dashboards) Overall Performance Analytics: How is HMC performing in terms of revenue and profit by region and country? . What are the most and least profitable models and brands? How effective is each sales channels? What model options are the top and bottom sellers? Days each model sits on the lot. Why is this metric important? What is the story you want to present in your dashboard and which metrics and charts are most effective to make your Bl dashboard? Submit a brief written report summarizing your analysis of the above