Do the preliminary analysis. You can use Excel or Tableau. You do not have to cr

Do the preliminary analysis. You can use Excel or Tableau. You do not have to create the dashboard for this assignment. Complete the report.
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, You should prepare a business report formatted as follows:
I. Title page
II. Executive summary
a. Clear and concise information about the problem the
report is analyzing
b. Main points, conclusions, and recommendations (use
bullets or numbered lists to highlight important points)
III. Introduction
IV. Main body
a. Follow the order of the questions in the assignment
b. A paragraph about the relevance of the findings can be
included in each section
c. Include a discussion of relevant descriptive statistics
V. Data tabulations/visualizations
a. These should support your findings in the main body
b. You may include these within the main body if you
prefer
VI. Recommendations
a. Based on your analysis, what should be HMC’s course
of action? Are there countries, brands, models, options,
and so on that the company should increase
or eliminate?
b. What are the potential implications of those actions?
Consider both financial and nonfinancial implications.
You should also submit a file with your analyses and
dashboards