Posted: March 16th, 2022

ANALYSING A SPREADSHEET AND PRESENTING A BUSINESS REPORT

ASSESSMENT TWO
TERM 1, 2022

ANALYSING A SPREADSHEET AND PRESENTING A BUSINESS REPORT
Due Date/Time: 11:59 pm, Friday Week 8, Term 1, 2022
30% of Final Grade

Case Study

“Taps Galore” is a specialist online store, situated in Singapore and was recently established by owners Jamie and Xin Rong. It sells a limited range of tapware at discounted prices.
Jamie and Xin Rong currently stock a range of taps from eight manufacturers. They advertise on social media and supplies four different ranges – value, standard, supreme and superior. They have calculated different discounts for each manufacturer based on the tap range. They believe that customers buying ‘value’ items will be more focused on ‘discounts’ than customers who purchase more expensive tapware. Jamie and Xin Rong buy the tapware at cost price and sell at recommended retail price less the advertised discount. Jamie and Xin Rong charge a flat rate of $9.99 for delivery but have recently noticed that several of their competitors have begun to offer deals which include free delivery.
Jamie and Xin Rong conducted extensive market research before setting up the business. Since their first sale in January, 2020 they have recorded the details of all sales in an excel spreadsheet. They have asked you to use the data provided in the spreadsheet to complete relevant calculations and to use Excel ‘tools’ to analyse the data provided. They then require you to write a business report which analyses and discusses both the past profitability of the business and the various options available to help increase future profitability.
Jamie and Xin Rong are interested in both the popularity and profitability of different manufacturers and ranges. They hope you can provide some insight regarding, the type of tapware they should focus their efforts on. They also want to identify their best customers so that they can market to them appropriately. In addition, they want to have some ideas of potential growth in the coming months and the likely effect on the business if they offered free delivery for all purchases over $100.00.
A spreadsheet has been provided containing the data for “Taps Galore” sales for 2020 and 2021.

Requirements and Specifications
You are expected to undertake descriptive, predictive, and prescriptive analysis of the data that Jamie and Xin Rong have maintained over the past two years. The results of the analysis are then required to be presented in a professionally organized report with respect to the requirements of the owners above and some specific expectations as follows:
• Provide an overview of gross profit trends, undertaking both descriptive and predictive analysis.
• Ace my homework – Write my paper – Online assignment help tutors – Discuss the results of your descriptive analysis and the options for future sales growth based on the requirements of Jamie and Xin Rong.
• Identify and discuss the potential effects to the business if ‘Taps Galore’ offered free delivery for all purchases over $100.00. Do you believe this is a good option? Why?
• Make three recommendations with regards to future changes which might assist in further improving the profitability of the business. Briefly justify these recommendations (i.e. prescribe what should be done and why this would be helpful, drawing on your predictive and prescriptive analysis).

Preparing the Business Report
Report structure
The analysis, findings and recommendations which you prepare for Jamie and Xin Rong 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 (ISYS2059), 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 and tables 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, revenue, costings etc)
 Clear recommendations that the business owner 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 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.
 Get custom essay samples and course-specific study resources via course hero homework for you service – Include a page header with a suitably formatted title (the header must not appear on the title page).
 Get custom essay samples and course-specific study resources via course hero homework for you service – Include a page footer with your name, student number and page number (the footer must not appear on the title page).
 Get custom essay samples and course-specific study resources via course hero homework for you service – 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
Report Submission
The Business Report must be submitted, in MS Word format, by 11:59 pm Friday Week 8, via the link provided in the “Assignments” area on the ISYS2059 Business Information Systems site on Canvas. A Student Guide to submission (using Turnitin) is available at:
https://www.rmit.edu.au/students/support-and-facilities/it-services-for-students/canvas/turnitin

A Guide to inserting a screenshot 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 1 in which one of the relevant cells is highlighted (B3) and the function for column B is clearly visible.)
• Label the screenshot appropriately.

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 (see Figure 2) you can:
• Select the relevant cell. Double click on the cell to show the formula.
• Create screen clipping as per the instructions above. Provide an appropriate label.

Figure 2 – Screenshot of Sumif function
To show several formulas in the one screenshot (see Figure 3) you can:
• Select the relevant cells.
• Select Formulas/Formula Auditing/Show formulas.
• Take the screenshot as per the directions above. (NOTE: Text needs to be large enough to be read clearly.)
Figure 3 – Screenshot showing functions in several columns

Order | Check Discount