Accounting assignments

Exam500896-MotomartExcelSpreadsheet.xlsx

Home >Business & Finance homework help >Accounting homework help >Accounting assignments

Plot-Salary

MONTH	NRVS (X)	SALARY (Y)	XY	X squared	Y squared	VACATION	ADV/TRNG	SPLY/LNDRY	FREIGHT	VEHICLES	DEMO'S	FLOOR-PLAN	TOTAL	NRVS	249
1	197	197	52,951	52,951	10,431,347	38,809	2,803,808,401	- 0	22,561	1,118	382	2,052	1,881	(78,173)	2,814,334,280	SALARIES	82,516	A-fixed cost
2	133	133	47,054	47,054	6,258,182	17,689	2,214,078,916	- 0	19,040	3,573	409	1,405	695	28,456	2,220,502,473	VC/UNIT	331.39	B-variable cost
3	132	132	55,372	55,372	7,309,104	17,424	3,066,058,384	- 0	14,373	1,388	742	1,380	469	34,423	3,073,548,431	TOTAL-HIGH	35,217.92
4	141	141	46,114	46,114	6,502,074	19,881	2,126,500,996	- 0	15,022	2,894	675	2,057	125	5,697	2,133,141,649	TOTAL-LOW	35,217.92
5	182	182	48,309	48,309	8,792,238	33,124	2,333,759,481	- 0	19,966	1,896	572	1,603	131	34,599	2,342,740,228
6	156	156	49,643	49,643	7,744,308	24,336	2,464,427,449	- 0	12,019	1,188	407	2,524	1,229	53,737	2,472,366,483	VACATION
7	196	196	55,784	55,784	10,933,664	38,416	3,111,854,656	300	13,217	3,912	643	2,348	1,206	5,507	3,122,965,437
8	178	178	47,957	47,957	8,536,346	31,684	2,299,873,849	- 0	17,303	2,012	605	1,208	436	32,436	2,308,591,793
9	159	159	53,743	53,743	8,545,137	25,281	2,888,310,049	- 0	16,535	2,717	209	2,400	1,476	28,950	2,897,040,240
10	141	141	53,109	53,109	7,488,369	19,881	2,820,565,881	- 0	23,821	1,102	184	2,076	1,168	20,876	2,828,229,576
11	152	152	45,491	45,491	6,914,632	23,104	2,069,431,081	300	14,146	2,630	331	1,677	635	45,278	2,076,524,796
12	31	31	57,479	57,479	1,781,849	961	3,303,835,441	- 0	22,223	7,043	560	2,183	1,014	66,745	3,305,832,977
13	280	280	49,049	49,049	13,733,720	78,400	2,405,804,401	- 0	19,992	1,999	582	1,927	(477)	(30,104)	2,419,708,538
14	136	136	46,698	46,698	6,350,928	18,496	2,180,703,204	300	20,251	1,192	603	1,156	1,839	50,583	2,187,241,948
15	174	174	59,790	59,790	10,403,460	30,276	3,574,844,100	200	20,082	1,336	492	1,898	1,260	18,803	3,585,441,487
16	171	171	80,773	80,773	13,812,183	29,241	6,524,277,529	600	26,716	3,873	559	1,808	510	23,080	6,538,337,645
17	167	167	71,130	71,130	11,878,710	27,889	5,059,476,900	9,212	25,223	5,560	356	1,816	2,350	18,774	5,071,589,050
18	161	161	82,490	82,490	13,280,890	25,921	6,804,600,100	6,007	21,106	1,737	439	1,384	(288)	23,802	6,818,126,078
19	173	173	98,172	98,172	16,983,756	29,929	9,637,741,584	500	17,799	1,847	1,628	1,962	1,591	33,848	9,655,010,788
20	161	161	90,685	90,685	14,600,285	25,921	8,223,769,225	2,690	28,038	4,415	(12)	2,446	(3,308)	13,480	8,238,624,550
21	167	167	97,771	97,771	16,327,757	27,889	9,559,168,441	600	37,284	2,827	480	2,296	1,709	22,965	9,575,787,790
22	153	153	87,129	87,129	13,330,737	23,409	7,591,462,641	1,740	24,236	5,836	79	3,175	798	18,898	7,605,045,807
23	201	201	95,910	95,910	19,277,910	40,401	9,198,728,100	2,074	27,244	3,387	188	1,287	(2,025)	38,699	9,218,309,085
24	33	33	109,192	109,192	3,603,336	1,089	11,922,892,864	2,782	20,376	12,132	593	2,563	1,010	68,285	11,926,823,414
25	227	227	89,041	89,041	20,212,307	51,529	7,928,299,681	1,880	26,719	4,383	769	2,205	2,493	(44,140)	7,948,735,908
26	150	150	92,165	92,165	13,824,750	22,500	8,494,387,225	3,602	14,727	10,231	593	2,289	(2,051)	36,311	8,508,484,507
27	142	142	88,981	88,981	12,635,302	20,164	7,917,618,361	744	27,880	7,734	414	1,891	386	19,865	7,930,510,703
28	104	104	95,898	95,898	9,973,392	10,816	9,196,426,404	960	21,872	(684)	425	2,288	178	19,013	9,206,646,460
29	121	121	96,245	96,245	11,645,645	14,641	9,263,100,025	- 0	18,705	8,329	483	2,223	(262)	16,228	9,274,998,507
30	99	99	106,364	106,364	10,530,036	9,801	11,313,300,496	- 0	23,835	2,540	417	1,683	(1,356)	37,637	11,324,117,817
31	150	150	90,564	90,564	13,584,600	22,500	8,201,838,096	1,950	25,605	5,862	222	1,586	486	(1,121)	8,215,660,914
32	144	144	98,418	98,418	14,172,192	20,736	9,686,102,724	1,540	17,763	6,998	49	1,751	(1,924)	34,757	9,700,553,422
33	154	154	110,436	110,436	17,007,144	23,716	12,196,110,096	2,693	32,379	8,131	818	2,082	1,547	26,419	12,213,435,897
34	130	130	102,042	102,042	13,265,460	16,900	10,412,569,764	1,060	19,324	6,026	1,015	1,714	132	21,134	10,426,106,613
35	202	202	124,413	124,413	25,131,426	40,804	15,478,594,569	3,519	22,412	9,120	1,255	2,173	(2,337)	18,578	15,504,070,345
36	51	51	116,897	116,897	5,961,747	2,601	13,664,908,609	1,520	29,998	6,798	68	1,779	1,195	91,520	13,671,239,629
37	148	148	97,083	97,083	14,368,284	21,904	9,425,108,889	1,080	9,112	6,627	565	1,324	1,164	(73,753)	9,439,639,362
38	153	153	104,727	104,727	16,023,231	23,409	10,967,744,529	3,230	38,616	5,892	369	1,523	(1,839)	30,443	10,984,078,857
39	83	83	95,622	95,622	7,936,626	6,889	9,143,566,884	953	22,690	3,450	(182)	2,087	454	17,725	9,151,748,820
40	101	101	96,438	96,438	9,740,238	10,201	9,300,287,844	1,244	14,703	5,259	709	2,095	868	26,402	9,310,282,439
41	140	140	114,995	114,995	16,099,300	19,600	13,223,850,025	- 0	28,764	2,294	1,006	1,304	(1,990)	(3,789)	13,240,226,504
42	132	132	105,337	105,337	13,904,484	17,424	11,095,883,569	160	27,253	8,155	521	1,667	1,869	15,090	11,110,070,866
43	112	112	98,989	98,989	11,086,768	12,544	9,798,822,121	2,480	24,419	1,621	514	1,040	329	(945)	9,810,148,869
44	127	127	124,352	124,352	15,792,704	16,129	15,463,419,904	1,800	26,011	902	917	2,880	(1,897)	30,405	15,479,538,459
45	139	139	115,875	115,875	16,106,625	19,321	13,427,015,625	1,417	24,492	5,158	(77)	1,281	2,959	14,781	13,443,423,332
46	156	156	113,035	113,035	17,633,460	24,336	12,776,911,225	1,820	31,158	2,901	450	2,259	417	15,613	12,794,849,709
47	126	126	119,106	119,106	15,007,356	15,876	14,186,239,236	3,338	32,213	14,426	120	1,394	(2,659)	40,968	14,201,590,480
48	33	33	104,199	104,199	3,438,567	1,089	10,857,431,601	1,537	30,177	9,250	819	1,516	4,517	43,189	10,861,170,660
49	209	209	98,938	98,938	20,678,042	43,681	9,788,727,844	1,866	26,737	1,694	853	1,657	601	(20,127)	9,809,660,724
50	124	124	108,606	108,606	13,467,144	15,376	11,795,263,236	3,676	31,084	9,040	498	2,266	(284)	18,236	11,809,027,484
51	131	131	106,396	106,396	13,937,876	17,161	11,320,108,816	1,197	33,278	2,099	605	1,952	668	15,176	11,334,331,620
52	144	144	106,778	106,778	15,376,032	20,736	11,401,541,284	241	32,657	9,328	483	1,852	1,409	25,245	11,417,222,823
53	93	93	124,805	124,805	11,606,865	8,649	15,576,288,025	500	29,794	4,268	788	1,704	(1,771)	6,493	15,588,194,925
54	199	199	110,153	110,153	21,920,447	39,601	12,133,683,409	1,910	38,431	5,407	529	1,882	453	21,851	12,155,934,226
55	170	170	117,276	117,276	19,936,920	28,900	13,753,660,176	800	27,640	9,305	(180)	977	1,310	7	13,773,900,407
56	186	186	112,055	112,055	20,842,230	34,596	12,556,323,025	980	28,657	1,803	(242)	846	(2,844)	17,192	12,577,470,353
57	200	200	114,765	114,765	22,953,000	40,000	13,171,005,225	1,695	36,425	8,839	859	2,856	1,532	14,864	13,194,294,825
58	146	146	128,007	128,007	18,689,022	21,316	16,385,792,049	1,560	27,720	10,944	(492)	1,864	1,400	10,121	16,404,811,518
59	222	222	116,811	116,811	25,932,042	49,284	13,644,809,721	2,249	27,941	5,775	245	1,141	(3,513)	7,946	13,671,066,453
60	73	73	115,899	115,899	8,460,627	5,329	13,432,578,201	1,594	30,950	12,750	717	486	1,746	188,040	13,441,512,238
1830	8796	5,443,506	783,702,813	1,419,510	532,565,292,186	84,100	1,460,714	300,269	28,628	110,148	18,820	1,317,018	533,364,621,218
a=	833,661,258,912	106,866	FIXED COST
7800984
b=	(858,909,996)	(110.10)	VARIABLE COST
7800984
r=	(858,909,996)	(0.20)
1.8115132686567E+19
4256187576.52514
R sq=	0.041	R-squared

SALARY (Y)

197 133 132 141 182 156 196 178 159 141 152 31 280 136 174 171 167 161 173 161 167 153 201 33 227 150 142 104 121 99 150 144 154 130 202 51 148 153 83 101 140 132 112 127 139 156 126 33 209 124 131 144 93 199 170 186 200 146 222 73 52951 47054 55372 46114 48309 49643 55784 47957 53743 53109 45491 57479 49049 46698 59790 80773 71130 82490 98172 90685 97771 87129 95910 109192 89041 92165 88981 95898 96245 106364 90564 98418 110436 102042 124413 116897 97083 104727 95622 96438 114995 105337 98989 124352 115875 113035 119106 104199 98938 108606 106396 106778 124805 110153 117276 112055 114765 128007 116811 115899

NRVS (X) 197 133 132 141 182 156 196 178 159 141 152 31 280 136 174 171 167 161 173 161 167 153 201 33 227 150 142 104 121 99 150 144 154 130 202 51 148 153 83 101 140 132 112 127 139 156 126 33 209 124 131 144 93 199 170 186 200 146 222 73 197 133 132 141 182 156 196 178 159 141 152 31 280 136 174 171 167 161 173 161 167 153 201 33 227 150 142 104 121 99 150 144 154 130 202 51 148 153 83 101 140 132 112 127 139 156 126 33 209 124 131 144 93 199 170 186 200 146 222 73 SALARY (Y)

52951 47054 55372 46114 48309 49643 55784 47957 53743 53109 45491 57479 49049 46698 59790 80773 71130 82490 98172 90685 97771 87129 95910 109192 89041 92165 88981 95898 96245 106364 90564 98418 110436 102042 124413 116897 97083 104727 95622 96438 114995 105337 98989 124352 115875 113035 119106 104199 98938 108606 106396 106778 124805 110153 117276 112055 114765 128007 116811 115899

SALARY (Y)

Plot-Vacation

MONTH	NRVS (X)	Vacation(Y)	XY	X Squared	Y Squared
1	197	197	- 0	- 0	0	38809	0
2	133	133	- 0	- 0	0	17689	0
3	132	132	- 0	- 0	0	17424	0
4	141	141	- 0	- 0	0	19881	0
5	182	182	- 0	- 0	0	33124	0
6	156	156	- 0	- 0	0	24336	0
7	196	196	300	300	58800	38416	90000
8	178	178	- 0	- 0	0	31684	0
9	159	159	- 0	- 0	0	25281	0
10	141	141	- 0	- 0	0	19881	0
11	152	152	300	300	45600	23104	90000
12	31	31	- 0	- 0	0	961	0
13	280	280	- 0	- 0	0	78400	0
14	136	136	300	300	40800	18496	90000
15	174	174	200	200	34800	30276	40000
16	171	171	600	600	102600	29241	360000
17	167	167	9,212	9,212	1538404	27889	84860944
18	161	161	6,007	6,007	967127	25921	36084049
19	173	173	500	500	86500	29929	250000
20	161	161	2,690	2,690	433090	25921	7236100
21	167	167	600	600	100200	27889	360000
22	153	153	1,740	1,740	266220	23409	3027600
23	201	201	2,074	2,074	416874	40401	4301476
24	33	33	2,782	2,782	91806	1089	7739524
25	227	227	1,880	1,880	426760	51529	3534400
26	150	150	3,602	3,602	540300	22500	12974404
27	142	142	744	744	105648	20164	553536
28	104	104	960	960	99840	10816	921600
29	121	121	- 0	- 0	0	14641	0
30	99	99	- 0	- 0	0	9801	0
31	150	150	1,950	1,950	292500	22500	3802500
32	144	144	1,540	1,540	221760	20736	2371600
33	154	154	2,693	2,693	414722	23716	7252249
34	130	130	1,060	1,060	137800	16900	1123600
35	202	202	3,519	3,519	710838	40804	12383361
36	51	51	1,520	1,520	77520	2601	2310400
37	148	148	1,080	1,080	159840	21904	1166400
38	153	153	3,230	3,230	494190	23409	10432900
39	83	83	953	953	79099	6889	908209
40	101	101	1,244	1,244	125644	10201	1547536
41	140	140	- 0	- 0	0	19600	0
42	132	132	160	160	21120	17424	25600
43	112	112	2,480	2,480	277760	12544	6150400
44	127	127	1,800	1,800	228600	16129	3240000
45	139	139	1,417	1,417	196963	19321	2007889
46	156	156	1,820	1,820	283920	24336	3312400
47	126	126	3,338	3,338	420588	15876	11142244
48	33	33	1,537	1,537	50721	1089	2362369
49	209	209	1,866	1,866	389994	43681	3481956
50	124	124	3,676	3,676	455824	15376	13512976
51	131	131	1,197	1,197	156807	17161	1432809
52	144	144	241	241	34704	20736	58081
53	93	93	500	500	46500	8649	250000
54	199	199	1,910	1,910	380090	39601	3648100
55	170	170	800	800	136000	28900	640000
56	186	186	980	980	182280	34596	960400
57	200	200	1,695	1,695	339000	40000	2873025
58	146	146	1,560	1,560	227760	21316	2433600
59	222	222	2,249	2,249	499278	49284	5058001
60	73	73	1,594	1,594	116362	5329	2540836
1830	8796	84,100	12513553	1419510	270943074
a=	9311578812	1,193.64	FIXED COST
7800984
b=	11,069,580	1.42	VARIABLE COST
7800984
r=	11,069,580	0.0000000002
7.1642477466049E+16
267661124.308423
Rsq=	2.38737749179432E-20	2.38737749179432E-18

Plot-ADVTRNG

MONTH	NRVS (X)	ADV/TRNG(Y)	XY	X Squared	Y Squared
1	197	197	22,561	22,561	4444517	38809	508998721
2	133	133	19,040	19,040	2532320	17689	362521600
3	132	132	14,373	14,373	1897236	17424	206583129
4	141	141	15,022	15,022	2118102	19881	225660484
5	182	182	19,966	19,966	3633812	33124	398641156
6	156	156	12,019	12,019	1874964	24336	144456361
7	196	196	13,217	13,217	2590532	38416	174689089
8	178	178	17,303	17,303	3079934	31684	299393809
9	159	159	16,535	16,535	2629065	25281	273406225
10	141	141	23,821	23,821	3358761	19881	567440041
11	152	152	14,146	14,146	2150192	23104	200109316
12	31	31	22,223	22,223	688913	961	493861729
13	280	280	19,992	19,992	5597760	78400	399680064
14	136	136	20,251	20,251	2754136	18496	410103001
15	174	174	20,082	20,082	3494268	30276	403286724
16	171	171	26,716	26,716	4568436	29241	713744656
17	167	167	25,223	25,223	4212241	27889	636199729
18	161	161	21,106	21,106	3398066	25921	445463236
19	173	173	17,799	17,799	3079227	29929	316804401
20	161	161	28,038	28,038	4514118	25921	786129444
21	167	167	37,284	37,284	6226428	27889	1390096656
22	153	153	24,236	24,236	3708108	23409	587383696
23	201	201	27,244	27,244	5476044	40401	742235536
24	33	33	20,376	20,376	672408	1089	415181376
25	227	227	26,719	26,719	6065213	51529	713904961
26	150	150	14,727	14,727	2209050	22500	216884529
27	142	142	27,880	27,880	3958960	20164	777294400
28	104	104	21,872	21,872	2274688	10816	478384384
29	121	121	18,705	18,705	2263305	14641	349877025
30	99	99	23,835	23,835	2359665	9801	568107225
31	150	150	25,605	25,605	3840750	22500	655616025
32	144	144	17,763	17,763	2557872	20736	315524169
33	154	154	32,379	32,379	4986366	23716	1048399641
34	130	130	19,324	19,324	2512120	16900	373416976
35	202	202	22,412	22,412	4527224	40804	502297744
36	51	51	29,998	29,998	1529898	2601	899880004
37	148	148	9,112	9,112	1348576	21904	83028544
38	153	153	38,616	38,616	5908248	23409	1491195456
39	83	83	22,690	22,690	1883270	6889	514836100
40	101	101	14,703	14,703	1485003	10201	216178209
41	140	140	28,764	28,764	4026960	19600	827367696
42	132	132	27,253	27,253	3597396	17424	742726009
43	112	112	24,419	24,419	2734928	12544	596287561
44	127	127	26,011	26,011	3303397	16129	676572121
45	139	139	24,492	24,492	3404388	19321	599858064
46	156	156	31,158	31,158	4860648	24336	970820964
47	126	126	32,213	32,213	4058838	15876	1037677369
48	33	33	30,177	30,177	995841	1089	910651329
49	209	209	26,737	26,737	5588033	43681	714867169
50	124	124	31,084	31,084	3854416	15376	966215056
51	131	131	33,278	33,278	4359418	17161	1107425284
52	144	144	32,657	32,657	4702608	20736	1066479649
53	93	93	29,794	29,794	2770842	8649	887682436
54	199	199	38,431	38,431	7647769	39601	1476941761
55	170	170	27,640	27,640	4698800	28900	763969600
56	186	186	28,657	28,657	5330202	34596	821223649
57	200	200	36,425	36,425	7285000	40000	1326780625
58	146	146	27,720	27,720	4047120	21316	768398400
59	222	222	27,941	27,941	6202902	49284	780699481
60	73	73	30,950	30,950	2259350	5329	957902500
1830	8796	1,460,714	214138652	1419510	38307442294
a=	189934547148	24,347.51	FIXED COST
7800984
b=	(121,224)	-0.02	VARIABLE COST
7800984
r=	(121,224)	-0
1.28529907815268E+18
Rsq=	8.89546854532247E-27	8.89546854532247E-25

Plot-SupplyLNDRY

MONTH	NRVS (X)	SUPPLY/LNDRY(Y)	XY	X Squared	Y Squared
1	197	197	1,118	1,118	220246	38809	1249924
2	133	133	3,573	3,573	475209	17689	12766329
3	132	132	1,388	1,388	183216	17424	1926544
4	141	141	2,894	2,894	408054	19881	8375236
5	182	182	1,896	1,896	345072	33124	3594816
6	156	156	1,188	1,188	185328	24336	1411344
7	196	196	3,912	3,912	766752	38416	15303744
8	178	178	2,012	2,012	358136	31684	4048144
9	159	159	2,717	2,717	432003	25281	7382089
10	141	141	1,102	1,102	155382	19881	1214404
11	152	152	2,630	2,630	399760	23104	6916900
12	31	31	7,043	7,043	218333	961	49603849
13	280	280	1,999	1,999	559720	78400	3996001
14	136	136	1,192	1,192	162112	18496	1420864
15	174	174	1,336	1,336	232464	30276	1784896
16	171	171	3,873	3,873	662283	29241	15000129
17	167	167	5,560	5,560	928520	27889	30913600
18	161	161	1,737	1,737	279657	25921	3017169
19	173	173	1,847	1,847	319531	29929	3411409
20	161	161	4,415	4,415	710815	25921	19492225
21	167	167	2,827	2,827	472109	27889	7991929
22	153	153	5,836	5,836	892908	23409	34058896
23	201	201	3,387	3,387	680787	40401	11471769
24	33	33	12,132	12,132	400356	1089	147185424
25	227	227	4,383	4,383	994941	51529	19210689
26	150	150	10,231	10,231	1534650	22500	104673361
27	142	142	7,734	7,734	1098228	20164	59814756
28	104	104	(684)	(684)	-71136	10816	467856
29	121	121	8,329	8,329	1007809	14641	69372241
30	99	99	2,540	2,540	251460	9801	6451600
31	150	150	5,862	5,862	879300	22500	34363044
32	144	144	6,998	6,998	1007712	20736	48972004
33	154	154	8,131	8,131	1252174	23716	66113161
34	130	130	6,026	6,026	783380	16900	36312676
35	202	202	9,120	9,120	1842240	40804	83174400
36	51	51	6,798	6,798	346698	2601	46212804
37	148	148	6,627	6,627	980796	21904	43917129
38	153	153	5,892	5,892	901476	23409	34715664
39	83	83	3,450	3,450	286350	6889	11902500
40	101	101	5,259	5,259	531159	10201	27657081
41	140	140	2,294	2,294	321160	19600	5262436
42	132	132	8,155	8,155	1076460	17424	66504025
43	112	112	1,621	1,621	181552	12544	2627641
44	127	127	902	902	114554	16129	813604
45	139	139	5,158	5,158	716962	19321	26604964
46	156	156	2,901	2,901	452556	24336	8415801
47	126	126	14,426	14,426	1817676	15876	208109476
48	33	33	9,250	9,250	305250	1089	85562500
49	209	209	1,694	1,694	354046	43681	2869636
50	124	124	9,040	9,040	1120960	15376	81721600
51	131	131	2,099	2,099	274969	17161	4405801
52	144	144	9,328	9,328	1343232	20736	87011584
53	93	93	4,268	4,268	396924	8649	18215824
54	199	199	5,407	5,407	1075993	39601	29235649
55	170	170	9,305	9,305	1581850	28900	86583025
56	186	186	1,803	1,803	335358	34596	3250809
57	200	200	8,839	8,839	1767800	40000	78127921
58	146	146	10,944	10,944	1597824	21316	119771136
59	222	222	5,775	5,775	1282050	49284	33350625
60	73	73	12,750	12,750	930750	5329	162562500
1830	8796	300,269	41123916	1419510	2197875157
a=	64508883054	8,269.33	FIXED COST
7800984
b=	(173,731,164)	-22.2704166551	VARIABLE COST
7800984
r=	(173,731,164)	-0.0000000005
3.25387132720666E+17
570427149.354469
Rsq=	2.85072096019561E-19	2.85072096019561E-17

Plot-FREIGHT

MONTH	NRVS (X)	FREIGHT(Y)	XY	X Squared	Y Squared
1	197	197	382	382	75254	38809	145924
2	133	133	409	409	54397	17689	167281
3	132	132	742	742	97944	17424	550564
4	141	141	675	675	95175	19881	455625
5	182	182	572	572	104104	33124	327184
6	156	156	407	407	63492	24336	165649
7	196	196	643	643	126028	38416	413449
8	178	178	605	605	107690	31684	366025
9	159	159	209	209	33231	25281	43681
10	141	141	184	184	25944	19881	33856
11	152	152	331	331	50312	23104	109561
12	31	31	560	560	17360	961	313600
13	280	280	582	582	162960	78400	338724
14	136	136	603	603	82008	18496	363609
15	174	174	492	492	85608	30276	242064
16	171	171	559	559	95589	29241	312481
17	167	167	356	356	59452	27889	126736
18	161	161	439	439	70679	25921	192721
19	173	173	1,628	1,628	281644	29929	2650384
20	161	161	(12)	(12)	-1932	25921	144
21	167	167	480	480	80160	27889	230400
22	153	153	79	79	12087	23409	6241
23	201	201	188	188	37788	40401	35344
24	33	33	593	593	19569	1089	351649
25	227	227	769	769	174563	51529	591361
26	150	150	593	593	88950	22500	351649
27	142	142	414	414	58788	20164	171396
28	104	104	425	425	44200	10816	180625
29	121	121	483	483	58443	14641	233289
30	99	99	417	417	41283	9801	173889
31	150	150	222	222	33300	22500	49284
32	144	144	49	49	7056	20736	2401
33	154	154	818	818	125972	23716	669124
34	130	130	1,015	1,015	131950	16900	1030225
35	202	202	1,255	1,255	253510	40804	1575025
36	51	51	68	68	3468	2601	4624
37	148	148	565	565	83620	21904	319225
38	153	153	369	369	56457	23409	136161
39	83	83	(182)	(182)	-15106	6889	33124
40	101	101	709	709	71609	10201	502681
41	140	140	1,006	1,006	140840	19600	1012036
42	132	132	521	521	68772	17424	271441
43	112	112	514	514	57568	12544	264196
44	127	127	917	917	116459	16129	840889
45	139	139	(77)	(77)	-10703	19321	5929
46	156	156	450	450	70200	24336	202500
47	126	126	120	120	15120	15876	14400
48	33	33	819	819	27027	1089	670761
49	209	209	853	853	178277	43681	727609
50	124	124	498	498	61752	15376	248004
51	131	131	605	605	79255	17161	366025
52	144	144	483	483	69552	20736	233289
53	93	93	788	788	73284	8649	620944
54	199	199	529	529	105271	39601	279841
55	170	170	(180)	(180)	-30600	28900	32400
56	186	186	(242)	(242)	-45012	34596	58564
57	200	200	859	859	171800	40000	737881
58	146	146	(492)	(492)	-71832	21316	242064
59	222	222	245	245	54390	49284	60025
60	73	73	717	717	52341	5329	514089
1830	8796	28,628	4238367	1419510	21369866
a=	3357056148	430.3375251122	FIXED COST
7800984
b=	2,490,132	0.3192074231	VARIABLE COST
7800984
r=	2,490,132	0.0000000007
3.60896592030278E+15
Rsq=	4.7607916619569E-19

Plot-Vehicles

MONTH	NRVS (X)	VEHICLES(Y)	XY	X Squared	Y Squared
1	197	197	2,052	2,052	404244	38809	4210704
2	133	133	1,405	1,405	186865	17689	1974025
3	132	132	1,380	1,380	182160	17424	1904400
4	141	141	2,057	2,057	290037	19881	4231249
5	182	182	1,603	1,603	291746	33124	2569609
6	156	156	2,524	2,524	393744	24336	6370576
7	196	196	2,348	2,348	460208	38416	5513104
8	178	178	1,208	1,208	215024	31684	1459264
9	159	159	2,400	2,400	381600	25281	5760000
10	141	141	2,076	2,076	292716	19881	4309776
11	152	152	1,677	1,677	254904	23104	2812329
12	31	31	2,183	2,183	67673	961	4765489
13	280	280	1,927	1,927	539560	78400	3713329
14	136	136	1,156	1,156	157216	18496	1336336
15	174	174	1,898	1,898	330252	30276	3602404
16	171	171	1,808	1,808	309168	29241	3268864
17	167	167	1,816	1,816	303272	27889	3297856
18	161	161	1,384	1,384	222824	25921	1915456
19	173	173	1,962	1,962	339426	29929	3849444
20	161	161	2,446	2,446	393806	25921	5982916
21	167	167	2,296	2,296	383432	27889	5271616
22	153	153	3,175	3,175	485775	23409	10080625
23	201	201	1,287	1,287	258687	40401	1656369
24	33	33	2,563	2,563	84579	1089	6568969
25	227	227	2,205	2,205	500535	51529	4862025
26	150	150	2,289	2,289	343350	22500	5239521
27	142	142	1,891	1,891	268522	20164	3575881
28	104	104	2,288	2,288	237952	10816	5234944
29	121	121	2,223	2,223	268983	14641	4941729
30	99	99	1,683	1,683	166617	9801	2832489
31	150	150	1,586	1,586	237900	22500	2515396
32	144	144	1,751	1,751	252144	20736	3066001
33	154	154	2,082	2,082	320628	23716	4334724
34	130	130	1,714	1,714	222820	16900	2937796
35	202	202	2,173	2,173	438946	40804	4721929
36	51	51	1,779	1,779	90729	2601	3164841
37	148	148	1,324	1,324	195952	21904	1752976
38	153	153	1,523	1,523	233019	23409	2319529
39	83	83	2,087	2,087	173221	6889	4355569
40	101	101	2,095	2,095	211595	10201	4389025
41	140	140	1,304	1,304	182560	19600	1700416
42	132	132	1,667	1,667	220044	17424	2778889
43	112	112	1,040	1,040	116480	12544	1081600
44	127	127	2,880	2,880	365760	16129	8294400
45	139	139	1,281	1,281	178059	19321	1640961
46	156	156	2,259	2,259	352404	24336	5103081
47	126	126	1,394	1,394	175644	15876	1943236
48	33	33	1,516	1,516	50028	1089	2298256
49	209	209	1,657	1,657	346313	43681	2745649
50	124	124	2,266	2,266	280984	15376	5134756
51	131	131	1,952	1,952	255712	17161	3810304
52	144	144	1,852	1,852	266688	20736	3429904
53	93	93	1,704	1,704	158472	8649	2903616
54	199	199	1,882	1,882	374518	39601	3541924
55	170	170	977	977	166090	28900	954529
56	186	186	846	846	157356	34596	715716
57	200	200	2,856	2,856	571200	40000	8156736
58	146	146	1,864	1,864	272144	21316	3474496
59	222	222	1,141	1,141	253302	49284	1301881
60	73	73	486	486	35478	5329	236196
1830	8796	110,148	16171067	1419510	217915630
a=	14115482148	165.7318622623	FIXED COST
85170600
b=	1,402,212	0.1797480933	VARIABLE COST
7800984
r=	1,402,212	0.0000000002
7.35130326700166E+15
RSqr=	3.63830145670299E-20

Plot-DEMO's

MONTH	NRVS (X)	DEMO'S(Y)	XY	X Squared	Y Squared
1	197	197	1,881	1,881	370557	38809	3538161
2	133	133	695	695	92435	17689	483025
3	132	132	469	469	61908	17424	219961
4	141	141	125	125	17625	19881	15625
5	182	182	131	131	23842	33124	17161
6	156	156	1,229	1,229	191724	24336	1510441
7	196	196	1,206	1,206	236376	38416	1454436
8	178	178	436	436	77608	31684	190096
9	159	159	1,476	1,476	234684	25281	2178576
10	141	141	1,168	1,168	164688	19881	1364224
11	152	152	635	635	96520	23104	403225
12	31	31	1,014	1,014	31434	961	1028196
13	280	280	(477)	(477)	-133560	78400	227529
14	136	136	1,839	1,839	250104	18496	3381921
15	174	174	1,260	1,260	219240	30276	1587600
16	171	171	510	510	87210	29241	260100
17	167	167	2,350	2,350	392450	27889	5522500
18	161	161	(288)	(288)	-46368	25921	82944
19	173	173	1,591	1,591	275243	29929	2531281
20	161	161	(3,308)	(3,308)	-532588	25921	10942864
21	167	167	1,709	1,709	285403	27889	2920681
22	153	153	798	798	122094	23409	636804
23	201	201	(2,025)	(2,025)	-407025	40401	4100625
24	33	33	1,010	1,010	33330	1089	1020100
25	227	227	2,493	2,493	565911	51529	6215049
26	150	150	(2,051)	(2,051)	-307650	22500	4206601
27	142	142	386	386	54812	20164	148996
28	104	104	178	178	18512	10816	31684
29	121	121	(262)	(262)	-31702	14641	68644
30	99	99	(1,356)	(1,356)	-134244	9801	1838736
31	150	150	486	486	72900	22500	236196
32	144	144	(1,924)	(1,924)	-277056	20736	3701776
33	154	154	1,547	1,547	238238	23716	2393209
34	130	130	132	132	17160	16900	17424
35	202	202	(2,337)	(2,337)	-472074	40804	5461569
36	51	51	1,195	1,195	60945	2601	1428025
37	148	148	1,164	1,164	172272	21904	1354896
38	153	153	(1,839)	(1,839)	-281367	23409	3381921
39	83	83	454	454	37682	6889	206116
40	101	101	868	868	87668	10201	753424
41	140	140	(1,990)	(1,990)	-278600	19600	3960100
42	132	132	1,869	1,869	246708	17424	3493161
43	112	112	329	329	36848	12544	108241
44	127	127	(1,897)	(1,897)	-240919	16129	3598609
45	139	139	2,959	2,959	411301	19321	8755681
46	156	156	417	417	65052	24336	173889
47	126	126	(2,659)	(2,659)	-335034	15876	7070281
48	33	33	4,517	4,517	149061	1089	20403289
49	209	209	601	601	125609	43681	361201
50	124	124	(284)	(284)	-35216	15376	80656
51	131	131	668	668	87508	17161	446224
52	144	144	1,409	1,409	202896	20736	1985281
53	93	93	(1,771)	(1,771)	-164703	8649	3136441
54	199	199	453	453	90147	39601	205209
55	170	170	1,310	1,310	222700	28900	1716100
56	186	186	(2,844)	(2,844)	-528984	34596	8088336
57	200	200	1,532	1,532	306400	40000	2347024
58	146	146	1,400	1,400	204400	21316	1960000
59	222	222	(3,513)	(3,513)	-779886	49284	12341169
60	73	73	1,746	1,746	127458	5329	3048516
1830	8796	18,820	1879687	1419510	160341750
a=	10181451348	1305.1496257395	FIXED COST
7800984
b=	(52,759,500)	-6.7631852597	VARIABLE COST
7800984
r=	(52,759,500)	-0.0000000007
7.22863563315984E+16
Rsqr=	5.32707331288371E-19

Plot Floor Plan

MONTH	NRVS (X)	Floor Plan(Y)	XY	X Squared	Y Squared
1	197	197	(78,173)	(78,173)	-15400081	38809	6111017929
2	133	133	28,456	28,456	3784648	17689	809743936
3	132	132	34,423	34,423	4543836	17424	1184942929
4	141	141	5,697	5,697	803277	19881	32455809
5	182	182	34,599	34,599	6297018	33124	1197090801
6	156	156	53,737	53,737	8382972	24336	2887665169
7	196	196	5,507	5,507	1079372	38416	30327049
8	178	178	32,436	32,436	5773608	31684	1052094096
9	159	159	28,950	28,950	4603050	25281	838102500
10	141	141	20,876	20,876	2943516	19881	435807376
11	152	152	45,278	45,278	6882256	23104	2050097284
12	31	31	66,745	66,745	2069095	961	4454895025
13	280	280	(30,104)	(30,104)	-8429120	78400	906250816
14	136	136	50,583	50,583	6879288	18496	2558639889
15	174	174	18,803	18,803	3271722	30276	353552809
16	171	171	23,080	23,080	3946680	29241	532686400
17	167	167	18,774	18,774	3135258	27889	352463076
18	161	161	23,802	23,802	3832122	25921	566535204
19	173	173	33,848	33,848	5855704	29929	1145687104
20	161	161	13,480	13,480	2170280	25921	181710400
21	167	167	22,965	22,965	3835155	27889	527391225
22	153	153	18,898	18,898	2891394	23409	357134404
23	201	201	38,699	38,699	7778499	40401	1497612601
24	33	33	68,285	68,285	2253405	1089	4662841225
25	227	227	(44,140)	(44,140)	-10019780	51529	1948339600
26	150	150	36,311	36,311	5446650	22500	1318488721
27	142	142	19,865	19,865	2820830	20164	394618225
28	104	104	19,013	19,013	1977352	10816	361494169
29	121	121	16,228	16,228	1963588	14641	263347984
30	99	99	37,637	37,637	3726063	9801	1416543769
31	150	150	(1,121)	(1,121)	-168150	22500	1256641
32	144	144	34,757	34,757	5005008	20736	1208049049
33	154	154	26,419	26,419	4068526	23716	697963561
34	130	130	21,134	21,134	2747420	16900	446645956
35	202	202	18,578	18,578	3752756	40804	345142084
36	51	51	91,520	91,520	4667520	2601	8375910400
37	148	148	(73,753)	(73,753)	-10915444	21904	5439505009
38	153	153	30,443	30,443	4657779	23409	926776249
39	83	83	17,725	17,725	1471175	6889	314175625
40	101	101	26,402	26,402	2666602	10201	697065604
41	140	140	(3,789)	(3,789)	-530460	19600	14356521
42	132	132	15,090	15,090	1991880	17424	227708100
43	112	112	(945)	(945)	-105840	12544	893025
44	127	127	30,405	30,405	3861435	16129	924464025
45	139	139	14,781	14,781	2054559	19321	218477961
46	156	156	15,613	15,613	2435628	24336	243765769
47	126	126	40,968	40,968	5161968	15876	1678377024
48	33	33	43,189	43,189	1425237	1089	1865289721
49	209	209	(20,127)	(20,127)	-4206543	43681	405096129
50	124	124	18,236	18,236	2261264	15376	332551696
51	131	131	15,176	15,176	1988056	17161	230310976
52	144	144	25,245	25,245	3635280	20736	637310025
53	93	93	6,493	6,493	603849	8649	42159049
54	199	199	21,851	21,851	4348349	39601	477466201
55	170	170	7	7	1190	28900	49
56	186	186	17,192	17,192	3197712	34596	295564864
57	200	200	14,864	14,864	2972800	40000	220938496
58	146	146	10,121	10,121	1477666	21316	102434641
59	222	222	7,946	7,946	1764012	49284	63138916
60	73	73	188,040	188,040	13726920	5329	35359041600
1830	8796	1,317,018	141115811	1419510	102221412490
a=	628265547624	80536.7050648995	FIXED COST
7800984
b=	(3,117,541,668)	-399.6344138124	VARIABLE COST
7800984
r=	(3,117,541,668)	-0.0000000001
3.43145653975565E+19
Rsqr=	8.25405822314102E-21

Plot Total

MONTH	NRVS (X)	Total(Y)	XY	X Squared	Y Squared
1	197	197	2772	2772	546084	38809	7683984
2	133	133	100632	100632	13384056	17689	10126799424
3	132	132	108147	108147	14275404	17424	11695773609
4	141	141	72584	72584	10234344	19881	5268437056
5	182	182	107076	107076	19487832	33124	11465269776
6	156	156	120747	120747	18836532	24336	14579838009
7	196	196	82917	82917	16251732	38416	6875228889
8	178	178	101957	101957	18148346	31684	10395229849
9	159	159	106030	106030	16858770	25281	11242360900
10	141	141	102336	102336	14429376	19881	10472656896
11	152	152	110488	110488	16794176	23104	12207598144
12	31	31	157247	157247	4874657	961	24726619009
13	280	280	42968	42968	12031040	78400	1846249024
14	136	136	122622	122622	16676592	18496	15036154884
15	174	174	103861	103861	18071814	30276	10787107321
16	171	171	137919	137919	23584149	29241	19021650561
17	167	167	134421	134421	22448307	27889	18069005241
18	161	161	136677	136677	22004997	25921	18680602329
19	173	173	157347	157347	27221031	29929	24758078409
20	161	161	138434	138434	22287874	25921	19163972356
21	167	167	165932	165932	27710644	27889	27533428624
22	153	153	141891	141891	21709323	23409	20133055881
23	201	201	166764	166764	33519564	40401	27810231696
24	33	33	216933	216933	7158789	1089	47059926489
25	227	227	83350	83350	18920450	51529	6947222500
26	150	150	157867	157867	23680050	22500	24921989689
27	142	142	147895	147895	21001090	20164	21872931025
28	104	104	139950	139950	14554800	10816	19586002500
29	121	121	141951	141951	17176071	14641	20150086401
30	99	99	171120	171120	16940880	9801	29282054400
31	150	150	125154	125154	18773100	22500	15663523716
32	144	144	159352	159352	22946688	20736	25393059904
33	154	154	184505	184505	28413770	23716	34042095025
34	130	130	152447	152447	19818110	16900	23240087809
35	202	202	179133	179133	36184866	40804	32088631689
36	51	51	249775	249775	12738525	2601	62387550625
37	148	148	43202	43202	6393896	21904	1866412804
38	153	153	182961	182961	27993033	23409	33474727521
39	83	83	142799	142799	11852317	6889	20391554401
40	101	101	147718	147718	14919518	10201	21820607524
41	140	140	142584	142584	19961760	19600	20330197056
42	132	132	160052	160052	21126864	17424	25616642704
43	112	112	128447	128447	14386064	12544	16498631809
44	127	127	185370	185370	23541990	16129	34362036900
45	139	139	165886	165886	23058154	19321	27518164996
46	156	156	167653	167653	26153868	24336	28107528409
47	126	126	208906	208906	26322156	15876	43641716836
48	33	33	195204	195204	6441732	1089	38104601616
49	209	209	112219	112219	23453771	43681	12593103961
50	124	124	173122	173122	21467128	15376	29971226884
51	131	131	161371	161371	21139601	17161	26040599641
52	144	144	177993	177993	25630992	20736	31681508049
53	93	93	166581	166581	15492033	8649	27749229561
54	199	199	180616	180616	35942584	39601	32622139456
55	170	170	157135	157135	26712950	28900	24691408225
56	186	186	158447	158447	29471142	34596	25105451809
57	200	200	181835	181835	36367000	40000	33063967225
58	146	146	181124	181124	26444104	21316	32805903376
59	222	222	158595	158595	35208090	49284	25152374025
60	73	73	352182	352182	25709286	5329	124032161124
1830	8796	8763203	1214883866	1419510	1431780089555
a=	1753335805194	224758.287569107	FIXED COST
7800984
b=	-4188101628	-536.8683781431	VARIABLE COST
7800984
r=	-4188101628	-0.0000000001
7.1090979991207E+19
Rsqr=	3.47060686331425E-21

60 Months

MONTH	NRVS	SALARY	VACATION	ADV/TRNG	SPLY/LNDRY	FREIGHT	VEHICLES	DEMO'S	FLOOR-PLAN	TOTAL
1	197	52,951	- 0	22,561	1,118	382	2,052	1,881	(78,173)	2,772
2	133	47,054	- 0	19,040	3,573	409	1,405	695	28,456	100,632
3	132	55,372	- 0	14,373	1,388	742	1,380	469	34,423	108,147
4	141	46,114	- 0	15,022	2,894	675	2,057	125	5,697	72,584
5	182	48,309	- 0	19,966	1,896	572	1,603	131	34,599	107,076
6	156	49,643	- 0	12,019	1,188	407	2,524	1,229	53,737	120,747
7	196	55,784	300	13,217	3,912	643	2,348	1,206	5,507	82,917
8	178	47,957	- 0	17,303	2,012	605	1,208	436	32,436	101,957
9	159	53,743	- 0	16,535	2,717	209	2,400	1,476	28,950	106,030
10	141	53,109	- 0	23,821	1,102	184	2,076	1,168	20,876	102,336
11	152	45,491	300	14,146	2,630	331	1,677	635	45,278	110,488
12	31	57,479	- 0	22,223	7,043	560	2,183	1,014	66,745	157,247
13	280	49,049	- 0	19,992	1,999	582	1,927	(477)	(30,104)	42,968
14	136	46,698	300	20,251	1,192	603	1,156	1,839	50,583	122,622
15	174	59,790	200	20,082	1,336	492	1,898	1,260	18,803	103,861
16	171	80,773	600	26,716	3,873	559	1,808	510	23,080	137,919
17	167	71,130	9,212	25,223	5,560	356	1,816	2,350	18,774	134,421
18	161	82,490	6,007	21,106	1,737	439	1,384	(288)	23,802	136,677
19	173	98,172	500	17,799	1,847	1,628	1,962	1,591	33,848	157,347
20	161	90,685	2,690	28,038	4,415	(12)	2,446	(3,308)	13,480	138,434
21	167	97,771	600	37,284	2,827	480	2,296	1,709	22,965	165,932
22	153	87,129	1,740	24,236	5,836	79	3,175	798	18,898	141,891
23	201	95,910	2,074	27,244	3,387	188	1,287	(2,025)	38,699	166,764
24	33	109,192	2,782	20,376	12,132	593	2,563	1,010	68,285	216,933
25	227	89,041	1,880	26,719	4,383	769	2,205	2,493	(44,140)	83,350
26	150	92,165	3,602	14,727	10,231	593	2,289	(2,051)	36,311	157,867
27	142	88,981	744	27,880	7,734	414	1,891	386	19,865	147,895
28	104	95,898	960	21,872	(684)	425	2,288	178	19,013	139,950
29	121	96,245	- 0	18,705	8,329	483	2,223	(262)	16,228	141,951
30	99	106,364	- 0	23,835	2,540	417	1,683	(1,356)	37,637	171,120
31	150	90,564	1,950	25,605	5,862	222	1,586	486	(1,121)	125,154
32	144	98,418	1,540	17,763	6,998	49	1,751	(1,924)	34,757	159,352
33	154	110,436	2,693	32,379	8,131	818	2,082	1,547	26,419	184,505
34	130	102,042	1,060	19,324	6,026	1,015	1,714	132	21,134	152,447
35	202	124,413	3,519	22,412	9,120	1,255	2,173	(2,337)	18,578	179,133
36	51	116,897	1,520	29,998	6,798	68	1,779	1,195	91,520	249,775
37	148	97,083	1,080	9,112	6,627	565	1,324	1,164	(73,753)	43,202
38	153	104,727	3,230	38,616	5,892	369	1,523	(1,839)	30,443	182,961
39	83	95,622	953	22,690	3,450	(182)	2,087	454	17,725	142,799
40	101	96,438	1,244	14,703	5,259	709	2,095	868	26,402	147,718
41	140	114,995	- 0	28,764	2,294	1,006	1,304	(1,990)	(3,789)	142,584
42	132	105,337	160	27,253	8,155	521	1,667	1,869	15,090	160,052
43	112	98,989	2,480	24,419	1,621	514	1,040	329	(945)	128,447
44	127	124,352	1,800	26,011	902	917	2,880	(1,897)	30,405	185,370
45	139	115,875	1,417	24,492	5,158	(77)	1,281	2,959	14,781	165,886
46	156	113,035	1,820	31,158	2,901	450	2,259	417	15,613	167,653
47	126	119,106	3,338	32,213	14,426	120	1,394	(2,659)	40,968	208,906
48	33	104,199	1,537	30,177	9,250	819	1,516	4,517	43,189	195,204
49	209	98,938	1,866	26,737	1,694	853	1,657	601	(20,127)	112,219
50	124	108,606	3,676	31,084	9,040	498	2,266	(284)	18,236	173,122
51	131	106,396	1,197	33,278	2,099	605	1,952	668	15,176	161,371
52	144	106,778	241	32,657	9,328	483	1,852	1,409	25,245	177,993
53	93	124,805	500	29,794	4,268	788	1,704	(1,771)	6,493	166,581
54	199	110,153	1,910	38,431	5,407	529	1,882	453	21,851	180,616
55	170	117,276	800	27,640	9,305	(180)	977	1,310	7	157,135
56	186	112,055	980	28,657	1,803	(242)	846	(2,844)	17,192	158,447
57	200	114,765	1,695	36,425	8,839	859	2,856	1,532	14,864	181,835
58	146	128,007	1,560	27,720	10,944	(492)	1,864	1,400	10,121	181,124
59	222	116,811	2,249	27,941	5,775	245	1,141	(3,513)	7,946	158,595
60	73	115,899	1,594	30,950	12,750	717	486	1,746	188,040	352,182
TOTAL	5,443,506	84,100	1,460,714	300,269	28,628	110,148	18,820	1,317,018	8,763,203

Salary vs NRVS 197 133 132 141 182 156 196 178 159 141 152 31 280 136 174 171 167 161 173 161 167 153 201 33 227 150 142 104 121 99 150 144 154 130 202 51 148 153 83 101 140 132 112 127 139 156 126 33 209 124 131 144 93 199 170 186 200 146 222 73 52951 47054 55372 46114 48309 49643 55784 47957 53743 53109 45491 57479 49049 46698 59790 80773 71130 82490 98172 90685 97771 87129 95910 109192 89041 92165 88981 95898 96245 106364 90564 98418 110436 102042 124413 116897 97083 104727 95622 96438 114995 105337 98989 124352 115875 113035 119106 104199 98938 108606 106396 106778 124805 110153 117276 112055 114765 128007 116811 115899

NRVS

Salary

Vacation vs NRVS 197 133 132 141 182 156 196 178 159 141 152 31 280 136 174 171 167 161 173 161 167 153 201 33 227 150 142 104 121 99 150 144 154 130 202 51 148 153 83 101 140 132 112 127 139 156 126 33 209 124 131 144 93 199 170 186 200 146 222 73 0 0 0 0 0 0 300 0 0 0 300 0 0 300 200 600 9212 6007 500 2690 600 1740 2074 2782 1880 3602 744 960 0 0 1950 1540 2693 1060 3519 1520 1080 3230 953 1244 0 160 2480 1800 1417 1820 3338 1537 1866 3676 1197 241 500 1910 800 980 1695 1560 2249 1594

NRVS

Vacation

ADV/TRNG vs NRVS 197 133 132 141 182 156 196 178 159 141 152 31 280 136 174 171 167 161 173 161 167 153 201 33 227 150 142 104 121 99 150 144 154 130 202 51 148 153 83 101 140 132 112 127 139 156 126 33 209 124 131 144 93 199 170 186 200 146 222 73 22561 19040 14373 15022 19966 12019 13217 17303 16535 23821 14146 22223 19992 20251 20082 26716 25223 21106 17799 28038 37284 24236 27244 20376 26719 14727 27880 21872 18705 23835 25605 17763 32379 19324 22412 29998 9112 38616 22690 14703 28764 27253 24419 26011 24492 31158 32213 30177 26737 31084 33278 32657 29794 38431 27640 28657 36425 27720 27941 30950

NRVS

ADV/TRNG

SPLY/LNDRY vs NRVS

SPLY/LNDRY 197 133 132 141 182 156 196 178 159 141 152 31 280 136 174 171 167 161 173 161 167 153 201 33 227 150 142 104 121 99 150 144 154 130 202 51 148 153 83 101 140 132 112 127 139 156 126 33 209 124 131 144 93 199 170 186 200 146 222 73 1118 3573 1388 2894 1896 1188 3912 2012 2717 1102 2630 7043 1999 1192 1336 3873 5560 1737 1847 4415 2827 5836 3387 12132 4383 10231 7734 -684 8329 2540 5862 6998 8131 6026 9120 6798 6627 5892 3450 5259 2294 8155 1621 902 5158 2901 14426 9250 1694 9040 2099 9328 4268 5407 9305 1803 8839 10944 5775 12750

NRVS

SPLY/LNDRY

Vehicles vs NRVS 197 133 132 141 182 156 196 178 159 141 152 31 280 136 174 171 167 161 173 161 167 153 201 33 227 150 142 104 121 99 150 144 154 130 202 51 148 153 83 101 140 132 112 127 139 156 126 33 209 124 131 144 93 199 170 186 200 146 222 73 2052 1405 1380 2057 1603 2524 2348 1208 2400 2076 1677 2183 1927 1156 1898 1808 1816 1384 1962 2446 2296 3175 1287 2563 2205 2289 1891 2288 2223 1683 1586 1751 2082 1714 2173 1779 1324 1523 2087 2095 1304 1667 1040 2880 1281 2259 1394 1516 1657 2266 1952 1852 1704 1882 977 846 2856 1864 1141 486

NRVS

Vehicles

Demo's vs NRVS 197 133 132 141 182 156 196 178 159 141 152 31 280 136 174 171 167 161 173 161 167 153 201 33 227 150 142 104 121 99 150 144 154 130 202 51 148 153 83 101 140 132 112 127 139 156 126 33 209 124 131 144 93 199 170 186 200 146 222 73 1881 695 469 125 131 1229 1206 436 1476 1168 635 1014 -477 1839 1260 510 2350 -288 1591 -3308 1709 798 -2025 1010 2493 -2051 386 178 -262 -1356 486 -1924 1547 132 -2337 1195 1164 -1839 454 868 -1990 1869 329 -1897 2959 417 -2659 4517 601 -284 668 1409 -1771 453 1310 -2844 1532 1400 -3513 1746

NRVS

Demo's

Floor Plan vs NRVS 197 133 132 141 182 156 196 178 159 141 152 31 280 136 174 171 167 161 173 161 167 153 201 33 227 150 142 104 121 99 150 144 154 130 202 51 148 153 83 101 140 132 112 127 139 156 126 33 209 124 131 144 93 199 170 186 200 146 222 73 -78173 28456 34423 5697 34599 53737 5507 32436 28950 20876 45278 66745 -30104 50583 18803 23080 18774 23802 33848 13480 22965 18898 38699 68285 -44140 36311 19865 19013 16228 37637 -1121 34757 26419 21134 18578 91520 -73753 30443 17725 26402 -3789 15090 -945 30405 14781 15613 40968 43189 -20127 18236 15176 25245 6493 21851 7 17192 14864 10121 7946 188040

NRVS

Floor Plan

Freight vs NRVS 197 133 132 141 182 156 196 178 159 141 152 31 280 136 174 171 167 161 173 161 167 153 201 33 227 150 142 104 121 99 150 144 154 130 202 51 148 153 83 101 140 132 112 127 139 156 126 33 209 124 131 144 93 199 170 186 200 146 222 73 382 409 742 675 572 407 643 605 209 184 331 560 582 603 492 559 356 439 1628 -12 480 79 188 593 769 593 414 425 483 417 222 49 818 1015 1255 68 565 369 -182 709 1006 521 514 917 -77 450 120 819 853 498 605 483 788 529 -180 -242 859 -492 245 717

NRVS

Freight

NRVS

Salary

NRVS

Vacation

NRVS

ADV/TRNG

SPLY/LNDRY vs NRVS

NRVS

SPLY/LNDRY

NRVS

Vehicles

NRVS

Demo's

NRVS

Floor Plan

NRVS

Freight

NRVS

Salary

NRVS

Vacation

NRVS

ADV/TRNG

SPLY/LNDRY vs NRVS

NRVS

SPLY/LNDRY

NRVS

Vehicles

NRVS

Demo's

NRVS

Floor Plan

NRVS

Freight

NRVS

Salary

NRVS

Vacation

NRVS

ADV/TRNG

SPLY/LNDRY vs NRVS

NRVS

SPLY/LNDRY

NRVS

Vehicles

NRVS

Demo's

NRVS

Floor Plan

NRVS

Freight

NRVS

Salary

NRVS

Vacation

NRVS

ADV/TRNG

SPLY/LNDRY vs NRVS

NRVS

SPLY/LNDRY

NRVS

Vehicles

NRVS

Demo's

NRVS

Floor Plan

NRVS

Freight

NRVS

Salary

NRVS

Vacation

NRVS

ADV/TRNG

SPLY/LNDRY vs NRVS

NRVS

SPLY/LNDRY

NRVS

Vehicles

NRVS

Demo's

NRVS

Floor Plan

NRVS

Freight

NRVS

Salary

NRVS

Vacation

NRVS

ADV/TRNG

SPLY/LNDRY vs NRVS

NRVS

SPLY/LNDRY

NRVS

Vehicles

NRVS

Demo's

NRVS

Floor Plan

NRVS

Freight

NRVS

Salary

NRVS

Vacation

NRVS

ADV/TRNG

SPLY/LNDRY vs NRVS

NRVS

SPLY/LNDRY

NRVS

Vehicles

NRVS

Demo's

NRVS

Floor Plan

NRVS

Freight

HighLow

MONTH	NRVS	SALARY	VACATION	ADV/TRNG	SPLY/LNDRY	FREIGHT	VEHICLES	DEMO'S	FLOOR-PLAN	TOTAL	NRVS	249
1	197	52,951	- 0	22,561	1,118	382	2,052	1,881	(78,173)	2,772	SALARIES	82,516	VEHICLES	187
2	133	47,054	- 0	19,040	3,573	409	1,405	695	28,456	100,632	VC/UNIT	331.39	VC/UNIT	0.75
3	132	55,372	- 0	14,373	1,388	742	1,380	469	34,423	108,147	FIXED-HIGH	35,217.92	FIXED-HIGH	1,653.72
4	141	46,114	- 0	15,022	2,894	675	2,057	125	5,697	72,584	FIXED-LOW	35,217.92	FIXED-LOW	1,653.72
5	182	48,309	- 0	19,966	1,896	572	1,603	131	34,599	107,076
6	156	49,643	- 0	12,019	1,188	407	2,524	1,229	53,737	120,747	VACATION	1,260	DEMOS	765
7	196	55,784	300	13,217	3,912	643	2,348	1,206	5,507	82,917	VC/UNIT	5.06	VC/UNIT	3.07
8	178	47,957	- 0	17,303	2,012	605	1,208	436	32,436	101,957	FIXED-HIGH	143.13	FIXED-HIGH	539.76
9	159	53,743	- 0	16,535	2,717	209	2,400	1,476	28,950	106,030	FIXED-LOW	143.13	FIXED-LOW	539.76
10	141	53,109	- 0	23,821	1,102	184	2,076	1,168	20,876	102,336
11	152	45,491	300	14,146	2,630	331	1,677	635	45,278	110,488	ADV/TRNG	13,574	FLOOR PLAN	(35,157)
12	31	57,479	- 0	22,223	7,043	560	2,183	1,014	66,745	157,247	VC/UNIT	54.51	VC/UNIT	(141.19)
13	280	49,049	- 0	19,992	1,999	582	1,927	(477)	(30,104)	42,968	FIXED-HIGH	12,456.06	FIXED-HIGH	49,654.98
14	136	46,698	300	20,251	1,192	603	1,156	1,839	50,583	122,622	FIXED-LOW	12,456.06	FIXED-LOW	5,011.98
15	174	59,790	200	20,082	1,336	492	1,898	1,260	18,803	103,861
16	171	80,773	600	26,716	3,873	559	1,808	510	23,080	137,919	SPLY/LNDRY	8,314	TOTAL	70,636
17	167	71,130	9,212	25,223	5,560	356	1,816	2,350	18,774	134,421	VC/UNIT	33.39	VC/UNIT	283.68
18	161	82,490	6,007	21,106	1,737	439	1,384	(288)	23,802	136,677	FIXED-HIGH	1,594.92	FIXED-HIGH	101,693.96
19	173	98,172	500	17,799	1,847	1,628	1,962	1,591	33,848	157,347	FIXED-LOW	1594.92	FIXED-LOW	101,693.96
20	161	90,685	2,690	28,038	4,415	(12)	2,446	(3,308)	13,480	138,434
21	167	97,771	600	37,284	2,827	480	2,296	1,709	22,965	165,932	FREIGHT	(823)
22	153	87,129	1,740	24,236	5,836	79	3,175	798	18,898	141,891	VC/UNIT	-3.305
23	201	95,910	2,074	27,244	3,387	188	1,287	(2,025)	38,699	166,764	FIXED-HIGH	11,869.46
24	33	109,192	2,782	20,376	12,132	593	2,563	1,010	68,285	216,933	FIXED-LOW	433.46
25	227	89,041	1,880	26,719	4,383	769	2,205	2,493	(44,140)	83,350
26	150	92,165	3,602	14,727	10,231	593	2,289	(2,051)	36,311	157,867
27	142	88,981	744	27,880	7,734	414	1,891	386	19,865	147,895	VC/Unit(Sal)	718.10	31
28	104	95,898	960	21,872	(684)	425	2,288	178	19,013	139,950	total fixed	35,217.92
29	121	96,245	- 0	18,705	8,329	483	2,223	(262)	16,228	141,951	total	57,479.00
30	99	106,364	- 0	23,835	2,540	417	1,683	(1,356)	37,637	171,120	VC/Unit(Sal)	49.40	280
31	150	90,564	1,950	25,605	5,862	222	1,586	486	(1,121)	125,154	total fixed	35,217.92
32	144	98,418	1,540	17,763	6,998	49	1,751	(1,924)	34,757	159,352	total	49,049.00
33	154	110,436	2,693	32,379	8,131	818	2,082	1,547	26,419	184,505
34	130	102,042	1,060	19,324	6,026	1,015	1,714	132	21,134	152,447
35	202	124,413	3,519	22,412	9,120	1,255	2,173	(2,337)	18,578	179,133	VC/Unit(Sal)	635.54	146
36	51	116,897	1,520	29,998	6,798	68	1,779	1,195	91,520	249,775	total	128,007.00
37	148	97,083	1,080	9,112	6,627	565	1,324	1,164	(73,753)	43,202
38	153	104,727	3,230	38,616	5,892	369	1,523	(1,839)	30,443	182,961
39	83	95,622	953	22,690	3,450	(182)	2,087	454	17,725	142,799
40	101	96,438	1,244	14,703	5,259	709	2,095	868	26,402	147,718
41	140	114,995	- 0	28,764	2,294	1,006	1,304	(1,990)	(3,789)	142,584
42	132	105,337	160	27,253	8,155	521	1,667	1,869	15,090	160,052
43	112	98,989	2,480	24,419	1,621	514	1,040	329	(945)	128,447
44	127	124,352	1,800	26,011	902	917	2,880	(1,897)	30,405	185,370
45	139	115,875	1,417	24,492	5,158	(77)	1,281	2,959	14,781	165,886
46	156	113,035	1,820	31,158	2,901	450	2,259	417	15,613	167,653
47	126	119,106	3,338	32,213	14,426	120	1,394	(2,659)	40,968	208,906
48	33	104,199	1,537	30,177	9,250	819	1,516	4,517	43,189	195,204
49	209	98,938	1,866	26,737	1,694	853	1,657	601	(20,127)	112,219
50	124	108,606	3,676	31,084	9,040	498	2,266	(284)	18,236	173,122
51	131	106,396	1,197	33,278	2,099	605	1,952	668	15,176	161,371
52	144	106,778	241	32,657	9,328	483	1,852	1,409	25,245	177,993
53	93	124,805	500	29,794	4,268	788	1,704	(1,771)	6,493	166,581
54	199	110,153	1,910	38,431	5,407	529	1,882	453	21,851	180,616
55	170	117,276	800	27,640	9,305	(180)	977	1,310	7	157,135
56	186	112,055	980	28,657	1,803	(242)	846	(2,844)	17,192	158,447
57	200	114,765	1,695	36,425	8,839	859	2,856	1,532	14,864	181,835
58	146	128,007	1,560	27,720	10,944	(492)	1,864	1,400	10,121	181,124
59	222	116,811	2,249	27,941	5,775	245	1,141	(3,513)	7,946	158,595
60	73	115,899	1,594	30,950	12,750	717	486	1,746	188,040	352,182
TOTAL	5,443,506	84,100	1,460,714	300,269	28,628	110,148	18,820	1,317,018	8,763,203

Sample

x	y	xy	x squared	y squared
1	43	43	99	99	4257	1849	9801
2	21	21	65	65	1365	441	4225
3	25	25	79	79	1975	625	6241
4	42	42	75	75	3150	1764	5625
5	57	57	87	87	4959	3249	7569
6	59	59	81	81	4779	3481	6561
sum	247	486	20485	11409	40022
a=	484979	=	65.1415715245	fixed
7445
b=	2868	=	0.3852249832	variable
7445
r =	2868	0.0000220451
1.69251843954679E+16	root of B19
130096827
r squared=	0.0000000005