hello, so i think i did all of this project correctly. However, i need someone to please do number 6 because i am unable to understand and answer. Can someone only do NO. 6?? i gave u all the data, even zoomed in!! I know theres an "Answer 6" in this picture but please ignore it, that was an attempt to answer. i will give thumbs up!!!
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, expl Part 2 (20%) 7 Show the impact of the fluctuation in exchange rate on the revenue figure in each country in 2020 Part 3 (20%) 8 The outcome of this exercise should be presented in a readable, clean, presentable and Printable format Fle Colors width: 1 page 1 Height 1 page CS Gridlines Headings View View A Fonts Themes Margins Orientation Size Print Breaks Background Print Area Effects Titles 27 Print Print Bri Forwa Themes Page Setup Scale to Fit Sheet Options R26 E 6 Trem Trains NIE 21 Country 40 S ht Geam Price in seinen Sale Price la locale (Unit Price 750 DOP 1,300.00 30.00 CAD 50,00 DO OESTE 1605 3.956 2.100 11. 200 1,200 300 4063 14 5,656 3917 201 11 34 3,344 1500 57 2.32 125 Canada Chitis Australia U Part 2 Alia U Part AUD 30.00 25.00 20.00 H 5 India 24 Canada China 2020 Sales SO 10455 37,16 EOS 45.4565224911 129773 DAS ZAS E70145 154,26252724 31,3720 5.950 149 7549595 2.775 SOS 96.00 $0.00 921617185 ALA 142 6814.525 EN 1.5 WORDEN 315 5 of Hair Care Rate Changes Beve 45222111 49.246 155 327,402.64 35, 135 21.01$ BL24118 16.875.00 5 30 413 SIS 556 17,375.34 2.210.37 2.3.2 34 20,5952 12.585 915 1.475.66 10% USA UK 5 5 $ $ 5 $ 102743 5 Answer to Number 6: The change in Number of units sold and change in revenue is consistent for each country. It remains the same Yearly Sales Exchange Rates D E F - A B C 1 Fitness Equipment Inc. 2 3 Treadmill Yearly Sales Analysis 4 5 Units Sold Country 2019 Sales(Qty) 6 Russia 3,605 7 India 3,966 8 Germany 4,200 9 Canada 3,777 0 China 3,974 1 Australia 3,656 2 USA 3,554 3 UK 3,844 4 Total 30,576 5 2020 Sales(Qty) 3,853 2,500 3,900 4,063 3,850 3,937 3,875 3,344 29,322 Qty Change % change 248 (1,466) (300) 286 (124) 281 321 (500) (1,254) 7% -37% -7% 8% -3% 8% 9% -13% -4% Country Russia India Germany Canada China Australia USA Price that Fit. Equip. Inc. set in the countries below Sale Price in local currency (Unit Price) 730.00 P * 1,300.00 30.00 CAD 30.00 160.00 AUD 30.00 $ 25.00 f 20.00 UK 1 WWE LES 144 India Case 452113 AM 12:19 51 WED Pitt 07753 2.210.31 PHI ONEY SIE SITE VA USD 5 2015 WA ISID 272825 302500 44145 399614 5.75 TE 16 SOT 595 ODOS 34175 LARSS 5:05 30 RELE 95875 5 low 5 TON ERO 55671 Answer to Number 6: The change in Number of units sold and change in revenue is consistent for each country. It remains the same. ates G