ISYS2056 Business Report On Eclipse Van Case Study - Assignment Solution

Introduction

The study consists of an assessment of the Eclipse Van information in specific, predictive and perceptive terms for 2017 and 2018. The process of this analysis will require to pool the data in a manner which can be extracted and analyzed descriptively, and create figures and graphs for a better understanding, from there on predictive analysis will be taken up to reveal the trends of the provided data. These analyzes are aimed at creating company knowledge using internal information analytics which can help entrepreneurs to identify patterns, links to other variables and company developments through all these, which allow them to make stronger company choices.

The Sales by Car Model in Table 1.1 reflects that the highest monthly sale in November 2018 where 52 units were sold, the lowest sales occurred in the month July 2017. It is also noticeable that the highest sales month are July and August of each year. The model Adventure65 is the highest sold model amongst all selling over 112 units in 2017 and 2018. The most demanded category is Caravan, where the motorhome is the least demanded category. In Table 1.2 we can see that the annual sales in units of 2017 are 259, and 342 units in the year 2018 from which we can analyze the sales of 2019, it can be noted that Safari40R showed significant growth and is expected to rise even more, whereas Adventure65 is expected to rise constantly at the rate of previous years. The annual sales are expected to be at 425 units where in 2018 the units sold were 342. Caravan is the most demanded category which has the Adventure series it accumulates to 48% of the total sales. The most promising product line is the Safari series where Safari 40R and Safari45R are the famous ones, it is also predicted that the Escape42 will only sale only 1 unit in 2019 which only has a markup of $3,585 and a fixed cost of batch per model of $5,000.

Table 1.2 Sales Prediction for 2019

Sales Staff Analysis

In Fig 2.1 we can see that the Gross profit of 2017 earned by the sales personnel, the peak of which is seen in November 2017 where Sales01 made the company a gross profit of $106,120, the lowest grossing month for 2017 was July-2017 where only $13,485 gross profit was made cumulatively by all sales personnel. The highest grossing month was November 2017 where the sales personnel made $243,510 in the month of November 2017 collectively. In Fig 2.2 we can see that Gross profit of 2018 earned by the sales personnel where the highest peaking month the November 2018 where Sales03 has the highest number of sales gross profit $135,676 in the month of November 2018. The lowest grossing month was August 2018 where the sales personnel made $26,642. Sales02 showed exceptional growth from 2017 to 2018 growing its revenue by 68%. The model which rates highly for sales personnel are the adventure65 where all the personnel sold this model in comparison to other models where Sales03 sold the highest number of units for the model.