Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cost Accounting A Managerial Emphasis

Authors: Charles T. Horngren, Srikant M. Datar, Madhav V. Rajan

14th Global Edition

978-0273753872, 0273753878

More Books

Students also viewed these Accounting questions