Using Spreadsheets To Make
Decisions
Grade: Distinction
, Introduction
I have recently joined a new company as a trainee data analyst. This company specialize
importing different types of cheeses from countries like France and the Netherlands.
Afterwards they supply the cheeses to multiple restaurants and a number of specialist
delicatessens across the United Kingdom. They have recently started having problems due
the exchange rate fluctuations, which they buy the cheese in which is Euro, and they sell
Pounds and due to the different variations in the economic growth.
They have noticed that their product, is relatively expensive and mostly sells when the
economic growth is good.
I have to help to develop some models to try and predict future sales of the cheese.
In order to prepare myself for the task given, I have to prepare a PowerPoint that showcas
the different ways spreadsheets models can be used.
, Stages of the Decision Making Process
Understanding the scenario
Identifying information and sources
Factors affecting the quality of information
Analysing the information
Identifying alternatives
Identifying consequences of implementing the alternatives
Making a decision
Justifying the decision
Communicating decision(s) to others
Decisions
Grade: Distinction
, Introduction
I have recently joined a new company as a trainee data analyst. This company specialize
importing different types of cheeses from countries like France and the Netherlands.
Afterwards they supply the cheeses to multiple restaurants and a number of specialist
delicatessens across the United Kingdom. They have recently started having problems due
the exchange rate fluctuations, which they buy the cheese in which is Euro, and they sell
Pounds and due to the different variations in the economic growth.
They have noticed that their product, is relatively expensive and mostly sells when the
economic growth is good.
I have to help to develop some models to try and predict future sales of the cheese.
In order to prepare myself for the task given, I have to prepare a PowerPoint that showcas
the different ways spreadsheets models can be used.
, Stages of the Decision Making Process
Understanding the scenario
Identifying information and sources
Factors affecting the quality of information
Analysing the information
Identifying alternatives
Identifying consequences of implementing the alternatives
Making a decision
Justifying the decision
Communicating decision(s) to others
