MIS171 Business Analytics

1. Summary of the total sales

The total sales ranges from a minimum of $ 81,450 per day to a maximum of $ 294,840. The expected value of sales per day is $ 134,660, this value does vary with standard deviation of $ 25340. From the descriptive statistics the total sales is skewed to the right indicating that most of the sales per day are over the expected sales.

Analysis of the sales data per month indicate that most of the sales are done in January with this value fluctuating from month to month.

2. Comparison between stores

The value of the total sales does vary from store to store. The online store is the leading seller of the beautiful products catering for around 29% of the total sales throughout the year. Store 1 follows with 27% of the total sales. On the other hand, store 4 is experiencing the worst sales only catering for 10% of the total sales. This poor performance in sales is replicated in store 2 which also just contribute 14% of the total sales.

The pie chart below gives a visual illustration.

Overall, the majority of the sales are made in January with online sales experiencing total sales per year way above the other stores. From February onwards, the sales of the online store are nearly uniform with that of store 1. The store 4 maintains a poor sales performance from January to December.

3. Comparison of total sales per day

Analysis of the total sales values indicate that there is a significance different between the sales values dictated by the day of the week. As presented in the pie chart all the weekdays experience lower sales value of 13% each while Saturday and Sunday do experience significantly higher sales with 17% and 18% respectively. This means that in general the stores are making most of the sales during the weekends as opposed to the weekdays.

Looking at the bar graph, its evident that the online store is making significantly higher sales on the weekends. During the weekdays the sales in the store 1 and online store tends to be uniform with the other stores indicating lower sales.

Store 1

Most of the sales in store 1 are made during the month of June. The sales value is at its lowest during the month of February.  The four months from May to August represents a high season for the sales in store 1 with April joining January in experiencing very low sales.

Store 2

This store experiences the lowest sales during the month of June, however the sales are highest in March. From April the sales begin to drop and hit the lowest level in June after which is rises gradually and kind of levels up from July to December.

Store3

There is a minimal fluctuation in sales over the months in store 3 though the highest sales occur in July while the value is lowest in February. The sales trend line rises from February to hit a maximum pint in July, afterwards it somehow levels of up to December.

Store 4

Just like store 3, this store experienced almost a level sales trend. It though makes most of the sales in October while February remains the month with the lowest sales.

Online store

The online store experiences booming sales in January. This value then drops afterwards to reach a minimum in the month of May. From May to December the sales kind of levels up with very little variation being shown among the months.

5. Relationship between visitors and sales

From the data availed only 0.23% of the total sales made in a day is as a result of the visitors to the stores in that particular day. Even with no visitor to the stores its expected that the total sales will be $ 127,665. When this is compared to the expected total sales per day which is $ 134660, we realise that with no visitors the firm will still achieve 95% of their expected sales. Even though the number of visitors does affect the total sales, the effect is minimal.normal distribution is described by the mean and standard deviation If we let the daily sales be a random variable represented by X Store 1     

1. 007578413
2. The sales target for store 1 should be $36,687
3. 0.00579192

1. 547986316
2. The sales target for store 2 should be $ 1949
3.  

0.372830056

1. 277064626
2. The sales target for store 3 should be $ 26459
3.  

 0.00000347029

1. 967816145
2. The sales target for store 4 should be $ 13194
3.  

0.7496317

1. 075416206

1. The sales target for store 5 should be $38822.