ANALYSING A SPREADSHEET AND PRESENTING A BUSINESS REPORT Case Study

ANALYSING A SPREADSHEET AND PRESENTING A BUSINESS REPORT - Case Study ExampleFrom the reference info provided by the business, there are 4 personas of produce succuss that are available for sale. Each type of succus 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 merchandise 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 pull ahead than the other two. This shows that mobile app based selling was more acceptable as compared to emails and or texts. Unlike the ema ils 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 conclude of acting as reminders. If not spread out proportionally, the emails and text messages would easily become nagging and mulish 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 indemnit y did not impact the sales upwards as would be expected. Reason