solution

How could using a software tool such as Microsoft Excel support Erica’s business decision making?

Explain the value chain and how Balogne could use it to improve operations

 

Order Now
SKU: Ema0041

Task A: EXCEL SPREADSHEET

Erica wants to evaluate the 2014 and 2015 sales figures. Erica knows enough about Excel to realise it could be a useful tool so she has asked you to create a Microsoft Excel prototype which provides an overview of the revenue and expenses over the two-year period. The data for the spreadsheet is available on the next page as well as a suggested layout with additional hints and information.

Graphs: You are also required to create two (2) graphs.

1. Show, by product, whether there has been a percentage growth or loss in earnings from 2014 to 2015. Graph must look like Graph 1 shown on next page (except amounts). Colors may differ.

2. Show the yearly earnings. Graph must look like Graph 2 shown on next page (except amounts). Colors may differ.

Both of your graphs must be included on your Excel file and copied into your business report

 

Task B: PROCESS MODEL

Produce one (1) As-Is process model (not hand drawn) using Swim Lane format from the details provided in the Background section (clearly state any assumptions made)

Your Swim Lane Diagram and assumptions must be copied into your business report

 

Task C: QUESTIONS

Respond to the following questions

(i) What is the role of business process modelling for organisations such as Balogne? What are some benefits to the General Manager, Ms Erica Norris in viewing a Process Model such as your Swim Lane Diagram for Balogne? Include your Swim Lane Diagram (from Task B) as part of your explanation.

 

(ii) How could using a software tool such as Microsoft Excel support Erica’s business decision making? Refer to the two (2) graphs (from Task A) as part of your explanation.

 

(iii) How could Balogne use Web 2.0 applications to better collaborate inside and outside the organization? In your explanation include two (2) different types of Web 2.0 applications you would recommend for adoption by Balogne. The first application must address the use of Web 2.0 for internal communication while the second application could be used to communicate with farmers or distributors.

 

(iv) How could Ms Norris use Decision Support Systems to help support her decision making?

 

(v) Explain the value chain and how Balogne could use it to improve operations.

Reviews

There are no reviews yet.

Be the first to review “How could using a software tool such as Microsoft Excel support Erica’s business decision making?”

Your email address will not be published. Required fields are marked *