ANALYSING A SPREADSHEET AND PRESENTING A BUSINESS REPORT
Case Study “Flamingo Dance Studio” is a small dance school located in the southern suburbs of Melbourne. Jane Flynn is the Owner/Manager and has been running the school for the past two years. Jane handles bookings, accounts and organises the teaching timetable and roster for the casual dance instructors she employs. Note that the instructors’ pay rates have been determined by experience, age and qualifications and so they differ for each instructor. The dance school offers a range of dance classes for children and a class for adults (referred to as the “Adult Dance” class). Jane also offers private tuition for students taking a Year 12 Dance subject. Classes are booked per semester. Since purchasing the dance school, Jane has been operating essentially the same timetable from semester 2 2017 through to semester 1 2019 and has continued to employ the same staff. In an effort to encourage new and current students to take extra classes she introduced a discount scheme during semester 2 2018 and semester 1 2019 (see the “Multiple class discount” columns in the spreadsheet). A discount is offered if two or more members of the one family enrol in a class or if a student enrols in two or more classes. Jane believes that it is time to review the effectiveness of her dance studio with regard to profitability. Is the business growing? Are her profits growing? What are the likely future trends? She wants to revise the timetable and possibly take other steps, to further increase profits and has asked you to: • Undertake descriptive analysis of the data she has maintained over the past four semesters. • Provide an overview of profitability trends undertaking predictive analysis. • Discuss the various options regarding possible future changes to the timetable based on your analysis. • Discuss at least one business issue you have identified as a result of your data analysis that you believe may need to be further analysed. E.g. You require further information from Jane before you can take action. Clearly explain your reasoning. • Make recommendations with regard to future changes which might assist in further improving profitability. Briefly justify these recommendations (i.e. prescribe what should be done and why this would be helpful, drawing on your predictive and prescriptive analysis). Jane has set up a spreadsheet. She has asked you to use the data provided in the spreadsheet to complete relevant calculations and to use Excel ‘tools’ to analyse the data provided. She then requires you to write a business report which analyses and discusses both profit growth and the various options available to help increase future profitability. A spreadsheet has been provided containing the data for “Flamingo Dance Studio” enrolments for semesters 2 in 2017, 1 and 2 in 2018 and 1 in 2019, and various related data on costs etc. PREPARING THE BUSINESS REPORT Report Content The analysis, findings and recommendations which you prepare for Jane 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 Information Systems), course number your workshop time and your workshop tutors’ names. A Table of Contents (TOC) automatically generated by Microsoft Word. Default settings for the table of contents should not be altered. A brief introduction which outlines clearly the purpose of the report. The analysis you have undertaken and a discussion regarding the results of this analysis. A discussion, based on the results of your analysis that outlines possible options for increasing future profitability. Discuss at least one business issue you have identified as a result of your data analysis that you believe may need to be further analysed. E.g. You require further information from Jane before you can take action. Clearly explain your reasoning. A short concluding summary of the major findings of the report. Clear recommendations that Jane can adopt. These recommendations must be drawn from the analysis you have carried out and must have been discussed in the body of your report. Report Format The report should be developed using the guidelines covered in the Pearson etext that has been recommended for Business Information Systems 1 – also see Canvas WLA & CLA On Line Communications 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 – i.e. the report should be between 900 and 1100 words.) • 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. Use double or 1.5 spacing. Fully Justify all text in the report. 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, student number and page number (the footer must not appear on the title page). Include relevant charts and tables 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 and tables must be discussed as part of the paper. In an appendix include screen shots of calculations (as discussed below) which you have used to assist in your analysis. (Note: You do not need to refer to this appendix in the body of your report.) A guide to inserting screen shots commences on page 4 of this document.
Assignment status: Solved by our experts