ISYS2056_ANALYSING A SPREADSHEET AND PRESENTING A BUSINESS_Flamingo Dance Studio Case Study

ISYS2056_BUSINESS INFORMATON SYSTEMS 1 ISYS 2056 Business Report Semester 1, 2019 Page 1 ISYS2056_ANALYSING A SPREADSHEET AND PRESENTING A BUSINESS REPORT (20% of Final Grade) 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