Case Study Analysis - HMC Sanjula Rasanjana Makoralage - 102839471 Chamith Lasitha Darmakeerthi Don Withanage - 102886804 Muhammad Affrizal Virdianto - 102874809 Rohit Singh - 102130381
Executive Summary HMC is a new and small automobile business trying to implement a data-driven approach to get a competitive advantage over the already prominent players in the automobile marketti This report analyzes HMC's global performance, analysis of financial data, analysis of operational data, and forecast analysisti Twelve questions have been addressed in the report that forms the four major part of the analysis as described aboveti The analysis of global performance addresses the regions and countries, the brands, the sales channels, and the models performing the bestti The Financial analysis consists of assessing the contribution margin, the average variable cost, and the variability in the variable cost per modelti It also includes the evaluation of the contribution margin for each channelti The third analysis has been done on the operational data and answers questions related to the options that have been the most and least popular and the number of days models have spent on the lotti The last analysis has been performed to forecast the sales volume and the contribution margin for the upcoming four quartersti Some of the key findings that have been discovered during the analysis are: . The USA has been the best-performing country in terms of gross sales, sales revenue, and the sales volume . Sales volume in the European and the South American market have been significantly low, with the Countries in Europe having a total volume of just 492 and the South American countries at just 579ti This is far less when compared to the North American market at 1,610ti . The brand Apechete has outperformed Tatra, despite it having a lower volume of salesti . Leasing and cash have been the most popular method of purchaseti · Advantage is the most profitable model, whereas Mortimer is the leastti . For the current contribution margin, advantage is on the top with ff5,935,938 and Mortimer on the bottom with just ff575,660ti . There has been a slight increment in the Average variable cost from the year 2015 to the year 2016ti
. Mortimer has the least variability in the variable costti . The retail sector has been the most significant contributor among the sales channel, whereas the government sector has the lowest contribution marginti . Premium radio has been the most popular options opted by customers . The model Island has spent the most days on the lot before the sale at an average day of 138ti . The first quarter of 2017 will reach an all-time high for the sales volume and contribution margin with an estimated 440 units sold and a contribution margin of ff6,022,586ti