ASSESSMENT TWO
\nTERM 1, 2022<\/p>\n
ANALYSING A SPREADSHEET AND PRESENTING A BUSINESS REPORT
\nDue Date\/Time: 11:59 pm, Friday Week 8, Term 1, 2022
\n30% of Final Grade<\/p>\n
Case Study<\/p>\n
\u201cTaps 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.
\nJamie 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 \u2018value\u2019 items will be more focused on \u2018discounts\u2019 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.
\nJamie 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 \u2018tools\u2019 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.
\nJamie 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.
\nA spreadsheet has been provided containing the data for \u201cTaps Galore\u201d sales for 2020 and 2021.<\/p>\n
Requirements and Specifications
\nYou 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:
\n\u2022\tProvide an overview of gross profit trends, undertaking both descriptive and predictive analysis.
\n\u2022\tDiscuss the results of your descriptive analysis and the options for future sales growth based on the requirements of Jamie and Xin Rong.
\n\u2022\tIdentify and discuss the potential effects to the business if \u2018Taps Galore\u2019 offered free delivery for all purchases over $100.00. Do you believe this is a good option? Why?
\n\u2022\tMake three recommendations with regards to future changes which might Help 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).<\/p>\n
Preparing the Business Report
\nReport structure
\nThe analysis, findings and recommendations which you prepare for Jamie and Xin Rong should be outlined in a professional business report. This report should include
\n\uf0a7\tA title page \u2013 with a relevant graphic, report title, student name\/number, course name (Business Information Systems), course number (ISYS2059), your workshop time and your workshop tutors\u2019 names.
\n\uf0a7\tA Table of Contents (TOC) automatically generated by Microsoft Word. Default settings for the table of contents should not be altered.
\n\uf0a7\tA brief introduction which outlines clearly the purpose of the report.
\n\uf0a7\tA discussion regarding the results of your analysis. Relevant descriptive, predictive and prescriptive analysis has been included.
\n\uf0a7\tRelevant charts and tables which are labelled correctly and Help the reader in understanding the results of your analysis.
\n\uf0a7\tA short concluding summary of the major findings of the report. (supported by relevant data: eg, revenue, costings etc)
\n\uf0a7\tClear 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.<\/p>\n
Report format
\nThe report should be developed using the guidelines covered in Canvas and workshops. Specifically, you should:
\n\u2022\tEnsure your report is concise – No more than 1200 words. This word count includes title page and TOC. It does not include appendices
\n\u2022\tPresent the report in a professional, business format with no spelling or grammatical errors.
\n\u2022\tUse appropriate headings and subheadings throughout the body of the report.
\n\uf0a7\tUse double or 1.5 spacing.
\n\uf0a7\tFully justify all text in the report.
\n\uf0a7\tInclude a page header with a suitably formatted title (the header must not appear on the title page).
\n\uf0a7\tInclude a page footer with your name, student number and page number (the footer must not appear on the title page).
\n\uf0a7\tInclude 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.
\n\uf0a7\tIn an appendix include screen shots of calculations (as discussed below) which you have used to Help 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.
\n\uf0a7\tDo not include references or citations in this report
\nReport Submission
\nThe Business Report must be submitted, in MS Word format, by 11:59 pm Friday Week 8, via the link provided in the \u201cAssignments\u201d area on the ISYS2059 Business Information Systems site on Canvas. A Student Guide to submission (using Turnitin) is available at:
\nhttps:\/\/www.rmit.edu.au\/students\/support-and-facilities\/it-services-for-students\/canvas\/turnitin<\/p>\n
A Guide to inserting a screenshot in \u2018Word\u2019
\n\u2022\tOpen 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.
\n\u2022\tOpen your \u2018Word\u2019 document.
\n\u2022\tSelect Insert\/Screenshot\/Screen Clipping.
\n\u2022\tSelect 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.)
\n\u2022\tLabel the screenshot appropriately.<\/p>\n
Figure 1 – Screen shot of Countif function
\nIf you need to create a screenshot of a column that is not located near the fx box (see Figure 2) you can:
\n\u2022\tSelect the relevant cell. Double click on the cell to show the formula.
\n\u2022\tCreate screen clipping as per the instructions above. Provide an appropriate label.<\/p>\n
Figure 2 \u2013 Screenshot of Sumif function
\nTo show several formulas in the one screenshot (see Figure 3) you can:
\n\u2022\tSelect the relevant cells.
\n\u2022\tSelect Formulas\/Formula Auditing\/Show formulas.
\n\u2022\tTake the screenshot as per the directions above. (NOTE: Text needs to be large enough to be read clearly.)
\nFigure 3 \u2013 Screenshot showing functions in several columns<\/p>\n","protected":false},"excerpt":{"rendered":"
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\u2026<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[479,172,478],"tags":[181,21,535,31,527,534,536,526,532,533,531,530,525,528,27,529],"class_list":["post-12011","post","type-post","status-publish","format-standard","hentry","category-nursing-course-hero","category-nursing-study-bay","category-nursing-study-pool","tag-buy-psychology-essay","tag-nursing-assignment-writing-service-uk","tag-nursing-essay-writing","tag-nursing-essay-writing-service","tag-nursing-essay-writing-service-uk","tag-nursing-essay-writing-uk","tag-nursing-essays-online","tag-nursing-essays-uk","tag-psychology-assignment-writing-service","tag-psychology-essay-pro-top-writers","tag-psychology-essay-writing-service-uk","tag-psychology-pro-papers","tag-sociology-essay-pro-research","tag-sociology-peachy-essay-writers","tag-write-my-nursing-essay","tag-writers-per-hour-sociology-writers"],"_links":{"self":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/12011","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/comments?post=12011"}],"version-history":[{"count":0,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/12011\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/media?parent=12011"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/categories?post=12011"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/tags?post=12011"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}