Performance Lawn Service, Episode6 An important part of planning manufacturing capacity is having a good forecast of sales. Elizabeth Burke is interested i

 An important part of planning manufacturing capacity is having a good forecast of sales. Elizabeth Burke is interested in forecasting sales of mowers and tractors in each marketing region, as well as industry sales, to assess future changes in market share. She also wants to forecast future increases in production costs. Develop forecasting models for these data and prepare a report of your results with appropriate charts and output from Excel. Upload your Word document AND your Excel worksheet file 

Excel sheet attached to add to assignment

Dealer Satisfaction

Dealer Satisfaction
tc={BC340A24-8BBA-491F-B401-F2D940BCB741}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:
This chart is showing Dealer Satisfaction between North America, South America, Europe, Pacific Rim and China. The data that was selected was rated on a a survery scale from 0-5 and between the the years of 2010-2014, except for China who started later in 2012. North America was leading in sample size and “in 5s” dealer satisfacion for “excelltence”. Although North America recieved the highest total numbers in dealer satisfactions for excellent rankings, in 2014, South America recieved 60 surverys and North America recieved 56 within the level 5 category.

Survey Scale:012345Sample
North AmericaSize
201010214221150
201100214201450
20121118341560
2013126123445100
2014235154456125
South America
201000026210
201100026210
20120014111430
20130113123350
20141124226090
Europe
201000137415
201100128415
2012001215725
2013001221630
2014001417830
Pacific Rim
20100012205
20110011305
20120011316
201300025310
201400127212
China
20120001001
20130014207
201400158216

Dealer Satisfaction by Region and Year

0 2010 2011 2012 2013 2014 South America 2010 2011 2012 2013 2014 Europe 2010 2011 2012 2013 2014 Pacific Rim 2010 2011 2012 2013 2014 China 2012 2013 2014 1 0 1 1 2 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 2010 2011 2012 2013 2014 South America 2010 2011 2012 2013 2014 Europe 2010 2011 2012 2013 2014 Pacific Rim 2010 2011 2012 2013 2014 China 2012 2013 2014 0 0 1 2 3 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2010 2011 2012 2013 2014 South America 2010 2011 2012 2013 2014 Europe 2010 2011 2012 2013 2014 Pacific Rim 2010 2011 2012 2013 2014 China 2012 2013 2014 2 2 1 6 5 0 0 1 1 2 1 1 1 1 1 1 1 1 0 1 0 1 1 3 2010 2011 2012 2013 2014 South America 2010 2011 2012 2013 2014 Europe 2010 2011 2012 2013 2014 Pacific Rim 2010 2011 2012 2013 2014 China 2012 2013 2014 14 14 8 12 15 2 2 4 3 4 3 2 2 2 4 2 1 1 2 2 1 4 5 4 2010 2011 2012 2013 2014 South America 2010 2011 2012 2013 2014 Europe 2010 2011 2012 2013 2014 Pacific Rim 2010 2011 2012 2013 2014 China 2012 2013 2014 22 20 34 34 44 6 6 11 12 22 7 8 15 21 17 2 3 3 5 7 0 2 8 5 2010 2011 2012 2013 2014 South America 2010 2011 2012 2013 2014 Europe 2010 2011 2012 2013 2014 Pacific Rim 2010 2011 2012 2013 2014 China 2012 2013 2014 11 14 15 45 56 2 2 14 33 60 4 4 7 6 8 0 0 1 3 2 0 0 2

This chart is showing Dealer Satisfaction between North America, South America, Europe, Pacific Rim and China. The data that was selected was rated on a a survery scale from 0-5 and between the the years of 2010-2014, except for China who started later in 2012. North America was leading in sample size and “in 5s” dealer satisfacion for “excelltence”. Although North America recieved the highest total numbers in dealer satisfactions for excellent rankings, in 2014, South America recieved 60 surverys and North America recieved 56 within the level 5 category.

End-User Satisfaction

End-User Satisfaction
tc={4E1782D3-7E9F-4E7B-83FB-A93AAF2BD2E6}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:
This chart is showing End-User Satisfaction between North America, South America, Europe, Pacific Rim and China. The data that was selected was rated on a a survery scale from 0-5 and between the the years of 2010-2014, except for China who started later in 2012. North America, South America, Europe, and the Pacific Rim all have the same sample size of 100 for each year between 2010 through 2014. China has a smaller sample size of 50 between the years of 2012 through 2014. You cansee that the ratings of 5’s, 4’s, and 3’s are the highest ratings. North America’s rating of 4 decreases every year starting with 2010 while the 5 ratings increase through the years. The Pacfic Rim’s 4 ratings are highest rated and is basically constant throughout the years while the 5 ratings are lower then 4 ratings the 5’s are constant throughout the years.

Sample
North America012345Size
2010136153738100
2011124183540100
2012125173441100
2013024153346100
2014023153149100
South America
2010125183638100
2011136173637100
2012026193736100
2013025203736100
2014025193737100
Europe
2010124213636100
2011125213437100
2012114263731100
2013113174137100
2014012194533100
Pacific Rim
2010235154134100
2011127154134100
2012125164036100
2013024174037100
2014013194235100
China
20120336281050
20131224301150
20140113311450

End-User Satisfaction by Region and Year

0 2010 2011 2012 2013 2014 South America 2010 2011 2012 2013 2014 Europe 2010 2011 2012 2013 2014 Pacific Rim 2010 2011 2012 2013 2014 China 2012 2013 2014 1 1 1 0 0 1 1 0 0 0 1 1 1 1 0 2 1 1 0 0 0 1 0 1 2010 2011 2012 2013 2014 South America 2010 2011 2012 2013 2014 Europe 2010 2011 2012 2013 2014 Pacific Rim 2010 2011 2012 2013 2014 China 2012 2013 2014 3 2 2 2 2 2 3 2 2 2 2 2 1 1 1 3 2 2 2 1 3 2 1 2 2010 2011 2012 2013 2014 South America 2010 2011 2012 2013 2014 Europe 2010 2011 2012 2013 2014 Pacific Rim 2010 2011 2012 2013 2014 China 2012 2013 2014 6 4 5 4 3 5 6 6 5 5 4 5 4 3 2 5 7 5 4 3 3 2 1 3 2010 2011 2012 2013 2014 South America 2010 2011 2012 2013 2014 Europe 2010 2011 2012 2013 2014 Pacific Rim 2010 2011 2012 2013 2014 China 2012 2013 2014 15 18 17 15 15 18 17 19 20 19 21 21 26 17 19 15 15 16 17 19 6 4 3 4 2010 2011 2012 2013 2014 South America 2010 2011 2012 2013 2014 Europe 2010 2011 2012 2013 2014 Pacific Rim 2010 2011 2012 2013 2014 China 2012 2013 2014 37 35 34 33 31 36 36 37 37 37 36 34 37 41 45 41 41 40 40 42 28 30 31 5 2010 2011 2012 2013 2014 South America 2010 2011 2012 2013 2014 Europe 2010 2011 2012 2013 2014 Pacific Rim 2010 2011 2012 2013 2014 China 2012 2013 2014 38 40 41 46 49 38 37 36 36 37 36 37 31 37 33 34 34 36 37 35 10 11 14

This chart is showing End-User Satisfaction between North America, South America, Europe, Pacific Rim and China. The data that was selected was rated on a a survery scale from 0-5 and between the the years of 2010-2014, except for China who started later in 2012. North America, South America, Europe, and the Pacific Rim all have the same sample size of 100 for each year between 2010 through 2014. China has a smaller sample size of 50 between the years of 2012 through 2014. You can see that the ratings of 5’s, 4’s, and 3’s are the highest ratings. North America’s rating of 4 decreases every year starting with 2010 while the 5 ratings increase through the years. The Pacfic Rim’s 4 ratings are highest rated and is basically constant throughout the years while the 5 ratings are lower then 4 ratings the 5’s are constant throughout the years.

Complaints

Complaints
tc={3A6BEBAD-C122-4573-AF72-C42391975593}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:
This chart is showing PLE’s Complaoints from registered by all customers each month within PLE’s 5 regions. From this data we can conclude that there is more use of the equipment in the summer months because of the higher number of complaints recieved. Based off the data shown form the region of China, their compaints are few and are steady throughout the months. This could be because they do not use this type of equipment in comparison to the other regions.

MonthWorldNASAEurPacChina
Jan-1016910212523
Feb-1018711513554
Mar-1021012815616
Apr-1022613616677
May-1023213717735
Jun-1026115119829
Jul-1024514018807
Aug-1022312816763
Sep-1019510315734
Oct-101749614622
Nov-101548411590
Dec-10163999541
Jan-1119512310593
Feb-1122114113625
Mar-1124015216666
Apr-11264163207011
May-1128317822758
Jun-11296170288612
Jul-11269153258110
Aug-1125614623798
Sep-1123113120737
Oct-1121412516685
Nov-1120111813664
Dec-111719611613
Jan-12200112156643
Feb-12216117187164
Mar-12234126207693
Apr-122531382379112
May-122821522685145
Jun-123051633091156
Jul-122961562889185
Aug-122791482686154
Sep-122661432482134
Oct-122431312176123
Nov-122321281873103
Dec-12203107157074
Jan-13216110197485
Feb-132391232379104
Mar-132661382683136
Apr-132841503088115
May-133151693391157
Jun-133401813795198
Jul-133191693492177
Aug-133041603290157
Sep-132771412987146
Oct-132501232683126
Nov-132281122477105
Dec-13213105237474
Jan-14240121268085
Feb-142511262882105
Mar-142811483185125
Apr-142981553589136
May-143221683995128
Jun-1435018343981511
Jul-1433017041951410
Aug-143111583893139
Sep-142891493389117
Oct-14265136308586
Nov-14239121268075
Dec-14219108237675

Complaints by Month and Region

World 40179 40210 40238 40269 40299 40330 40360 40391 40422 40452 40483 40513 40544 40575 40603 40634 40664 40695 40725 40756 40787 40817 40848 40878 40909 40940 40969 41000 41030 41061 41091 41122 41153 41183 41214 41244 41275 41306 41334 41365 41395 41426 41456 41487 41518 41548 41579 41609 41640 41671 41699 41730 41760 41791 41821 41852 41883 41913 41944 41974 169 187 210 226 232 261 245 223 195 174 154 163 195 221 240 264 283 296 269 256 231 214 201 171 200 216 234 253 282 305 296 279 266 243 232 203 216 239 266 284 315 340 319 304 277 250 228 213 240 251 281 298 322 350 330 311 289 265 239 219 NA 40179 40210 40238 40269 40299 40330 40360 40391 40422 40452 40483 40513 40544 40575 40603 40634 40664 40695 40725 40756 40787 40817 40848 40878 40909 40940 40969 41000 41030 41061 41091 41122 41153 41183 41214 41244 41275 41306 41334 41365 41395 41426 41456 41487 41518 41548 41579 41609 41640 41671 41699 41730 41760 41791 41821 41852 41883 41913 41944 41974 102 115 128 136 137 151 140 128 103 96 84 99 123 141 152 163 178 170 153 146 131 125 118 96 112 117 126 138 152 163 156 148 143 131 128 107 110 123 138 150 169 181 169 160 141 123 112 105 121 126 148 155 168 183 170 158 149 136 121 108 SA 40179 40210 40238 40269 40299 40330 40360 40391 40422 40452 40483 40513 40544 40575 40603 40634 40664 40695 40725 40756 40787 40817 40848 40878 40909 40940 40969 41000 41030 41061 41091 41122 41153 41183 41214 41244 41275 41306 41334 41365 41395 41426 41456 41487 41518 41548 41579 41609 41640 41671 41699 41730 41760 41791 41821 41852 41883 41913 41944 41974 12 13 15 16 17 19 18 16 15 14 11 9 10 13 16 20 22 28 25 23 20 16 13 11 15 18 20 23 26 30 28 26 24 21 18 15 19 23 26 30 33 37 34 32 29 26 24 23 26 28 31 35 39 43 41 38 33 30 26 23 Eur 40179 40210 40238 40269 40299 40330 40360 40391 40422 40452 40483 40513 40544 40575 40603 40634 40664 40695 40725 40756 40787 40817 40848 40878 40909 40940 40969 41000 41030 41061 41091 41122 41153 41183 41214 41244 41275 41306 41334 41365 41395 41426 41456 41487 41518 41548 41579 41609 41640 41671 41699 41730 41760 41791 41821 4185 2 41883 41913 41944 41974 52 55 61 67 73 82 80 76 73 62 59 54 59 62 66 70 75 86 81 79 73 68 66 61 66 71 76 79 85 91 89 86 82 76 73 70 74 79 83 88 91 95 92 90 87 83 77 74 80 82 85 89 95 98 95 93 89 85 80 76 Pac 40179 40210 40238 40269 40299 40330 40360 40391 40422 40452 40483 40513 40544 40575 40603 40634 40664 40695 40725 40756 40787 40817 40848 40878 40909 40940 40969 41000 41030 41061 41091 41122 41153 41183 41214 41244 41275 41306 41334 41365 41395 41426 41456 41487 41518 41548 41579 41609 41640 41671 41699 41730 41760 41791 41821 41852 41883 41913 41944 41974 3 4 6 7 5 9 7 3 4 2 0 1 3 5 6 11 8 12 10 8 7 5 4 3 4 6 9 11 14 15 18 15 13 12 10 7 8 10 13 11 15 19 17 15 14 12 10 7 8 10 12 13 12 15 14 13 11 8 7 7 China 40179 40210 40238 40269 40299 40330 40360 40391 40422 40452 40483 40513 40544 40575 40603 40634 40664 40695 40725 40756 40787 40817 40848 40878 40909 40940 40969 41000 41030 41061 41091 41122 41153 41183 41214 41244 41275 41306 41334 41365 41395 41426 41456 41487 41518 41548 41579 41609 41640 41671 41699 41730 41760 41791 41821 41852 41883 41913 41944 41974 3 4 3 2 5 6 5 4 4 3 3 4 5 4 6 5 7 8 7 7 6 6 5 4 5 5 5 6 8 11 10 9 7 6 5 5

This chart is showing PLE’s Complaints from registered customers each month within PLE’s 5 regions. From this data we can conclude that there is more use of the equipment in the summer months because of the higher number of complaints recieved. China has the fewest number of compaints, this is due to the less customer usage. Based off the data, the Pacific Rim and South America do not have as many complaints as North America does due to less people using or purchasing PLE’s equipment. .

Mower Unit Sales

Mower Unit Sales
tc={6A814A1A-8E51-48A1-A543-AEC7E2B5497F}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:
The chart identifies the unit sales PLE’s mower equipment. We can see that the highest peak for mower sales is in the summer months and then a decline in sales starting in early fall months. BAsed off this chart, North America is the region with the highest unit sales for PLE’s mowers.

MonthNASAEuropePacificChinaWorld
Jan-10600020072010007020
Feb-10795022099012009280
Mar-108100250132011009780
Apr-1090502801650120011100
May-1099003101590130011930
Jun-10102003001620120012240
Jul-1087302801590140010740
Aug-1081402501560130010080
Sep-106480230159013008430
Oct-105990220132012007650
Nov-10532021099013006650
Dec-10464018066014005620
Jan-11598021069014007020
Feb-117620240102015009030
Mar-1183702501290140010050
Apr-1188302901620150010890
May-1193103301650130011420
Jun-11102303101590140012270
Jul-1187202901560150010720
Aug-117710270153014009650
Sep-116320250159015008310
Oct-115840250126016007510
Nov-11496024090015006250
Dec-11435021066015005370
Jan-12602022057016006970
Feb-12792025084015009160
Mar-128430270111016009970
Apr-1290403101500170011020
May-1298203601440160011780
Jun-12103703301410170012280
Jul-1290503101440160010960
Aug-127620300141017009500
Sep-126420280135018008230
Oct-125890270108018007420
Nov-12534026084019006630
Dec-12443023051018005350
Jan-13610025048020007030
Feb-13801027075019009220
Mar-1384302801140200010050
Apr-1391103201410210011050
May-1397303801340190011640
Jun-13101203601360200012040
Jul-1390803201410200011010
Aug-137820310149021009830
Sep-136540300131022008370
Oct-13601029098021007490
Nov-13527027077022006530
Dec-13538026043023006300
Jan-14621027040020007080
Feb-14803028075019009250
Mar-148540300970210010020
Apr-1491203401310220510995
May-14957039012602001611436
Jun-141023038012402102212082
Jul-14958035013002302611486
Aug-1476803401250220149504
Sep-1468703201210220158635
Oct-145930310970230117451
Nov-14526030065024036453
Dec-14483029030023015651

Mower Unit Sales by Month and Region

NA 40179 40210 40238 40269 40299 40330 40360 40391 40422 40452 40483 40513 40544 40575 40603 40634 40664 40695 40725 40756 40787 40817 40848 40878 40909 40940 40969 41000 41030 41061 41091 41122 41153 41183 41214 41244 41275 41306 41334 41365 41395 41426 41456 41487 41518 41548 41579 41609 41640 41671 41699 41730 41760 41791 41821 41852 41883 41913 41944 41974 6000 7950 8100 9050 9900 10200 8730 8140 6480 5990 5320 4640 5980 7620 8370 8830 9310 10230 8720 7710 6320 5840 4960 4350 6020 7920 8430 9040 9820 10370 9050 7620 6420 5890 5340 4430 6100 8010 8430 9110 9730 10120 9080 7820 6540 6010 5270 5380 6210 8030 8540 9120 9570 10230 9580 7680 6870 5930 5260 4830 SA 40179 40210 40238 40269 40299 40330 40360 40391 40422 40452 40483 40513 40544 40575 40603 40634 40664 40695 40725 40756 40

Looking for this or a Similar Assignment? Click below to Place your Order