Statistics HW

tracway_data_.xls

Home >Mathematics homework help >Statistics HW

C1 Dealer Satisfaction

Dealer Satisfaction
Survey Scale:	0	1	2	3	4	5	Sample
North America							Size
2008	1	0	2	13	22	12	50
2009	0	0	2	14	20	14	50
2010	1	1	1	6	36	15	60
2011	1	2	6	13	38	40	100
2012	2	3	5	15	44	56	125
South America
2008	0	0	0	2	6	2	10
2009	0	0	0	2	6	2	10
2010	0	0	1	4	9	14	28
2011	0	1	1	3	12	30	47
2012	1	1	2	4	21	48	77
Europe
2008	0	0	1	3	7	4	15
2009	0	0	1	2	8	4	15
2010	0	0	1	2	8	4	15
2011	0	0	1	2	8	4	15
2012	0	0	1	2	8	4	15
Pacific Rim
2008	0	0	1	2	2	0	5
2009	0	0	1	1	3	0	5
2010	0	0	1	1	3	1	6
2011	0	0	0	2	3	1	6
2012	0	0	1	2	3	2	8
China
2010	0	0	0	1	0	0	1
2011	0	0	1	1	0	0	2
2012	0	0	1	1	3	0	5

This worksheet provides dealer survey results of perceived Tracway product quality by year

C2 End-User Satisfaction

End-User Satisfaction
							Sample
NA	0	1	2	3	4	5	Size
2008	1	3	6	15	37	38	100
2009	1	2	4	18	35	40	100
2010	1	2	5	17	35	40	100
2011	0	2	4	18	36	40	100
2012	0	2	3	17	37	41	100
SA
2008	1	2	5	18	36	38	100
2009	1	3	6	17	36	37	100
2010	0	2	6	19	37	36	100
2011	0	2	5	20	37	36	100
2012	0	2	5	19	37	37	100
Eur
2008	1	2	4	21	36	36	100
2009	1	2	5	18	37	37	100
2010	1	1	4	19	38	37	100
2011	1	1	3	17	39	39	100
2012	0	1	2	18	40	39	100
Pac
2008	2	3	5	15	41	34	100
2009	1	2	7	15	41	34	100
2010	1	2	5	16	40	36	100
2011	0	2	4	17	40	37	100
2012	0	1	3	19	42	35	100
China
2010	0	3	5	12	62	18	100
2011	1	2	4	14	58	21	100
2012	0	2	5	15	56	22	100

This worksheet provides customer survey results of perceived Tracway product quality by year

C3 2012 Customer Survey

2012 Customer Survey
Region	Quality	Ease of Use	Price	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	4	5	5	4
NA	5	5	5	4
NA	5	5	3	5
NA	5	4	4	4
NA	5	4	5	2
NA	4	4	5	5
NA	4	4	4	5
NA	5	4	4	4
NA	5	4	3	5
NA	5	4	5	4
NA	5	5	4	5
NA	5	4	4	4
NA	5	4	5	2
NA	5	3	4	5
NA	5	4	5	5
NA	5	4	1	5
NA	4	5	3	5
NA	3	5	2	5
NA	5	5	4	4
NA	4	4	3	5
NA	3	2	4	5
NA	1	4	3	4
NA	4	5	3	5
NA	5	5	4	4
NA	4	5	5	5
NA	5	5	4	5
NA	5	5	4	4
NA	4	2	4	5
NA	5	4	5	4
NA	5	4	5	4
NA	5	5	4	3
NA	5	5	5	5
NA	4	5	5	3
NA	5	5	4	5
NA	4	4	5	5
NA	5	5	3	4
NA	4	5	2	4
NA	5	5	5	4
NA	4	5	4	3
NA	4	5	5	4
SA	5	4	3	5
SA	5	4	2	4
SA	5	4	5	5
SA	4	2	4	5
SA	5	4	4	5
SA	4	5	2	5
SA	5	4	4	4
SA	4	5	3	5
SA	4	4	4	3
SA	4	4	2	4
SA	5	4	3	4
SA	3	3	5	5
SA	5	4	3	4
SA	5	4	2	5
SA	4	4	3	4
SA	4	4	3	5
SA	1	5	3	4
SA	5	4	2	4
SA	4	4	4	4
SA	4	4	5	5
SA	5	4	2	4
SA	4	4	5	5
SA	4	4	4	3
SA	3	3	4	5
SA	5	4	4	4
SA	4	4	4	1
SA	4	5	5	5
SA	4	1	4	5
SA	4	5	4	4
SA	4	4	4	5
SA	5	4	3	4
SA	4	4	4	5
SA	5	5	4	3
SA	5	5	4	4
SA	4	4	2	4
SA	4	4	4	5
SA	5	4	4	5
SA	5	4	4	4
SA	5	4	1	4
SA	3	4	4	5
SA	4	3	5	4
SA	4	4	2	3
SA	5	4	3	3
SA	4	3	4	5
SA	5	3	5	5
SA	5	4	4	4
SA	5	4	4	4
SA	3	4	3	4
SA	4	4	1	4
SA	4	3	4	3
Eur	4	5	5	3
Eur	4	4	4	2
Eur	3	4	5	4
Eur	3	4	1	3
Eur	4	4	5	5
Eur	5	5	5	5
Eur	5	5	5	1
Eur	4	5	5	4
Eur	3	4	4	4
Eur	3	5	3	3
Eur	4	4	5	4
Eur	5	4	5	5
Eur	5	3	4	4
Eur	5	5	4	5
Eur	3	4	4	4
Eur	4	5	4	5
Eur	4	5	4	4
Eur	5	4	4	5
Eur	4	5	4	4
Eur	3	5	3	4
Eur	4	4	4	2
Eur	5	5	3	4
Eur	5	3	4	5
Eur	4	5	2	4
Eur	4	3	4	4
Eur	5	4	3	3
Eur	2	4	4	4
Eur	5	4	5	4
Eur	4	5	4	3
Eur	5	4	1	5
Pac	5	4	4	5
Pac	5	5	5	5
Pac	4	4	4	4
Pac	4	3	4	4
Pac	5	4	5	4
Pac	4	4	4	4
Pac	5	5	4	5
Pac	4	2	3	3
Pac	3	4	4	4
Pac	5	4	4	5
China	5	5	4	4
China	5	5	4	3
China	4	4	3	3
China	4	4	3	3
China	4	4	3	2
China	4	4	3	3
China	4	4	3	2
China	3	4	3	3
China	3	4	2	2
China	2	3	2	1

This worksheet gives samples of tractor customer ratings of key quality characteristics. Samples were stratified to reflect relative sales volume by region

C4 Complaints

Complaints
Month	World	NA	SA	Eur	Pac	China
Jan-08	169	102	12	52	3
Feb-08	187	115	13	55	4
Mar-08	210	128	15	61	6
Apr-08	226	136	16	67	7
May-08	232	137	17	73	5
Jun-08	261	151	19	82	9
Jul-08	245	140	18	80	7
Aug-08	223	128	16	76	3
Sep-08	195	103	15	73	4
Oct-08	174	96	14	62	2
Nov-08	145	75	11	59	0
Dec-08	163	99	9	54	1
Jan-09	195	123	10	59	3
Feb-09	221	141	13	62	5
Mar-09	240	152	16	66	6
Apr-09	264	163	20	70	11
May-09	283	178	22	75	8
Jun-09	296	170	28	86	12
Jul-09	269	153	25	81	10
Aug-09	256	146	23	79	8
Sep-09	231	131	20	73	7
Oct-09	214	125	16	68	5
Nov-09	201	118	13	66	4
Dec-09	171	96	11	61	3
Jan-10	200	112	15	66	4	3
Feb-10	216	117	18	71	6	4
Mar-10	234	126	20	76	9	3
Apr-10	253	138	23	79	11	2
May-10	282	152	26	85	14	5
Jun-10	305	163	30	91	15	6
Jul-10	296	156	28	89	18	5
Aug-10	279	148	26	86	15	4
Sep-10	266	143	24	82	13	4
Oct-10	243	131	21	76	12	3
Nov-10	232	128	18	73	10	3
Dec-10	203	107	15	70	7	4
Jan-11	216	110	19	74	8	5
Feb-11	239	123	23	79	10	4
Mar-11	266	138	26	83	13	6
Apr-11	284	150	30	88	11	5
May-11	315	169	33	91	15	7
Jun-11	340	181	37	95	19	8
Jul-11	319	169	34	92	17	7
Aug-11	304	160	32	90	15	7
Sep-11	277	141	29	87	14	6
Oct-11	250	123	26	83	12	6
Nov-11	228	112	24	77	10	5
Dec-11	213	105	23	74	7	4
Jan-12	240	121	26	80	8	5
Feb-12	251	126	28	82	10	5
Mar-12	281	148	31	85	12	5
Apr-12	298	155	35	89	13	6
May-12	322	168	39	95	12	8
Jun-12	350	183	43	98	15	11
Jul-12	330	170	41	95	14	10
Aug-12	311	158	38	93	13	9
Sep-12	289	149	33	89	11	7
Oct-12	265	136	30	85	8	6
Nov-12	239	121	26	80	7	5
Dec-12	219	108	23	76	7	5

This worksheet records the number of customer complaints received by region each month. The world column is the total of the five regional columns.

C5 Mower Unit Sales

Mower Unit Sales
Month	NA	SA	Europe	Pacific	China	World
Jan-08	6000	200	720	100	0	7020
Feb-08	7950	220	990	120	0	9280
Mar-08	8100	250	1320	110	0	9780
Apr-08	9050	280	1650	120	0	11100
May-08	9900	310	1590	130	0	11930
Jun-08	10200	300	1620	120	0	12240
Jul-08	8730	280	1590	140	0	10740
Aug-08	8140	250	1560	130	0	10080
Sep-08	6480	230	1590	130	0	8430
Oct-08	5990	220	1320	120	0	7650
Nov-08	5320	210	990	130	0	6650
Dec-08	4640	180	660	140	0	5620
Jan-09	5980	210	690	140	0	7020
Feb-09	7620	240	1020	150	0	9030
Mar-09	8370	250	1290	140	0	10050
Apr-09	8830	290	1620	150	0	10890
May-09	9310	330	1650	130	0	11420
Jun-09	10230	310	1590	140	0	12270
Jul-09	8720	290	1560	150	0	10720
Aug-09	7710	270	1530	140	0	9650
Sep-09	6320	250	1590	150	0	8310
Oct-09	5840	250	1260	160	0	7510
Nov-09	4960	240	900	150	0	6250
Dec-09	4350	210	660	150	0	5370
Jan-10	6020	220	570	160	0	6970
Feb-10	7920	250	840	150	0	9160
Mar-10	8430	270	1110	160	0	9970
Apr-10	9040	310	1500	170	0	11020
May-10	9820	360	1440	160	0	11780
Jun-10	10370	330	1410	170	0	12280
Jul-10	9050	310	1440	160	0	10960
Aug-10	7620	300	1410	170	0	9500
Sep-10	6420	280	1350	180	0	8230
Oct-10	5890	270	1080	180	0	7420
Nov-10	5340	260	840	190	0	6630
Dec-10	4430	230	510	180	0	5350
Jan-11	6100	250	480	200	0	7030
Feb-11	8010	270	750	190	0	9220
Mar-11	8430	280	1140	200	0	10050
Apr-11	9110	320	1410	210	0	11050
May-11	9730	380	1340	190	0	11640
Jun-11	10120	360	1360	200	0	12040
Jul-11	9080	320	1410	200	0	11010
Aug-11	7820	310	1490	210	0	9830
Sep-11	6540	300	1310	220	0	8370
Oct-11	6010	290	980	210	0	7490
Nov-11	5270	270	770	220	0	6530
Dec-11	5380	260	430	230	0	6300
Jan-12	6210	270	400	200	0	7080
Feb-12	8030	280	750	190	0	9250
Mar-12	8540	300	970	210	0	10020
Apr-12	9120	340	1310	220	0	10990
May-12	9570	390	1260	200	0	11420
Jun-12	10230	380	1240	210	0	12060
Jul-12	9580	350	1300	230	0	11460
Aug-12	7680	340	1250	220	0	9490
Sep-12	6870	320	1210	220	0	8620
Oct-12	5930	310	970	230	0	7440
Nov-12	5260	300	650	240	0	6450
Dec-12	4830	290	300	230	0	5650

This worksheet provides Tracway mower sales in units by month and region. The World Column provides total sales by month, aggregated over all regions.

C6 Tractor Unit Sales

Tractor Unit Sales
Month	NA	SA	Eur	Pac	China	World
Jan-08	570	250	560	210	0	1590
Feb-08	610	270	600	230	0	1710
Mar-08	630	260	680	240	0	1810
Apr-08	680	270	650	260	0	1860
May-08	650	280	580	260	0	1770
Jun-08	600	270	590	280	0	1740
Jul-08	510	260	760	290	0	1820
Aug-08	500	280	640	270	0	1690
Sep-08	470	290	650	260	0	1670
Oct-08	450	280	670	250	0	1650
Nov-08	400	290	880	240	0	1810
Dec-08	360	280	850	230	0	1720
Jan-09	570	320	620	250	0	1760
Feb-09	650	350	760	270	0	2030
Mar-09	740	390	740	270	0	2140
Apr-09	840	440	780	280	0	2340
May-09	830	470	690	290	0	2280
Jun-09	760	490	720	300	0	2270
Jul-09	680	480	680	310	0	2150
Aug-09	670	460	710	300	0	2140
Sep-09	640	460	690	290	0	2080
Oct-09	620	440	650	260	0	1970
Nov-09	570	430	680	250	0	1930
Dec-09	530	420	650	240	0	1840
Jan-10	620	510	610	250	10	2000
Feb-10	790	590	680	250	10	2320
Mar-10	890	610	730	260	20	2510
Apr-10	960	600	820	270	20	2670
May-10	1040	620	810	290	20	2780
Jun-10	1030	640	800	310	20	2800
Jul-10	1000	590	760	340	20	2710
Aug-10	910	600	720	320	30	2580
Sep-10	800	670	660	310	30	2470
Oct-10	730	630	630	290	30	2310
Nov-10	690	710	600	280	30	2310
Dec-10	640	570	570	260	30	2070
Jan-11	730	650	500	280	30	2190
Feb-11	930	680	590	290	50	2540
Mar-11	1160	710	620	300	60	2850
Apr-11	1510	730	730	310	60	3340
May-11	1650	760	740	330	70	3550
Jun-11	1490	800	720	340	80	3430
Jul-11	1460	840	670	350	80	3400
Aug-11	1390	830	610	340	90	3260
Sep-11	1360	820	600	330	100	3210
Oct-11	1340	810	560	320	100	3130
Nov-11	1240	810	550	300	110	3010
Dec-11	1100	750	520	290	110	2770
Jan-12	1250	780	480	200	110	2820
Feb-12	1550	800	520	210	120	3200
Mar-12	1820	830	560	220	120	3550
Apr-12	2010	890	570	230	120	3820
May-12	2230	930	590	250	130	4130
Jun-12	2490	980	600	270	130	4470
Jul-12	2440	1000	580	280	130	4430
Aug-12	2320	970	570	250	130	4240
Sep-12	2190	960	550	230	130	4060
Oct-12	2080	930	530	220	130	3890
Nov-12	2050	920	510	190	130	3800
Dec-12	2000	900	490	190	130	3710

This worksheet records Tracway tractor sales in units by month by region. The world column provides total sales for that month.

C7 Industry Mower Total Sales

Industry Mower Total Sales
Month	NA	SA	Eur	Pac	World
Jan-08	60000	571	13091	1000	74662
Feb-08	77184	611	17679	1111	96585
Mar-08	77885	658	22759	1068	102369
Apr-08	86190	778	27966	1237	116171
May-08	96117	886	27895	1313	126210
Jun-08	97143	882	30566	1176	129768
Jul-08	84757	848	29444	1359	116409
Aug-08	79804	735	28364	1238	110141
Sep-08	64800	657	28393	1215	95065
Oct-08	59307	595	24444	1154	85500
Nov-08	52157	553	18000	1262	71972
Dec-08	45049	462	12453	1386	59349
Jan-09	58627	553	12778	1443	73401
Feb-09	76200	615	18214	1515	96545
Mar-09	82871	658	23889	1373	108791
Apr-09	84904	784	29455	1442	116584
May-09	93100	846	29464	1215	124625
Jun-09	93000	838	27414	1333	122585
Jul-09	83048	763	27368	1415	112594
Aug-09	74854	692	27321	1296	104164
Sep-09	60769	625	29444	1402	92241
Oct-09	55619	610	23774	1468	81470
Nov-09	48155	571	17308	1351	67386
Dec-09	42647	512	12941	1389	57489
Jan-10	57885	537	10962	1509	70892
Feb-10	77647	595	15273	1402	94917
Mar-10	81845	659	20556	1524	104583
Apr-10	86095	756	26786	1574	115211
May-10	91776	878	24828	1468	118949
Jun-10	100680	825	24737	1560	127801
Jul-10	86190	756	24828	1441	113216
Aug-10	71887	714	25179	1545	99325
Sep-10	60000	651	24545	1667	86863
Oct-10	55566	643	19286	1698	77193
Nov-10	50857	619	15273	1810	68558
Dec-10	42596	548	9107	1731	53982
Jan-11	58095	581	8571	1887	69135
Feb-11	75566	614	13158	1845	91182
Mar-11	80286	622	19655	1923	102486
Apr-11	85140	727	25179	1981	113027
May-11	90093	826	23103	1810	115832
Jun-11	95472	783	24286	1942	122482
Jul-11	87308	681	24737	1961	114686
Aug-11	74476	646	26607	2000	103729
Sep-11	61698	625	22982	2075	87381
Oct-11	57238	617	16897	2019	76771
Nov-11	50673	587	13750	2095	67105
Dec-11	51238	591	7818	2150	61797
Jan-12	59712	563	7547	1852	69673
Feb-12	77961	571	13889	1743	94165
Mar-12	83725	625	18302	1892	104544
Apr-12	90297	723	25192	2037	118250
May-12	91143	848	24706	1887	118583
Jun-12	99320	792	25306	1944	127363
Jul-12	93922	745	27083	2170	123919
Aug-12	73143	739	26042	2037	101961
Sep-12	66699	667	26304	2018	95688
Oct-12	56476	660	22558	2072	81766
Nov-12	51068	625	14773	2182	68648
Dec-12	46893	604	6977	2035	56510

This worksheet contains worldwide sales of mowers by ALL producers, including Tracway.

C8 Industry Tractor Total Sales

Industry Tractor Total Sales
Month	NA	SA	Eur	Pac	China	World
Jan-08	8143	1000	5091	1000	284	15518
Feb-08	8592	1051	5310	1090	283	16325
Mar-08	8630	1016	6071	1127	285	17129
Apr-08	8947	1027	5856	1209	288	17327
May-08	8442	1057	5273	1221	286	16278
Jun-08	7500	1019	5315	1327	287	15448
Jul-08	6145	977	7170	1324	289	15905
Aug-08	5882	1057	5926	1268	290	14422
Sep-08	5595	1086	6075	1209	293	14258
Oct-08	5233	1045	6321	1168	295	14061
Nov-08	4494	1078	8381	1127	298	15378
Dec-08	3913	1029	7944	1085	301	14272
Jan-09	5938	1172	5688	1185	306	14289
Feb-09	6633	1273	7037	1286	302	16530
Mar-09	7327	1423	6981	1286	303	17320
Apr-09	8077	1612	7500	1346	307	18842
May-09	7830	1728	6571	1388	309	17826
Jun-09	7103	1815	6990	1449	312	17669
Jul-09	6239	1771	6667	1490	315	16482
Aug-09	6036	1685	6762	1449	318	16250
Sep-09	5664	1679	6635	1394	321	15692
Oct-09	5345	1618	6311	1256	315	14844
Nov-09	4831	1564	6476	1214	318	14402
Dec-09	4454	1522	6250	1171	320	13716
Jan-10	5299	1835	5922	1208	333	14597
Feb-10	6529	2115	6667	1214	313	16836
Mar-10	7120	2202	7228	1256	606	18412
Apr-10	7619	2151	8200	1311	571	19852
May-10	8387	2214	7941	1415	556	20513
Jun-10	8110	2278	7921	1520	526	20355
Jul-10	7752	2100	7677	1675	513	19716
Aug-10	6894	2128	7200	1584	769	18575
Sep-10	6015	2367	6735	1527	750	17394
Oct-10	5368	2211	6495	1422	732	16226
Nov-10	4964	2483	6061	1366	714	15587
Dec-10	4444	1986	5816	1262	698	14207
Jan-11	5000	2257	5051	1373	714	14394
Feb-11	6284	2353	6082	1436	1163	17318
Mar-11	7785	2457	6327	1478	1364	19410
Apr-11	9934	2517	7604	1512	1333	22901
May-11	10645	2612	7789	1642	1556	24244
Jun-11	9490	2749	7347	1667	1739	22992
Jul-11	9182	2887	6979	1733	1702	22483
Aug-11	8528	2833	6489	1700	1915	21465
Sep-11	8293	2789	6316	1642	2083	21123
Oct-11	8221	2765	5833	1576	2128	20523
Nov-11	7470	2746	5789	1493	2292	19789
Dec-11	6509	2534	5591	1450	2245	18329
Jan-12	7267	2635	5106	1010	2292	18311
Feb-12	8807	2703	5474	1045	2449	20477
Mar-12	10168	2795	6022	1106	2400	22489
Apr-12	11044	2997	6064	1150	2353	23607
May-12	12120	3131	6344	1244	2600	25439
Jun-12	13459	3311	6593	1357	2653	27374
Jul-12	13048	3390	6304	1421	2600	26764
Aug-12	12275	3277	6064	1263	2549	25428
Sep-12	11347	3232	5789	1173	2453	23995
Oct-12	10667	3131	5699	1128	2500	23125
Nov-12	10459	3087	5604	974	2453	22578
Dec-12	10050	3030	5444	979	2453	21957

This worksheet contains worldwide sales of tractors by all producers, including Tracway.

C9 Mktshare Mowers

Market Share Mowers
Month	World	NA	SA	Eur	Pac
Jan-08	0.094	0.100	0.350	0.055	0.100
Feb-08	0.096	0.103	0.360	0.056	0.108
Mar-08	0.096	0.104	0.380	0.058	0.103
Apr-08	0.096	0.105	0.360	0.059	0.097
May-08	0.095	0.103	0.350	0.057	0.099
Jun-08	0.094	0.105	0.340	0.053	0.102
Jul-08	0.092	0.103	0.330	0.054	0.103
Aug-08	0.092	0.102	0.340	0.055	0.105
Sep-08	0.089	0.100	0.350	0.056	0.107
Oct-08	0.089	0.101	0.370	0.054	0.104
Nov-08	0.092	0.102	0.380	0.055	0.103
Dec-08	0.095	0.103	0.390	0.053	0.101
Jan-09	0.096	0.102	0.380	0.054	0.097
Feb-09	0.094	0.100	0.390	0.056	0.099
Mar-09	0.092	0.101	0.380	0.054	0.102
Apr-09	0.093	0.104	0.370	0.055	0.104
May-09	0.092	0.100	0.390	0.056	0.107
Jun-09	0.100	0.110	0.370	0.058	0.105
Jul-09	0.095	0.105	0.380	0.057	0.106
Aug-09	0.093	0.103	0.390	0.056	0.108
Sep-09	0.090	0.104	0.400	0.054	0.107
Oct-09	0.092	0.105	0.410	0.053	0.109
Nov-09	0.093	0.103	0.420	0.052	0.111
Dec-09	0.093	0.102	0.410	0.051	0.108
Jan-10	0.098	0.104	0.410	0.052	0.106
Feb-10	0.097	0.102	0.420	0.055	0.107
Mar-10	0.095	0.103	0.410	0.054	0.105
Apr-10	0.096	0.105	0.410	0.056	0.108
May-10	0.099	0.107	0.410	0.058	0.109
Jun-10	0.096	0.103	0.400	0.057	0.109
Jul-10	0.097	0.105	0.410	0.058	0.111
Aug-10	0.096	0.106	0.420	0.056	0.110
Sep-10	0.095	0.107	0.430	0.055	0.108
Oct-10	0.096	0.106	0.420	0.056	0.106
Nov-10	0.097	0.105	0.420	0.055	0.105
Dec-10	0.099	0.104	0.420	0.056	0.104
Jan-11	0.102	0.105	0.430	0.056	0.106
Feb-11	0.101	0.106	0.440	0.057	0.103
Mar-11	0.098	0.105	0.450	0.058	0.104
Apr-11	0.098	0.107	0.440	0.056	0.106
May-11	0.100	0.108	0.460	0.058	0.105
Jun-11	0.098	0.106	0.460	0.056	0.103
Jul-11	0.096	0.104	0.470	0.057	0.102
Aug-11	0.095	0.105	0.480	0.056	0.105
Sep-11	0.096	0.106	0.480	0.057	0.106
Oct-11	0.098	0.105	0.470	0.058	0.104
Nov-11	0.097	0.104	0.460	0.056	0.105
Dec-11	0.102	0.105	0.440	0.055	0.107
Jan-12	0.102	0.104	0.480	0.053	0.108
Feb-12	0.098	0.103	0.490	0.054	0.109
Mar-12	0.096	0.102	0.480	0.053	0.111
Apr-12	0.093	0.101	0.470	0.052	0.108
May-12	0.096	0.105	0.460	0.051	0.106
Jun-12	0.095	0.103	0.480	0.049	0.108
Jul-12	0.092	0.102	0.470	0.048	0.106
Aug-12	0.093	0.105	0.460	0.048	0.108
Sep-12	0.090	0.103	0.480	0.046	0.109
Oct-12	0.091	0.105	0.470	0.043	0.111
Nov-12	0.094	0.103	0.480	0.044	0.110
Dec-12	0.100	0.103	0.480	0.043	0.113

This worksheet provides Tracway market share for mowers based on unit sales.

C10 Mktshare Tractors

Market Share Tractors
Month	World	NA	SA	Eur	Pac	China
Jan-08	0.102	0.070	0.250	0.110	0.210
Feb-08	0.105	0.071	0.257	0.113	0.211
Mar-08	0.106	0.073	0.256	0.112	0.213
Apr-08	0.107	0.076	0.263	0.111	0.215
May-08	0.109	0.077	0.265	0.110	0.213
Jun-08	0.113	0.080	0.265	0.111	0.211
Jul-08	0.114	0.083	0.266	0.106	0.219
Aug-08	0.117	0.085	0.265	0.108	0.213
Sep-08	0.117	0.084	0.267	0.107	0.215
Oct-08	0.117	0.086	0.268	0.106	0.214
Nov-08	0.118	0.089	0.269	0.105	0.213
Dec-08	0.121	0.092	0.272	0.107	0.212
Jan-09	0.123	0.096	0.273	0.109	0.211
Feb-09	0.123	0.098	0.275	0.108	0.210
Mar-09	0.124	0.101	0.274	0.106	0.210
Apr-09	0.124	0.104	0.273	0.104	0.208
May-09	0.128	0.106	0.272	0.105	0.209
Jun-09	0.128	0.107	0.270	0.103	0.207
Jul-09	0.130	0.109	0.271	0.102	0.208
Aug-09	0.132	0.111	0.273	0.105	0.207
Sep-09	0.133	0.113	0.274	0.104	0.208
Oct-09	0.133	0.116	0.272	0.103	0.207
Nov-09	0.134	0.118	0.275	0.105	0.206
Dec-09	0.134	0.119	0.276	0.104	0.205
Jan-10	0.137	0.117	0.278	0.103	0.207	0.030
Feb-10	0.138	0.121	0.279	0.102	0.206	0.032
Mar-10	0.136	0.125	0.277	0.101	0.207	0.033
Apr-10	0.134	0.126	0.279	0.100	0.206	0.035
May-10	0.136	0.124	0.280	0.102	0.205	0.036
Jun-10	0.138	0.127	0.281	0.101	0.204	0.038
Jul-10	0.137	0.129	0.281	0.099	0.203	0.039
Aug-10	0.139	0.132	0.282	0.100	0.202	0.039
Sep-10	0.142	0.133	0.283	0.098	0.203	0.040
Oct-10	0.142	0.136	0.285	0.097	0.204	0.041
Nov-10	0.148	0.139	0.286	0.099	0.205	0.042
Dec-10	0.146	0.144	0.287	0.098	0.206	0.043
Jan-11	0.152	0.146	0.288	0.099	0.204	0.042
Feb-11	0.147	0.148	0.289	0.097	0.202	0.043
Mar-11	0.147	0.149	0.289	0.098	0.203	0.044
Apr-11	0.146	0.152	0.290	0.096	0.205	0.045
May-11	0.146	0.155	0.291	0.095	0.201	0.045
Jun-11	0.149	0.157	0.291	0.098	0.204	0.046
Jul-11	0.151	0.159	0.291	0.096	0.202	0.047
Aug-11	0.152	0.163	0.293	0.094	0.200	0.047
Sep-11	0.152	0.164	0.294	0.095	0.201	0.048
Oct-11	0.153	0.163	0.293	0.096	0.203	0.047
Nov-11	0.152	0.166	0.295	0.095	0.201	0.048
Dec-11	0.151	0.169	0.296	0.093	0.200	0.049
Jan-12	0.154	0.172	0.296	0.094	0.198	0.048
Feb-12	0.156	0.176	0.296	0.095	0.201	0.049
Mar-12	0.158	0.179	0.297	0.093	0.199	0.050
Apr-12	0.162	0.182	0.297	0.094	0.200	0.051
May-12	0.162	0.184	0.297	0.093	0.201	0.050
Jun-12	0.163	0.185	0.296	0.091	0.199	0.049
Jul-12	0.166	0.187	0.295	0.092	0.197	0.050
Aug-12	0.167	0.189	0.296	0.094	0.198	0.051
Sep-12	0.169	0.193	0.297	0.095	0.196	0.053
Oct-12	0.168	0.195	0.297	0.093	0.195	0.052
Nov-12	0.168	0.196	0.298	0.091	0.195	0.053
Dec-12	0.169	0.199	0.297	0.090	0.194	0.053

This worksheet provides Tracway market share for tractors based on unti sales.

F1 Revenues

Revenues
Month	NA	SA	Eur	Pac	China	World
Jan-08	$ 2,310,000	$ 770,000	$ 1,752,000	$ 640,000	$ - 0	$ 5,472,000
Feb-08	$ 2,625,000	$ 832,000	$ 1,899,000	$ 702,000	$ - 0	$ 6,058,000
Mar-08	$ 2,700,000	$ 805,000	$ 2,172,000	$ 731,000	$ - 0	$ 6,408,000
Apr-08	$ 2,945,000	$ 838,000	$ 2,115,000	$ 792,000	$ - 0	$ 6,690,000
May-08	$ 2,940,000	$ 871,000	$ 1,899,000	$ 793,000	$ - 0	$ 6,503,000
Jun-08	$ 2,820,000	$ 840,000	$ 1,932,000	$ 852,000	$ - 0	$ 6,444,000
Jul-08	$ 2,403,000	$ 808,000	$ 2,439,000	$ 884,000	$ - 0	$ 6,534,000
Aug-08	$ 2,314,000	$ 865,000	$ 2,076,000	$ 823,000	$ - 0	$ 6,078,000
Sep-08	$ 2,058,000	$ 893,000	$ 2,109,000	$ 793,000	$ - 0	$ 5,853,000
Oct-08	$ 1,949,000	$ 862,000	$ 2,142,000	$ 762,000	$ - 0	$ 5,715,000
Nov-08	$ 1,732,000	$ 891,000	$ 2,739,000	$ 733,000	$ - 0	$ 6,095,000
Dec-08	$ 1,544,000	$ 858,000	$ 2,616,000	$ 704,000	$ - 0	$ 5,722,000
Jan-09	$ 2,394,900	$ 1,014,050	$ 1,994,450	$ 789,700	$ - 0	$ 6,193,100
Feb-09	$ 2,815,100	$ 1,110,200	$ 2,463,100	$ 852,750	$ - 0	$ 7,241,150
Mar-09	$ 3,172,850	$ 1,235,250	$ 2,429,450	$ 851,700	$ - 0	$ 7,689,250
Apr-09	$ 3,531,150	$ 1,394,450	$ 2,588,100	$ 883,750	$ - 0	$ 8,397,450
May-09	$ 3,550,550	$ 1,491,650	$ 2,312,250	$ 912,650	$ - 0	$ 8,267,100
Jun-09	$ 3,430,150	$ 1,551,550	$ 2,398,950	$ 944,700	$ - 0	$ 8,325,350
Jul-09	$ 3,023,600	$ 1,518,450	$ 2,271,800	$ 976,750	$ - 0	$ 7,790,600
Aug-09	$ 2,886,550	$ 1,454,350	$ 2,361,650	$ 944,700	$ - 0	$ 7,647,250
Sep-09	$ 2,647,600	$ 1,452,250	$ 2,305,950	$ 914,750	$ - 0	$ 7,320,550
Oct-09	$ 2,535,200	$ 1,390,250	$ 2,147,300	$ 822,800	$ - 0	$ 6,895,550
Nov-09	$ 2,287,800	$ 1,358,200	$ 2,202,500	$ 790,750	$ - 0	$ 6,639,250
Dec-09	$ 2,099,750	$ 1,324,050	$ 2,084,300	$ 759,750	$ - 0	$ 6,267,850
Jan-10	$ 2,677,200	$ 1,681,700	$ 2,045,200	$ 830,100	$ 32,500	$ 7,266,700
Feb-10	$ 3,438,700	$ 1,945,000	$ 2,302,400	$ 829,000	$ 32,500	$ 8,547,600
Mar-10	$ 3,819,800	$ 2,012,200	$ 2,494,600	$ 862,600	$ 65,000	$ 9,254,200
Apr-10	$ 4,114,400	$ 1,984,100	$ 2,830,000	$ 896,200	$ 65,000	$ 9,889,700
May-10	$ 4,460,200	$ 2,054,600	$ 2,790,900	$ 960,100	$ 65,000	$ 10,330,800
Jun-10	$ 4,488,200	$ 2,116,300	$ 2,755,100	$ 1,026,200	$ 65,000	$ 10,450,800
Jul-10	$ 4,245,500	$ 1,951,600	$ 2,628,400	$ 1,122,600	$ 65,000	$ 10,013,100
Aug-10	$ 3,795,700	$ 1,983,000	$ 2,495,100	$ 1,058,700	$ 97,500	$ 9,430,000
Sep-10	$ 3,306,200	$ 2,208,300	$ 2,293,500	$ 1,027,300	$ 97,500	$ 8,932,800
Oct-10	$ 3,020,400	$ 2,077,200	$ 2,166,300	$ 962,300	$ 97,500	$ 8,323,700
Nov-10	$ 2,829,900	$ 2,336,100	$ 2,042,400	$ 930,900	$ 97,500	$ 8,236,800
Dec-10	$ 2,567,300	$ 1,877,800	$ 1,908,600	$ 864,800	$ 97,500	$ 7,316,000
Jan-11	$ 3,183,500	$ 2,238,750	$ 1,755,200	$ 975,000	$ 102,000	$ 8,254,450
Feb-11	$ 4,083,150	$ 2,343,050	$ 2,092,250	$ 1,007,850	$ 170,000	$ 9,696,300
Mar-11	$ 4,913,450	$ 2,446,200	$ 2,239,100	$ 1,043,000	$ 204,000	$ 10,845,750
Apr-11	$ 6,181,650	$ 2,518,800	$ 2,644,150	$ 1,078,150	$ 204,000	$ 12,626,750
May-11	$ 6,728,950	$ 2,627,700	$ 2,670,100	$ 1,143,850	$ 238,000	$ 13,408,600
Jun-11	$ 6,229,800	$ 2,761,400	$ 2,604,400	$ 1,179,000	$ 272,000	$ 13,046,600
Jul-11	$ 6,008,200	$ 2,892,800	$ 2,440,150	$ 1,213,000	$ 272,000	$ 12,826,150
Aug-11	$ 5,625,300	$ 2,857,650	$ 2,245,350	$ 1,180,150	$ 306,000	$ 12,214,450
Sep-11	$ 5,376,100	$ 2,822,500	$ 2,190,650	$ 1,147,300	$ 340,000	$ 11,876,550
Oct-11	$ 5,247,150	$ 2,787,350	$ 2,016,700	$ 1,112,150	$ 340,000	$ 11,503,350
Nov-11	$ 4,822,050	$ 2,785,050	$ 1,958,550	$ 1,045,300	$ 374,000	$ 10,984,950
Dec-11	$ 4,358,700	$ 2,579,900	$ 1,817,450	$ 1,012,450	$ 374,000	$ 10,142,500
Jan-12	$ 5,276,250	$ 2,841,750	$ 1,778,000	$ 745,000	$ 396,000	$ 11,037,000
Feb-12	$ 6,583,750	$ 2,915,000	$ 1,965,750	$ 779,750	$ 432,000	$ 12,676,250
Mar-12	$ 7,619,500	$ 3,025,500	$ 2,137,250	$ 818,250	$ 432,000	$ 14,032,500
Apr-12	$ 8,376,000	$ 3,246,500	$ 2,215,750	$ 855,500	$ 432,000	$ 15,125,750
May-12	$ 9,224,250	$ 3,396,750	$ 2,281,500	$ 925,000	$ 468,000	$ 16,295,500
Jun-12	$ 10,242,750	$ 3,575,500	$ 2,315,000	$ 998,250	$ 468,000	$ 17,599,500
Jul-12	$ 9,981,500	$ 3,643,750	$ 2,250,500	$ 1,036,750	$ 468,000	$ 17,380,500
Aug-12	$ 9,312,000	$ 3,534,500	$ 2,208,250	$ 927,500	$ 468,000	$ 16,450,250
Sep-12	$ 8,742,750	$ 3,496,000	$ 2,131,250	$ 855,500	$ 468,000	$ 15,693,500
Oct-12	$ 8,229,250	$ 3,386,750	$ 2,029,250	$ 820,750	$ 468,000	$ 14,934,000
Nov-12	$ 8,037,500	$ 3,349,500	$ 1,917,250	$ 714,000	$ 468,000	$ 14,486,250
Dec-12	$ 7,803,750	$ 3,276,250	$ 1,801,500	$ 712,750	$ 468,000	$ 14,062,250

This worksheet records Tracway revenues from sales by month by region. The world column provides total sales for that month.

F2 Pre-Tax Earnings

Pre-Tax Earnings
	Unit Costs		Production units		Production			Dealer	Tax&Ship
Month	Tractor	Mower	Tractors	Mowers	Cost	Overhead	Revenue	0.2	0.05	Profit	ROR
Jan-08	$ 1,750	$ 50	1590	7020	$ 3,133,500	$ 773,540	$ 5,472,000	$ 1,094,400	$ 273,600	$ 196,960	0.0360
Feb-08	$ 1,755	$ 50	1710	9280	$ 3,465,050	$ 773,540	$ 6,058,000	$ 1,211,600	$ 302,900	$ 304,910	0.0503
Mar-08	$ 1,763	$ 51	1810	9780	$ 3,689,810	$ 773,540	$ 6,408,000	$ 1,281,600	$ 320,400	$ 342,650	0.0535
Apr-08	$ 1,770	$ 51	1860	11100	$ 3,858,300	$ 773,540	$ 6,690,000	$ 1,338,000	$ 334,500	$ 385,660	0.0576
May-08	$ 1,778	$ 51	1770	11930	$ 3,755,490	$ 773,540	$ 6,503,000	$ 1,300,600	$ 325,150	$ 348,220	0.0535
Jun-08	$ 1,785	$ 51	1740	12240	$ 3,730,140	$ 773,540	$ 6,444,000	$ 1,288,800	$ 322,200	$ 329,320	0.0511
Jul-08	$ 1,792	$ 51	1820	10740	$ 3,809,180	$ 773,540	$ 6,534,000	$ 1,306,800	$ 326,700	$ 317,780	0.0486
Aug-08	$ 1,795	$ 51	1690	10080	$ 3,547,630	$ 773,540	$ 6,078,000	$ 1,215,600	$ 303,900	$ 237,330	0.0390
Sep-08	$ 1,801	$ 52	1670	8430	$ 3,446,030	$ 773,540	$ 5,853,000	$ 1,170,600	$ 292,650	$ 170,180	0.0291
Oct-08	$ 1,804	$ 52	1650	7650	$ 3,374,400	$ 773,540	$ 5,715,000	$ 1,143,000	$ 285,750	$ 138,310	0.0242
Nov-08	$ 1,810	$ 52	1810	6650	$ 3,621,900	$ 773,540	$ 6,095,000	$ 1,219,000	$ 304,750	$ 175,810	0.0288
Dec-08	$ 1,813	$ 52	1720	5620	$ 3,410,600	$ 773,540	$ 5,722,000	$ 1,144,400	$ 286,100	$ 107,360	0.0188
Jan-09	$ 1,835	$ 55	1760	7020	$ 3,615,700	$ 831,570	$ 6,193,100	$ 1,238,620	$ 309,655	$ 197,555	0.0319
Feb-09	$ 1,841	$ 55	2030	9030	$ 4,233,880	$ 831,570	$ 7,241,150	$ 1,448,230	$ 362,058	$ 365,413	0.0505
Mar-09	$ 1,848	$ 55	2140	10050	$ 4,507,470	$ 831,570	$ 7,689,250	$ 1,537,850	$ 384,463	$ 427,898	0.0556
Apr-09	$ 1,854	$ 55	2340	10890	$ 4,937,310	$ 831,570	$ 8,397,450	$ 1,679,490	$ 419,873	$ 529,208	0.0630
May-09	$ 1,860	$ 56	2280	11420	$ 4,880,320	$ 831,570	$ 8,267,100	$ 1,653,420	$ 413,355	$ 488,435	0.0591
Jun-09	$ 1,866	$ 56	2270	12270	$ 4,922,940	$ 831,570	$ 8,325,350	$ 1,665,070	$ 416,268	$ 489,503	0.0588
Jul-09	$ 1,872	$ 56	2150	10720	$ 4,625,120	$ 831,570	$ 7,790,600	$ 1,558,120	$ 389,530	$ 386,260	0.0496
Aug-09	$ 1,878	$ 56	2140	9650	$ 4,559,320	$ 831,570	$ 7,647,250	$ 1,529,450	$ 382,363	$ 344,548	0.0451
Sep-09	$ 1,885	$ 56	2080	8310	$ 4,386,160	$ 831,570	$ 7,320,550	$ 1,464,110	$ 366,028	$ 272,683	0.0372
Oct-09	$ 1,892	$ 57	1970	7510	$ 4,155,310	$ 831,570	$ 6,895,550	$ 1,379,110	$ 344,778	$ 184,783	0.0268
Nov-09	$ 1,897	$ 57	1930	6250	$ 4,017,460	$ 831,570	$ 6,639,250	$ 1,327,850	$ 331,963	$ 130,408	0.0196
Dec-09	$ 1,903	$ 57	1840	5370	$ 3,807,610	$ 831,570	$ 6,267,850	$ 1,253,570	$ 313,393	$ 61,708	0.0098
Jan-10	$ 1,925	$ 59	2000	6970	$ 4,261,230	$ 950,120	$ 7,266,700	$ 1,453,340	$ 363,335	$ 238,675	0.0328
Feb-10	$ 1,931	$ 59	2320	9160	$ 5,020,360	$ 950,120	$ 8,547,600	$ 1,709,520	$ 427,380	$ 440,220	0.0515
Mar-10	$ 1,938	$ 59	2510	9970	$ 5,452,610	$ 950,120	$ 9,254,200	$ 1,850,840	$ 462,710	$ 537,920	0.0581
Apr-10	$ 1,944	$ 59	2670	11020	$ 5,840,660	$ 950,120	$ 9,889,700	$ 1,977,940	$ 494,485	$ 626,495	0.0633
May-10	$ 1,950	$ 59	2780	11780	$ 6,116,020	$ 950,120	$ 10,330,800	$ 2,066,160	$ 516,540	$ 681,960	0.0660
Jun-10	$ 1,956	$ 60	2800	12280	$ 6,213,600	$ 950,120	$ 10,450,800	$ 2,090,160	$ 522,540	$ 674,380	0.0645
Jul-10	$ 1,963	$ 60	2710	10960	$ 5,977,330	$ 950,120	$ 10,013,100	$ 2,002,620	$ 500,655	$ 582,375	0.0582
Aug-10	$ 1,969	$ 60	2580	9500	$ 5,650,020	$ 950,120	$ 9,430,000	$ 1,886,000	$ 471,500	$ 472,360	0.0501
Sep-10	$ 1,976	$ 60	2470	8230	$ 5,374,520	$ 950,120	$ 8,932,800	$ 1,786,560	$ 446,640	$ 374,960	0.0420
Oct-10	$ 1,983	$ 60	2310	7420	$ 5,025,930	$ 950,120	$ 8,323,700	$ 1,664,740	$ 416,185	$ 266,725	0.0320
Nov-10	$ 1,990	$ 61	2310	6630	$ 5,001,330	$ 950,120	$ 8,236,800	$ 1,647,360	$ 411,840	$ 226,150	0.0275
Dec-10	$ 1,996	$ 61	2070	5350	$ 4,458,070	$ 950,120	$ 7,316,000	$ 1,463,200	$ 365,800	$ 78,810	0.0108
Jan-11	$ 1,940	$ 59	2190	7030	$ 4,663,370	$ 851,370	$ 8,254,450	$ 1,650,890	$ 412,723	$ 676,098	0.0819
Feb-11	$ 1,946	$ 59	2540	9220	$ 5,486,820	$ 851,370	$ 9,696,300	$ 1,939,260	$ 484,815	$ 934,035	0.0963
Mar-11	$ 1,952	$ 59	2850	10050	$ 6,156,150	$ 851,370	$ 10,845,750	$ 2,169,150	$ 542,288	$ 1,126,793	0.1039
Apr-11	$ 1,958	$ 59	3340	11050	$ 7,191,670	$ 851,370	$ 12,626,750	$ 2,525,350	$ 631,338	$ 1,427,023	0.1130
May-11	$ 1,964	$ 60	3550	11640	$ 7,670,600	$ 851,370	$ 13,408,600	$ 2,681,720	$ 670,430	$ 1,534,480	0.1144
Jun-11	$ 1,970	$ 60	3430	12040	$ 7,479,500	$ 851,370	$ 13,046,600	$ 2,609,320	$ 652,330	$ 1,454,080	0.1115
Jul-11	$ 1,976	$ 60	3400	11010	$ 7,379,000	$ 851,370	$ 12,826,150	$ 2,565,230	$ 641,308	$ 1,389,243	0.1083
Aug-11	$ 1,983	$ 60	3260	9830	$ 7,054,380	$ 851,370	$ 12,214,450	$ 2,442,890	$ 610,723	$ 1,255,088	0.1028
Sep-11	$ 1,990	$ 60	3210	8370	$ 6,890,100	$ 851,370	$ 11,876,550	$ 2,375,310	$ 593,828	$ 1,165,943	0.0982
Oct-11	$ 1,996	$ 60	3130	7490	$ 6,696,880	$ 851,370	$ 11,503,350	$ 2,300,670	$ 575,168	$ 1,079,263	0.0938
Nov-11	$ 2,012	$ 61	3010	6530	$ 6,454,450	$ 851,370	$ 10,984,950	$ 2,196,990	$ 549,248	$ 932,893	0.0849
Dec-11	$ 2,008	$ 61	2770	6300	$ 5,946,460	$ 851,370	$ 10,142,500	$ 2,028,500	$ 507,125	$ 809,045	0.0798
Jan-12	$ 2,073	$ 63	2820	7080	$ 6,291,900	$ 852,160	$ 11,037,000	$ 2,207,400	$ 551,850	$ 1,133,690	0.1027
Feb-12	$ 2,077	$ 63	3200	9250	$ 7,229,150	$ 852,160	$ 12,676,250	$ 2,535,250	$ 633,813	$ 1,425,878	0.1125
Mar-12	$ 2,081	$ 63	3550	10020	$ 8,018,810	$ 852,160	$ 14,032,500	$ 2,806,500	$ 701,625	$ 1,653,405	0.1178
Apr-12	$ 2,086	$ 63	3820	10990	$ 8,660,890	$ 852,160	$ 15,125,750	$ 3,025,150	$ 756,288	$ 1,831,263	0.1211
May-12	$ 2,092	$ 63	4130	11420	$ 9,359,420	$ 852,160	$ 16,295,500	$ 3,259,100	$ 814,775	$ 2,010,045	0.1233
Jun-12	$ 2,098	$ 63	4470	12060	$ 10,137,840	$ 852,160	$ 17,599,500	$ 3,519,900	$ 879,975	$ 2,209,625	0.1256
Jul-12	$ 2,104	$ 64	4430	11460	$ 10,054,160	$ 852,160	$ 17,380,500	$ 3,476,100	$ 869,025	$ 2,129,055	0.1225
Aug-12	$ 2,110	$ 64	4240	9490	$ 9,553,760	$ 852,160	$ 16,450,250	$ 3,290,050	$ 822,513	$ 1,931,768	0.1174
Sep-12	$ 2,116	$ 64	4060	8620	$ 9,142,640	$ 852,160	$ 15,693,500	$ 3,138,700	$ 784,675	$ 1,775,325	0.1131
Oct-12	$ 2,122	$ 64	3890	7440	$ 8,730,740	$ 852,160	$ 14,934,000	$ 2,986,800	$ 746,700	$ 1,617,600	0.1083
Nov-12	$ 2,129	$ 64	3800	6450	$ 8,503,000	$ 852,160	$ 14,486,250	$ 2,897,250	$ 724,313	$ 1,509,528	0.1042
Dec-12	$ 2,135	$ 64	3710	5650	$ 8,282,450	$ 852,160	$ 14,062,250	$ 2,812,450	$ 703,113	$ 1,412,078	0.1004

This worksheet calculates Tracway costs to include overhead allocation. Production cost is unit cost times unit volume totaled over both products. Overhead is spread equally by month. Revenue is the total for both products by month. Dealer's receive 20% of Tracway revenue. Tax & shipping is 5% of revenue. ROR is profit/revenue.

I1 On-Time Delivery

On-Time Delivery
Month	Percent	Number of deliveries
Jan-08	98.4%	1086
Feb-08	98.1%	1101
Mar-08	98.3%	1108
Apr-08	98.6%	1216
May-08	98.7%	1183
Jun-08	98.6%	1176
Jul-08	98.6%	1198
Aug-08	98.7%	1205
Sep-08	98.7%	1226
Oct-08	98.8%	1209
Nov-08	98.5%	1198
Dec-08	98.4%	1243
Jan-09	98.6%	1218
Feb-09	98.6%	1241
Mar-09	98.5%	1236
Apr-09	98.7%	1258
May-09	98.7%	1262
Jun-09	98.8%	1227
Jul-09	98.7%	1243
Aug-09	98.7%	1281
Sep-09	98.6%	1272
Oct-09	98.7%	1295
Nov-09	98.7%	1298
Dec-09	98.7%	1313
Jan-10	98.8%	1279
Feb-10	98.8%	1320
Mar-10	98.7%	1352
Apr-10	98.8%	1336
May-10	98.8%	1291
Jun-10	98.8%	1342
Jul-10	98.9%	1352
Aug-10	98.8%	1377
Sep-10	98.8%	1385
Oct-10	98.7%	1356
Nov-10	98.8%	1362
Dec-10	98.8%	1349
Jan-11	98.9%	1386
Feb-11	98.8%	1358
Mar-11	98.9%	1371
Apr-11	99.0%	1362
May-11	99.1%	1350
Jun-11	98.9%	1381
Jul-11	99.0%	1392
Aug-11	99.1%	1371
Sep-11	98.9%	1402
Oct-11	99.0%	1384
Nov-11	99.0%	1391
Dec-11	99.1%	1369
Jan-12	99.2%	1401
Feb-12	99.1%	1388
Mar-12	99.3%	1395
Apr-12	99.2%	1412
May-12	99.2%	1403
Jun-12	99.1%	1415
Jul-12	99.2%	1426
Aug-12	99.2%	1431
Sep-12	99.2%	1438
Oct-12	99.2%	1425
Nov-12	99.3%	1413
Dec-12	99.2%	1439

This worksheet shows the percent of all shipments to Tracway from suppliers that meet Tracway's delivery-to-need date.

I2 Defects After Delivery

Defects After Delivery
	2008	2009	2010	2011	2012
January	812	828	824	782	771
February	810	832	836	795	775
March	813	847	818	792	747
April	823	839	825	786	742
May	832	832	804	773	756
June	848	840	812	781	749
July	837	849	806	796	743
August	831	857	798	788	751
September	827	839	804	784	741
October	838	842	813	772	745
November	826	828	805	777	738
December	819	816	786	769	736

This worksheet shows the number of defects per million items found upon receipt for all shipments received by Tracway from its suppliers.

I3 Time to Pay Suppliers

Time to Pay Suppliers
Month	Working Days
Jan-08	8.32
Feb-08	8.28
Mar-08	8.29
Apr-08	8.32
May-08	8.36
Jun-08	8.35
Jul-08	8.34
Aug-08	8.3
Sep-08	8.36
Oct-08	8.33
Nov-08	8.32
Dec-08	8.29
Jan-09	7.89
Feb-09	7.65
Mar-09	7.58
Apr-09	7.53
May-09	7.48
Jun-09	7.43
Jul-09	7.36
Aug-09	7.35
Sep-09	7.32
Oct-09	7.3
Nov-09	7.27
Dec-09	7.25
Jan-10	7.22
Feb-10	7.21
Mar-10	7.22
Apr-10	7.2
May-10	7.25
Jun-10	7.23
Jul-10	7.28
Aug-10	7.25
Sep-10	7.24
Oct-10	7.26
Nov-10	7.21
Dec-10	7.23
Jan-11	7.24
Feb-11	7.19
Mar-11	7.21
Apr-11	7.23
May-11	7.22
Jun-11	7.19
Jul-11	7.17
Aug-11	7.18
Sep-11	7.16
Oct-11	7.16
Nov-11	7.15
Dec-11	7.14
Jan-12	7.12
Feb-12	7.11
Mar-12	7.11
Apr-12	7.11
May-12	7.11
Jun-12	7.1
Jul-12	7.1
Aug-12	7.09
Sep-12	7.09
Oct-12	7.09
Nov-12	7.09
Dec-12	7.08

This worksheet shows the average days from the time an invoice is received until Tracway sends payment.

I4 Response Time

Response time
Q1 2011	Q2 2011	Q3 2011	Q4 2011	Q1 2012	Q2 2012	Q3 2012	Q4 2012
4.36	4.33	3.71	4.44	2.75	3.45	1.67	2.55
5.42	4.73	2.52	4.07	3.24	1.95	2.58	2.30
5.50	1.63	2.69	5.11	4.35	2.77	3.47	1.04
2.79	4.21	3.47	3.49	5.58	1.83	3.12	1.59
5.55	6.89	5.12	4.69	2.89	3.72	1.00	3.11
3.65	0.92	1.00	6.36	5.09	4.59	5.40	4.05
8.02	5.27	3.44	8.26	2.33	1.17	3.90	3.38
4.00	0.90	6.04	1.91	1.69	1.46	4.49	1.26
3.34	3.85	2.53	8.93	3.88	1.90	2.06	0.90
4.92	5.00	2.39	6.85	3.39	2.95	4.49	2.31
3.55	3.52	3.26	5.69	5.14	4.69	3.57	2.71
3.52	5.20	4.68	3.05	0.98	3.34	3.41	1.65
1.25	5.13	3.59	5.91	2.34	3.59	3.31	3.58
2.18	5.29	1.07	1.00	2.80	4.03	2.79	2.96
4.35	1.00	2.86	1.82	3.06	2.39	2.09	3.78
2.46	2.18	4.44	3.74	2.40	1.63	4.28	2.87
2.07	4.55	4.87	6.11	1.59	2.40	4.47	0.90
2.90	2.13	6.76	4.78	3.05	4.44	1.94	4.87
2.58	5.24	2.84	4.13	1.50	4.96	3.90	3.11
5.50	4.08	1.25	7.17	5.58	4.41	3.32	0.90
2.47	4.04	3.43	5.70	3.11	3.40	2.20	3.52
4.24	5.09	2.98	1.00	1.08	3.15	3.52	3.18
1.88	7.66	4.65	3.40	3.63	4.87	2.31	0.90
4.25	4.65	2.66	2.04	1.86	3.97	1.00	1.35
5.08	0.90	4.99	4.37	1.90	3.85	5.90	1.62
4.40	2.01	3.76	2.47	6.07	2.81	1.09	1.87
1.64	1.34	3.12	3.20	1.00	1.76	4.60	1.03
6.40	8.05	2.12	5.83	1.00	5.58	3.52	2.31
3.68	4.91	4.32	3.94	1.19	4.92	4.14	1.99
3.92	5.06	3.61	2.47	3.79	2.63	4.13	3.97
4.13	3.26	4.02	3.89	5.86	3.27	2.43	1.00
3.34	4.26	2.63	6.88	0.90	2.86	2.34	3.51
3.28	1.70	4.47	1.71	2.24	3.83	2.53	2.41
3.24	2.30	4.18	6.39	0.90	1.79	4.14	2.47
3.25	5.35	4.73	6.57	3.87	2.70	2.65	4.02
5.20	2.33	2.65	4.18	2.46	3.61	3.21	2.03
5.28	3.67	2.36	8.82	3.84	0.90	3.85	3.62
4.33	4.73	3.64	3.35	2.43	3.38	2.20	4.12
4.64	1.05	5.62	5.50	1.54	4.38	4.57	1.40
2.65	2.67	0.90	6.51	0.90	2.87	2.99	2.49
3.42	4.16	6.40	0.90	3.69	2.11	4.19	2.67
3.97	0.90	3.21	2.87	1.73	2.86	3.03	4.33
1.26	3.51	3.55	7.45	3.52	3.12	1.90	1.95
6.16	5.95	5.93	3.49	2.23	1.86	2.09	2.70
6.40	2.05	5.52	3.03	5.35	2.41	1.03	1.76
1.00	8.21	4.96	7.46	5.11	2.98	2.95	2.64
3.63	2.52	4.85	4.84	6.46	0.90	7.42	4.49
5.34	3.99	5.57	2.88	5.61	1.01	3.79	1.62
3.74	2.59	4.82	0.95	3.63	4.56	2.48	1.10
5.63	1.34	3.18	3.05	3.87	5.67	2.71	4.50

This worksheet gives samples of Tracway response times to customer service calls each quarter. Data are given in hours.

L1 Employee Satisfaction

Employee Satisfaction
	Design &				Sales &
Quarter	Production	Sample size	Manager	Sample size	Administration	Sample size	Total	Sample size
1st Q-09	2.86	100	3.81	10	3.51	30	3.07	140
2nd Q-09	2.91	100	3.76	10	3.38	30	3.07	140
3rd Q-09	2.84	100	3.82	10	3.42	30	3.03	140
4th Q-09	2.83	100	3.48	10	3.61	30	3.04	140
1st Q-10	2.91	100	3.75	20	3.37	30	3.11	150
2nd Q-10	2.94	100	3.92	20	3.53	30	3.19	150
3rd Q-10	2.86	100	3.89	20	3.47	30	3.12	150
4th Q-10	2.83	100	3.58	20	3.66	30	3.10	150
1st Q-11	2.95	100	3.82	20	3.71	40	3.25	160
2nd Q-11	3.01	100	4.01	20	3.53	40	3.27	160
3rd Q-11	3.03	100	3.92	20	3.61	40	3.29	160
4th Q-11	2.96	100	3.86	20	3.48	40	3.20	160
1st Q-12	3.08	100	3.92	20	3.52	40	3.30	160
2nd Q-12	3.12	100	4.00	20	3.37	40	3.29	160
3rd Q-12	3.06	100	3.93	20	3.46	40	3.27	160
4th Q-12	3.01	100	3.72	20	3.58	40	3.24	160

This worksheet shows Tracway employee overall job satisfaction survey results by classification. Data are averages. Scores are arithmetic means of overall satisfaction on a 0 to 5 rating scale.

S1 Engines

Engines
Sample	Time (min)
1	65.1
2	62.3
3	60.4
4	58.7
5	58.1
6	56.9
7	57.0
8	56.5
9	55.1
10	54.3
11	53.7
12	53.2
13	52.8
14	52.5
15	52.1
16	51.8
17	51.5
18	51.3
19	50.9
20	50.5
21	50.2
22	50.0
23	49.7
24	49.5
25	49.3
26	49.4
27	49.1
28	49.0
29	48.8
30	48.5
31	48.3
32	48.2
33	48.1
34	47.9
35	47.7
36	47.6
37	47.4
38	47.1
39	46.9
40	46.8
41	46.7
42	46.6
43	46.5
44	46.5
45	46.2
46	46.3
47	46.0
48	45.8
49	45.7
50	45.6

This worksheet gives data for fifty test samples of the time required to produce a new lawn mower engine using a new technology.

S2 Transmission Costs

Transmission Costs
Current	Process A	Process B
$ 242	$ 242	$ 292
$ 176	$ 275	$ 321
$ 286	$ 199	$ 314
$ 269	$ 219	$ 242
$ 327	$ 273	$ 278
$ 264	$ 265	$ 300
$ 296	$ 435	$ 301
$ 333	$ 285	$ 286
$ 242	$ 384	$ 315
$ 288	$ 387	$ 300
$ 314	$ 299	$ 304
$ 302	$ 145	$ 300
$ 335	$ 266	$ 351
$ 242	$ 216	$ 277
$ 281	$ 331	$ 284
$ 289	$ 247	$ 276
$ 259	$ 280	$ 312
$ 322	$ 267	$ 273
$ 209	$ 210	$ 281
$ 282	$ 391	$ 303
$ 304	$ 297	$ 306
$ 391	$ 346	$ 312
$ 236	$ 230	$ 287
$ 383	$ 332	$ 306
$ 299	$ 301	$ 312
$ 300	$ 277	$ 295
$ 278	$ 336	$ 288
$ 303	$ 217	$ 313
$ 315	$ 274	$ 286
$ 321	$ 339	$ 338

This worksheet contains sample data for existing Tracway transmission production, as well as for two new processes. Costs represent the costs to build one tractor transmission.

S3 Blade Weight

Blade Weight
Sample		Observations				Sample mean	Sample range
1	4.88	4.75	4.97	4.93	5.05	4.916	0.30
2	4.92	4.99	5.06	4.88	4.97	4.964	0.18
3	5.02	5.00	5.06	4.88	4.96	4.984	0.18
4	4.97	4.91	5.04	4.81	4.96	4.938	0.23
5	5.00	5.18	4.87	5.16	4.99	5.040	0.31
6	4.99	4.95	5.00	5.03	5.04	5.002	0.09
7	4.86	4.63	5.03	4.87	4.91	4.860	0.40
8	5.07	4.89	5.02	5.09	5.19	5.052	0.30
9	5.04	5.11	5.02	4.94	5.03	5.028	0.17
10	4.87	5.05	5.06	5.08	4.99	5.010	0.21
11	4.77	5.03	5.21	4.97	5.12	5.020	0.44
12	5.14	5.02	5.09	5.23	4.97	5.090	0.26
13	5.04	4.96	4.97	5.12	4.88	4.994	0.24
14	5.00	5.04	5.01	5.09	5.07	5.042	0.09
15	4.88	4.93	4.90	5.12	5.01	4.968	0.24
16	4.91	5.06	4.89	4.93	4.89	4.936	0.17
17	5.09	5.07	4.93	4.79	4.95	4.966	0.30
18	4.97	5.00	5.16	5.10	5.09	5.064	0.19
19	4.98	5.03	5.02	5.12	5.09	5.048	0.14
20	5.07	5.00	5.01	4.86	4.89	4.966	0.21
21	5.03	4.95	5.10	5.00	4.93	5.002	0.17
22	5.12	4.99	5.03	4.94	4.85	4.986	0.27
23	5.08	5.02	5.07	4.95	5.03	5.030	0.13
24	4.86	4.90	4.92	4.95	4.92	4.910	0.09
25	5.11	5.10	5.08	4.87	5.09	5.050	0.24
26	4.92	5.01	4.96	5.09	4.99	4.994	0.17
27	5.18	4.84	4.74	4.94	4.92	4.924	0.44
28	4.93	5.01	4.91	5.01	4.87	4.946	0.14
29	5.12	4.88	5.12	5.04	4.90	5.012	0.24
30	5.08	4.97	5.00	5.05	5.02	5.024	0.11

This worksheet provides samples of mower blade weights with calculated sample means and ranges.

S4 Mower Test

Mower Test

Sample

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

This worksheet provides 30 samples of 100 test results of mower functional performance after assembly.

S5 Process Capability

Process Capability														zigzag
5.21
5.02
4.9
5														0.05
5.16														0.05
5.03														0.05
4.96														0.05
5.04														0.05
4.98														0.05
5.07														0.05
5.02														0.05
5.06														0.05
4.85														0.05
4.9														0.05
4.97														0.05
5.09														0.05
4.89														0.05
4.87														0.05
5.01														0.05
4.97														0.05
4.85														0.05
5.3														0.05
5.1														0.05
5.07														0.05
4.93														0.05
4.99														0.05
5.04														0.05
5.14														0.05
5.09														0.05
5.06														0.05
4.85														0.05
4.93														0.05
5.04														0.05
5.09														0.05
5.07														0.05
4.99														0.05
5.01														0.05
4.88														0.05
4.93														0.05
5.1														0.05
4.94														0.05
4.88														0.05
4.89														0.05
4.89														0.05
4.85														0.05
4.8														0.05
5.02														0.05
4.9														0.05
4.73														0.05
5.04														0.05
5.07														0.05
4.81														0.05
5.04														0.05
5.03														0.05
5														0.05
5.1														0.05
5.1														0.05
4.89														0.05
4.91														0.05
4.97														0.05
4.98														0.05
5.01														0.05
5.01														0.05
5.09														0.05
4.93														0.05
5.04														0.05
5.11														0.05
5.07														0.05
4.95														0.05
4.86														0.05
5.1														0.05
4.95														0.05
5.22														0.05
4.81														0.05
4.91														0.05
4.9														0.05
4.94														0.05
4.81														0.05
5.11														0.05
4.81														0.05
4.97														0.05
5.07														0.05
5.03														0.05
4.81														0.05
4.95														0.05
4.89														0.05
5.08														0.05
4.93														0.05
5														0.05
4.94														0.05
5.13														0.05
5														0.05
5.07														0.05
4.82														0.05
5.03														0.05
4.85														0.05
4.89														0.05
4.82														0.05
5.18														0.05
5.02														0.05
5.05														0.05
4.88														0.05
5.08														0.05
4.98
5.02
4.99
5.02
5.03
5.02
5.07
4.95
4.95
4.94
5.12
5.08
4.91
4.96
4.96
4.94
5.19
4.91
5.01
4.93
5.05
4.96
4.92
4.95
5.08
4.97
5.04
4.94
4.98
5.03
5.05
4.9
5.09
5.21
4.87
5.02
4.81
4.96
5.06
4.86
4.96
4.99
4.94
5.06
4.95
5.02
5.01
5.04
5.01
5.02
5.03
5.18
5.1
5.14
4.92
4.97
4.92
5.14
4.92
5.03
4.98
4.76
4.94
4.9
4.91
4.96
5
5.13
5.13
4.92
4.98
4.89
4.88
5.11
5.11
5
5.03
4.94
4.88
4.91
4.86
4.9
4.9
4.87
4.93
5.14
4.87
5
4.88
4.88
5
4.9
4.93
4.99
4.91
4.96
4.78

This worksheet contains 200 samples of blade weights taken from a controlled process.

S6 Employee Retention

Employee Retention
Duration	Yrseducation	College gpa	Age	M/F	College Grad	Local
10	18	3.01	33	0	1	1
10	16	2.78	25	1	1	1
10	18	3.15	26	1	1	0
10	18	3.86	24	0	1	1
9.6	16	2.58	25	0	1	1
8.5	16	2.96	23	1	1	1
8.4	17	3.56	35	1	1	1
8.4	16	2.64	23	1	1	1
8.2	18	3.43	32	0	1	1
7.9	15	2.75	34	1	0	1
7.6	13	2.95	28	1	0	1
7.5	13	2.50	23	1	0	1
7.5	16	2.86	24	1	1	1
7.2	15	2.38	23	0	0	1
6.8	16	3.47	27	0	1	1
6.5	16	3.10	26	1	1	1
6.3	13	2.98	21	1	0	1
6.2	16	2.71	23	1	1	0
5.9	13	2.95	20	0	0	1
5.8	18	3.36	25	1	1	1
5.4	16	2.75	24	1	1	0
5.1	17	2.48	32	1	1	0
4.8	14	2.76	28	1	0	1
4.7	16	3.12	25	0	1	0
4.5	13	2.96	23	1	0	1
4.3	16	2.80	25	1	1	0
4	17	3.57	24	1	1	1
3.9	16	3.00	26	0	1	0
3.7	16	2.86	23	1	1	0
3.7	15	3.19	24	1	0	0
3.7	16	3.50	23	0	1	0
3.5	14	2.84	21	1	0	1
3.4	16	3.13	24	1	1	0
2.5	13	1.75	22	1	0	0
1.8	16	2.98	25	1	1	0
1.5	15	2.13	22	1	0	0
0.9	16	2.79	23	0	1	1
0.8	18	3.15	26	1	1	0
0.7	13	1.84	22	0	0	0
0.3	18	3.79	24	0	1	0

This worksheet gives cross-sectional data for 40 Tracway managers who were first employed within the last 10 years. Variables are: Duration - years with Tracway Yrseducation - years of school completed College gpa - GPA in college Age - age when hired M/F - male = 0; female = 1 College grad - obtained college degree Local - from the local area when hired