Description
One of PLE’s manufacturing plants supplies various engine components to manufacturers of motorcycles on a Just In Time basis. Planned production capacity for one component is 100 units per shift, and the plant operates one shift per day. Because of fluctuations in customers’ assembly operations, however, demand fluctuates and is historically between 80 and 130 units per day. To maintain sufficient inventory to meet its Just In Time commitments, PLE’s management is considering a policy to run a second shift the next day if inventory falls to 50 or below at the end of a day (after the daily demand is known). For the annual budget-planning process, managers need to know how many additional shifts will be needed. The fundamental equation that governs this process each day is:
ending inventory = beginning inventory + production − demand ending inventory = beginning inventory + production − demand
Develop a spreadsheet model to simulate 260 working days (one year), and count the number of additional shifts that are required. Assume that the initial inventory is 100 units. Use psi functions for all uncertain cells in building your model. Using the number of additional shifts required as the output cell for a Monte Carlo simulation, find the distribution of the number of shifts that the company can expect to need over the next year. Explain and summarize your findings in a report to the plant manager and make a recommendation as to how many shifts to plan in next year’s budget. Upload your Word document AND your Excel worksheet file to the Assignment drop box.
Plagiarism
You are expected to write primarily in your own voice, using paraphrase, summary, and synthesis techniques when integrating information from class and outside sources. Use an author’s exact words only when the language is especially vivid, unique, or needed for technical accuracy. Failure to do so may result in charges of academic dishonesty.
Overusing an author’s exact words, such as including block quotations to meet word counts, may lead your readers to conclude that you lack appropriate comprehension of the subject matter or that you are neither an original thinker nor a skillful writer.
Unformatted Attachment Preview
A
1
2
3
B
C
D
E
F
G
Mower Unit Sales
Month
NA
SA Europe Pacific China World
Jan-14 6000 200
720
100
0 7020
5
Feb-14 7950 220
990
120
0 9280
6
Mar-14 8100 250 1320
110
0 9780
7
Apr-14 9050 280 1650
120
0 ####
8
May-14 9900 310 1590
130
0 ####
9
Jun-14 10200 300 1620
120
0 ####
10
Jul-14 8730 280 1590
140
0 ####
11
Aug-14 8140 250 1560
130
0 ####
12
Sep-14 6480 230 1590
130
0 8430
13
Oct-14 5990 220 1320
120
0 7650
14
Nov-14 5320 210
990
130
0 6650
15
Dec-14 4640 180
660
140
0 5620
16
Jan-15 5980 210
690
140
0 7020
17
Feb-15 7620 240 1020
150
0 9030
18
Mar-15 8370 250 1290
140
0 ####
19
Apr-15 8830 290 1620
150
0 ####
20
May-15 9310 330 1650
130
0 ####
21
Jun-15 10230 310 1590
140
0 ####
22
Jul-15 8720 290 1560
150
0 ####
23
Aug-15 7710 270 1530
140
0 9650
24
Sep-15 6320 250 1590
150
0 8310
25
Oct-15 5840 250 1260
160
0 7510
26
Nov-15 4960 240
900
150
0 6250
27
Dec-15 4350 210
660
150
0 5370
28
Jan-16 6020 220
570
160
0 6970
29
Feb-16 7920 250
840
150
0 9160
30
Mar-16 8430 270 1110
160
0 9970
31
Apr-16 9040 310 1500
170
0 ####
32
May-16 9820 360 1440
160
0 ####
33
Jun-16 10370 330 1410
170
0 ####
34
Jul-16 9050 310 1440
160
0 ####
35
Aug-16 7620 300 1410
170
0 9500
36
Sep-16 6420 280 1350
180
0 8230
37
Oct-16 5890 270 1080
180
0 7420
38
Nov-16 5340 260
840
190
0 6630
39
Dec-16 4430 230
510
180
0 5350
40
Jan-17 6100 250
480
200
0 7030
41
Feb-17 8010 270
750
190
0 9220
42
Mar-17 8430 280 1140
200
0 ####
43
Apr-17 9110 320 1410
210
0 ####
44
May-17 9730 380 1340
190
0 ####
45
Jun-17 10120 360 1360
200
0 ####
46
Jul-17 9080 320 1410
200
0 ####
47
Aug-17 7820 310 1490
210
0 9830
48
Sep-17 6540 300 1310
220
0 8370
49
Oct-17 6010 290
980
210
0 7490
50
Nov-17 5270 270
770
220
0 6530
51
Dec-17 5380 260
430
230
0 6300
52
Jan-18 6210 270
400
200
0 7080
53
Feb-18 8030 280
750
190
0 9250
54
Mar-18 8540 300
970
210
5 ####
55
Apr-18 9120 340 1310
220
16 ####
56
May-18 9570 390 1260
200
22 ####
57
Jun-18 10230 380 1240
210
26 ####
58
Jul-18 9580 350 1300
230
14 ####
59
Aug-18 7680 340 1250
220
15 9505
60
Sep-18 6870 320 1210
220
11 8631
61
Oct-18 5930 310
970
230
3 7443
62
Nov-18 5260 300
650
240
1 6451
63
Dec-18 4830 290
300
230
0 5650
4
Tractor Unit Sales
Month NA
SA
Eur
Pacific China World
Jan-14
570
250
560
212
0
1592
Feb-14
611
270
600
230
0
1711
Mar-14
630
260
680
240
0
1810
Apr-14
684
270
650
263
0
1867
May-14
650
280
580
269
0
1779
Jun-14
600
270
590
280
0
1740
Jul-14
512
264
760
290
0
1826
Aug-14
500
280
645
270
0
1695
Sep-14
478
290
650
263
0
1681
Oct-14
455
280
670
258
0
1663
Nov-14
407
290
888
240
0
1825
Dec-14
360
280
850
230
0
1720
Jan-15
571
320
620
250
0
1761
Feb-15
650
350
760
275
0
2035
Mar-15
740
390
742
270
0
2142
Apr-15
840
440
780
280
0
2340
May-15
830
470
690
290
0
2280
Jun-15
760
490
721
300
0
2271
Jul-15
681
481
680
312
0
2154
Aug-15
670
460
711
305
0
2146
Sep-15
640
460
695
290
0
2085
Oct-15
620
440
650
260
0
1970
Nov-15
570
436
680
250
0
1936
Dec-15
533
420
657
240
0
1850
Jan-16
620
510
610
250
10
2000
Feb-16
792
590
680
250
12
2324
Mar-16
890
610
730
260
20
2510
Apr-16
960
600
820
270
22
2672
May-16
1040
620
810
290
20
2780
Jun-16
1032
640
807
310
24
2813
Jul-16
1006
590
760
340
20
2716
Aug-16
910
600
720
320
31
2581
Sep-16
803
670
660
313
30
2476
Oct-16
730
630
630
290
37
2317
Nov-16
699
710
603
280
32
2324
Dec-16
647
570
570
260
33
2080
Jan-17
730
650
500
287
35
2202
Feb-17
930
680
590
290
50
2540
Mar-17
1160
724
620
300
63
2867
Apr-17
1510
730
730
310
68
3348
May-17
1650
760
740
330
70
3550
Jun-17
1490
800
720
340
82
3432
Jul-17
1460
840
670
350
80
3400
Aug-17
1390
830
610
341
90
3261
Sep-17
1360
820
599
330
100
3209
Oct-17
1340
810
560
320
102
3132
Nov-17
1240
827
550
300
110
3027
Dec-17
1103
750
520
290
114
2777
Jan-18
1250
780
480
200
111
2821
Feb-18
1550
805
523
210
121
3209
Mar-18
1820
830
560
220
123
3553
Apr-18
2010
890
570
230
120
3820
May-18
2230
930
590
253
130
4133
Jun-18
2490
980
600
270
136
4476
Jul-18
2440
1002
580
280
134
4436
Aug-18
2334
970
570
250
132
4256
Sep-18
2190
960
550
230
137
4067
Oct-18
2080
930
530
220
130
3890
Nov-18
2050
920
517
190
139
3816
Dec-18
2004
902
490
190
131
3717
Month
Mower Unit Sales
Jan-14
Feb-14
Mar-14
Apr-14
May-14
Jun-14
Jul-14
Aug-14
Sep-14
Oct-14
Nov-14
Dec-14
Jan-15
Feb-15
Mar-15
Apr-15
May-15
Jun-15
Jul-15
Aug-15
Sep-15
Oct-15
Nov-15
Dec-15
Jan-16
Feb-16
Mar-16
Apr-16
May-16
Jun-16
Jul-16
Aug-16
Sep-16
Oct-16
Nov-16
Dec-16
Jan-17
Feb-17
Mar-17
Apr-17
May-17
Jun-17
Jul-17
Tractor Unit Sales
7020
1592
9280
1711
9780
1810
11100
1867
11930
1779
12240
1740
10740
1826
10080
1695
8430
1681
7650
1663
6650
1825
5620
1720
7020
1761
9030
2035
10050
2142
10890
2340
11420
2280
12270
2271
10720
2154
9650
2146
8310
2085
7510
1970
6250
1936
5370
1850
6970
2000
9160
2324
9970
2510
11020
2672
11780
2780
12280
2813
10960
2716
9500
2581
8230
2476
30000000
7420
2317
25000000
6630
2324
20000000
5350
2080
15000000
7030
2202
10000000
9220
2540
5000000
10050
2867
11050
3348
11640
3550
12040
3432
11010
3400
40000000
35000000
Aug-17
Sep-17
Oct-17
Nov-17
Dec-17
Jan-18
Feb-18
Mar-18
Apr-18
May-18
Jun-18
Jul-18
Aug-18
Sep-18
Oct-18
Nov-18
Dec-18
9830
3261
8370
3209
7490
3132
6530
3027
6300
2777
7080
2821
9250
3209
10025
3553
11006
3820
11442
4133
12086
4476
11474
4436
9505
4256
8631
4067
7443
3890
6451
3816
5650
3717
Unit Cost Production TractorUnit Cost production Mower Total Mower Cost
1750
50
351000
1755
50
464000
1763
51
498780
1770
51
566100
1778
51
608430
1785
51
624240
1792
51
547740
1795
51
514080
1801
52
438360
1804
52
397800
1810
52
345800
1813
52
292240
1835
55
386100
1841
55
496650
1848
55
552750
1854
55
598950
1860
56
639520
1866
56
687120
1872
56
600320
1878
56
540400
1885
56
465360
1892
57
428070
1897
57
356250
1903
57
306090
1925
59
411230
1931
59
540440
1938
59
588230
1944
59
650180
1950
Selling
Expense
59
695020
60
736800
1963
60
657600
60
570000
1956
40000000
35000000
1969
y = 7E-177e0.2096x
R² = 0.999
30000000
1976
60
493800
25000000
1983
60
445200
20000000
1990
61
404430
15000000
1996
61
326350
10000000
2011
59
414770
5000000
2001
59
543980
59
592950
59
651950
0
2013
2024
2014
2015
2016
2030
Year
2039
2017
2018
2019
60
698400
2026
60
722400
2034
60
660600
2033
60
589800
2056
60
502200
2065
60
449400
2068
61
398330
2069
61
384300
2073
63
446040
2077
63
582750
2081
63
631575
2086
63
693378
2092
63
720846
2098
63
761418
2104
64
734336
2110
64
608320
2116
64
552384
2122
64
476352
2129
64
412864
2135
64
361600
Total Tractor cost
2786000
Year
Gross Revenue for Mower
3002805
2014
5648570
3191030
2015
6057580
3304590
2016
6519280
3163062
2017
6609080
3105900
2018
6981863
3272192
3042525
3027481
Year
Mower Price/unit
3000052
2014
150
3303250
2015
175
3118360
2016
180
3231435
2017
185
3746435
2018
190
3958416
4338360
4240800
Dealers Commission
18%
4237686
YEAR
2014
4032288
Total Sales Revenue
84532250
4030188
Total COGS
42965817
3930225
Selling Expense
15215805
3727240
Total Operating Expenses
9375948
3672592
Pre-tax
16974680
3520550
Tax Expense
8487340
3850000
Net Income
8487340
4487644
25000000
4864380
5194368
20000000
Total Sales Revenue vs Year
5421000
5502228
250000000
15000000
200000000
y = 4E-176e0.2096x
10000000
R² = 0.999
5331508
4892576
4594611
4624760
4151680
4428222
5082540
5802808
6796440
7238450
6953232
6915600
TotalSales
5081989
150000000
5000000
100000000
0
2013.5 2014 2014.5 2015
50000000
0
2013
2014
2015
2016
Year
2017
2018
2019
6629613
6597704
6467580
6259836
5745613
5847933
6665093
7393793
7968520
8646236
9390648
9333344
8980160
8605772
8254580
8124264
7935795
Goss Revenue for Tractor
37317247
46666215
57996744
74917638
97146138
Tractor Price/unit
Total unit sales Total
for Tractors
unit sales for Mowers
Gross Revenue for Mower
Net Income
3250
110520
20909
16578000
3400
108490
24970
18985750
3600
109270
29593
19668600
3700
110560
36745
20453600
3800
110043
46194
20908170
2015
2016
2017
2018
103883750
126203400
156410100
196445370
52723795
64516024
81526718
104128001
18699075
22716612
28153818
35360166.6
10071429
11511717
10337905
10343775
22389451
27459047
36391659
46613427.4
11194725.5
13729523.5
18195829.5
23306713.7
11194725.5
13729523.5
18195829.5
23306713.7
y = 5E-213e0.2506x
R² = 0.9986
Total Operating Expenses vs Year
Total COGS
14000000
90000000
12000000
Total Cogs
70000000
Operating Expense
y = 8E-179e0.2123x
R² = 0.9985
80000000
60000000
50000000
40000000
2015 2015.5 2016 2016.5 2017 2017.5 2018 2018.5
30000000
8000000
6000000
4000000
2000000
20000000
0
2013
10000000
0
2013
10000000
2014
2015
2016
year
2017
2018
2014
2015
Goss Revenue for Tractor
67954250
84898000
106534800
135956500
175537200
l Operating Expenses vs Year
y = 3E-13e0.0223x
R² = 0.1961
2015
2016
Year
2017
2018
2019
Operating and Interest Expenses
Month
Administrative
Depreciation
Interest
Jan-14
$633,073
$140,467
$7,244
Feb-14
$607,904
$165,636
$7,679
Mar-14
$630,687
$142,853
$6,887
Apr-14
$613,401
$160,139
$6,917
May-14
$607,664
$165,876
$8,316
Jun-14
$632,967
$140,573
$7,428
Jul-14
$609,604
$163,936
$8,737
Aug-14
$607,749
$165,791
$7,054
Sep-14
$603,367
$170,173
$8,862
Oct-14
$629,083
$144,457
$8,488
Nov-14
$611,995
$161,545
$7,049
Dec-14
$625,712
$147,828
$8,807
Jan-15
$656,123
$175,447
$7,430
Feb-15
$652,679
$178,891
$6,791
Mar-15
$655,521
$176,049
$8,013
Apr-15
$676,581
$154,989
$8,979
May-15
$676,581
$154,989
$7,484
Jun-15
$656,440
$175,130
$7,858
Jul-15
$661,969
$169,601
$7,424
Aug-15
$677,212
$154,358
$6,848
Sep-15
$653,545
$178,025
$6,751
Oct-15
$657,388
$174,182
$8,160
Nov-15
$672,475
$159,095
$7,898
Dec-15
$656,325
$175,245
$8,953
Jan-16
$723,594
$226,526
$9,443
Feb-16
$759,042
$191,078
$8,464
Mar-16
$749,187
$200,933
$10,264
Apr-16
$751,499
$198,621
$8,547
May-16
$741,452
$208,668
$8,578
Jun-16
$729,122
$220,998
$9,519
Jul-16
$734,783
$215,337
$9,343
Aug-16
$748,208
$201,912
$8,448
Sep-16
$738,186
$211,934
$9,957
Oct-16
$759,403
$190,717
$9,738
Nov-16
$726,183
$223,937
$9,785
Dec-16
$757,037
$193,083
$8,191
Jan-17
$672,232
$179,138
$9,914
Feb-17
$665,023
$186,347
$9,954
Mar-17
$667,657
$183,713
$10,859
Apr-17
May-17
Jun-17
Jul-17
Aug-17
Sep-17
Oct-17
Nov-17
Dec-17
Jan-18
Feb-18
Mar-18
Apr-18
May-18
Jun-18
Jul-18
Aug-18
Sep-18
Oct-18
Nov-18
Dec-18
$654,198
$659,435
$661,190
$647,321
$666,743
$678,705
$658,990
$656,221
$676,934
$641,571
$634,973
$662,054
$654,962
$645,579
$658,112
$637,711
$638,317
$651,996
$630,766
$645,095
$637,807
$197,172
$191,935
$190,180
$204,049
$184,627
$172,665
$192,380
$195,149
$174,436
$210,589
$217,187
$190,106
$197,198
$206,581
$194,048
$214,449
$213,843
$200,164
$221,394
$207,065
$214,353
$9,730
$10,430
$10,222
$10,102
$10,610
$9,374
$10,830
$9,017
$10,423
$9,985
$9,766
$11,148
$9,339
$9,468
$10,324
$9,737
$9,290
$9,213
$10,143
$10,383
$9,059
Year
Operating expenes
2014
$9,375,948
2015
$10,071,429
2016
$11,511,717
2017
$10,337,905
2018
$10,343,775
Unit Production Costs
Month
Tractor
Jan-14
Feb-14
Mar-14
Apr-14
May-14
Jun-14
Jul-14
Aug-14
Sep-14
Oct-14
Nov-14
Dec-14
Jan-15
Feb-15
Mar-15
Apr-15
May-15
Jun-15
Jul-15
Aug-15
Sep-15
Oct-15
Nov-15
Dec-15
Jan-16
Feb-16
Mar-16
Apr-16
May-16
Jun-16
Jul-16
Aug-16
Sep-16
Oct-16
Nov-16
Dec-16
Jan-17
Feb-17
Mar-17
Mower
$1,750
$50
$1,755
$50
$1,763
$51
$1,770
$51
$1,778
$51
$1,785
$51
$1,792
$51
$1,795
$51
$1,801
$52
$1,804
$52
$1,810
$52
$1,813
$52
$1,835
$55
$1,841
$55
$1,848
$55
$1,854
$55
$1,860
$56
$1,866
$56
$1,872
$56
$1,878
$56
$1,885
$56
$1,892
$57
$1,897
$57
$1,903
$57
$1,925
$59
$1,931
$59
$1,938
$59
$1,944
$59
$1,950
$59
$1,956
$60
$1,963
$60
$1,969
$60
$1,976
$60
$1,983
$60
$1,990
$61
$1,996
$61
$2,011
$59
$2,001
$59
$2,024
$59
Apr-17
May-17
Jun-17
Jul-17
Aug-17
Sep-17
Oct-17
Nov-17
Dec-17
Jan-18
Feb-18
Mar-18
Apr-18
May-18
Jun-18
Jul-18
Aug-18
Sep-18
Oct-18
Nov-18
Dec-18
$2,030
$2,039
$2,026
$2,034
$2,033
$2,056
$2,065
$2,068
$2,069
$2,073
$2,077
$2,081
$2,086
$2,092
$2,098
$2,104
$2,110
$2,116
$2,122
$2,129
$2,135
$59
$60
$60
$60
$60
$60
$60
$61
$61
$63
$63
$63
$63
$63
$63
$64
$64
$64
$64
$64
$64
A
1
2
3
B
C
D
E
F
G
Mower Unit Sales
Month
NA
SA Europe Pacific China World
Jan-14 6000 200
720
100
0 7020
5
Feb-14 7950 220
990
120
0 9280
6
Mar-14 8100 250 1320
110
0 9780
7
Apr-14 9050 280 1650
120
0 ####
8
May-14 9900 310 1590
130
0 ####
9
Jun-14 10200 300 1620
120
0 ####
10
Jul-14 8730 280 1590
140
0 ####
11
Aug-14 8140 250 1560
130
0 ####
12
Sep-14 6480 230 1590
130
0 8430
13
Oct-14 5990 220 1320
120
0 7650
14
Nov-14 5320 210
990
130
0 6650
15
Dec-14 4640 180
660
140
0 5620
16
Jan-15 5980 210
690
140
0 7020
17
Feb-15 7620 240 1020
150
0 9030
18
Mar-15 8370 250 1290
140
0 ####
19
Apr-15 8830 290 1620
150
0 ####
20
May-15 9310 330 1650
130
0 ####
21
Jun-15 10230 310 1590
140
0 ####
22
Jul-15 8720 290 1560
150
0 ####
23
Aug-15 7710 270 1530
140
0 9650
24
Sep-15 6320 250 1590
150
0 8310
25
Oct-15 5840 250 1260
160
0 7510
26
Nov-15 4960 240
900
150
0 6250
27
Dec-15 4350 210
660
150
0 5370
28
Jan-16 6020 220
570
160
0 6970
29
Feb-16 7920 250
840
150
0 9160
30
Mar-16 8430 270 1110
160
0 9970
31
Apr-16 9040 310 1500
170
0 ####
32
May-16 9820 360 1440
160
0 ####
33
Jun-16 10370 330 1410
170
0 ####
34
Jul-16 9050 310 1440
160
0 ####
35
Aug-16 7620 300 1410
170
0 9500
36
Sep-16 6420 280 1350
180
0 8230
37
Oct-16 5890 270 1080
180
0 7420
38
Nov-16 5340 260
840
190
0 6630
39
Dec-16 4430 230
510
180
0 5350
40
Jan-17 6100 250
480
200
0 7030
41
Feb-17 8010 270
750
190
0 9220
42
Mar-17 8430 280 1140
200
0 ####
43
Apr-17 9110 320 1410
210
0 ####
44
May-17 9730 380 1340
190
0 ####
45
Jun-17 10120 360 1360
200
0 ####
46
Jul-17 9080 320 1410
200
0 ####
47
Aug-17 7820 310 1490
210
0 9830
48
Sep-17 6540 300 1310
220
0 8370
49
Oct-17 6010 290
980
210
0 7490
50
Nov-17 5270 270
770
220
0 6530
51
Dec-17 5380 260
430
230
0 6300
52
Jan-18 6210 270
400
200
0 7080
53
Feb-18 8030 280
750
190
0 9250
54
Mar-18 8540 300
970
210
5 ####
55
Apr-18 9120 340 1310
220
16 ####
56
May-18 9570 390 1260
200
22 ####
57
Jun-18 10230 380 1240
210
26 ####
58
Jul-18 9580 350 1300
230
14 ####
59
Aug-18 7680 340 1250
220
15 9505
60
Sep-18 6870 320 1210
220
11 8631
61
Oct-18 5930 310
970
230
3 7443
62
Nov-18 5260 300
650
240
1 6451
63
Dec-18 4830 290
300
230
0 5650
4
Tractor Unit Sales
Month NA
SA
Eur
Pacific China World
Jan-14
570
250
560
212
0
1592
Feb-14
611
270
600
230
0
1711
Mar-14
630
260
680
240
0
1810
Apr-14
684
270
650
263
0
1867
May-14
650
280
580
269
0
1779
Jun-14
600
270
590
280
0
1740
Jul-14
512
264
760
290
0
1826
Aug-14
500
280
645
270
0
1695
Sep-14
478
290
650
263
0
1681
Oct-14
455
280
670
258
0
1663
Nov-14
407
290
888
240
0
1825
Dec-14
360
280
850
230
0
1720
Jan-15
571
320
620
250
0
1761
Feb-15
650
350
760
275
0
2035
Mar-15
740
390
742
270
0
2142
Apr-15
840
440
780
280
0
2340
May-15
830
470
690
290
0
2280
Jun-15
760
490
721
300
0
2271
Jul-15
681
481
680
312
0
2154
Aug-15
670
460
711
305
0
2146
Sep-15
640
460
695
290
0
2085
Oct-15
620
440
650
260
0
1970
Nov-15
570
436
680
250
0
1936
Dec-15
533
420
657
240
0
1850
Jan-16
620
510
610
250
10
2000
Feb-16
792
590
680
250
12
2324
Mar-16
890
610
730
260
20
2510
Apr-16
960
600
820
270
22
2672
May-16
1040
620
810
290
20
2780
Jun-16
1032
640
807
310
24
2813
Jul-16
1006
590
760
340
20
2716
Aug-16
910
600
720
320
31
2581
Sep-16
803
670
660
313
30
2476
Oct-16
730
630
630
290
37
2317
Nov-16
699
710
603
280
32
2324
Dec-16
647
570
570
260
33
2080
Jan-17
730
650
500
287
35
2202
Feb-17
930
680
590
290
50
2540
Mar-17
1160
724
620
300
63
2867
Apr-17
1510
730
730
310
68
3348
May-17
1650
760
740
330
70
3550
Jun-17
1490
800
720
340
82
3432
Jul-17
1460
840
670
350
80
3400
Aug-17
1390
830
610
341
90
3261
Sep-17
1360
820
599
330
100
3209
Oct-17
1340
810
560
320
102
3132
Nov-17
1240
827
550
300
110
3027
Dec-17
1103
750
520
290
114
2777
Jan-18
1250
780
480
200
111
2821
Feb-18
1550
805
523
210
121
3209
Mar-18
1820
830
560
220
123
3553
Apr-18
2010
890
570
230
120
3820
May-18
2230
930
590
253
130
4133
Jun-18
2490
980
600
270
136
4476
Jul-18
2440
1002
580
280
134
4436
Aug-18
2334
970
570
250
132
4256
Sep-18
2190
960
550
230
137
4067
Oct-18
2080
930
530
220
130
3890
Nov-18
2050
920
517
190
139
3816
Dec-18
2004
902
490
190
131
3717
Month
Mower Unit Sales
Jan-14
Feb-14
Mar-14
Apr-14
May-14
Jun-14
Jul-14
Aug-14
Sep-14
Oct-14
Nov-14
Dec-14
Jan-15
Feb-15
Mar-15
Apr-15
May-15
Jun-15
Jul-15
Aug-15
Sep-15
Oct-15
Nov-15
Dec-15
Jan-16
Feb-16
Mar-16
Apr-16
May-16
Jun-16
Jul-16
Aug-16
Sep-16
Oct-16
Nov-16
Dec-16
Jan-17
Feb-17
Mar-17
Apr-17
May-17
Jun-17
Jul-17
Tractor Unit Sales
7020
1592
9280
1711
9780
1810
11100
1867
11930
1779
12240
1740
10740
1826
10080
1695
8430
1681
7650
1663
6650
1825
5620
1720
7020
1761
9030
2035
10050
2142
10890
2340
11420
2280
12270
2271
10720
2154
9650
2146
8310
2085
7510
1970
6250
1936
5370
1850
6970
2000
9160
2324
9970
2510
11020
2672
11780
2780
12280
2813
10960
2716
9500
2581
8230
2476
30000000
7420
2317
25000000
6630
2324
20000000
5350
2080
15000000
7030
2202
10000000
9220
2540
5000000
10050
2867
11050
3348
11640
3550
12040
3432
11010
3400
40000000
35000000
Aug-17
Sep-17
Oct-17
Nov-17
Dec-17
Jan-18
Feb-18
Mar-18
Apr-18
May-18
Jun-18
Jul-18
Aug-18
Sep-18
Oct-18
Nov-18
Dec-18
9830
3261
8370
3209
7490
3132
6530
3027
6300
2777
7080
2821
9250
3209
10025
3553
11006
3820
11442
4133
12086
4476
11474
4436
9505
4256
8631
4067
7443
3890
6451
3816
5650
3717
Unit Cost Production TractorUnit Cost production Mower Total Mower Cost
1750
50
351000
1755
50
464000
1763
51
498780
1770
51
566100
1778
51
608430
1785
51
624240
1792
51
547740
1795
51
514080
1801
52
438360
1804
52
397800
1810
52
345800
1813
52
292240
1835
55
386100
1841
55
496650
1848
55
552750
1854
55
598950
1860
56
639520
1866
56
687120
1872
56
600320
1878
56
540400
1885
56
465360
1892
57
428070
1897
57
356250
1903
57
306090
1925
59
411230
1931
59
540440
1938
59
588230
1944
59
650180
1950
Selling
Expense
59
695020
60
736800
1963
60
657600
60
570000
1956
40000000
35000000
1969
y = 7E-177e0.2096x
R² = 0.999
30000000
1976
60
493800
25000000
1983
60
445200
20000000
1990
61
404430
15000000
1996
61
326350
10000000
2011
59
414770
5000000
2001
59
543980
59
592950
59
651950
0
2013
2024
2014
2015
2016
2030
Year
2039
2017
2018
2019
60
698400
2026
60
722400
2034
60
660600
2033
60
589800
2056
60
502200
2065
60
449400
2068
61
398330
2069
61
384300
2073
63
446040
2077
63
582750
2081
63
631575
2086
63
693378
2092
63
720846
2098
63
761418
2104
64
734336
2110
64
608320
2116
64
552384
2122
64
476352
2129
64
412864
2135
64
361600
Total Tractor cost
2786000
Year
Gross Revenue for Mower
3002805
2014
5648570
3191030
2015
6057580
3304590
2016
6519280
3163062
2017
6609080
3105900
2018
6981863
3272192
3042525
3027481
Year
Mower Price/unit
3000052
2014
150
3303250
2015
175
3118360
2016
180
3231435
2017
185
3746435
2018
190
3958416
4338360
4240800
Dealers Commission
18%
4237686
YEAR
2014
4032288
Total Sales Revenue
84532250
4030188
Total COGS
42965817
3930225
Selling Expense
15215805
3727240
Total Operating Expenses
9375948
3672592
Pre-tax
16974680
3520550
Tax Expense
8487340
3850000
Net Income
8487340
4487644
25000000
4864380
5194368
20000000
Total Sales Revenue vs Year
5421000
5502228
250000000
15000000
200000000
y = 4E-176e0.2096x
10000000
R² = 0.999
5331508
4892576
4594611
4624760
4151680
4428222
5082540
5802808
6796440
7238450
6953232
6915600
TotalSales
5081989
150000000
5000000
100000000
0
2013.5 2014 2014.5 2015
50000000
0
2013
2014
2015
2016
Year
2017
2018
2019
6629613
6597704
6467580
6259836
5745613
5847933
6665093
7393793
7968520
8646236
9390648
9333344
8980160
8605772
8254580
8124264
7935795
Goss Revenue for Tractor
37317247
46666215
57996744
74917638
97146138
Tractor Price/unit
Total unit sales Total
for Tractors
unit sales for Mowers
Gross Revenue for Mower
Net Income
3250
110520
20909
16578000
3400
108490
24970
18985750
3600
109270
29593
19668600
3700
110560
36745
20453600
3800
110043
46194
20908170
2015
2016
2017
2018
103883750
126203400
156410100
196445370
52723795
64516024
81526718
104128001
18699075
22716612
28153818
35360166.6
10071429
11511717
10337905
10343775
22389451
27459047
36391659
46613427.4
11194725.5
13729523.5
18195829.5
23306713.7
11194725.5
13729523.5
18195829.5
23306713.7
y = 5E-213e0.2506x
R² = 0.9986
Total Operating Expenses vs Year
Total COGS
14000000
90000000
12000000
Total Cogs
70000000
Operating Expense
y = 8E-179e0.2123x
R² = 0.9985
80000000
60000000
50000000
40000000
2015 2015.5 2016 2016.5 2017 2017.5 2018 2018.5
30000000
8000000
6000000
4000000
2000000
20000000
0
2013
10000000
0
2013
10000000
2014
2015
2016
year
2017
2018
2014
2015
Goss Revenue for Tractor
67954250
84898000
106534800
135956500
175537200
l Operating Expenses vs Year
y = 3E-13e0.0223x
R² = 0.1961
2015
2016
Year
2017
2018
2019
Operating and Interest Expenses
Month
Administrative
Depreciation
Interest
Jan-14
$633,073
$140,467
$7,244
Feb-14
$607,904
$165,636
$7,679
Mar-14
$630,687
$142,853
$6,887
Apr-14
$613,401
$160,139
$6,917
May-14
$607,664
$165,876
$8,316
Jun-14
$632,967
$140,573
$7,428
Jul-14
$609,604
$163,936
$8,737
Aug-14
$607,749
$165,791
$7,054
Sep-14
$603,367
$170,173
$8,862
Oct-14
$629,083
$144,457
$8,488
Nov-14
$611,995
$161,545
$7,049
Dec-14
$625,712
$147,828
$8,807
Jan-15
$656,123
$175,447
$7,430
Feb-15
$652,679
$178,891
$6,791
Mar-15
$655,521
$176,049
$8,013
Apr-15
$676,581
$154,989
$8,979
May-15
$676,581
$154,989
$7,484
Jun-15
$656,440
$175,130
$7,858
Jul-15
$661,969
$169,601
$7,424
Aug-15
$677,212
$154,358
$6,848
Sep-15
$653,545
$178,025
$6,751
Oct-15
$657,388
$174,182
$8,160
Nov-15
$672,475
$159,095
$7,898
Dec-15
$656,325
$175,245
$8,953
Jan-16
$723,594
$226,526
$9,443
Feb-16
$759,042
$191,078
$8,464
Mar-16
$749,187
$200,933
$10,264
Apr-16
$751,499
$198,621
$8,547
May-16
$741,452
$208,668
$8,578
Jun-16
$729,122
$220,998
$9,519
Jul-16
$734,783
$215,337
$9,343
Aug-16
$748,208
$201,912
$8,448
Sep-16
$738,186
$211,934
$9,957
Oct-16
$759,403
$190,717
$9,738
Nov-16
$726,183
$223,937
$9,785
Dec-16
$757,037
$193,083
$8,191
Jan-17
$672,232
$179,138
$9,914
Feb-17
$665,023
$186,347
$9,954
Mar-17
$667,657
$183,713
$10,859
Apr-17
May-17
Jun-17
Jul-17
Aug-17
Sep-17
Oct-17
Nov-17
Dec-17
Jan-18
Feb-18
Mar-18
Apr-18
May-18
Jun-18
Jul-18
Aug-18
Sep-18
Oct-18
Nov-18
Dec-18
$654,198
$659,435
$661,190
$647,321
$666,743
$678,705
$658,990
$656,221
$676,934
$641,571
$634,973
$662,054
$654,962
$645,579
$658,112
$637,711
$638,317
$651,996
$630,766
$645,095
$637,807
$197,172
$191,935
$190,180
$204,049
$184,627
$172,665
$192,380
$195,149
$174,436
$210,589
$217,187
$190,106
$197,198
$206,581
$194,048
$214,449
$213,843
$200,164
$221,394
$207,065
$214,353
$9,730
$10,430
$10,222
$10,102
$10,610
$9,374
$10,830
$9,017
$10,423
$9,985
$9,766
$11,148
$9,339
$9,468
$10,324
$9,737
$9,290
$9,213
$10,143
$10,383
$9,059
Year
Operating expenes
2014
$9,375,948
2015
$10,071,429
2016
$11,511,717
2017
$10,337,905
2018
$10,343,775
Unit Production Costs
Month
Tractor
Jan-14
Feb-14
Mar-14
Apr-14
May-14
Jun-14
Jul-14
Aug-14
Sep-14
Oct-14
Nov-14
Dec-14
Jan-15
Feb-15
Mar-15
Apr-15
May-15
Jun-15
Jul-15
Aug-15
Sep-15
Oct-15
Nov-15
Dec-15
Jan-16
Feb-16
Mar-16
Apr-16
May-16
Jun-16
Jul-16
Aug-16
Sep-16
Oct-16
Nov-16
Dec-16
Jan-17
Feb-17
Mar-17
Mower
$1,750
$50
$1,755
$50
$1,763
$51
$1,770
$51
$1,778
$51
$1,785
$51
$1,792
$51
$1,795
$51
$1,801
$52
$1,804
$52
$1,810
$52
$1,813
$52
$1,835
$55
$1,841
$55
$1,848
$55
$1,854
$55
$1,860
$56
$1,866
$56
$1,872
$56
$1,878
$56
$1,885
$56
$1,892
$57
$1,897
$57
$1,903
$57
$1,925
$59
$1,931
$59
$1,938
$59
$1,944
$59
$1,950
$59
$1,956
$60
$1,963
$60
$1,969
$60
$1,976
$60
$1,983
$60
$1,990
$61
$1,996
$61
$2,011
$59
$2,001
$59
$2,024
$59
Apr-17
May-17
Jun-17
Jul-17
Aug-17
Sep-17
Oct-17
Nov-17
Dec-17
Jan-18
Feb-18
Mar-18
Apr-18
May-18
Jun-18
Jul-18
Aug-18
Sep-18
Oct-18
Nov-18
Dec-18
$2,030
$2,039
$2,026
$2,034
$2,033
$2,056
$2,065
$2,068
$2,069
$2,073
$2,077
$2,081
$2,086
$2,092
$2,098
$2,104
$2,110
$2,116
$2,122
$2,129
$2,135
$59
$60
$60
$60
$60
$60
$60
$61
$61
$63
$63
$63
$63
$63
$63
$64
$64
$64
$64
$64
$64
Dealer Satisfaction
Survey Scale:
North America
2014
2015
2016
2017
2018
0
1
2
3
4
1
0
1
1
2
0
0
1
2
3
2
2
1
6
5
14
14
8
12
15
22
20
34
34
44
5 Sample
Size
11
50
14
50
15
60
45
100
56
125
0
0
0
0
1
0
0
0
1
1
0
0
1
1
2
2
2
4
3
4
6
6
11
12
22
2
2
14
33
60
10
10
30
50
90
2014
2015
2016
2017
2018
0
0
0
0
0
0
0
0
0
0
1
1
1
1
1
3
2
2
2
4
7
8
15
21
17
4
4
7
6
8
15
15
25
30
30
Pacific Rim
2014
2015
2016
2017
2018
0
0
0
0
0
0
0
0
0
0
1
1
1
0
1
2
1
1
2
2
2
3
3
5
7
0
0
1
3
2
5
5
6
10
12
0
0
0
0
0
0
0
1
1
1
4
5
0
2
8
0
0
2
1
7
16
South America
2014
2015
2016
2017
2018
Europe
China
2016
2017
2018
End-User Satisfaction
0
1
2
3
4
Sample
5 Size
1
1
1
0
0
3
2
2
2
2
6
4
5
4
3
15
18
17
15
15
37
35
34
33
31
38
40
41
46
49
100
100
100
100
100
1
1
0
0
0
2
3
2
2
2
5
6
6
5
5
18
17
19
20
19
36
36
37
37
37
38
37
36
36
37
100
100
100
100
100
2014
2015
2016
2017
2018
1
1
1
1
0
2
2
1
1
1
4
5
4
3
2
21
21
26
17
19
36
34
37
41
45
36
37
31
37
33
100
100
100
100
100
Pacific Rim
2014
2015
2016
2017
2018
2
1
1
0
0
3
2
2
2
1
5
7
5
4
3
15
15
16
17
19
41
41
40
40
42
34
34
36
37
35
100
100
100
100
100
0
1
0
3
2
1
3
2
1
6
4
3
28 10
30 11
31 14
50
50
50
Survey Scale:
North America
2014
2015
2016
2017
2018
South America
2014
2015
2016
2017
2018
Europe
China
2016
2017
2018
Customer Survey
Region Quality Ease of UsePrice Service
NA
4
1
3
4
NA
4
4
4
5
NA
4
5
4
3
NA
5
4
4
4
NA
5
4
5
4
NA
5
5
3
5
NA
5
4
4
2
NA
5
5
4
5
NA
4
4
4
5
NA
4
5
4
5
NA
4
5
1
4
NA
5
5
4
4
NA
5
4
3
3
NA
4
5
4
4
NA
5
4
3
5
NA
5
5
2
5
NA
5
4
2
5
NA
5
4
2
5
NA
4
5
4
4
NA
4
4
5
4
NA
4
4
2
4
NA
4
3
3
4
NA
5
5
2
5
NA
5
3
4
3
NA
5
4
4
5
NA
5
5
2
5
NA
5
5
5
3
NA
4
4
5
4
NA
5
4
4
4
NA
5
1
5
5
NA
5
4
3
5
NA
4
5
1
4
NA
4
4
3
5
NA
5
3
4
4
NA
5
5
2
4
NA
5
4
4
4
NA
5
5
4
4
NA
5
5
4
5
NA
4
3
3
5
NA
5
4
4
3
NA
5
4
3
4
NA
5
5
1
5
NA
5
4
5
4
NA
3
4
3
4
NA
5
4
2
4
NA
5
5
4
5
NA
5
5
3
4
NA
5
4
4
4
NA
5
4
4
4
NA
5
4
4
5
NA
5
4
1
4
NA
5
4
5
5
NA
5
5
3
4
NA
5
4
4
5
NA
4
3
5
5
NA
5
4
4
4
NA
5
5
5
5
NA
5
5
4
5
NA
4
4
4
4
NA
5
4
5
5
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
4
5
5
5
5
4
4
5
5
5
5
5
5
5
5
5
4
3
5
4
3
1
4
5
4
5
5
4
5
5
5
5
4
5
4
5
4
5
4
4
5
5
5
4
5
4
5
4
4
4
5
3
5
5
4
4
1
5
4
4
5
4
4
5
5
5
4
4
4
4
4
4
4
5
4
4
3
4
4
5
5
5
4
2
4
5
5
5
5
5
2
4
4
5
5
5
5
4
5
5
5
5
5
4
4
4
2
4
5
4
5
4
4
4
3
4
4
4
4
5
4
4
4
4
4
4
5
5
3
4
5
5
4
4
3
5
4
4
5
4
5
1
3
2
4
3
4
3
3
4
5
4
4
4
5
5
4
5
5
4
5
3
2
5
4
5
3
2
5
4
4
2
4
3
4
2
3
5
3
2
3
3
3
2
4
5
2
5
4
4
4
5
4
2
5
5
4
5
4
5
4
2
5
5
5
5
5
4
5
5
4
5
4
5
5
4
5
4
4
3
5
3
5
5
4
4
4
3
4
5
4
5
5
5
5
4
5
3
4
4
5
4
5
4
5
4
4
4
5
4
5
3
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
SA
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Eur
Pac
Pac
Pac
Pac
Pac
Pac
3
5
4
4
4
4
4
5
4
5
5
4
4
5
5
5
3
4
4
5
4
5
5
5
3
4
4
4
4
3
3
4
5
5
4
3
3
4
5
5
5
3
4
4
5
4
3
4
5
5
4
4
5
2
5
4
5
5
5
4
4
5
4
3
4
4
5
1
5
4
4
4
5
5
4
4
4
4
4
4
3
4
4
3
3
4
4
4
4
3
5
4
4
4
4
5
5
5
4
5
4
4
3
5
4
5
5
4
5
5
4
5
3
5
3
4
4
4
5
4
4
5
4
3
4
4
4
4
4
5
4
4
4
3
4
4
4
2
4
4
4
1
4
5
2
3
4
5
4
4
3
1
4
5
4
5
1
5
5
5
5
4
3
5
5
4
4
4
4
4
4
4
3
4
3
4
2
4
3
4
5
4
1
4
5
4
4
5
4
5
4
1
5
5
4
5
4
5
3
4
4
5
5
4
4
5
4
3
3
5
5
4
4
4
4
3
3
2
4
3
5
5
1
4
4
3
4
5
4
5
4
5
4
5
4
4
2
4
5
4
4
3
4
4
3
5
5
5
4
4
4
4
Pac
Pac
Pac
Pac
China
China
China
China
China
China
China
China
China
China
5
4
3
5
5
5
4
4
4
4
4
3
3
2
5
2
4
4
5
5
4
4
4
4
4
4
4
3
4
3
4
4
4
4
3
3
3
3
3
3
2
2
5
3
4
5
4
3
3
3
2
3
2
3
2
1
Complaints
Month World NA SA Eur Pac China
Jan-14
169 102 12
52
3
Feb-14
187 115 13
55
4
Mar-14
210 128 15
61
6
Apr-14
226 136 16
67
7
May-14
232 137 17
73
5
Jun-14
261 151 19
82
9
Jul-14
245 140 18
80
7
Aug-14
223 128 16
76
3
Sep-14
195 103 15
73
4
Oct-14
174 96 14
62
2
Nov-14
154 84 11
59
0
Dec-14
163 99
9
54
1
Jan-15
195 123 10
59
3
Feb-15
221 141 13
62
5
Mar-15
240 152 16
66
6
Apr-15
264 163 20
70
11
May-15
283 178 22
75
8
Jun-15
296 170 28
86
12
Jul-15
269 153 25
81
10
Aug-15
256 146 23
79
8
Sep-15
231 131 20
73
7
Oct-15
214 125 16
68
5
Nov-15
201 118 13
66
4
Dec-15
171 96 11
61
3
Jan-16
200 112 15
66
4
3
Feb-16
216 117 18
71
6
4
Mar-16
234 126 20
76
9
3
Apr-16
253 138 23
79
11
2
May-16
282 152 26
85
14
5
Jun-16
305 163 30
91
15
6
Jul-16
296 156 28
89
18
5
Aug-16
279 148 26
86
15
4
Sep-16
266 143 24
82
13
4
Oct-16
243 131 21
76
12
3
Nov-16
232 128 18
73
10
3
Dec-16
203 107 15
70
7
4
Jan-17
216 110 19
74
8
5
Feb-17
239 123 23
79
10
4
Mar-17
266 138 26
83
13
6
Apr-17
284 150 30
88
11
5
May-17
315 169 33
91
15
7
Jun-17
340 181 37
95
19
8
Jul-17
319 169 34
92
17
7
Aug-17
304 160 32
90
15
7
Sep-17
277 141 29
87
14
6
Oct-17
250 123 26
83
12
6
Nov-17
228 112 24
77
10
5
Dec-17
213 105 23
74
7
4
Jan-18
240 121 26
80
8
5
Feb-18
251 126 28
82
10
5
Mar-18
281 148 31
85
12
5
Apr-18
298 155 35
89
13
6
May-18
322 168 39
95
12
8
Jun-18
350 183 43
98
15
11
Jul-18
330 170 41
95
14
10
Aug-18
311 158 38
93
13
9
Sep-18
289 149 33
89
11
7
Oct-18
265 136 30
85
8
6
Nov-18
239 121 26
80
7
5
Dec-18
219 108 23
76
7
5
A
1
2
3
B
C
D
E
F
G
Mower Unit Sales
Month
NA
SA Europe Pacific China World
Jan-14 6000 200
720
100
0 7020
5
Feb-14 7950 220
990
120
0 9280
6
Mar-14 8100 250 1320
110
0 9780
7
Apr-14 9050 280 1650
120
0 ####
8
May-14 9900 310 1590
130
0 ####
9
Jun-14 10200 300 1620
120
0 ####
10
Jul-14 8730 280 1590
140
0 ####
11
Aug-14 8140 250 1560
130
0 ####
12
Sep-14 6480 230 1590
130
0 8430
13
Oct-14 5990 220 1320
120
0 7650
14
Nov-14 5320 210
990
130
0 6650
15
Dec-14 4640 180
660
140
0 5620
16
Jan-15 5980 210
690
140
0 7020
17
Feb-15 7620 240 1020
150
0 9030
18
Mar-15 8370 250 1290
140
0 ####
19
Apr-15 8830 290 1620
150
0 ####
20
May-15 9310 330 1650
130
0 ####
21
Jun-15 10230 310 1590
140
0 ####
22
Jul-15 8720 290 1560
150
0 ####
23
Aug-15 7710 270 1530
140
0 9650
24
Sep-15 6320 250 1590
150
0 8310
25
Oct-15 5840 250 1260
160
0 7510
26
Nov-15 4960 240
900
150
0 6250
27
Dec-15 4350 210
660
150
0 5370
28
Jan-16 6020 220
570
160
0 6970
29
Feb-16 7920 250
840
150
0 9160
30
Mar-16 8430 270 1110
160
0 9970
31
Apr-16 9040 310 1500
170
0 ####
32
May-16 9820 360 1440
160
0 ####
33
Jun-16 10370 330 1410
170
0 ####
34
Jul-16 9050 310 1440
160
0 ####
35
Aug-16 7620 300 1410
170
0 9500
36
Sep-16 6420 280 1350
180
0 8230
37
Oct-16 5890 270 1080
180
0 7420
38
Nov-16 5340 260
840
190
0 6630
39
Dec-16 4430 230
510
180
0 5350
40
Jan-17 6100 250
480
200
0 7030
41
Feb-17 8010 270
750
190
0 9220
42
Mar-17 8430 280 1140
200
0 ####
43
Apr-17 9110 320 1410
210
0 ####
44
May-17 9730 380 1340
190
0 ####
45
Jun-17 10120 360 1360
200
0 ####
46
Jul-17 9080 320 1410
200
0 ####
47
Aug-17 7820 310 1490
210
0 9830
48
Sep-17 6540 300 1310
220
0 8370
49
Oct-17 6010 290
980
210
0 7490
50
Nov-17 5270 270
770
220
0 6530
51
Dec-17 5380 260
430
230
0 6300
52
Jan-18 6210 270
400
200
0 7080
53
Feb-18 8030 280
750
190
0 9250
54
Mar-18 8540 300
970
210
5 ####
55
Apr-18 9120 340 1310
220
16 ####
56
May-18 9570 390 1260
200
22 ####
57
Jun-18 10230 380 1240
210
26 ####
58
Jul-18 9580 350 1300
230
14 ####
59
Aug-18 7680 340 1250
220
15 9505
60
Sep-18 6870 320 1210
220
11 8631
61
Oct-18 5930 310
970
230
3 7443
62
Nov-18 5260 300
650
240
1 6451
63
Dec-18 4830 290
300
230
0 5650
4
Tractor Unit Sales
Month NA
SA
Eur
Pacific China World
Jan-14
570
250
560
212
0
1592
Feb-14
611
270
600
230
0
1711
Mar-14
630
260
680
240
0
1810
Apr-14
684
270
650
263
0
1867
May-14
650
280
580
269
0
1779
Jun-14
600
270
590
280
0
1740
Jul-14
512
264
760
290
0
1826
Aug-14
500
280
645
270
0
1695
Sep-14
478
290
650
263
0
1681
Oct-14
455
280
670
258
0
1663
Nov-14
407
290
888
240
0
1825
Dec-14
360
280
850
230
0
1720
Jan-15
571
320
620
250
0
1761
Feb-15
650
350
760
275
0
2035
Mar-15
740
390
742
270
0
2142
Apr-15
840
440
780
280
0
2340
May-15
830
470
690
290
0
2280
Jun-15
760
490
721
300
0
2271
Jul-15
681
481
680
312
0
2154
Aug-15
670
460
711
305
0
2146
Sep-15
640
460
695
290
0
2085
Oct-15
620
440
650
260
0
1970
Nov-15
570
436
680
250
0
1936
Dec-15
533
420
657
240
0
1850
Jan-16
620
510
610
250
10
2000
Feb-16
792
590
680
250
12
2324
Mar-16
890
610
730
260
20
2510
Apr-16
960
600
820
270
22
2672
May-16
1040
620
810
290
20
2780
Jun-16
1032
640
807
310
24
2813
Jul-16
1006
590
760
340
20
2716
Aug-16
910
600
720
320
31
2581
Sep-16
803
670
660
313
30
2476
Oct-16
730
630
630
290
37
2317
Nov-16
699
710
603
280
32
2324
Dec-16
647
570
570
260
33
2080
Jan-17
730
650
500
287
35
2202
Feb-17
930
680
590
290
50
2540
Mar-17
1160
724
620
300
63
2867
Apr-17
1510
730
730
310
68
3348
May-17
1650
760
740
330
70
3550
Jun-17
1490
800
720
340
82
3432
Jul-17
1460
840
670
350
80
3400
Aug-17
1390
830
610
341
90
3261
Sep-17
1360
820
599
330
100
3209
Oct-17
1340
810
560
320
102
3132
Nov-17
1240
827
550
300
110
3027
Dec-17
1103
750
520
290
114
2777
Jan-18
1250
780
480
200
111
2821
Feb-18
1550
805
523
210
121
3209
Mar-18
1820
830
560
220
123
3553
Apr-18
2010
890
570
230
120
3820
May-18
2230
930
590
253
130
4133
Jun-18
2490
980
600
270
136
4476
Jul-18
2440
1002
580
280
134
4436
