BUS0117 Information Systems for Business (April 2024)

Hello, if you have any need, please feel free to consult us, this is my wechat: wx91due

BUS0117 Information Systems for Business (April 2024)

Continual Assessment 2

Group Assignment (40%)

Total marks: 100 marks

Section A – Business Analytics using MS Excel (75 marks)

Case Study

Auston Juices Pty Ltd is a wholly Australian owned and operated business that has been making fruit juice for 10 years. Having conducted a successful trial of fruit juice products throughout regions in Australia, Mike Auston the owner and managing director of the company, wishes to further expand into the non-alcoholic beverage market and has conducted a three-months trial of ‘mixer’ drinks.  These drinks will be advertised as ‘adult’ mixers and sold with cocktail recipes printed directly onto the can.

The new trial of the ‘mixer’ drinks was conducted from June to August 2023.    Michelle, the Director of Marketing at Auston Juices, conducted the trial from retail stores in each of Auston Juices four sales regions.  The four regions include New South Wales, Queensland, Victoria and Western Australia.

The ‘mixer’ drinks that have been trialled are ALMOND PASSION, MANGO DELIGHT, RASPBERRY SODA, TRIPLE SHOT ESPRESSO, LIME SOFT DRINK and CRANBERRY WIZZ.   All the juices will only be available in 300 ml aluminium cans.

Mike has negotiated with several retail stores.  The trial was conducted in association with four retailers in Victoria, and three retailers in each of the other regions (see the accompanying spreadsheet).

Sales data (number of cans sold) for the 3-months trial period is provided in an accompanying spreadsheet.   Mike wants you to analyse the results of the trial and, drawing on this analysis, to advise him on the marketing potential for each flavour, the different regions, and the different retailers.  He is also interested in any other factors that need to be considered when interpreting the results, and finally your advice on any other factors that may need to be considered before final decisions are made concerning the ongoing sales of the ‘mixer’ drinks.

You are expected to undertake descriptive and predictive analysis of the data provided in the accompanying spreadsheet. The results of the analysis are then required to be presented in a professionally organised report with respect to the requirements of the business owner stated above.

Preparing the Business Analysis Report

Report structure

The analysis, findings and recommendations which you prepare for the company should be outlined in a professional business analysis report.

This report should include:

· A Title page – with a report title, student name/number, class, module name (Information Systems for Business).

· A Table of Contents (TOC)

· A brief Introduction which clearly outlines the purpose of the report.

· The Analysis you have undertaken and a Discussion regarding the results of this analysis. You will have to conduct Descriptive and Predictive Analysis of the data.

· A short Conclusion which summarises the major findings of the report.

· At least THREE clear Recommendations that the management 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 written and presented to a professional standard and directed towards the management of the company.

Specifically you should:

· Ensure your report is concise: 2000 words. This word count includes Title page and Table of Contents.

· 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.

· You must include relevant charts and tables you have created in the body of your report (appropriately labelled). The material in the charts and tables must be discussed as part of the report.

· There is no need to include references or citations as this is a business report.

Section B – Presentation (25 marks)

The group will be required to make a presentation (15-20 mins) about their analysis of the business during the last two lessons. Your lecturer will provide more details about the format and structure of the presentation.

The group will have to prepare a set of PowerPoint slides to support the presentation.

Every member of the group will have to participate in the group presentation.

Submission Guidelines

You will need to upload the following files to the Canvas (Learning Management System) dropbox by the assignment due date:

1. MS Excel file (containing all relevant data and analysis worksheets).

2. MS Word file (containing the business analysis report).

Marking scheme for the Business Analysis Report