2016 Deloitte Foundation/fsa faculty Consortium Advisory Case/Assignment: Huskie Motor Corporation: Where do we go from here?

Huskie Motor Corporation (HMC) is automobile manufacturing company with production and sales throughout the world. HMC has asked your project 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 (http://marketrealist.com/2015/02/intense-competition-leads-low-profit-margins-automakers/). 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:

To assist you with your analysis HMC has provided you with an Excel spreadsheet that reflects their sales and costs from January 2015 to September 2015. They have also provided you with their plan data and their marketing plan data. The worksheet titled “Information” in the file provides additional background information about the spreadsheet.

Split into groups of 5 people. Meet with your team members and do the following:

• 
  Review the Excel file: Huskie_Motor_Corporation_Student_Version_FSA.
  
• 
  Review the Automotive Industry Background Information provided in the “Auto Industry Analysis” folder.
  
• 
  Your team should discuss the following:
  
  • 
    What is the purpose of this analysis?
    
  • 
    What is the key question, problem, or issue?
    
  • 
    What data will be needed to answer the key question/problem/issue?
    
  • 
    What are the relevant key concepts?
    
  • 
    What assumptions are we making?
    

Your team should answer the following questions using the Tableau file “HMC_Tableau_FSA” and/or the Excel above.

• 
  Overall Performance Analytics:
  
  • 
    How is HMC performing globally?
    
  • 
    How are various HMC brands performing?
    
  • 
    How are the various sales channels performing?
    
  • 
    What are the most & least profitable models?
    
• 
  Financial Analytics:
  
  • 
    What is the current contribution cost per model?
    
  • 
    What is the average change in cost per model?
    
  • 
    What is the current contribution margin and sales volume per channel?
    

• 
  Operations Analytics
  
  • 
    What model options are the top and bottom sellers?
    
  • 
    How many days on the lot are the various models?
    
• 
  Forecast:
  
  • 
    Sales Volume (Q4 2015 – Q2 2016)
    
  • 
    Contribution Margin (Q4 2015 – Q2 2016)
    

• 
  Your team should elect a representative to present your answers to Exercises I & II.
  
• 
  Five teams will be randomly chosen to present their findings.