ISYS2059: Business Computing- Susana & Marcus Horton- Business Report Assignment Help

Internal Code: TV822

Business Report Assignment Help:

Task: Susana and Marcus Horton own and run Hortons Estate in the Yarra Valley in Victoria, Australia. The Winery contains a 30 hectare vineyard and a cellar door which is open to the public. Susana and Marcus want to focus on building their clientele through online and telephone sales. They have been opening the cellar door to the public seven days per week. They want to focus on the times of the week which are most profitable, and they also would like to analyse which stock they carry is the most profitable. Hortons Estate’s traditional customer base has been Victoria. Susana sees the expansion into other states as a great marketing opportunity. She is considering offering a permanent discount online to all retailers who have registered online. She would like to know the effectiveness of the previously offered 12% discount in the month of February. Marcus tends to the grapes and supervises wine production. Susana is responsible for all other winery operations. She employs two staff to assist her. Michael Overton is employed on a full time basis and Eloise Simmons is employed two days per week. The winery has delivery charges of $28 for each case of wine to any state except Victoria (VIC). However, all deliveries are free in the month of March. Susana has asked you to analyse the sales data and write a report with regards to the effectiveness of the recent campaigns and her efforts to increase sales outside of Victoria. She realises there are other factors that may impact these results. These should be outlined and considered before you make your recommendations to improve the business. They are interested in analyses about which days the cellar doors could be closed altogether, and which stock could be dropped. And they are open to other suggestions for ways in which they might improve their business. Perform analyses consistent with this business case. You should create a sheet which performs the basic calculations for discount and delivery. Also provide some pivot tables which show an analysis which is useful from a business perspective. A spreadsheet has been provided for you that contains data for sales during January, February and March.