MJC5100 Module 5 The DV Case Directions Huskie Motors Project

24/7 Homework Help

Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!

MJC5100 Module 5 The DV Case Directions Huskie Motors ProjectMJC5100 Module 5 The DV Case Directions Huskie Motors ProjectORDER NOW FOR CUSTOMIZED AND ORIGINAL ESSAY PAPERS This is a case study, please read the case file, finish the part 1,2and 3. Part I is according to the excel file. 2 attachmentsSlide 1 of 2attachment_1attachment_1attachment_2attachment_2SS MAcc 611Module 5Data Visualization CaseDeloitte FoundationHuskie 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:Brand Models AvailableApechete Chare, Island, Pebble, Rack, Sparro, Stork, Summet, TridoJackson Baller, Clock, Core, Crux, Elevator, Fraction, Mud, Roof, Salsa, WoodSpecial Gazelle, Performance, SprinklesTatra Advantage, Blooper, Jespie, Mortimer, RamblerContribution Margin and Sales Volume from January – September 2015 are reflected below:Contribution Margin:Brand Q1 Q2 Q3 Grand TotalApechete $ 1,441,796.25 $ 784,707.25 $ 717,039.95 $ 2,943,543.45Jackson $ 819,042.25 $ 418,069.85 $ 443,079.90 $ 1,680,192.00Special $ 183,537.70 $ 95,224.50 $ 90,445.90 $ 369,208.10Tatra $ 738,760.01 $ 522,609.37 $ 924,124.21 $ 2,185,493.59Grand Total $ 3,183,136.21 $ 1,820,610.97 $ 2,174,689.96 $ 7,178,437.14Sales Volume:Brand Q1 Q2 Q3 Grand TotalApechete 144 75 72 291Jackson 120 60 60 240Special 36 17 16 69Tatra 123 104 188 415Grand Total 423 256 336 1015HMC 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 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.Part I: Data AnalysisAnswer the following questions using the data provided in the Excel file. You will need to use pivot tables and this is your preliminary analysis. You may submit excel charts or a memo with your preliminary analysis. This is my chance to make sure you are on the right track.Overall Performance Analytics:How is HMC performing globally? (This means which region and country of sale have the highest sales)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 current contribution margin and sales volume per channel?Operations AnalyticsWhat model options are the top and bottom sellers?How many days on the lot are the various models? Part II – Data Visualization Dashboard for Top ManagementAfter completing analysis of the Overall Performance, Financial Analysis, and Operations Analysis, prepare a Business Intelligence (BI) Dashboard to show your results. You can have 1 or 2 Dashboards to tell your story about Husky Motor Company.Exercise III- The Written ReportSubmit a professionally written report formatted as follows:Title PageClear and concise information about the problem you are analyzingMain points, conclusions and recommendations (Use bullets or numbered lists to highlight important points)Recommendations to Husky Motor Company Get a 10 % discount on an order above $ 100 Use the following coupon code : NURSING10 Order NowjQuery(document).ready(function($) { $.post(‘https:// hippoessays.com/wp-admin/admin-ajax.php’, {action: ‘wpt_view_count’, id: ‘61969’});});jQuery(document).ready(function($) { $.post(‘https:// hippoessays.com/wp-admin/admin-ajax.php’, {action: ‘mts_view_count’, id: ‘61969’});});

Hire a competent writer to help you with

MJC5100 Module 5 The DV Case Directions Huskie Motors Project

troublesome homework