EXCEL for Business Intelligence - Business Process Models - Management Assignment Help

Assignment Task:

Assignment specifications

The primary aim of this assignment is to understand the effect and impact that business processes, complementary technologies and information systems have on an organisation. This means that you need to discuss how the organisation within the case study will use your proposed solutions to gain an additional advantage over its competitors. There is an expectation that your submission will be analytical, and will draw on theory to frame responses to tasks.

Task A: EXCEL for business intelligence

UMC wants to evaluate the sales statistics for the past year and the current year to predict future sales. The general manager knows enough about Excel to realise it could be a useful tool, so he has asked you to create a Microsoft Excel prototype which lists the milk product types with the client ordering details and the revenues collected. The partly-completed spreadsheet; from a random average week (week 32) is available as a separate attachment. Sales data is collected on a 52-week cycle.

Spreadsheet requirements

Complete the spreadsheet using the correct formulas to fill in the missing data:

• In the 'Ordering raw data' table, complete the 'Equiv litre per crate/carton' column. Also complete the 'Supplier price per unit' and 'Retail Sale price per unit' columns.

• In the 'Milk products' table, complete the 'Supplier price per unit' column.

• Complete the milk production table

The formulas required to reveal the missing data include VLOOKUP and SUMIF. Absolute addressing is also required.

Spreadsheet graphs

You are also required to create three graphs:

• Create a column chart: show total orders by customers for Week 32 for all 3 years (2016-2018).

• Create a column or pie chart: by using the milk production data, create a chart illustrating these figures.

• Create a column or pie chart. Your choice: This chart can reflect an element from any of the data tables that you feel will add value to the user.

All graphs must be dynamic to show visible changes instantly when the data is altered.

Discuss your chart and the perceived benefits in the main report.

Task B: Business process models

Produce one process model (not hand-drawn) using the swim lane format from the details provided in the case study:

• The first swim lane diagram is provided. Use this model and the provided template to assist you in developing a second swim lane diagram that represents the proposed ‘to-be’ application processes at UMC.

• A partly completed template has been provided.

Task C: General questions

1. What is the role of business process modelling for organisations such as UMC? What are the benefits of providing an as-is model and a to-be model to the General Manager? Include your swim lane diagram (from Task B) as part of your explanation.

2. Broadly explain the importance of information in organisations like UMC and provide an example of how information technology can be a useful tool for attracting new customers and gathering information. Provide some recommendations on how UMC could be modernised. Consider network improvements and cloud services as a part of your recommendations.

3. To promote the use of the new ordering system, UMC will need to develop a mobile-compliant version of the new ordering system as either a native stand-alone app or as a mobile webpage app. Provide the general manager with a valid argument for the preferred method.

4. Discuss the differences between web analytics, social network analysis and customer relationship management, including outlining the environment from which the information is collected, the type of information it collects and the benefit from the information collected.

5. As UMC will be collecting information (personal and financial) from its clients, outline the privacy laws and cybersecurity measures that the company will need to consider to assure the customer that their information is safe and secure.

This Management Assignment has been solved by our Management Experts at onlineassignmentbank. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.