Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1 Fitness Equipment Inc. 2 3 Treadmill Yearly Sales Analysis 4 5 Units Sold 6 3,605 Country 2019 Sales(Qty) 2020 Sales (Qty) Qty Change
1 Fitness Equipment Inc. 2 3 Treadmill Yearly Sales Analysis 4 5 Units Sold 6 3,605 Country 2019 Sales(Qty) 2020 Sales (Qty) Qty Change % change Russia 3,853 Russia 730.00 P 7 India 3,966 2,500 India 8 Germany 4,200 3,900 Germany 9 Canada 3,777 4,063 Canada CAD 10 China 3,974 3,850 China 1,300.00 30.00 30.00 160.00 Price that Fit. Equip. Inc. set in the countries below Country Sale Price in local currency (Unit Price) You are asked to do Part 1 (60%) 1 Calculate the year-to-year change in number of units sold per country, in absolute value and in percentage 2 Highlight the drop in sales 3 Provide the sales (revenue) sparkline for each country in 2019 and 2020 in US dollars 4 Calculate the year-to-year change in revenue per country, in absolute value and in percentage 5 Highlight the drop in revenue 6 Does the change in #of unit sold reflects in the change in revenue in all countries? where the answer is no, explain why Part 2 (20%) 7 Show the impact of the fluctuation in exchange rate on the revenue figure in each country in 2020 11 Australia 3,656 3,937 Australia AUD 30.00 Part 3 (20%) 8 The outcome of this exercise should be presented in a readable, clean, presentable and Printable format 12 USA 3,554 3,875 USA $ 25.00 13 UK 3,844 3,344 UK 20.00 14 Total 30,576 29,322 15 16 17 18 19 Revenue 20 Country 2019 Sales 2020 Sales $ Change % change 21 Russia 22 India 23 24 25 Germany Canada China 26 Australia 27 28 29 USA UK Total 30 31 32 33 34 35 36 37 Yearly Sales Exchange Rates + ] 100%
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started