We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.

ANALYSING A SPREADSHEET AND PRESENTING A BUSINESS REPORT - Case Study Example

Comments (0) Cite this document
Summary
The main aim is to compare the marketing strategies and determining which is most preferable to the marketing strategist. The business under study is involved…
Download full paper
GRAB THE BEST PAPER
ANALYSING A SPREADSHEET AND PRESENTING A BUSINESS REPORT
Read TextPreview

Extract of sample
ANALYSING A SPREADSHEET AND PRESENTING A BUSINESS REPORT

Download file to see previous pages... 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 ...Download file to see next pagesRead More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“ANALYSING A SPREADSHEET AND PRESENTING A BUSINESS REPORT Case Study”, n.d.)
Retrieved from https://studentshare.org/e-commerce/1691371-analysing-a-spreadsheet-and-presenting-a-business-report
(ANALYSING A SPREADSHEET AND PRESENTING A BUSINESS REPORT Case Study)
https://studentshare.org/e-commerce/1691371-analysing-a-spreadsheet-and-presenting-a-business-report.
“ANALYSING A SPREADSHEET AND PRESENTING A BUSINESS REPORT Case Study”, n.d. https://studentshare.org/e-commerce/1691371-analysing-a-spreadsheet-and-presenting-a-business-report.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document
CHECK THESE SAMPLES - THEY ALSO FIT YOUR TOPIC
Report on International Business Machines Corp (IBM)
IBM-Indiana did manage to achieve cost savings of US$ 3.2 million in the year that it was implemented and $5 million a year each year afterward (Martin, 2004). However, while IBM-Indiana succeeded in its cost saving objective two issues arose. These issues are manifested as the key problems that IBMers at Indiana experienced during the implementation phase of the telecommuting project.
6 Pages(1500 words)Case Study
Business Report: A Company Analysis on General Motors
Each of the approaches has shown significant weaknesses on the side of the aforementioned company, especially when it comes to its financial standing. As the company loses much money, it may not be able to train the semiskilled and unskilled people of the developing nation.
5 Pages(1250 words)Case Study
Business Report: Media planning
Village Surf had been established in 1969 and is well maintained at present “in the classic 1960’s tradition” (Village Surf Shoppe, 143). The objective of this paper is to make a SWOT Analysis of this business organization and offer media strategies to help the firm move to a higher level of business.
7 Pages(1750 words)Case Study
Video Business Case Report on acQuire Technology Solutions - Case 2
The financial crisis affected not only the financial institutions but also a majority of other private and public organizations operating both internationally and domestically. The current economic and financial position of a corporate organization has been studied on this paper to prepare the decision criteria for the company.
8 Pages(2000 words)Case Study
Business marketing report
The strategic options for the new product launch are many, and include choice of target market, pricing, sourcing options, manufacturing options, advertising options, viability of target market and alternatives, on whether an endorser is necessary for the new product and why, on the inclusion of accessories or not in the offerings of MMG, the state of the competition and how to strategize based on competition data, what the right promotional plan is and how to justify the increase in promotional budget, and how to spend the budget, and the like.
9 Pages(2250 words)Case Study
Video Business Case Report
The primary is the falling profitability, low liquidity ratio, high debt ratio, and lower market valuation. The company needs to look at solutions to improve its falling profitability. First it should look at improving the cash position of the business. To decrease the debt-equity ratio is to improve the profitability of the company.
6 Pages(1500 words)Case Study
Oral Business Report
It has 6 factories and 26 trading stores in Victoria. Essential farming requisites like fertiliser and pasture stock, animal health care products, and machine parts are being provided to the farmers through trading stores. (Devondale, not dated) Not only catering the Australian consumer markets, Devondale is also the market leader in hospitality industry.
2 Pages(500 words)Case Study
Business Report for Radisson Hotels and Resorts
It operates in 61 countries with 435 operations (Wikipedia). In fact, most of Radisson Hotels and Resorts are located in the United States (since 359 operations are placed in the United States) (Wikipedia). Outside the United States, the company has been franchised by Rezidor Hotel Group (Forbes).
10 Pages(2500 words)Case Study
Business Report_ Informative report
include the key findings that the sampling denoted as well as some key suggestions for how the situation may seek to be rectified given the constraints of both money and time. The fact of the matter is that a number of issues were uncovered as a result of the study which has
4 Pages(1000 words)Case Study
Recommendation for a spreadsheet to be used by the project managers
There are numerous spreadsheet tools that can be used by the company to attain its objectives such as Excel, OxygenOffice, Zoho, Oracle Office,
1 Pages(250 words)Case Study
Let us find you another Case Study on topic ANALYSING A SPREADSHEET AND PRESENTING A BUSINESS REPORT for FREE!
Contact us:
+16312120006
Contact Us Now
FREE Mobile Apps:
  • About StudentShare
  • Testimonials
  • FAQ
  • Blog
  • Free Essays
  • New Essays
  • Essays
  • The Newest Essay Topics
  • Index samples by all dates
Join us:
Contact Us