Managerial Accounting Cost Analysis Motomart 2

profilemajk_v
MotomartDemoExcel1500896.xlsx
Home>Business & Finance homework help>Management homework help>Managerial Accounting Cost Analysis Motomart 2

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

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

HighLow

MONTH NRVS SALARY VACATION ADV/TRNG SPLY/LNDRY FREIGHT VEHICLES DEMO'S FLOOR-PLAN TOTAL NRVS 249 249
1 197 52,951 - 0 22,561 1,118 382 2,052 1,881 (78,173) 2,772 SALARIES 82,516 VEHICLES 2,689
2 133 47,054 - 0 19,040 3,573 409 1,405 695 28,456 100,632 VC/UNIT 331.39 VC/UNIT 10.80
3 132 55,372 - 0 14,373 1,388 742 1,380 469 34,423 108,147 FIXED-HIGH 35,217.92 FIXED-HIGH 151.22
4 141 46,114 - 0 15,022 2,894 675 2,057 125 5,697 72,584 FIXED-LOW 35,217.92 FIXED-LOW 151.22
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 9,012 DEMOS 8,030
7 196 55,784 300 13,217 3,912 643 2,348 1,206 5,507 82,917 VC/UNIT 36.19 VC/UNIT 32.25
8 178 47,957 - 0 17,303 2,012 605 1,208 436 32,436 101,957 FIXED-HIGH (921.98) FIXED-HIGH (4,512.72)
9 159 53,743 - 0 16,535 2,717 209 2,400 1,476 28,950 106,030 FIXED-LOW (921.98) FIXED-LOW (4,512.72)
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,524 FLOOR PLAN 266,213
12 31 57,479 - 0 22,223 7,043 560 2,183 1,014 66,745 157,247 VC/UNIT 54.31 VC/UNIT 1,069.13
13 280 49,049 - 0 19,992 1,999 582 1,927 (477) (30,104) 42,968 FIXED-HIGH (781.71) FIXED-HIGH (111,315.98)
14 136 46,698 300 20,251 1,192 603 1,156 1,839 50,583 122,622 FIXED-LOW (781.71) FIXED-LOW (111,315.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 15110 TOTAL 8,763,203
17 167 71,130 9,212 25,223 5,560 356 1,816 2,350 18,774 134,421 VC/UNIT 60.68 VC/UNIT 35,193.59
18 161 82,490 6,007 21,106 1,737 439 1,384 (288) 23,802 136,677 FIXED-HIGH (2,565.16) FIXED-HIGH (4,410,698.18)
19 173 98,172 500 17,799 1,847 1,628 1,962 1,591 33,848 157,347 FIXED-LOW -2565.16 FIXED-LOW 18,820.00
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 2120
22 153 87,129 1,740 24,236 5,836 79 3,175 798 18,898 141,891 VC/UNIT 8.514
23 201 95,910 2,074 27,244 3,387 188 1,287 (2,025) 38,699 166,764 FIXED-HIGH (755.94)
24 33 109,192 2,782 20,376 12,132 593 2,563 1,010 68,285 216,933 FIXED-LOW -755.94
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

vacation

month NRVS(x) VACATION(Y) XY X squared Y squared
1 197 197 0 0 0 38,809 0
2 133 133 0 0 0 17,689 0
3 132 132 0 0 0 17,424 0
4 141 141 0 0 0 19,881 0
5 182 182 0 0 0 33,124 0
6 156 156 0 0 0 24,336 0
7 196 196 300 300 58,800 38,416 90,000
8 178 178 0 0 0 31,684 0
9 159 159 0 0 0 25,281 0
10 141 141 0 0 0 19,881 0
11 152 152 300 300 45,600 23,104 90,000
12 31 31 0 0 0 961 0
13 280 280 0 0 0 78,400 0
14 136 136 300 300 84,000 18,496 90,000
15 174 174 200 200 34,800 30,276 40,000
16 171 171 600 600 102,600 29,241 360,000
17 167 167 9,212 9,212 1,538,404 27,889 84,860,944
18 161 161 6,007 6,007 967,127 25,921 36,084,049
19 173 173 500 500 86,500 29,929 250,000
20 161 161 2,690 2,690 433,090 25,921 7,236,100
21 167 167 600 600 100,200 27,889 360,000
22 153 153 1,740 1,740 266,220 23,409 3,027,600
23 201 201 2,074 2,074 416,874 40,401 4,301,476
24 33 33 2,782 2,782 91,806 1,089 2,948,920
25 227 227 1,880 1,880 426,760 51,529 3,534,400
26 150 150 3,602 3,602 540,300 22,500 12,974,404
27 142 142 744 744 105,648 20,164 553,536
28 104 104 960 960 105,648 10,816 921,600
29 121 121 0 0 0 14,641 0
30 99 99 0 0 0 9,801 0
31 150 150 1,950 1,950 292,500 22,500 3,802,500
32 144 144 1,540 1,540 221,760 20,736 2,371,600
33 154 154 2,693 2,693 414,722 23,716 7,252,249
34 130 130 1,060 1,060 137,800 16,900 1,123,600
35 202 202 3,519 3,519 710,838 40,804 1,123,600
36 51 51 1,520 1,520 77,520 2,601 2,310,400
37 148 148 1,080 1,080 159,840 21,904 1,166,400
38 153 153 3,230 3,230 494,190 23,409 10,432,900
39 83 83 953 953 79,099 6,889 908,209
40 101 101 1,244 1,244 125,644 10,201 1,547,536
41 140 140 0 0 0 19,600 0
42 132 132 160 160 21,120 17,424 25,600
43 112 112 2,480 2,480 277,760 12,544 6,150,400
44 127 127 1,800 1,800 228,600 16,129 3,240,000
45 139 139 1,417 1,417 196,963 19,321 2,007,889
46 156 156 1,820 1,820 283,920 24,336 3,312,400
47 126 126 3,338 3,338 420,588 15,876 11,142,244
48 33 33 1,537 1,537 50,721 1,089 2,362,369
49 209 209 1,866 1,866 389,994 43,681 3,481,956
50 124 124 3,676 3,676 455,824 15,376 13,512,976
51 131 131 1,197 1,197 156,807 17,161 1,432,809
52 144 144 241 241 34,704 20,736 58,081
53 93 93 500 500 46,500 8,649 250,000
54 199 199 1,910 1,910 380,090 39,601 3,648,100
55 170 170 800 800 136,000 28,900 640,000
56 186 186 980 980 182,280 34,596 960,400
57 200 200 1,695 1,695 339,000 40,000 2,873,025
58 146 146 1,560 1,560 227,760 21,316 2,433,600
59 222 222 2,249 2,249 499,278 49,284 5,058,001
60 73 73 1,594 1,594 455,824 5,329 2,540,836
TOTAL 84,100 84,100 12,902,023 1,419,510 254,892,709
a= 119,380,791,000 1,402 FIXED COST
85170600
b= 774,121,380 9.09 VARIABLE COST
85170600
r= 774,121,380 0.93
7.00166426283324E+17
836759479.350742
R sq= 0.856 R-squared
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 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 VACATION(Y) 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 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 XY 0 0 0 0 0 0 58800 0 0 0 45600 0 0 84000 34800 102600 1538404 967127 86500 433090 100200 266220 416874 91806 426760 X squared 38809 17689 17424 19881 33124 24336 38416 31684 25281 19881 23104 961 78400 18496 30276 29241 27889 25921 29929 25921 27889 23409 40401 1089 51529 Y squared 0 0 0 0 0 0 90000 0 0 0 90000 0 0 90000 40000 360000 84860944 36084049 250000 7236100 360000 3027600 4301476 2948920 3534400

adv

MONTH NRVS(x) ADV/TRNG(Y) XY X squared Y squared
1 197 197 22,561 22,561 4,444,517 38,809 508,998,721
2 133 133 19,040 19,040 2,532,320 17,689 362,521,600
3 132 132 14,373 14,373 1,897,236 17,424 206,583,129
4 141 141 15,022 15,022 2,118,102 19,881 225,660,484
5 182 182 19,966 19,966 3,633,812 33,124 398,641,156
6 156 156 12,019 12,019 1,874,964 24,336 144,456,361
7 196 196 13,217 13,217 2,590,532 38,416 174,689,089
8 178 178 17,303 17,303 3,079,934 31,684 299,393,809
9 159 159 16,535 16,535 2,629,065 25,281 273,406,225
10 141 141 23,821 23,821 3,358,761 19,881 567,440,041
11 152 152 14,146 14,146 2,150,192 23,104 200,109,316
12 31 31 22,223 22,223 688,913 961 493,861,729
13 280 280 19,992 19,992 5,597,760 78,400 399,680,064
14 136 136 20,251 20,251 2,754,136 18,496 410,103,001
15 174 174 20,082 20,082 3,494,268 30,276 403,286,724
16 171 171 26,716 26,716 4,568,436 29,241 713,744,656
17 167 167 25,223 25,223 4,212,241 27,889 636,199,729
18 161 161 21,106 21,106 3,398,066 25,921 445,463,236
19 173 173 17,799 17,799 3,079,227 29,929 316,804,401
20 161 161 28,038 28,038 4,514,118 25,921 786,129,444
21 167 167 37,284 37,284 6,226,428 27,889 1,390,096,656
22 153 153 24,236 24,236 3,708,108 23,409 587,383,696
23 201 201 27,244 27,244 5,476,044 40,401 742,235,536
24 33 33 20,376 20,376 672,408 1,089 415,181,376
25 227 227 26,719 26,719 6,065,213 51,529 216,884,529
26 150 150 14,727 14,727 2,209,050 22,500 216,884,529
27 142 142 27,880 27,880 3,958,960 20,164 777,294,400
28 104 104 21,872 21,872 2,274,688 10,816 478,384,384
29 121 121 18,705 18,705 2,263,305 14,641 349,877,025
30 99 99 23,835 23,835 2,359,665 9,801 568,107,225
31 150 150 25,605 25,605 3,840,750 22,500 655,616,025
32 144 144 17,763 17,763 2,557,872 20,736 315,524,169
33 154 154 32,379 32,379 4,986,366 23,716 1,048,399,641
34 130 130 19,324 19,324 2,512,120 16,900 373,416,976
35 202 202 22,412 22,412 4,527,224 40,804 502,297,744
36 51 51 29,998 29,998 1,529,898 2,601 899,880,004
37 148 148 9,112 9,112 1,348,576 21,904 83,028,544
38 153 153 38,616 38,616 5,908,248 23,409 1,491,195,456
39 83 83 22,690 22,690 1,883,270 6,889 514,836,100
40 101 101 14,703 14,703 1,485,003 10,201 216,178,209
41 140 140 28,764 28,764 4,026,960 19,600 827,367,696
42 132 132 27,253 27,253 3,597,396 17,424 742,726,009
43 112 112 24,419 24,419 2,734,928 12,544 596,287,561
44 127 127 26,011 26,011 3,303,397 16,129 676,572,121
45 139 139 24,492 24,492 3,404,388 19,321 599,858,064
46 156 156 31,158 31,158 4,860,648 24,336 970,820,964
47 126 126 32,213 32,213 4,058,838 15,876 1,037,677,369
48 33 33 30,177 30,177 995,841 1,089 910,651,329
49 209 209 26,737 26,737 5,588,033 43,681 714,867,169
50 124 124 31,084 31,084 3,854,416 15,376 966,215,056
51 131 131 33,278 33,278 4,359,418 17,161 1,107,425,284
52 144 144 32,657 32,657 4,702,608 20,736 1,066,479,649
53 93 93 29,794 29,794 2,770,842 8,649 887,682,436
54 199 199 38,431 38,431 7,647,769 39,601 1,476,941,761
55 170 170 27,640 27,640 4,698,800 28,900 763,969,600
56 186 186 28,657 28,657 5,330,202 34,596 821,223,649
57 200 200 36,425 36,425 7,285,000 40,000 1,326,780,625
58 146 146 27,720 27,720 4,047,120 21,316 768,398,400
59 222 222 27,941 27,941 6,202,902 49,284 780,699,481
60 73 73 30,950 30,950 2,259,350 5,329 957,902,500
TOTAL 1,460,714 1,460,714 214,138,652 1,419,510 37,810,421,862
a= 2,073,498,130,140 24,345 FIXED COST
85170600
b= 12,848,319,120 150.85 VARIABLE COST
85170600
r= 12,848,319,120 3.79
1.14929141142202E+19
3390120073.71719
R sq= 14.364 R-squared
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 ADV/TRNG(Y) 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 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 XY 4444517 2532320 1897236 2118102 3633812 1874964 2590532 3079934 2629065 3358761 2150192 688913 5597760 2754136 3494268 4568436 4212241 3398066 3079227 4514118 6226428 3708108 5476044 672408 6065213 2209050 3958960 2274688 2263305 2359665 3840750 2557872 4986366 2512120 4527224 1529898 1348576 5908248 1883270 1485003 4026960 3597396 2734928 3303397 3404388 4860648 4058838 995841 5588033 3854416 4359418 4702608 2770842 7647769 4698800 5330202 7285000 4047120 6202902 2259350 X squared 38809 17689 17424 19881 33124 24336 38416 31684 25281 19881 23104 961 78400 18496 30276 29241 27889 25921 29929 25921 27889 23409 40401 1089 51529 22500 20164 10816 14641 9801 22500 20736 23716 16900 40804 2601 21904 23409 6889 10201 19600 17424 12544 16129 19321 24336 15876 1089 43681 15376 17161 20736 8649 39601 28900 34596 40000 21316 49284 5329 Y squared 508998721 362521600 206583129 225660484 398641156 144456361 174689089 299393809 273406225 567440041 200109316 493861729 399680064 410103001 403286724 713744656 636199729 445463236 316804401 786129444 1390096656 587383696 742235536 415181376 216884529 216884529 777294400 478384384 349877025 568107225 655616025 315524169 1048399641 373416976 502297744 899880004 83028544 1491195456 514836100 216178209 827367696 742726009 596287561 676572121 599858064 970820964 1037677369 910651329 714867169 966215056 1107425284 1066479649 887682436 1476941761 763969600 821223649 1326780625 768398400 780699481 957902500

laudry

MONTH NRVS(x) SPLY/LNDRY(y) XY X squared Y squared
1 197 197 1,118 1,118 220,246 38,809 1,249,924
2 133 133 3,573 3,573 475,209 17,689 12,766,329
3 132 132 1,388 1,388 183,216 17,424 1,926,544
4 141 141 2,894 2,894 408,054 19,881 8,375,236
5 182 182 1,896 1,896 345,072 33,124 3,594,816
6 156 156 1,188 1,188 185,328 24,336 1,411,344
7 196 196 3,912 3,912 766,752 38,416 15,303,744
8 178 178 2,012 2,012 358,136 31,684 4,048,144
9 159 159 2,717 2,717 432,003 25,281 7,382,089
10 141 141 1,102 1,102 155,382 19,881 1,214,404
11 152 152 2,630 2,630 399,760 23,104 6,916,900
12 31 31 7,043 7,043 218,333 961 49,603,849
13 280 280 1,999 1,999 559,720 78,400 3,996,001
14 136 136 1,192 1,192 162,112 18,496 1,420,864
15 174 174 1,336 1,336 232,464 30,276 1,784,896
16 171 171 3,873 3,873 662,283 29,241 15,000,129
17 167 167 5,560 5,560 928,520 27,889 30,913,600
18 161 161 1,737 1,737 279,657 25,921 3,017,169
19 173 173 1,847 1,847 319,531 29,929 3,411,409
20 161 161 4,415 4,415 710,815 25,921 19,492,225
21 167 167 2,827 2,827 472,109 27,889 7,991,929
22 153 153 5,836 5,836 892,908 23,409 34,058,896
23 201 201 3,387 3,387 680,787 40,401 11,471,769
24 33 33 12,132 12,132 400,356 1,089 147,185,424
25 227 227 4,383 4,383 994,941 51,529 19,210,689
26 150 150 10,231 10,231 1,534,650 22,500 104,673,361
27 142 142 7,734 7,734 1,098,228 20,164 59,814,756
28 104 104 -684 -684 -71,136 10,816 467,856
29 121 121 8,329 8,329 1,007,809 14,641 69,372,241
30 99 99 2,540 2,540 337,820 9,801 6,451,600
31 150 150 5,862 5,862 879,300 22,500 34,363,044
32 144 144 6,998 6,998 1,007,712 20,736 48,972,004
33 154 154 8,131 8,131 1,252,174 23,716 66,113,161
34 130 130 6,026 6,026 783,380 16,900 36,312,676
35 202 202 9,120 9,120 1,842,240 40,804 83,174,400
36 51 51 6,798 6,798 346,698 2,601 46,212,804
37 148 148 6,627 6,627 980,796 21,904 43,917,129
38 153 153 5,892 5,892 901,476 23,409 34,715,664
39 83 83 3,450 3,450 286,350 6,889 11,902,500
40 101 101 5,259 5,259 531,159 10,201 27,657,081
41 140 140 2,294 2,294 321,160 19,600 5,262,436
42 132 132 8,155 8,155 1,076,460 17,424 66,504,025
43 112 112 1,621 1,621 181,552 12,544 2,627,641
44 127 127 902 902 114,554 16,129 813,604
45 139 139 5,158 5,158 716,962 19,321 26,604,964
46 156 156 2,901 2,901 452,556 24,336 8,415,801
47 126 126 14,426 14,426 1,817,676 15,876 208,109,476
48 33 33 9,250 9,250 305,250 1,089 85,562,500
49 209 209 1,694 1,694 354,046 43,681 2,869,636
50 124 124 9,040 9,040 1,120,960 15,376 81,721,600
51 131 131 2,099 2,099 274,969 17,161 4,405,801
52 144 144 9,328 9,328 1,343,232 20,736 87,011,584
53 93 93 4,268 4,268 396,924 8,649 18,215,824
54 199 199 5,407 5,407 1,075,993 39,601 29,235,649
55 170 170 9,305 9,305 1,581,850 28,900 86,583,025
56 186 186 1,803 1,803 335,358 34,596 3,250,809
57 200 200 8,839 8,839 1,767,800 40,000 78,127,921
58 146 146 10,944 10,944 1,597,824 21,316 119,771,136
59 222 222 5,775 5,775 1,282,050 49,284 33,350,625
60 73 73 12,750 12,750 930,750 5,329 162,562,500
TOTAL 300,269 300,269 41,210,276 1,419,510 2,197,875,157
a= 426,234,848,190 5,004 FIXED COST
85170600
b= 2,472,616,560 29.03 VARIABLE COST
85170600
r= 2,472,616,560 1.31
3.55255405293727E+18
1884822021.55463
R sq= 1.721 R-squared
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 SPLY/LNDRY(y) 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 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 XY 220246 475209 183216 408054 345072 185328 766752 358136 432003 155382 399760 218333 559720 162112 232464 662283 928520 279657 319531 710815 472109 892908 680787 400356 994941 1534650 1098228 -71136 1007809 337820 879300 1007712 1252174 783380 1842240 346698 980796 901476 286350 531159 321160 1076460 181552 114554 716962 452556 1817676 305250 354046 1120960 274969 1343232 396924 1075993 1581850 335358 1767800 1597824 1282050 930750 X squared 38809 17689 17424 19881 33124 24336 38416 31684 25281 19881 23104 961 78400 18496 30276 29241 27889 25921 29929 25921 27889 23409 40401 1089 51529 22500 20164 10816 14641 9801 22500 20736 23716 16900 40804 2601 21904 23409 6889 10201 19600 17424 12544 16129 19321 24336 15876 1089 43681 15376 17161 20736 8649 39601 28900 34596 40000 21316 49284 5329 Y squared 1249924 12766329 1926544 8375236 3594816 1411344 15303744 4048144 7382089 1214404 6916900 49603849 3996001 1420864 1784896 15000129 30913600 3017169 3411409 19492225 7991929 34058896 11471769 147185424 19210689 104673361 59814756 467856 69372241 6451600 34363044 48972004 66113161 36312676 83174400 46212804 43917129 34715664 11902500 27657081 5262436 66504025 2627641 813604 26604964 8415801 208109476 85562500 2869636 81721600 4405801 87011584 18215824 29235649 86583025 3250809 78127921 119771136 33350625 162562500

freight

MONTH NRVS(x) FREIGHT(y) XY X squared Y squared
1 197 197 382 382 75,254 38809 145,924
2 133 133 409 409 54,397 17689 167,281
3 132 132 742 742 97,944 17424 550,564
4 141 141 675 675 95,175 19881 455,625
5 182 182 572 572 104,104 33124 327,184
6 156 156 407 407 63,492 24336 165,649
7 196 196 643 643 126,028 38416 413,449
8 178 178 605 605 107,690 31684 366,025
9 159 159 209 209 33,231 25281 43,681
10 141 141 184 184 25,944 19881 33,856
11 152 152 331 331 50,312 23104 109,561
12 31 31 560 560 17,360 961 313,600
13 280 280 582 582 162,960 78400 338,724
14 136 136 603 603 82,008 18496 363,609
15 174 174 492 492 85,608 30276 242,064
16 171 171 559 559 95,589 29241 312,481
17 167 167 356 356 59,452 27889 126,736
18 161 161 439 439 70,679 25921 192,721
19 173 173 1,628 1,628 281,644 25921 2,650,384
20 161 161 (12) (12) (1,932) 29929 144
21 167 167 480 480 80,160 27889 230,400
22 153 153 79 79 12,087 23409 6,241
23 201 201 188 188 37,788 40401 35,344
24 33 33 593 593 19,569 1089 351,649
25 227 227 769 769 174,563 51529 591,361
26 150 150 593 593 88,950 22500 351,649
27 142 142 414 414 58,788 20164 171,396
28 104 104 425 425 44,200 10816 180,625
29 121 121 483 483 58,443 14641 233,289
30 99 99 417 417 41,283 9801 173,889
31 150 150 222 222 33,300 22500 49,284
32 144 144 49 49 7,056 20736 2,401
33 154 154 818 818 125,972 23716 669,124
34 130 130 1,015 1,015 131,950 16900 1,030,225
35 202 202 1,255 1,255 253,510 40804 1,575,025
36 51 51 68 68 3,468 2601 4,624
37 148 148 565 565 83,620 21904 319,225
38 153 153 369 369 56,457 23409 136,161
39 83 83 (182) (182) (15,106) 6889 33,124
40 101 101 709 709 71,609 10201 502,681
41 140 140 1,006 1,006 140,840 19600 1,012,036
42 132 132 521 521 68,772 17424 271,441
43 112 112 514 514 57,568 12544 264,196
44 127 127 917 917 116,459 16129 840,889
45 139 139 (77) (77) (10,703) 19321 5,929
46 156 156 450 450 70,200 24336 202,500
47 126 126 120 120 15,120 15876 14,400
48 33 33 819 819 27,027 1089 670,761
49 209 209 853 853 178,277 43681 727,609
50 124 124 498 498 61,752 15376 248,004
51 131 131 605 605 79,255 17161 366,025
52 144 144 483 483 69,552 20736 620,944
53 93 93 788 788 73,284 8649 620,944
54 199 199 529 529 105,271 39601 279,841
55 170 170 (180) (180) (30,600) 28900 32,400
56 186 186 (242) (242) (45,012) 34596 58,564
57 200 200 859 859 171,800 40000 737,881
58 146 146 (492) (492) (71,832) 21316 242,064
59 222 222 245 245 54,390 49284 60,025
60 73 73 717 717 52,341 5329 514,089
TOTAL 28,628 28,628 4,238,367 1419510 21,757,521
a= 40,637,732,280 477 FIXED COST
85170600
b= 254,302,020 2.99 VARIABLE COST
85170600
r= 254,302,020 1.25
4.13834471022456E+16
203429218.899954
R sq= 1.563 R-squared
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 FREIGHT(y) 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 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 XY 75254 54397 97944 95175 104104 63492 126028 107690 33231 25944 50312 17360 162960 82008 85608 95589 59452 70679 281644 -1932 80160 12087 37788 19569 174563 88950 58788 44200 58443 41283 33300 7056 125972 131950 253510 3468 83620 56457 -15106 71609 140840 68772 57568 116459 -10703 70200 15120 27027 178277 61752 79255 69552 73284 105271 -30600 -45012 171800 -71832 54390 52341 X squared 38809 17689 17424 19881 33124 24336 38416 31684 25281 19881 23104 961 78400 18496 30276 29241 27889 25921 25921 29929 27889 23409 40401 1089 51529 22500 20164 10816 14641 9801 22500 20736 23716 16900 40804 2601 21904 23409 6889 10201 19600 17424 12544 16129 19321 24336 15876 1089 43681 15376 17161 20736 8649 39601 28900 34596 40000 21316 49284 5329 Y squared 145924 167281 550564 455625 327184 165649 413449 366025 43681 33856 109561 313600 338724 363609 242064 312481 126736 192721 2650384 144 230400 6241 35344 351649 591361 351649 171396 180625 233289 173889 49284 2401 669124 1030225 1575025 4624 319225 136161 33124 502681 1012036 271441 264196 840889 5929 202500 14400 670761 727609 248004 366025 620944 620944 279841 32400 58564 737881 242064 60025 514089

vehicle

MONTH NRVS(x) VEHICLES(y) XY X squared Y squared
1 197 197 2,052 2,052 404,244 38809 4210704
2 133 133 1,405 1,405 186,865 17689 1974025
3 132 132 1,380 1,380 182,160 17424 1904400
4 141 141 2,057 2,057 290,037 19881 4231249
5 182 182 1,603 1,603 291,746 33124 2569609
6 156 156 2,524 2,524 393,744 24336 6370576
7 196 196 2,348 2,348 460,208 38416 5513104
8 178 178 1,208 1,208 215,024 31684 1459264
9 159 159 2,400 2,400 381,600 25281 5760000
10 141 141 2,076 2,076 292,716 19881 4309776
11 152 152 1,677 1,677 254,904 23104 2812329
12 31 31 2,183 2,183 67,673 961 4765489
13 280 280 1,927 1,927 539,560 78400 3713329
14 136 136 1,156 1,156 157,216 18496 1336336
15 174 174 1,898 1,898 330,252 30276 3602404
16 171 171 1,808 1,808 309,168 29241 3268864
17 167 167 1,816 1,816 303,272 27889 3297856
18 161 161 1,384 1,384 222,824 25921 1915456
19 173 173 1,962 1,962 339,426 29929 3849444
20 161 161 2,446 2,446 393,806 25921 5982916
21 167 167 2,296 2,296 383,432 27889 5271616
22 153 153 3,175 3,175 485,775 23409 10080625
23 201 201 1,287 1,287 258,687 40401 1656369
24 33 33 2,563 2,563 84,579 1089 6568969
25 227 227 2,205 2,205 500,535 51529 4862025
26 150 150 2,289 2,289 343,350 22500 5239521
27 142 142 1,891 1,891 268,522 20164 3575881
28 104 104 2,288 2,288 237,952 10816 5234944
29 121 121 2,223 2,223 268,983 14641 4941729
30 99 99 1,683 1,683 166,617 9801 2832489
31 150 150 1,586 1,586 237,900 22500 2515396
32 144 144 1,751 1,751 252,144 20736 3066001
33 154 154 2,082 2,082 320,628 23716 4334724
34 130 130 1,714 1,714 222,820 16900 2937796
35 202 202 2,173 2,173 438,946 40804 4721929
36 51 51 1,779 1,779 90,729 2601 3164841
37 148 148 1,324 1,324 195,952 21904 1752976
38 153 153 1,523 1,523 233,019 23409 2319529
39 83 83 2,087 2,087 173,221 6889 4355569
40 101 101 2,095 2,095 211,595 10201 4389025
41 140 140 1,304 1,304 182,560 19600 1700416
42 132 132 1,667 1,667 220,044 17424 2778889
43 112 112 1,040 1,040 116,480 12544 1081600
44 127 127 2,880 2,880 365,760 16129 8294400
45 139 139 1,281 1,281 178,059 19321 1640961
46 156 156 2,259 2,259 352,404 24336 5103081
47 126 126 1,394 1,394 175,644 15876 1943236
48 33 33 1,516 1,516 50,028 1089 2298256
49 209 209 1,657 1,657 346,313 43681 2745649
50 124 124 2,266 2,266 280,984 15376 5134756
51 131 131 1,952 1,952 255,712 17161 3810304
52 144 144 1,852 1,852 266,688 20736 3429904
53 93 93 1,704 1,704 158,472 8649 2903616
54 199 199 1,882 1,882 374,518 39601 3541924
55 170 170 977 977 166,090 28900 954529
56 186 186 846 846 157,356 34596 715716
57 200 200 2,856 2,856 571,200 40000 8156736
58 146 146 1,864 1,864 272,144 21316 3474496
59 222 222 1,141 1,141 253,302 49284 1301881
60 73 73 486 486 35,478 5329 236196
TOTAL 110,148 110,148 16,171,067 1419510 217915630
a= 156,356,187,480 1,836 FIXED COST
85170600
b= 970,264,020 11.39 VARIABLE COST
85170600
r= 970,264,020 3.42
8.02610170758576E+16
283303754.080064
R sq= 11.729 R-squared

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 VEHICLES(y) 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 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 XY 404244 186865 182160 290037 291746 393744 460208 215024 381600 292716 254904 67673 539560 157216 330252 309168 303272 222824 339426 393806 383432 485775 258687 84579 500535 343350 268522 237952 268983 166617 237900 252144 320628 222820 438946 90729 195952 233019 173221 211595 182560 220044 116480 365760 178059 352404 175644 50028 346313 280984 255712 266688 158472 374518 166090 157356 571200 272144 253302 35478 X squared 38809 17689 17424 19881 33124 24336 38416 31684 25281 19881 23104 961 78400 18496 30276 29241 27889 25921 29929 25921 27889 23409 40401 1089 51529 22500 20164 10816 14641 9801 22500 20736 23716 16900 40804 2601 21904 23409 6889 10201 19600 17424 12544 16129 19321 24336 15876 1089 43681 15376 17161 20736 8649 39601 28900 34596 40000 21316 49284 5329 Y squared 4210704 1974025 1904400 4231249 2569609 6370576 5513104 1459264 5760000 4309776 2812329 4765489 3713329 1336336 3602404 3268864 3297856 1915456 3849444 5982916 5271616 10080625 1656369 6568969 4862025 5239521 3575881 5234944 4941729 2832489 2515396 3066001 4334724 2937796 4721929 3164841 1752976 2319529 4355569 4389025 1700416 2778889 1081600 8294400 1640961 51 03081 1943236 2298256 2745649 5134756 3810304 3429904 2903616 3541924 954529 715716 8156736 3474496 1301881 236196

demo's

MONTH NRVS(x) DEMO'S XY X squared Y squared
1 197 197 1,881 1,881 370,557 38809 3,538,161
2 133 133 695 695 92,435 17689 483,025
3 132 132 469 469 61,908 17424 219,961
4 141 141 125 125 17,625 19881 15,625
5 182 182 131 131 23,842 33124 17,161
6 156 156 1,229 1,229 191,724 24336 1,510,441
7 196 196 1,206 1,206 236,376 38416 1,454,436
8 178 178 436 436 77,608 31684 190,096
9 159 159 1,476 1,476 234,684 25281 2,178,576
10 141 141 1,168 1,168 164,688 19881 1,364,224
11 152 152 635 635 96,520 23104 403,225
12 31 31 1,014 1,014 31,434 961 1,028,196
13 280 280 (477) (477) (133,560) 78400 227,529
14 136 136 1,839 1,839 250,104 18496 3,381,921
15 174 174 1,260 1,260 219,240 30276 1,587,600
16 171 171 510 510 87,210 29241 260,100
17 167 167 2,350 2,350 392,450 27889 5,522,500
18 161 161 (288) (288) (46,368) 25921 82,944
19 173 173 1,591 1,591 275,243 29929 2,531,281
20 161 161 (3,308) (3,308) (532,588) 25921 10,942,864
21 167 167 1,709 1,709 285,403 27889 2,920,681
22 153 153 798 798 122,094 23409 636,804
23 201 201 (2,025) (2,025) (407,025) 40401 4,100,625
24 33 33 1,010 1,010 33,330 1089 1,020,100
25 227 227 2,493 2,493 565,911 51529 6,215,049
26 150 150 (2,051) (2,051) (307,650) 22500 4,206,601
27 142 142 386 386 54,812 20164 148,996
28 104 104 178 178 18,512 10816 31,684
29 121 121 (262) (262) (31,702) 14641 68,644
30 99 99 (1,356) (1,356) (134,244) 9801 1,838,736
31 150 150 486 486 72,900 22500 236,196
32 144 144 (1,924) (1,924) (277,056) 20736 3,701,776
33 154 154 1,547 1,547 238,238 23716 2,393,209
34 130 130 132 132 17,160 16900 17,424
35 202 202 (2,337) (2,337) (472,074) 40804 5,461,569
36 51 51 1,195 1,195 60,945 2601 1,428,025
37 148 148 1,164 1,164 172,272 21904 1,354,896
38 153 153 (1,839) (1,839) (281,367) 23409 3,381,921
39 83 83 454 454 37,682 6889 206,116
40 101 101 868 868 87,668 10201 753,424
41 140 140 (1,990) (1,990) (278,600) 19600 3,960,100
42 132 132 1,869 1,869 246,708 17424 3,493,161
43 112 112 329 329 36,848 12544 108,241
44 127 127 (1,897) (1,897) (240,919) 16129 3,598,609
45 139 139 2,959 2,959 411,301 19321 8,755,681
46 156 156 417 417 65,052 24336 173,889
47 126 126 (2,659) (2,659) (335,034) 15876 7,070,281
48 33 33 4,517 4,517 149,061 1089 20,403,289
49 209 209 601 601 125,609 43681 361,201
50 124 124 (284) (284) (35,216) 15376 80,656
51 131 131 668 668 87,508 17161 446,224
52 144 144 1,409 1,409 202,896 20736 1,985,281
53 93 93 (1,771) (1,771) (164,703) 8649 3,136,441
54 199 199 453 453 90,147 39601 205,209
55 170 170 1,310 1,310 222,700 28900 1,716,100
56 186 186 (2,844) (2,844) (528,984) 34596 8,088,336
57 200 200 1,532 1,532 306,400 40000 2,347,024
58 146 146 1,400 1,400 204,400 21316 1,960,000
59 222 222 (3,513) (3,513) (779,886) 49284 12,341,169
60 73 73 1,746 1,746 127,458 5329 3,048,516
TOTAL 18,820 18,820 1,879,687 1419510 160,341,750
a= 26,715,178,200 314 FIXED COST
85170600
b= 112,781,220 1.32 VARIABLE COST
85170600
r= 112,781,220 0.13
7.8921740392956E+17
888379087.962768
R sq= 0.016 R-squared

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 DEMO'S 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 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 XY 370557 92435 61908 17625 23842 191724 236376 77608 234684 164688 96520 31434 -133560 250104 219240 87210 392450 -46368 275243 -532588 285403 122094 -407025 33330 565911 -307650 54812 18512 -31702 -134244 72900 -277056 238238 17160 -472074 60945 172272 -281367 37682 87668 -278600 246708 36848 -240919 411301 65052 -335034 149061 125609 -35216 87508 202896 -164703 90147 222700 -528984 306400 204400 -779886 127458 X squared 38809 17689 17424 19881 33124 24336 38416 31684 25281 19881 23104 961 78400 18496 30276 29241 27889 25921 29929 25921 27889 23409 40401 1089 51529 22500 20164 10816 14641 9801 22500 20736 23716 16900 40804 2601 21904 23409 6889 10201 19600 17424 12544 16129 19321 24336 15876 1089 43681 15376 17161 20736 8649 39601 28900 34596 40000 21316 49284 5329 Y squared 3538161 483025 219961 15625 17161 1510441 1454436 190096 2178576 1364224 403225 1028196 227529 3381921 1587600 260100 5522500 82944 2531281 10942864 2920681 636804 4100625 1020100 6215049 4206601 148996 31684 68644 1838736 236196 3701776 2393209 17424 5461569 1428025 1354896 3381921 206116 753424 3960100 3493161 108241 3598609 8755681 173889 7070281 20403289 361201 80656 446224 1985281 3136441 205209 1716100 8088336 2347024 1960000 12341169 3048516

floor plan

MONTH NRVS(x) FLOOR-PLAN(Y) XY X squared Y squared
1 197 197 (78,173) (78,173) (15,400,081) 38809 6111017929
2 133 133 28,456 28,456 3,784,648 17689 809743936
3 132 132 34,423 34,423 4,543,836 17424 1184942929
4 141 141 5,697 5,697 803,277 19881 32455809
5 182 182 34,599 34,599 6,297,018 33124 1197090801
6 156 156 53,737 53,737 8,382,972 24336 2887665169
7 196 196 5,507 5,507 1,079,372 38416 30327049
8 178 178 32,436 32,436 5,773,608 31684 1052094096
9 159 159 28,950 28,950 4,603,050 25281 838102500
10 141 141 20,876 20,876 2,943,516 19881 435807376
11 152 152 45,278 45,278 6,882,256 23104 2050097284
12 31 31 66,745 66,745 2,069,095 961 4454895025
13 280 280 (30,104) (30,104) (8,429,120) 78400 906250816
14 136 136 50,583 50,583 6,879,288 18496 2558639889
15 174 174 18,803 18,803 3,271,722 30276 353552809
16 171 171 23,080 23,080 3,946,680 29241 532686400
17 167 167 18,774 18,774 3,135,258 27889 352463076
18 161 161 23,802 23,802 3,832,122 25921 566535204
19 173 173 33,848 33,848 5,855,704 29929 1145687104
20 161 161 13,480 13,480 2,170,280 25921 181710400
21 167 167 22,965 22,965 3,835,155 27889 527391225
22 153 153 18,898 18,898 2,891,394 23409 357134404
23 201 201 38,699 38,699 7,778,499 40401 1497612601
24 33 33 68,285 68,285 2,253,405 1089 4662841225
25 227 227 (44,140) (44,140) (10,019,780) 51529 1948339600
26 150 150 36,311 36,311 5,446,650 22500 1318488721
27 142 142 19,865 19,865 2,820,830 20164 394618225
28 104 104 19,013 19,013 1,977,352 10816 361494169
29 121 121 16,228 16,228 1,963,588 14641 263347984
30 99 99 37,637 37,637 3,726,063 9801 1416543769
31 150 150 (1,121) (1,121) (168,150) 22500 1256641
32 144 144 34,757 34,757 5,005,008 20736 1208049049
33 154 154 26,419 26,419 4,068,526 23716 697963561
34 130 130 21,134 21,134 2,747,420 16900 446645956
35 202 202 18,578 18,578 3,752,756 40804 345142084
36 51 51 91,520 91,520 4,667,520 2601 8375910400
37 148 148 (73,753) (73,753) (10,915,444) 21904 5439505009
38 153 153 30,443 30,443 4,657,779 23409 926776249
39 83 83 17,725 17,725 1,471,175 6889 314175625
40 101 101 26,402 26,402 2,666,602 10201 697065604
41 140 140 (3,789) (3,789) (530,460) 19600 14356521
42 132 132 15,090 15,090 1,991,880 17424 227708100
43 112 112 (945) (945) (105,840) 12544 893025
44 127 127 30,405 30,405 3,861,435 16129 924464025
45 139 139 14,781 14,781 2,054,559 19321 218477961
46 156 156 15,613 15,613 2,435,628 24336 243765769
47 126 126 40,968 40,968 5,161,968 15876 1678377024
48 33 33 43,189 43,189 1,425,237 1089 1865289721
49 209 209 (20,127) (20,127) (4,206,543) 43681 405096129
50 124 124 18,236 18,236 2,261,264 15376 332551696
51 131 131 15,176 15,176 1,988,056 17161 230310976
52 144 144 25,245 25,245 3,635,280 20736 637310025
53 93 93 6,493 6,493 603,849 8649 42159049
54 199 199 21,851 21,851 4,348,349 39601 477466201
55 170 170 7 7 1,190 28900 49
56 186 186 17,192 17,192 3,197,712 34596 295564864
57 200 200 14,864 14,864 2,972,800 40000 220938496
58 146 146 10,121 10,121 1,477,666 21316 102434641
59 222 222 7,946 7,946 1,764,012 49284 63138916
60 73 73 188,040 188,040 13,726,920 5329 35359041600
TOTAL 1,317,018 1,317,018 141,115,811 1419510 102221412490
a= 1,869,520,221,180 21,950 FIXED COST
85170600
b= 8,466,948,660 99.41 VARIABLE COST
85170600
r= 8,466,948,660 0.44
3.74644035117765E+20
19355723575.1538
R sq= 0.191 R-squared

NRVS(x) 197 133 132 141 182 156 19 6 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 FLOOR-PLAN(Y) -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 -78173 284 56 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 XY -15400081 3784648 4543836 803277 6297018 8382972 1079372 5773608 4603050 2943516 6882256 2069095 -8429120 6879288 3271722 3946680 3135258 3832122 5855704 2170280 3835155 2891394 7778499 2253405 -10019780 5446650 2820830 1977352 1963588 3726063 -168150 5005008 4068526 2747420 3752756 4667520 -10915444 4657779 1471175 2666602 -530460 1991880 -105840 3861435 2054559 2435628 5161968 1425237 -4206543 2261264 1988056 3635280 603849 4348349 1190 3197712 2972800 1477666 1764012 13726920 X squared 38809 17689 17424 19881 33124 24336 38416 31684 25281 19881 23104 961 78400 18496 30276 29241 27889 25921 29929 25921 27889 23409 40401 1089 51529 22500 20164 10816 14641 9801 22500 20736 23716 16900 40804 2601 21904 23409 6889 10201 19600 17424 12544 16129 19321 24336 15876 1089 43681 15376 17161 20736 8649 39601 28900 34596 40000 21316 49284 5329 Y squared 6111017929 809743936 1184942929 32455809 1197090801 2887665169 30327049 1052094096 838102500 435807376 2050097284 4454895025 906250816 2558639889 353552809 532686400 352463076 566535204 1145687104 181710400 527391225 357134404 1497612601 4662841225 1948339600 1318488721 394618225 361494169 263347984 1416543769 1256641 1208049049 697963561 446645956 345142084 8375910400 5439505009 926776249 314175625 697065604 14356521 227708100 893025 924464025 218477961 243765769 1678377024 1865289721 405096129 332551696 230310976 637310025 42159049 477466201 49 295564864 220938496 102434641 63138916 35359041600