Due Date: Saturday 6-April-2019 11:59 PM Singapore Time Note: Singapore Time (20% of Final Grade)…

Due Date: Saturday 6-April-2019 11:59 PM Singapore Time

Note: Singapore Time

(20% of Final Grade)

Case Study

“Red Dot Dance!” is a small dance school located in Orchard Central in Singapore. Vanessa Linardi is the owner Manager and has been running the school for the past two years. Vanessa handles bookings, accounts and organises the teaching timetable and roster for the casual dance instructors she employs. (Pay rates have been determined by both age and qualifications.) The dance school offers a range of dance classes for both children and adults. She also offers private. Classes are booked per semester.

Since purchasing the dance school Vanessa has been operating the same timetable and has continued to employ the same staff. Last semester, in an effort to encourage new and current students to take extra classes she introduced a discount scheme. 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.

Vanessa has set up a spreadsheet. She has asked you to use the data to complete relevant calculations and to use excel ‘tools’ to analyse the data she has given you. She then requires you to write a business report which analyses and discusses profit growth and discusses the various options available to help increase future profitability.

A spreadsheet has been provided – containing the data for ‘Red Dot Dance!’ enrolments changes to the currecfit growth and options regarding changes to the currect timetable.  er overall profits growing? for semester 1 and 2 in 2018 and 2019. (Semester 2 is booked ahead.)

Vanessa believes that it is time to review the effectiveness of her dance studio’s profitability. Is the business growing? Are her overall profits growing? What is the likely future trend? She wants to revise the timetable to further increase profits and has asked you to,

Analyse the       past two year’s data,

Provide an         overview of profitability trends and perform a predictive analysis,

Discuss the        various options regarding possible future changes to the timetable based on your analysis,

Make 2-4 recommendations for future changes which might assist in further         improving profitability. Briefly justify these recommendations. (The         suggestions should make business sense.)

PREPARING THE BUSINESS REPORT

Report Content

The analysis, findings and recommendations which you prepare for Vanessa 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 (ISYS2059), 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 you have      carried out and a discussion regarding the results of this analysis.

A discussion, which is based       on the results of your analysis and outlines possible options for   increasing future profitability.

Identification/discussion    regarding at least one area where further analysis could/should be        conducted.

A short concluding   summary of the        content of the report.

Finally, at least three clear recommendations that Vanessa 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 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.

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, but no        more than four 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. (note: you do not need to refer to this appendix in the         body of your report)

Report Submission

The Business Report must be submitted, in MS Word format, via the link provided in the “Assignments” area on the ISYS2059 Business Computing 1 site on Canvas.

A Guide to inserting a screen shot in ‘Word’ .

Open and/or minimise the program/sheet you wish to create the screen shot from (in this case       your excel document) As your screenshots are designed to show         calculations you should make sure you have highlighted the relevant         cell and the function is clearly visible in the function dialogue      (fx) box.

Open your ‘Word’ document

Select       insert/screenshot/screen clipping

Select the sheet you wish to       create the screenshot from. The screen should fade and a + appear. Use the + as a cropping tool to select the required screenshot.        Note: there is no need to show every cell. (see figure one in which        one of the relevant cells is highlighted (B3) and the function for         column B is clearly visible.

Label the screenshot appropriately

No   Figure 1 – Screen shot of Countif function

If      you need to create a screenshot of a column that is not located near         the fx box you can:

Select the relevant cell.               Double click on the cell to show the formula

Create screen clipping as            per instructions above. Provide an appropriate la el

Figure      2 – Screenshot of Sumif function

To show several formulas in the one screenshot:

Select       Formulas/Formula auditing/show formulas

Take the screenshot as per the directions above. (NOTE: Text needs to be large enough to ready clearly.)

Figure 3 – Screenshot showing functions in several columns