Question: 1. Overall performance analytics: a. How is HMC performing globally? b. How are various HMC brands performing? c. How are the various sales channels performing?

1. Overall performance analytics: a. How is HMC performing globally? b. How are various HMC brands performing? c. How are the various sales channels performing? d. What are the most and least profitable models? 2. Financial analytics: a. What is the current contribution margin (CM) per model? b. What is the average variable cost per model, and how has that changed over time? c. Which model has the most variability in variable costs? d. What is the current CM per channel? 3. Operations analytics: a. What model options are the top and bottom sellers? b. How many days are the various models on the lot prior to sale? 4. Forecast: a. Sales Volume - Four quarters in advance (Hint: use "Trendline option in Excel or Forecast option in "Tableau) b. Contribution Margin - Four quarters in advance (Hint: use Trendline option in Excel or Forecast option in "Tableau) Once you have prepared the analysis, Kevin would like you to prepare an interactive dashboard for each of the four areas described earlier. The client uses Tableau for data visualization and would like you to create the dashboards using that software. Kevin has also given you guidelines for preparing a draft of the business report (see "Deliverable") that will be delivered to HMC along with the dashboards

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

HUSKIE MOTOR CORPORATION: OPERATIONS HMC is currently selling in 15 countries in three regions: North America, South America, and Europe. Table 1 provides a breakdown of the countries within each...

1. Overall performance analytics: a. How is HMC performing globally? . Include analysis of individual regions and/ or countries. In which is HMC performing best/worst? . In your memo you can explain...

expertise and its focus on data analytics and visualization. Miranda asked Megan Martinez, a senior staff accountant at HMC,and Adam Green, a staff acoountant at HMC, to work with D \& A on the...

Huskie MotorCS061318.pdf HMC CC Clean Data (4).xlsx The final deliverable should be a Word document with embedded tables/charts/pivot tables from Excel used to support your answers to the below...

Overall performance analytics: a . How is HMC performing globally? Identified a correct measure, explained correctly b . How are various HMC brands performing? identified a correct measure, explained...

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 and least profitable models

Maverick Motors Inc.: Where do we go from here? Maverick Motors Inc. (MMI) is automobile manufacturing company with production and sales throughout the world. MMI has asked your project team to...

Imagine being an advisor to Hank Harris. What would you suggest should be Seller Labs' competitive strategy going forward? (Please use the case study below to answer the question in two-three...

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...

Brands in the Salesforce Dilem DS. INC: SPECTRUM BRAN company's individual and maintain customer relationships, and to clude competition from tak ing advantage of any perceived disruptions during...

How are modern tools of banking revolutionizing the relationship between banks and their clientele?

A 6-year bond with a 4% coupon sells for $102.46 with a 3.5384% yield. The conversion factor for the bond is 0.90046. An 8-year bond with 5.5% coupons sells for $113.564 with a conversion factor of...

12. Quantitative Easing Whats the difference between ordinary open-market purchases and quantitative easing?

7. Many consumers believe fine dining restaurants use the highest quality ingredients and only offer healthy menu items, and that fast-food restaurants use low quality ingredients and offer unhealthy...

4. Give an example of how the consistency principle can be used to influence others.

6. Give an example of how the liking principle can be used to influence others.

5. Give an example of how the consensus principle can be used to influence others.