Accounting assignments

profilebeegirlie61
Exam500899-MotomartExcelSpreadsheet1.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

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 -202 5 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

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