Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I could not fit all of the data in 1 picture, but provide a step by step on how to solve it please! Mower Unit

I could not fit all of the data in 1 picture, but provide a step by step on how to solve it please!

image text in transcribed

Mower Unit Sales 1. Rearrange DATA- Create PIVOT-TABLE to answer Sales by Month, by Year- using region as the filter 2. Using TRENDLINE find the best fit for each region (5 Trendlines Including WORLD) 3. FOR DASHBOARD: Create a PIE Chart for YEAR 2018 of total units sold by region Month NA SA Europe Pacific China World Jan-14 6000 200 720 100 0 7020 Feb-14 7950 220 990 120 0 9280 Mar-14 8100 250 1320 110 0 9780 Apr-14 9050 280 1650 120 0 11100 May-14 9900 310 1590 130 0 11930 Jun-14 10200 300 1620 120 0 12240 Jul-14 8730 280 1590 140 0 10740 Aug-14 8140 250 1560 130 0 10080 Sep-14 6480 230 1590 130 0 8430 Oct-14 5990 220 1320 120 0 7650 Nov-14 5320 210 990 130 0 6650 Dec-14 4640 180 660 140 0 5620 Jan-15 5980 210 690 140 0 7020 Feb-15 7620 240 1020 150 0 9030 Mar-15 8370 250 1290 140 0 10050 Apr-15 8830 290 1620 150 0 0 10890 May-15 9310 330 1650 130 0 11420 Jun-15 10230 310 1590 140 0 12270 Jul-15 8720 290 1560 150 0 10720 Aug-15 7710 270 1530 140 0 9650 Sep-15 6320 250 1590 150 0 8310 Oct-15 5840 250 1260 160 0 7510 Nov-15 4960 240 900 150 0 6250 Dec-15 4350 210 660 150 0 5370 Jan-16 6020 220 570 160 0 6970 Feb-16 7920 250 840 150 0 9160 Mar-16 8430 270 1110 160 0 9970 Apr-16 - 9040 310 1500 170 0 11020 May-16 9820 360 1440 160 0 11780 Jun-16 10370 330 1410 170 0 12280 Jul-16 9050 310 1440 160 0 10960 Aug-16 7620 300 1410 170 0 9500 Sep-16 6420 280 1350 180 0 8230 Oct-16 5890 270 1080 180 0 7420 Nov-16 5340 260 840 190 0 6630 Dec-16 4430 230 510 180 0 5350 Jan-17 6100 250 480 200 0 7030 Feb-17 8010 270 750 190 0 9220 Mar-17 8430 280 1140 200 0 0 10050 Apr-17 9110 320 1410 210 0 11050 May-17 9730 380 1340 190 0 11640 Jun-17 10120 360 1360 200 0 12040 Jul-17 9080 320 1410 200 0 11010 Aug-17 7820 310 1490 210 0 9830 Sep-17 6540 300 1310 220 0 8370 Oct-17 6010 290 980 210 0 7490 Nov-17 5270 270 770 220 0 0 6530 Dec-17 5380 260 430 230 0 6300 Jan-18 6210 270 400 200 0 7080 Feb-18 8030 280 750 190 0 9250 Mar-18 8540 300 970 210 5 10025 Apr-18 9120 340 1310 220 16 11006 May-18 9570 390 1260 200 22 11442 Jun-18 10230 380 1240 210 26 12086 Jul 18 0580 250 1200 220 11.474

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

Step: 3

blur-text-image

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

Frank Woods Business Accounting Volume 2

Authors: Frank Wood, Alan Sangster

14th Edition

1292209178, 9781292209173

More Books

Students also viewed these Accounting questions