Reference no: EM133282374
Assignment
It is often said that the market for agricultural goods is indicative of a perfectly competitive market. Hence, what are the implications of a perfectly competitive market for a firm with pretensions to compete in such a market?
Assignment Guide
To enable your preparation and understanding of this assignment you will need to study lecture 6 of the module and chapters 8 and 9 of Begg, Vernasca, Fischer, and Dornbusch, and Jones chapter 4 of Sloman and Jones. To complete the assignment, you will need to explain and discuss the concept of perfect competition and its defining characteristics. This will require a clear explanation of the essential requirements that must be satisfied if a market is to be perfectly competitive and to demonstrate how the perfectly competitive firm determines its best level of output in both the short-run and long-run, in addition to other related points.
After studying the HMC case, you are required to write a report containing critical analysis of the key issues, challenges, and opportunities related to the organisation's endeavour to capitalise on Data Analytics. HMC has provided us with this following dataset: HMC 2019-2020 Dataset.xls Download HMC 2019-2020 Datasetxls
The following items are expected to be part of the report (this is an extract from the HMC Case):
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. Operational 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?
C. What is the impact of our Marketing to our sales and/or financial performance?
4.Forecast:
A. Sales Volume -Four quarters in advance (Hint: use Forecast option in Tableau)
B. Contribution Margin -Four quarters in advance (Hint: use Forecast option in Tableau)
C. If there is an increase of 0.7% (average) on existing tariffs imposed by government of the countries we are operating in starting in 2022, what would be our projected after-tax for the year end of 2022 and 2023 (assuming we are looking at calendar-year)?
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. You have been given some guidelines for preparing the business report