Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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?

image text in transcribed
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Horngrens Cost Accounting A Managerial Emphasis

Authors: Srikant M. Datar, Madhav V. Rajan, Louis Beaubien

8th Canadian Edition

134453735, 9780134824680, 134824687, 9780134733081 , 978-0134453736

More Books

Students also viewed these Accounting questions