ISYS2056 Business Information Systems Assignment-RMIT University Australia.

Report Requirements:
You are expected to undertake descriptive, predictive and prescriptive analysis of the data that Jose has provided and use Excel to analyse the data. The results of the analysis are then required to be presented in a professionally organized report that analyses and discusses both profitability so far and the various options available to help increase future profitability.
ISYS2056 Business Information Systems Assignment-RMIT University Australia.

Some specific expectations are as follows:

• Analyse the past two financial year’s sales figures – has the business been profitable?
  Identify the key variables/features (eg products, costs, customer revenues, time, etc.) which have lead to this outcome.
• Predict the likely profits for the final quarter of the financial year of 2020 (April June) and for the following financial year July 2020 – June 2021 (predictive analysis)
• Discuss (briefly) options for improving profitability based on your analysis in the first bullet.
• Identify at least one business issue you have identified from your analysis that the business should further explore. Clearly explain your reasoning using data to support your discussion
• Advise them on their expansion plans – Is it feasible to repay the $350000 costs within 5 years from the profits of the band room expansion given current interest rates? What should they charge? Justify your answer with calculations.
• Make two specific recommendations with regard to improving profitability which are based on your previous analysis. Briefly justify these recommendations (i.e. prescribe what should be done and why this would be helpful, drawing on your previous predictive and descriptive analysis). (These are in addition to the expansion plans)

Preparing the Business Report
Report structure and specifications
The analysis, findings and recommendations which you prepare for Jose and Ellie should be outlined in a professional business report. This report should include

ISYS2056 Business Information Systems Assignment-RMIT University Australia.

• A title page – with a relevant graphic, report title, student name/number, course name(Business Information Systems), course number (ISYS2056), 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.
• A discussion regarding the results of your analysis. Relevant descriptive, predictive and prescriptive analysis has been included.
• Relevant charts which are labelled correctly and assist the reader in understanding the results of your analysis.
• A short concluding summary of the major findings of the report. (supported by relevant data: eg, use final figures you have calculated. etc)
• Clear recommendations that the business owner can adopt. These recommendations must be drawn from the analysis you have carried out in the body of the report.
• You should incorporate good report writing practices – refer to “Writing a Business Report” on the assignment page.

ISYS2056 Business Information Systems Assignment-RMIT University Australia.

Report format:
The report should be developed using the guidelines covered in Canvas and workshops. Specifically, you should:

• Ensure your report is concise – No more than 1200 words. This word count includes title page and TOC. It does not include appendices
• 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 in the body of your report (appropriately labelled). The charts and tables (screenshots of your spreadsheet are not appropriate) 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.
• Do not include references or citations in this report