ANALYSING A SPREADSHEET AND PRESENTING A BUSINESS REPORT Case Study

ANALYSING A SPREADSHEET AND PRESENTING A BUSINESS REPORT - Case Study spokespersonFrom 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, matchless 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 collect 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 comparability the pivot table charts against the sales calculations over the five weeks, orange and mandarin orange 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. Unli ke the emails or texts, the mobile apps presented more benefits to the retailers purchasing 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 unaccompanied 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 creation 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 sell below par. That is , the two-for-one policy did not impact the sales upwards as would be expected. Reason