10 Search You have recently joined a new company as a trainee data analyst. The company import a range of different specialty Cheeses from France and the Netherlands. They supply the cheese to a number of different restaurants and specialist delicatessens throughout the UK. The company face a number of challenges due to currency exchange rate fluctuations (between the Euro, that they buy the cheese in, and the pound that they sell it in) and the variations in economic growth. Their product is relatively expensive and sells better when economic growth is good and less well when it is poor. You have been asked to design and create a spreadsheet model which can predict the potential impact of exchange rate fluctuations on the company profit margins. The model should use the data collected by the company on average monthly sales of the top five best-selling cheeses in their range. (See Assignment attached) The typical margin applied to calculate the UK sales price is 40%, Profit is calculated by subtracting the cost per kilo in pounds from the sales price. The company have found that on average for each 10p rise in the sales price (based on the 0.7 exchange rate) the average monthly sales drops by 20 units. If the exchange rate drops below 0.7 then the sales increase by a similar amount. When the exchange rate increases the company can do one of two things: volume decrease the margin so prices stay the same increase the prices keeping the margin the same, but this will reduce sales Your model should show the impact of doing each of these on the overall profit the company makes. The model you develop should be designed to be used by people who are not experts in spreadsheets and should include a user interface which allows the user to enter the exchange rate and then choose to either change the margin or the prices
10 Search You have recently joined a new company as a trainee data analyst. The company import a range of different specialty Cheeses from France and the Netherlands. They supply the cheese to a number of different restaurants and specialist delicatessens throughout the UK. The company face a number of challenges due to currency exchange rate fluctuations (between the Euro, that they buy the cheese in, and the pound that they sell it in) and the variations in economic growth. Their product is relatively expensive and sells better when economic growth is good and less well when it is poor. You have been asked to design and create a spreadsheet model which can predict the potential impact of exchange rate fluctuations on the company profit margins. The model should use the data collected by the company on average monthly sales of the top five best-selling cheeses in their range. (See Assignment attached) The typical margin applied to calculate the UK sales price is 40%, Profit is calculated by subtracting the cost per kilo in pounds from the sales price. The company have found that on average for each 10p rise in the sales price (based on the 0.7 exchange rate) the average monthly sales drops by 20 units. If the exchange rate drops below 0.7 then the sales increase by a similar amount. When the exchange rate increases the company can do one of two things: volume decrease the margin so prices stay the same increase the prices keeping the margin the same, but this will reduce sales Your model should show the impact of doing each of these on the overall profit the company makes. The model you develop should be designed to be used by people who are not experts in spreadsheets and should include a user interface which allows the user to enter the exchange rate and then choose to either change the margin or the prices
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
Can u help me with the spreadsheet please
Transcribed Image Text:10
Search
You have recently joined a new company as a trainee data analyst. The company
import a range of different specialty Cheeses from France and the Netherlands. They
supply the cheese to a number of different restaurants and specialist delicatessens
throughout the UK. The company face a number of challenges due to currency
exchange rate fluctuations (between the Euro, that they buy the cheese in, and the
pound that they sell it in) and the variations in economic growth. Their product is
relatively expensive and sells better when economic growth is good and less well when
it is poor.
You have been asked to design and create a spreadsheet model which can predict the
potential impact of exchange rate fluctuations on the company profit margins.
The model should use the data collected by the company on average monthly sales of
the top five best-selling cheeses in their range. (See Assignment attached)
The typical margin applied to calculate the UK sales price is 40%, Profit is calculated
by subtracting the cost per kilo in pounds from the sales price. The company have
found that on average for each 10p rise in the sales price (based on the 0.7 exchange
rate) the average monthly sales drops by 20 units. If the exchange rate drops below
0.7 then the sales increase by a similar amount.
When the exchange rate increases the company can do one of two things:
volume
decrease the margin so prices stay the same
increase the prices keeping the margin the same, but this will reduce sales
Your model should show the impact of doing each of these on the overall profit the
company makes.
The model you develop should be designed to be used by people who are not experts
in spreadsheets and should include a user interface which allows the user to enter the
exchange rate and then choose to either change the margin or the prices
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY