{br} STUCK with your assignment? {br} When is it due? {br} Get FREE assistance. Page Title: {title}{br} Page URL: {url}
UK: +44 748 007-0908, USA: +1 917 810-5386 [email protected]

ANALYSING A SPREADSHEET AND PRESENTING A BUSINESS REPORT
Due Date: Sunday September 20, 11:59 pm – 2015
(15% of Final Grade)
Case Study
Colin Hammer, the owner and manager of Hammer Wines, has decided to trial the sale of a new range of fresh fruit juices in May, June and July 2015.  Margaret Brand, the Director of Marketing at Hammer Wines, has obtained agreement to conduct the trial from three 7-Eleven and three Woolworths stores in each state of Australia.  The juices to be sold at Woolworths’ outlets are GOJI WHIP, TRIPLE BERRY MIX, ACAI MIX and BLUBANA.  The 7-Eleven retail outlets will trial the sale of PARADISE, SUMMER SET, TROPICAL BANANA, HAVANA and PALM juices.  All of the juices will only be available in small cartons of 250ml.
A Mobile App has been developed that will enable retail outlets to dispatch fruit juice orders from their smartphones, and Hammer Wines have assured all outlets that use this app that delivery will occur within 24 hours. The Mobile App logs orders and optimises delivery routes using all available jobs/deliveries and a mapping feature. A simple drag-and-drop feature will enable all customer orders to be tracked by both Hammer Wines and the retail outlets that are participating in the trial.
Margaret believes that Woolworths has huge marketing potential for their new juices.   They have, therefore, negotiated with Woolworths and agreed on a wholesale price of $1.00 per 250 ml carton.  (This price includes regular promotions in the Woolworths’ catalogue.)  7-Eleven has agreed to purchase the juices from Hammer Wines for $1.20 per 250 ml carton. Commercial refrigerators and additional (refrigerated) delivery trucks have been leased by Colin, in each state, for the three month trial period.
A spreadsheet has been provided for you that contains the sales data by flavour and by state for each of the new juices sold at Woolworths and 7 Eleven, during the 3 month trial period. Note that the data provided lists the number of 250ml cartons sold.  Colin wants you to analyse the results of the trial, in particular the popularity of each juice (so that he can make decisions about which juice types he should continue to distribute, the viability of setting up permanent distribution centres in each state and whether he should focus his efforts on distributing through one or both of the current retailers).
PREPARING THE BUSINESS REPORT
Report Content
The analysis, findings and recommendations which you prepare for Colin should be outlined in a professional business report.
This report should include:
?    A Title Page – With an appropriate graphic, report title and student name / number.   You should also provide your contact phone number, the course name (Business Computing 1), course number (ISYS2056), your workshop time and your workshop tutors’ names.
?    A Table of Contents (TOC) generated by the word processor.  MSWord default settings for the table of contents should not be altered.
?    A brief Introduction that outlines clearly the purpose of the report.
?    A brief presentation of the analysis you have carried out of the data contained in the spreadsheet.
?    A section that identifies and discusses the results of your analysis.
?    A section that identifies and discusses other factors that may be affecting the results.
?    A short concluding summary of the content of the report.
?    Finally, at least two clear recommendations that Colin can adopt. These recommendations must be drawn from the analysis that you have carried out, and must have been discussed in the body of your report.
Report Format
The report should be developed using MSWord, and presented following the guidelines covered at the ‘Business Communications’ Workshop (see in particular the material in the Pearson Media Library – Communicating Business Problems and Business Solutions>>Consolidation>>Online Business Communication – Report Writing)
Specifically you should:
•    Ensure your report is concise:  1000 words.  This word count includes title page and TOC.   It does not include appendices.  (Note: a 10% variance is acceptable.)
•    Present the report in a professional, business format with no spelling or grammatical errors.
•    Use headings and subheadings throughout the body of the report.
?    Use Times New Roman 12 pitch point font, with 1.5 line spacing.
?    Align text using full justification.
?    Include a page header with a suitably formatted title (the header must not appear on the title page).
?    Include a page footer with your name, id number and page number (the footer must not appear on the title page).
?    Include page numbering that should start on the page where the “Introduction” section of the Business Report commences.
?    Include at least two charts – which you have created – either in the body of your report (appropriately labelled) or as an appendix at the end of the report. The material in the charts must be discussed as part of the paper.
Some Issues to be consider
Some issues to consider when analysing the data:
•    How did the number of juice cartons sold, and the revenue for Hammer Wines, vary/trend during the trial – depending on: (1) the type of juice; (2) the retail outlet; and (3) the state?
•    What other factors may be affecting the results of this 3 month trial?
•    Are there other factors that need to be considered before a final decision is made?

Sample Answer

Compelling correspondence is essential to the achievement all things considered but since of the changing idea of the present working environments, successful correspondence turns out to be more troublesome, and because of the numerous impediments that will permit beneficiaries to acknowledge the plan of the sender It is restricted. Misguided judgments.In spite of the fact that correspondence inside the association is rarely completely open, numerous straightforward arrangements can be executed to advance the effect of these hindrances.

Concerning specific contextual analysis, two significant correspondence standards, correspondence channel determination and commotion are self-evident. This course presents the standards of correspondence, the act of general correspondence, and different speculations to all the more likely comprehend the correspondence exchanges experienced in regular daily existence. The standards and practices that you learn in this course give the premise to additionally learning and correspondence.

This course starts with an outline of the correspondence cycle, the method of reasoning and hypothesis. In resulting modules of the course, we will look at explicit use of relational connections in close to home and expert life. These incorporate relational correspondence, bunch correspondence and dynamic, authoritative correspondence in the work environment or relational correspondence. Rule of Business Communication In request to make correspondence viable, it is important to follow a few rules and standards. Seven of them are fundamental and applicable, and these are clear, finished, brief, obliging, right, thought to be, concrete. These standards are frequently called 7C for business correspondence. The subtleties of these correspondence standards are examined underneath: Politeness Principle: When conveying, we should build up a cordial relationship with every individual who sends data to us.

To be inviting and polite is indistinguishable, and politeness requires an insightful and amicable activity against others. Axioms are notable that gracious “pay of graciousness is the main thing to win everything”. Correspondence staff ought to consistently remember this. The accompanying standards may assist with improving courtesy:Preliminary considering correspondence with family All glad families have the mystery of progress. This achievement originates from a strong establishment of closeness and closeness. Indeed, through private correspondence these cozy family connections become all the more intently. Correspondence is the foundation of different affiliations, building solid partners of obedient devotion, improving family way of life, and assisting with accomplishing satisfaction (Gosche, p. 1). In any case, so as to keep up an amicable relationship, a few families experienced tumultuous encounters. Correspondence in the family is an intricate and alluring marvel. Correspondence between families isn’t restricted to single messages between families or verbal correspondence.

It is a unique cycle that oversees force, closeness and limits, cohesiveness and flexibility of route frameworks, and makes pictures, topics, stories, ceremonies, rules, jobs, making implications, making a feeling of family life An intelligent cycle that makes a model. This model has passed ages. Notwithstanding the view as a family and family automatic framework, one of the greatest exploration establishments in between family correspondence centers around a family correspondence model. Family correspondence model (FCP) hypothesis clarifies why families impart in their own specific manner dependent on one another ‘s psychological direction. Early FCP research established in media research is keen on how families handle broad communications data. Family correspondence was perceived as an exceptional scholastic exploration field by the National Communications Association in 1989. Family correspondence researchers were at first impacted by family research, social brain science, and relational hypothesis, before long built up the hypothesis and began research in a family framework zeroed in on a significant job. Until 2001, the primary issue of the Family Communication Research Journal, Family Communication Magazine, was given. Family correspondence is more than the field of correspondence analysts in the family. Examination on family correspondence is normally done by individuals in brain science, humanism, and family research, to give some examples models. However, as the popular family correspondence researcher Leslie Baxter stated, it is the focal point of this intelligent semantic creation measure making the grant of family correspondence special. In the field of in-home correspondence, correspondence is normally not founded on autonomous messages from one sender to one beneficiary, yet dependent on the dynamic interdependency of data shared among families It is conceptualized. The focal point of this methodology is on the shared trait of semantic development inside family frameworks. As such, producing doesn’t happen in vacuum, however it happens in a wide scope of ages and social exchange.

Standards are rules end up being followed when performing work to agree to a given objective. Hierarchical achievement relies significantly upon compelling correspondence. So as to successfully impart, it is important to follow a few standards and rules. Coming up next are rules to guarantee powerful correspondence: clearness: lucidity of data is a significant guideline of correspondence. For beneficiaries to know the message plainly, the messages ought to be sorted out in a basic language. To guarantee that beneficiaries can without much of a stretch comprehend the importance of the message, the sender needs to impart unmistakably and unhesitatingly so the beneficiary can plainly and unquestionably comprehend the data.>

Our customer support team is here to answer your questions. Ask us anything!