ANALYSING A SPREADSHEET AND PRESENTING A BUSINESS REPORT
ANALYSING A SPREADSHEET AND PRESENTING A BUSINESS REPORT
Due Date: Saturday September 15, 2018 – 11:59 pm
(20% of Final Grade)
‘Pete’s Cheap Car Sales’ is a small second-hand car yard situated in Melbourne, Victoria. Peter and Alan Moffet own the business and lease the car yard. There motto is ‘We sell great cars at a cheap price’
Peter selects and buys cars at auction and organises road worthy certificates, cleaning and repairs. Alan is responsible for managing the accounts, HR and marketing. They employ four sales staff to handle sales and assist with administration. Cars are sold to both private and fleet customers.
Over the past few months Peter has become concerned about stagnating profits. He notices that, whilst some cars sell quickly, others sit in the car yard for long periods of time. He realises that having cars sitting idle in the car yard is costing them money. He can find no pattern to sales trends. Is it the newer cars that sell well or perhaps smaller cars are more marketable? Should they be focusing on fleet buyers? Perhaps customers prefer Japanese cars? He is becoming extremely confused and frustrated. The one thing he knows for certain is that the car yard is small and the vehicle stock is overflowing. He clearly needs to reduce stock levels. His overall goal is to increase profits and he realises that he needs to focus on selling the most profitable vehicles.
Peter has employed you, a business analyst to help solve his dilemma. He has given you a copy of his ‘sales’ details for the past six months and hopes you can use this data to recommend how he can achieve his goals of increased profits and reduced vehicle turnover time.
In addition, Peter is presently conducting a review of sales staff. Julia Robert, Peter’s senior salesperson, has announced her retirement and Peter hopes to promote a junior sales person to a senior position. You have been asked to conduct a financial review of the profitability and earnings of sales staff and make recommendations re possible promotions. As part of this review you should discuss at least two other factors that Peter might need to consider before he makes a final decision in this regard.
He has asked you to complete any relevant calculations and to use excel ‘tools’ to analyse the relevant data. He then requires you to provide a business report which analyses:
1. Options regarding any changes he should make to the range of cars Pete focuses on in the caryard
2. Staff performance with regard to a possible promotion.
Peter is interested in clear, detailed advice supported by relevant evidence from past sales data.
A spreadsheet has been provided for you containing the sales data for January 1 to June 30, 2018.
PREPARING THE BUSINESS REPORT
The analysis, findings and recommendations which you prepare for Pete should be outlined in a professional business report.
This report should include:
? A Title Page – With a relevant graphic, report title, student name/ number, course name (Business Computing 1), course number (ISYS2056), your workshop time and your workshop tutors’ names.
? A Table of Contents (TOC) generated by Microsoft Word. 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 covering the questions concerning Pete and Alan’s stagnating profits and the review of sales staff.
? Discussion regarding the results of your analysis.
? Identification and a discussion regarding other factors that may need to be considered before a final decision can be made regarding the staff promotion.
? A short concluding summary of the content of the report.
? Finally, at least three clear recommendations that Peter and Alan 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.
The report should be developed using the guidelines covered in the Pearson etext – Chapter 8 Online Business Communication Workshop Consolidation Learning Activities Online Business Communication – CLA.pdf
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 appropriate headings and subheadings throughout the body of the report.
? Align text using full justification.
? Use double or 1.5 spacing
? 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 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.
? In an appendix include screen shots of calculations which you have used to assist in your analysis.
The Business Report must be submitted, in MS Word format, by Saturday September 15, 11:59 pm, via the Turnitin link provided in the “Assignments” area on the ISYS2056 Business Computing 1 site on Canvas. A Student Guide to submission using Turnitin is available at:
Looking for answers ?
Chat with us at get the answers
Welcome toFoundations of InformationTechnology (Business) BBS102 / BHM102 / BAC 102Week 4:Individual Assignment DetailsMr Peter Steven Matheis© Melbourne Polytechnic 2018Any third party materials…Its a business computing subject. Have you got professional tutors who specialise in it as I could not find the subject above. Please look at attached, the excel filed and case study instruction. ANALYSING…FNS50315 ASSESSMENTPart 3 – Learning Activities and AssignmentsforFNS50315 Diploma of Finance and Mortgage Broking ManagementSuccessful completion of the online Learning Activity questions and the 5 Assignments…ASSESSMENT BRIEFCOURSE: Bachelor of Business /Bachelor of AccountingUnit: Management PrinciplesUnit Code: MGTP102Type of Assessment: Assessment 3 – Individual Essay WritingLength/Duration: 2000 wordsCourse…Assessment Task 2: International marketing plan – PowerPoint presentationGoal: In this assessment task, you are given the opportunity to hone your presentation skills by presenting to a supportive, yet…2. The article states that “The Australian Taxpayers’ Alliance said the Turnbull governments online shopping tax punishes Aussie consumers and denies shoppers the same choice available to billions of shoppers…200909Enterprise LawSpring Semester 2018 Mid-session ExamValue: 20 marksAssessment tasks exist to help students learn and apply their knowledge. Grades exist to show how fully this goal is attained.This…Show All