ANALYSING A SPREADSHEET AND PRESENTING A BUSINESS REPORT Case Study

ANALYSING A SPREADSHEET AND PRESENTING A BUSINESS REPORT - Case Study Example From the reference data provided by the business, there are 4 types of fruit juices that are available for sale. Each type of juice has two variances in size, one in 375ml and another in 750ml. According to the sales calculations presented in the spreadsheet charts, the fruit juices differ in the number of sales they attract. The variance could be mainly due to, popularity of a type of fruit juice among buyers or the price per carton for each. However, various factors may apply depending on the market of operation for the business. By comparing the pivot table charts against the sales calculations over the five weeks, orange and mandarin are seen to have higher sales. As the weeks progress, sales for the two types of fruit juices are seen to project further than the other two. This shows that mobile app based marketing was more acceptable as compared to emails and or texts. Unlike the emails or texts, the mobile apps presented more benefits to the retailers buying the fruit juices. That is, a retailer would be able to plan a reminder, place an order and track customer orders right from their smartphones. Emails and texts, on the other hand, would only serve the purpose of acting as reminders. If not spread out proportionally, the emails and text messages would easily become nagging and stubborn to the retail buyers. From the charts, the buyers would prefer being reminded through a smartphone mobile app. In the fourth week marketing strategy, a two-for-one strategy was introduced on mandarin fruit juice. From the pivot table, the sales for the mandarin fruit juice are seen to consistently increase from the second week: Little change is seen on the sales at the fourth or fifth week. A further look at the sales for mandarin juice reveals that, though the product made more sales that apple and grapefruit juice, it was selling below par. That is, the two-for-one policy did not impact the sales upwards as would be expected. Reason