ISYS 2059
Lim Jun Xian Clarence s9104475G Presents: MONTEGO BAY APARTMENTS
Workshop Lecturer: Dr Lawrence Sim
Workshop Timing: 12-3pm
(Note: Windows 7)
*
1 Executive Summary 3 2 Body 3 2.1 Why create the spreadsheet? 3 2.2 What the spreadsheet says. 4 2.3 The What If Analysis 6 3 Appendices 8 4 Conclusion/Recommendations 9 *
Executive Summary
The function of this business report is to analyse the data given and give suggested approaches to further improve the business. It includes the analysis of the given data and the recommendations that will aid with the business success. Information from the spreadsheet was analysed and solutions to problems were given. Key findings such as the revenue and profits were reviewed. Mistakes were also made on the spreadsheets given that have already been remedied. In conclusion, this business report analyses all the data given and there was an attempt to solve the problems identified.
Body
Why create the spreadsheet?
The purpose of creating the spreadsheet is to allow users to analyse raw data more efficiently. It allows the performance of analytical decisions, understand problems, make decisions and implement solutions. The spreadsheet can be used to analyse all the information and construct a profit analysis table to analyse how healthy the business is. It also allows the user to view the information in a more organized, formatted and structured way. The spreadsheet allows us to give more informed and accurate information, and from there we can better guide the owners of “Montego Bay Apartments”.
The creation of the spreadsheet allowed the owner, Miranda Ho, to process data easily compared to her previous system of manually recording bookings based on when they were received. The recording of details manually compared to a spreadsheet is far less efficient as