Kindly refer to the word docs. All the required information for the business report is inside it. Also, there is an excel file attached with the word docs. file together, it is also required for the assignment.
ISYS2059 BUSINESS INFORMATION SYSTEMS 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. · 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. · 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 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 ISYS 2059 Business Report Term 1, 2022Page 1 charges and discounts Costs and Advertised Discounts ManufacturerDiscount (off RRP)RangeITEMDescriptionCost PriceRecommended Retail Price (RRP) Clark22%ValueFRA113Basin Mixer$ 190.00$ 285.00 Abey16%StandardFRA221Bath mixer$ 180.00$ 270.00 Mondella16%StandardFRA222Bath tap set$ 175.00$ 263.00 Franke16%StandardFRA600Showerhead Round$ 205.00$ 308.00 Phoenix12%SupremeFRA444Showerhead Square$ 240.00$ 360.00 Aguzzo12%SupremeABE113Laundry Tap Mixer$ 150.00$ 225.00 Fantini12%SuperiorABE123Basin tap set$ 140.00$ 210.00 Hansgrohe6%SuperiorABE222Kitchen Tap Mixer$ 190.00$ 285.00 FRA226Watersaver Showerhead$ 195.00$ 293.00 FRA231Basin Tap set$ 160.00$ 240.00 Delivery ChargesABE244Bath mixer$ 135.00$ 203.00 Free Delivery if over $ 100.00ABE500Basin Sink Mixer$ 150.00$ 225.00 Delivery charge per item$9.99ABE300Showerhead fast flow$ 157.00$ 236.00 CLA245Bath mixer$ 55.00$ 83.00 CLA321Basin Sink Mixer$ 60.00$ 90.00 CLA555Kitchen Tap Mixer$ 70.00$ 105.00 CLA666Laundry Tap Mixer$ 65.00$ 98.00 PHO223Basin Sink Mixer$ 280.00$ 420.00 PHO224Bath mixer$ 290.00$ 435.00 PHO225Watersaver Showerhead$ 340.00$ 510.00 HAN225Showerhead$ 750.00$ 1,125.00 HAN226Kitchen Tap Mixer$ 850.00$ 1,275.00 MON112Basin Mixer$ 125.00$ 188.00 MON221Bath mixer$ 129.00$ 194.00 MON222Watersaver Showerhead$ 140.00$ 210.00 MON333Kitchen Tap Mixer$ 155.00$ 233.00 MON444Laundry Tap Mixer$ 150.00$ 225.00 FAN240Bath tap set$ 222.00$ 333.00 FAN234Showerhead$ 397.00$ 596.00 FAN332Basin Mixer$ 340.00$ 510.00 HAN443Basin Mixer$ 639.00$ 959.00 HAN643Basin Mixer$ 650.00$ 975.00 AGU234Basin tap set$ 450.00$ 675.00 AGU555Basin Mixer$ 440.00$ 660.00 &"Calibri"&12&KEEDC00RMIT Classification: Trusted&1# calcs customer sales and charge Date of SaleCustomerProduct IdManufacturerFinishRetail Charge% discount$ discountDiscounted PriceDeliveryTotal ChargeRangeCost PriceChargeGross profit 3-Jan-20Singapore Bathroom RenovationsFRA231FrankeChrome$ 240.0016%$ 38.40$ 201.60$ 9.99$ 211.59Standard$ 160.00$ 211.59$ 51.59 3-Jan-20Singapore Bathroom RenovationsABE222AbeyChrome$ 285.0016%$ 45.60$ 239.40$ 9.99$ 249.39Standard$ 190.00$ 249.39$ 59.39 3-Jan-20Singapore Bathroom RenovationsFRA444FrankeChrome$ 360.0016%$ 57.60$ 302.40$ 9.99$ 312.39Standard$ 240.00$ 312.39$ 72.39 6-Jan-20Cindy TanMON221MondellaChrome$ 194.0016%$ 31.04$ 162.96$ 9.99$ 172.95Standard$ 129.00$ 172.95$ 43.95 7-Jan-20Superior Bathroom Reno'sFRA600FrankeChrome$ 308.0016%$ 49.28$ 258.72$ 9.99$ 268.71Standard$ 205.00$ 268.71$ 63.71 7-Jan-20Xin ChenFRA226FrankeChrome$ 293.0016%$ 46.88$ 246.12$ 9.99$ 256.11Standard$ 195.00$ 256.11$ 61.11 7-Jan-20Superior Bathroom Reno'sHAN443HansgroheGold$