ISYS2056 Business Information Systems Assignment

Assignment Help Other Subject

Reference no: EM132553540 , Length: word count:1000

ISYS2056 Business Information Systems Assignment - RMIT University, Australia

Task - ANALYSING A SPREADSHEET AND PRESENTING A BUSINESS REPORT

"Taps To Go" is a specialist on line store, situated in Melbourne and managed by owner Alex and Ash Sparks. It sells a limited range of tapware at discounted prices.

Alex and Ash currently stock a range of taps from seven manufacturers. They advertise on social media and supply four different ranges - basics, value, superior and luxury. They have calculated different discounts for each manufacturer based on the tap range. They believe that customers buying 'basic' items would be more focused on 'discounts' than customers who purchase more expensive superior or luxury tapware. Alex and Ash buy the tapware at cost price and sell at recommended retail price less the advertised discount. Presently delivery costs are based on the state which the goods are delivered to. However, Alex and Ash have recently received complaints on social media that this method unfairly penalises some of their interstate customers.

Alex and Ash conducted extensive market research before setting up the business. Since 2017 they have recorded 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 gross profit and the various options available to help increase future profitability.

Alex and Ash are interested in both 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 wonder if the current discount options are appropriate. In addition, they want to have some idea of potential growth in the coming months and the likely effect on the business if the delivery charges were changed to a flat rate of $10.20. (ie: rather than the current delivery rate, which is calculated according to the state to which the item is delivered)

A spreadsheet has been provided containing the data for "Taps to Go" sales for 2017, 2018 and 2019.

In summary -

Undertake descriptive, predictive and prescriptive analysis of the data Alex and Ash have maintained over the past three years. Present your findings in a professionally presented report:

Provide an overview of gross profit trends, undertaking predictive analysis.

Discuss the results of your descriptive analysis and options for future sales growth.(based on the requirements of Alex and Ash)

Identify and discuss the potential effects to the business if delivery were to be changed to a flat rate of $10.20.

Make recommendations with regard to future changes which might assist in further improving profitability. 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 Content

The analysis, findings and recommendations which you prepare for Alex and Ash should be outlined in a well presented, 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 (ISYS2056), 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 Alex and Ash 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.

Attachment:- Business Information Systems Assignment Files.rar

Reference no: EM132553540

Questions Cloud

Define description of your field instructor leadership style : Post a blog post that includes: A description of your field instructor's leadership style and an explanation of whether the leadership style will promote your.

Evaluate one advantage of using a psychosocial framework : Describe four specific psychosocial factors that should be taken into account in order to understand the psychosocial context when working with the group you.

Find and calculate the new break-even quantity : Find and Calculate the new break-even quantity. make provision for a 10% increase in fixed production costs and an increase in variable costs of R15 per unit.

Calculate the mass of aluminum bromide : Aluminum bromide can be prepared by the reaction of aluminum metal with bromine gas shown by the equation:

ISYS2056 Business Information Systems Assignment : ISYS2056 Business Information Systems Assignment Help and Solution - RMIT University, Australia - Assessment Writing Service

Evaluate options and approaches to testing software : Evaluate Options and Approaches to Testing Software and Vulnerabilities - compare these in the light of needing to test new software and the critical security

Sample of propanoic acid : Use the following information to answer the next 2 questions. A 100 mL sample of propanoic acid has a pH of 4.28

What are the risks and benefits of the treatments : Choose either hypertension or COPD. Discuss at least three symptoms caused by physiologic changes and consequences of the disease and how pharmaceutical.

Which statements is true regarding the definition of a fund : Which statements is true regarding the definition of a fund? Resources, related liabilities, and residual equities or balances and changes therein are segregate

User Account

All Pages