Fill in the correct figures in Table 5 (FC, VC R-sq). Please see below images of charts and sheets to aide you with filling in the correct figures for table 5
Step 4 Using the Excel file "Exam 500896 - Motomart Excel Spreadsheet" as per the instructions found above under the "Project Requirements", reproduce and complete the following Table 5 and answer the four questions. The Excel file pro- vides an example of how to arrive at the figures that need to be entered into the Table. You will create new worksheets for each of the remaining expenses. Do the work to arrive at the figures for each expense. Be sure to include the Excel file as part of your submission to "backup" the data presented in the Table in the Word document being submitted. The Excel spread sheet, while it will be included in your sub- mission for the project, will not be graded. It is supporting documentation for what is being presented in the Word docu- ment. Only the information that is in the Word document will be graded. The FC and VC should be rounded to the nearest dollar. The R-sq is a percentage figure carried out to 2 decimal places. Fill in the correct figures in the below table Column Expense 1 Salaries 2 Vacation 3 Advertising and training 4 Supplies/tools/laundry 5 Freight 6 Vehicles 7 Demonstrators 8 Floor planning Computed total 9 Total Table 5 FC $106,866 VC -$110 R-sq 4.10% Excel Spreadsheet Plot salary A B C E 1 MONTINRYS (X) SALARY (Y) F XY 10,431,347 1 197 197 52,951 52,951 2 133 133 47,054 47,054 6,258,182 3 132 132 55,372 55,372 7,309,104 141 141 46,114 46,114 6,502,074 182 182 48,309 48,309 8,792,238 156 156 49,643 49,643 7,744,308 196 196 55,784 55,784 10,933,664 178 178 47,957 47,957 8,536,346 159 159 53,743 53,743 8,545,137 141 141 53,109 53,109 7,488,369 152 152 45,491 45,491 6,914,632 31 31 57,479 57,479 1,781,849 280 280 49,049 49,049 13,733,720 136 136 46,698 46,698 6,350,928 174 174 59,790 59,790 10,403,460 16 171 171 80,773 80,773 13,812,183 17 167 167 71,130 71,130 11,878,710 18 161 161 82,490 82,490 13,280,890 19 173 173 98,172 98,172 16,983,756 20 161 161 90,685 90,685 14,600,285 Plot-Salary 60 Months HighLow Sample New Worksheet 2345659987 10 11 12 13 14 15 16 17 18 19 20 21 456 7 00 O 8 9 10 11 12 23456 13 14 15 H Y squared 2,803,808,401 38,809 17,689 2,214,078,916 17,424 3,066,058,384 19,881 2,126,500,996 33,124 2,333,759,481 24,336 2,464,427,449 38,416 3,111,854,656 31,684 2,299,873,849 25,281 2,888,310,049 19,881 2,820,565,881 23,104 2,069,431,081 961 3,303,835,441 78,400 2,405,804,401 18,496 2,180,703,204 30,276 3,574,844,100 29,241 6,524,277,529 27,889 5,059,476,900 25,921 6,804,600,100 29,929 9,637,741,584 25,921 8,223,769,225 35.000 G X squared ||||| Excel Spreadsheet-Plot salary Part 2 (continuation) 22 21 167 167 97,771 23 153 153 87,129 24 201 201 95,910 25 33 33 109,192 26 227 227 89,041 150 150 92,165 142 142 88,981 104 104 95,898 121 121 96,245 99 99 106,364 150 150 90,564 144 144 98,418 154 154 110,436 130 130 102,042 202 202 124,413 51 51 116,897 148 148 97,083 153 153 104,727 83 83 95,622 101 101 96,438 140 140 114,995 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 333 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 2888wwww 39 40 41 97,771 16,327,757 87,129 13,330,737 95,910 19,277,910 109,192 3,603,336 89,041 20,212,307 92,165 13,824,750 88,981 12,635,302 95,898 9,973,392 96,245 11,645,645 106,364 10,530,036 90,564 13,584,600 98,418 14,172,192 110,436 17,007,144 102,042 13,265,460 124,413 25,131,426 116,897 5,961,747 97,083 14,368,284 104,727 16,023,231 95,622 7,936,626 96,438 9,740,238 114,995 16,099,300 27,889 9,559,168,441 23,409 7,591,462,641 40,401 9,198,728,100 1,089 11,922,892,864 51,529 7,928,299,681 22,500 8,494,387,225 20,164 7,917,618,361 10,816 9,196,426,404 14,641 9,263,100,025 9,801 11,313,300,496 22,500 8,201,838,096 20,736 9,686,102,724 23,716 12,196,110,096 16,900 10,412,569,764 40,804 15,478,594,569 2,601 13,664,908,609 21,904 9,425,108,889 23,409 10,967,744,529 6,889 9,143,566,884 10,201 9,300,287,844 19,600 13,223,850,025 34445 46 47 48 49 50 51 52 53 54 55 In in in in 56 57 58 59 60 9358 Excel Spreadsheet-Plot salary Part 3 (continuation) A B C D E F 132 13,904,484 105,337 98,989 105,337 98,989 11,086,768 112 127 124,352 124,352 15,792,704 139 115,875 115,875 16,106,625 156 113,035 113,035 17,633,460 126 119,106 119,106 15,007,356 33 104,199 104,199 3,438,567 209 98,938 98,938 20,678,042 124 108,606 108,606 13,467,144 131 106,396 106,396 13,937,876 144 106,778 106,778 15,376,032 93 124,805 124,805 11,606,865 199 110,153 110,153 21,920,447 170 117,276 117,276 19,936,920 112,055 20,842,230 186 112,055 200 114,765 114,765 22,953,000 146 128,007 128,007 18,689,022 222 116,811 116,811 25,932,042 73 115,899 115,899 8,460,627 5,443,506 783,702,813 61 7339599 42 43 44 45 46 47 48 49 23 st in 178 In in in ininin in in in in 50 51 52 53 54 55 56 58 59 60 62 1830 63 57 132 112 127 139 156 126 33 209 124 131 144 93 199 170 186 200 146 222 73 8796 G H 17,424 11,095,883,569 12,544 9,798,822,121 16,129 15,463,419,904 19,321 13,427,015,625 24,336 12,776,911,225 15,876 14,186,239,236 1,089 10,857,431,601 43,681 9,788,727,844 15,376 11,795,263,236 17,161 11,320,108,816 20,736 11,401,541,284 8,649 15,576,288,025 39,601 12,133,683,409 28,900 13,753,660,176 34,596 12,556,323,025 40,000 13,171,005,225 21,316 16,385,792,049 49,284 13,644,809,721 5,329 13,432,578,201 1,419,510 532,565,292,186 Mo NRVS 1 2 3 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Table 3 SEMI-FIXED (MIXED) EXPENSES FOR THE 60-MONTH PERIOD (FY 1984 THROUGH 1988) Salary Vacation 197 $52,951 S 133 $ 47,054 S 132 $ 55,372 S 141 $ 46,114 S 182 $ 48,309 $ 156 $49,643 $ 196 $ 55,784 $ 300 178 $ 47,957 $ 159 $ 53,743 S $ (30,104) 300 $ 18,800 141 $ 53,109 $ 152 $ 45,491 $ 300 31 $ 57,479 $ 280 $ 49,049 $ 136 $ 46,698 $ 174 $ 59,790 $ 200 171 S 80,773 $ 600 167 $ 71,130 $ 9,212 161 $ 82,490 $ 6,007 173 $ 98,172 $ 500 161 $ 90,685 $ 2,690 167 $ 97,771 $ 600 153 $ 87,129 $ 1,740 201 $ 95,910 $ 2,074 33 $109,192 $ 2,782 227 $ 89,041 $ 1,880 150 $92,165 $ 3,602 142 $ 88,981 $ 744 104 $ 95,898 $ 960 121 $ 96,245 $ Adv/Trng SplyTis/Lndry Freight Vehicles Demo's Floor-Plan $ 22,561 S 1,118 $ 382 $2,052 $1,881 S (78,173) $ 19,040 $ 3,573 $ 409 $1,405 $ 695 $ 28,456 $ 14,373 $ 1,388 S 742 S 1,380 $469 $ 34,423 $ 15,022 $ 2,894 $ 675 $2,057 $125 S 5,697 $ 19,966 $ 1,896 $ 572 $1,603 $ 131 $ 34,599 $ 12,019 $ 1,188 $ 407 $2,524 $1,229 $ 53,737 $ 13,217 S 3,912 S 643 S 2,348 $ 1,206 $ 5,507 $ 17,303 $ 2,012 $ 605 $1,208 $ 436 $ 32,436 $ 16,535 $ 2,717 $ 209 $2,400 $ 1,476 $ 28,950 $ 23,821 $ 1,102 $184 $2,076 $ 1,168 $ 20,876 $ 14,146 $ 2,630 S 331 S 1,677 $ 635 $ 45,278 $22,223 $ 7,043 $ 580 $ 2.183 $ 1,014 $ AR 745 $ 19,992 S 1,999 $582 $1,927 S (477) $ 20,251 $ 1,192 $ 603 $1,156 $ 1,839 $50,583 $ 20,082 $ 1,336 $ 492 $1,898 $ 1,260 $ 26,716 S 3,873 $ 559 $1,808 S 510 $ 23,080 $ 25,223 $ 5,560 $ 356 $1,816 $ 2,350 $ 18,774 $ 21,106 S 1,737 $ 439 $1,384 S (288) $ 23,802 $ 17,799 S 1,847 $1,628 $ 1,962 $ 1,591 $ 33,848 $ 28,038 S 4,415 (12) $2,446 $ (3,308) $ 13,480 $ 37,284 S 2,827 $ 480 $ 2,296 $ 1,709 $22,965 $ 24,236 $ 5,836 $ 79 $ 3,175 $ 798 $ 18,898 $ 27,244 $ 3,387 $ 188 $ 1,287 $(2,025) $ 38,699 $ 20,376 $ 12,132 $ 593 $ 2,563 $1,010 $ 68,285 $ 26,719 $ 4,383 $ 769 $2,205 $2,493 $S (44,140) $ 14,727 S 10,231 $ 593 $2,289 $ (2,051) $ 36,311 $ 27,880 $ 7,734 S 414 $1,891 $ 386 $ 19,865 (684) S 425 S 2,288 $ 178 $ 19,013 8,329 $ 483 $2,223 $ (262) S 16,228 2,540 S 417 S 1,683 $(1,356) $ 37,637 5,862 S 222 $1,586 $ 486 S (1,121) 6.998 $ 21,872 S $ 18,705 $ 99 $106,364 $ 150 $ 90,564 $ 1,950 $ 23,835 $ $ 25,605 $ $ 17.763 S 144 S 98.418 $ 1.540 S 49 28 29 30 31 32 Total $2,772 $100,632 $108,147 $ 72,584 $107.076 $120,747 $82,917 $101,957 $106,030 $102,336 $110,488 $157,247 $42.968 $122,622 $103,861 $137,919 $134,421 $136,677 $157,347 $138,434 $165,932 $141,891 $166,764 $216,933 $ 83,350 $157,867 $147,895 $139,950 $141,951 $171,120 $125,154 S 1.751 $(1.924) S 34.757 $159.352 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 154 $110,436 $ 2,693 130 $102,042 $ 1,060 202 $124,413 $3,519 51 $116,897 $ 1,520 148 $ 97,083 $ 1,080 153 $104,727 $ 3,230 83 $ 95,622 $ 953 101 $ 96,438 $ 1,244 140 $114,995 $ 132 $105,337 $ 160 112 $ 98,989 $ 2,480 127 $124,352 $1,800 139 $115,875 $ 1,417 156 $113,035 $ 1,820 126 $119,106 $ 3,338 33 $104,199 $ 1,537 209 $ 98,938 $ 1,866 124 $108,606 $ 3,676 131 $106,396 $ 1,197 144 $106,778 $ 241 93 $124,805 $ 500 199 $110,153 $ 1.910 170 $117,276 $ 800 186 $112,055 $ 980 200 $114,765 $ 1,695 146 $128,007 $ 1,560 222 $116,811 $2,249 73 $115,899 $ 1,594 8,131 $ 818 S 2,082 $1,547 $ 26,419 $184,505 6,026 $1,015 $1,714 $ 132 $ 21,134 $152,447 9,120 $1,255 $2,173 $(2,337) $ 18,578 $179,133 6,798 $ 68 $ 1,779 $ 1,195 $91,520 $249,775 6,627 $ 565 $1,324 $ 1,164 S (73,753) $ 43,202 5,892 $369 $ 1,523 $(1,839) $ 30,443 $182,961 3,450 S (182) $2,087 $ 454 $ 17,725 $142,799 5.259 $ 709 $ 2,095 $ 868 $ 26,402 2,294 $1,006 $1,304 $(1.990) $ (3,789) 8,155 S 521 S 1,667 $ 1,869 $ 15,090 1,621 S514 $1,040 $ 329 S (945) $ 917 $ 2,880 $(1,897) S 30,405 $ (77) $1,281 $2,959 $14,781 S 450 $2,259 $ 417 $ 15,613 $ 1,394 $ (2,659) $ 40,968 $1,516 $ 4,517 $ 43,189 $1,657 $ 601 $2,266 $ (284) $ 18,236 $ 1,952 $ 668 $147,718 $142,584 $160,052 $128,447 $185,370 $165,886 $167,653 $ 120 $208,906 $195,204 $ 819 $ 853 $ 498 S (20,127) $112,219 $173,122 $ 605 $ 15,176 $161,371 $ 483 $ 1,852 $ 1,409 $ 25,245 $ 1,704 $(1,771) $ 6,493 $1,882 $ 453 $ 21,851 977 $1,310 S 7 $177,993 $166,581 $180,616 $157,135 $158,447 $ 788 $ 529 $ (180) $ S (242) S $ 859 $ S (492) S $ 245 $ $ 717 S $181,835 846 $(2,844) S 17,192 2,856 $ 1,532 S 14,864 1,864 $1,400 $ 10,121 $ (3,513) $ $181,124 1,141 486 7,946 $158,595 $ 1,746 $ 188,040 $352,182 $ 32,379 $ 19,324 $ $ 22,412 $ $ 29,998 $ $ 9,112 S $ 38,616 $ $ 22,690 $ $ 14,703 $ $ 28,764 $ $ 27,253 $ $ 24,419 $ $ 26,011 S 902 $ 24,492 $ 5,158 $ 31,158 $ 2,901 $ 32,213 $ 14,426 $ 30,177 $ 9,250 $ 26,737 $ 1,694 $ 31,084 $ 9,040 $ 33,278 $ 2,099 $ 32,657 $ 9,328 $ 29,794 $ 4,268 $ 38,431 $ 5,407 $ 27,640 $ 9,305 $ 28,657 $ 1,803 $ 36,425 $ 8,839 $ 27,720 S 10,944 $ 27,941 $ 5,775 $ 30,950 $ 12,750 Step 4 Using the Excel file "Exam 500896 - Motomart Excel Spreadsheet" as per the instructions found above under the "Project Requirements", reproduce and complete the following Table 5 and answer the four questions. The Excel file pro- vides an example of how to arrive at the figures that need to be entered into the Table. You will create new worksheets for each of the remaining expenses. Do the work to arrive at the figures for each expense. Be sure to include the Excel file as part of your submission to "backup" the data presented in the Table in the Word document being submitted. The Excel spread sheet, while it will be included in your sub- mission for the project, will not be graded. It is supporting documentation for what is being presented in the Word docu- ment. Only the information that is in the Word document will be graded. The FC and VC should be rounded to the nearest dollar. The R-sq is a percentage figure carried out to 2 decimal places. Fill in the correct figures in the below table Column Expense 1 Salaries 2 Vacation 3 Advertising and training 4 Supplies/tools/laundry 5 Freight 6 Vehicles 7 Demonstrators 8 Floor planning Computed total 9 Total Table 5 FC $106,866 VC -$110 R-sq 4.10% Excel Spreadsheet Plot salary A B C E 1 MONTINRYS (X) SALARY (Y) F XY 10,431,347 1 197 197 52,951 52,951 2 133 133 47,054 47,054 6,258,182 3 132 132 55,372 55,372 7,309,104 141 141 46,114 46,114 6,502,074 182 182 48,309 48,309 8,792,238 156 156 49,643 49,643 7,744,308 196 196 55,784 55,784 10,933,664 178 178 47,957 47,957 8,536,346 159 159 53,743 53,743 8,545,137 141 141 53,109 53,109 7,488,369 152 152 45,491 45,491 6,914,632 31 31 57,479 57,479 1,781,849 280 280 49,049 49,049 13,733,720 136 136 46,698 46,698 6,350,928 174 174 59,790 59,790 10,403,460 16 171 171 80,773 80,773 13,812,183 17 167 167 71,130 71,130 11,878,710 18 161 161 82,490 82,490 13,280,890 19 173 173 98,172 98,172 16,983,756 20 161 161 90,685 90,685 14,600,285 Plot-Salary 60 Months HighLow Sample New Worksheet 2345659987 10 11 12 13 14 15 16 17 18 19 20 21 456 7 00 O 8 9 10 11 12 23456 13 14 15 H Y squared 2,803,808,401 38,809 17,689 2,214,078,916 17,424 3,066,058,384 19,881 2,126,500,996 33,124 2,333,759,481 24,336 2,464,427,449 38,416 3,111,854,656 31,684 2,299,873,849 25,281 2,888,310,049 19,881 2,820,565,881 23,104 2,069,431,081 961 3,303,835,441 78,400 2,405,804,401 18,496 2,180,703,204 30,276 3,574,844,100 29,241 6,524,277,529 27,889 5,059,476,900 25,921 6,804,600,100 29,929 9,637,741,584 25,921 8,223,769,225 35.000 G X squared ||||| Excel Spreadsheet-Plot salary Part 2 (continuation) 22 21 167 167 97,771 23 153 153 87,129 24 201 201 95,910 25 33 33 109,192 26 227 227 89,041 150 150 92,165 142 142 88,981 104 104 95,898 121 121 96,245 99 99 106,364 150 150 90,564 144 144 98,418 154 154 110,436 130 130 102,042 202 202 124,413 51 51 116,897 148 148 97,083 153 153 104,727 83 83 95,622 101 101 96,438 140 140 114,995 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 333 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 2888wwww 39 40 41 97,771 16,327,757 87,129 13,330,737 95,910 19,277,910 109,192 3,603,336 89,041 20,212,307 92,165 13,824,750 88,981 12,635,302 95,898 9,973,392 96,245 11,645,645 106,364 10,530,036 90,564 13,584,600 98,418 14,172,192 110,436 17,007,144 102,042 13,265,460 124,413 25,131,426 116,897 5,961,747 97,083 14,368,284 104,727 16,023,231 95,622 7,936,626 96,438 9,740,238 114,995 16,099,300 27,889 9,559,168,441 23,409 7,591,462,641 40,401 9,198,728,100 1,089 11,922,892,864 51,529 7,928,299,681 22,500 8,494,387,225 20,164 7,917,618,361 10,816 9,196,426,404 14,641 9,263,100,025 9,801 11,313,300,496 22,500 8,201,838,096 20,736 9,686,102,724 23,716 12,196,110,096 16,900 10,412,569,764 40,804 15,478,594,569 2,601 13,664,908,609 21,904 9,425,108,889 23,409 10,967,744,529 6,889 9,143,566,884 10,201 9,300,287,844 19,600 13,223,850,025 34445 46 47 48 49 50 51 52 53 54 55 In in in in 56 57 58 59 60 9358 Excel Spreadsheet-Plot salary Part 3 (continuation) A B C D E F 132 13,904,484 105,337 98,989 105,337 98,989 11,086,768 112 127 124,352 124,352 15,792,704 139 115,875 115,875 16,106,625 156 113,035 113,035 17,633,460 126 119,106 119,106 15,007,356 33 104,199 104,199 3,438,567 209 98,938 98,938 20,678,042 124 108,606 108,606 13,467,144 131 106,396 106,396 13,937,876 144 106,778 106,778 15,376,032 93 124,805 124,805 11,606,865 199 110,153 110,153 21,920,447 170 117,276 117,276 19,936,920 112,055 20,842,230 186 112,055 200 114,765 114,765 22,953,000 146 128,007 128,007 18,689,022 222 116,811 116,811 25,932,042 73 115,899 115,899 8,460,627 5,443,506 783,702,813 61 7339599 42 43 44 45 46 47 48 49 23 st in 178 In in in ininin in in in in 50 51 52 53 54 55 56 58 59 60 62 1830 63 57 132 112 127 139 156 126 33 209 124 131 144 93 199 170 186 200 146 222 73 8796 G H 17,424 11,095,883,569 12,544 9,798,822,121 16,129 15,463,419,904 19,321 13,427,015,625 24,336 12,776,911,225 15,876 14,186,239,236 1,089 10,857,431,601 43,681 9,788,727,844 15,376 11,795,263,236 17,161 11,320,108,816 20,736 11,401,541,284 8,649 15,576,288,025 39,601 12,133,683,409 28,900 13,753,660,176 34,596 12,556,323,025 40,000 13,171,005,225 21,316 16,385,792,049 49,284 13,644,809,721 5,329 13,432,578,201 1,419,510 532,565,292,186 Mo NRVS 1 2 3 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Table 3 SEMI-FIXED (MIXED) EXPENSES FOR THE 60-MONTH PERIOD (FY 1984 THROUGH 1988) Salary Vacation 197 $52,951 S 133 $ 47,054 S 132 $ 55,372 S 141 $ 46,114 S 182 $ 48,309 $ 156 $49,643 $ 196 $ 55,784 $ 300 178 $ 47,957 $ 159 $ 53,743 S $ (30,104) 300 $ 18,800 141 $ 53,109 $ 152 $ 45,491 $ 300 31 $ 57,479 $ 280 $ 49,049 $ 136 $ 46,698 $ 174 $ 59,790 $ 200 171 S 80,773 $ 600 167 $ 71,130 $ 9,212 161 $ 82,490 $ 6,007 173 $ 98,172 $ 500 161 $ 90,685 $ 2,690 167 $ 97,771 $ 600 153 $ 87,129 $ 1,740 201 $ 95,910 $ 2,074 33 $109,192 $ 2,782 227 $ 89,041 $ 1,880 150 $92,165 $ 3,602 142 $ 88,981 $ 744 104 $ 95,898 $ 960 121 $ 96,245 $ Adv/Trng SplyTis/Lndry Freight Vehicles Demo's Floor-Plan $ 22,561 S 1,118 $ 382 $2,052 $1,881 S (78,173) $ 19,040 $ 3,573 $ 409 $1,405 $ 695 $ 28,456 $ 14,373 $ 1,388 S 742 S 1,380 $469 $ 34,423 $ 15,022 $ 2,894 $ 675 $2,057 $125 S 5,697 $ 19,966 $ 1,896 $ 572 $1,603 $ 131 $ 34,599 $ 12,019 $ 1,188 $ 407 $2,524 $1,229 $ 53,737 $ 13,217 S 3,912 S 643 S 2,348 $ 1,206 $ 5,507 $ 17,303 $ 2,012 $ 605 $1,208 $ 436 $ 32,436 $ 16,535 $ 2,717 $ 209 $2,400 $ 1,476 $ 28,950 $ 23,821 $ 1,102 $184 $2,076 $ 1,168 $ 20,876 $ 14,146 $ 2,630 S 331 S 1,677 $ 635 $ 45,278 $22,223 $ 7,043 $ 580 $ 2.183 $ 1,014 $ AR 745 $ 19,992 S 1,999 $582 $1,927 S (477) $ 20,251 $ 1,192 $ 603 $1,156 $ 1,839 $50,583 $ 20,082 $ 1,336 $ 492 $1,898 $ 1,260 $ 26,716 S 3,873 $ 559 $1,808 S 510 $ 23,080 $ 25,223 $ 5,560 $ 356 $1,816 $ 2,350 $ 18,774 $ 21,106 S 1,737 $ 439 $1,384 S (288) $ 23,802 $ 17,799 S 1,847 $1,628 $ 1,962 $ 1,591 $ 33,848 $ 28,038 S 4,415 (12) $2,446 $ (3,308) $ 13,480 $ 37,284 S 2,827 $ 480 $ 2,296 $ 1,709 $22,965 $ 24,236 $ 5,836 $ 79 $ 3,175 $ 798 $ 18,898 $ 27,244 $ 3,387 $ 188 $ 1,287 $(2,025) $ 38,699 $ 20,376 $ 12,132 $ 593 $ 2,563 $1,010 $ 68,285 $ 26,719 $ 4,383 $ 769 $2,205 $2,493 $S (44,140) $ 14,727 S 10,231 $ 593 $2,289 $ (2,051) $ 36,311 $ 27,880 $ 7,734 S 414 $1,891 $ 386 $ 19,865 (684) S 425 S 2,288 $ 178 $ 19,013 8,329 $ 483 $2,223 $ (262) S 16,228 2,540 S 417 S 1,683 $(1,356) $ 37,637 5,862 S 222 $1,586 $ 486 S (1,121) 6.998 $ 21,872 S $ 18,705 $ 99 $106,364 $ 150 $ 90,564 $ 1,950 $ 23,835 $ $ 25,605 $ $ 17.763 S 144 S 98.418 $ 1.540 S 49 28 29 30 31 32 Total $2,772 $100,632 $108,147 $ 72,584 $107.076 $120,747 $82,917 $101,957 $106,030 $102,336 $110,488 $157,247 $42.968 $122,622 $103,861 $137,919 $134,421 $136,677 $157,347 $138,434 $165,932 $141,891 $166,764 $216,933 $ 83,350 $157,867 $147,895 $139,950 $141,951 $171,120 $125,154 S 1.751 $(1.924) S 34.757 $159.352 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 154 $110,436 $ 2,693 130 $102,042 $ 1,060 202 $124,413 $3,519 51 $116,897 $ 1,520 148 $ 97,083 $ 1,080 153 $104,727 $ 3,230 83 $ 95,622 $ 953 101 $ 96,438 $ 1,244 140 $114,995 $ 132 $105,337 $ 160 112 $ 98,989 $ 2,480 127 $124,352 $1,800 139 $115,875 $ 1,417 156 $113,035 $ 1,820 126 $119,106 $ 3,338 33 $104,199 $ 1,537 209 $ 98,938 $ 1,866 124 $108,606 $ 3,676 131 $106,396 $ 1,197 144 $106,778 $ 241 93 $124,805 $ 500 199 $110,153 $ 1.910 170 $117,276 $ 800 186 $112,055 $ 980 200 $114,765 $ 1,695 146 $128,007 $ 1,560 222 $116,811 $2,249 73 $115,899 $ 1,594 8,131 $ 818 S 2,082 $1,547 $ 26,419 $184,505 6,026 $1,015 $1,714 $ 132 $ 21,134 $152,447 9,120 $1,255 $2,173 $(2,337) $ 18,578 $179,133 6,798 $ 68 $ 1,779 $ 1,195 $91,520 $249,775 6,627 $ 565 $1,324 $ 1,164 S (73,753) $ 43,202 5,892 $369 $ 1,523 $(1,839) $ 30,443 $182,961 3,450 S (182) $2,087 $ 454 $ 17,725 $142,799 5.259 $ 709 $ 2,095 $ 868 $ 26,402 2,294 $1,006 $1,304 $(1.990) $ (3,789) 8,155 S 521 S 1,667 $ 1,869 $ 15,090 1,621 S514 $1,040 $ 329 S (945) $ 917 $ 2,880 $(1,897) S 30,405 $ (77) $1,281 $2,959 $14,781 S 450 $2,259 $ 417 $ 15,613 $ 1,394 $ (2,659) $ 40,968 $1,516 $ 4,517 $ 43,189 $1,657 $ 601 $2,266 $ (284) $ 18,236 $ 1,952 $ 668 $147,718 $142,584 $160,052 $128,447 $185,370 $165,886 $167,653 $ 120 $208,906 $195,204 $ 819 $ 853 $ 498 S (20,127) $112,219 $173,122 $ 605 $ 15,176 $161,371 $ 483 $ 1,852 $ 1,409 $ 25,245 $ 1,704 $(1,771) $ 6,493 $1,882 $ 453 $ 21,851 977 $1,310 S 7 $177,993 $166,581 $180,616 $157,135 $158,447 $ 788 $ 529 $ (180) $ S (242) S $ 859 $ S (492) S $ 245 $ $ 717 S $181,835 846 $(2,844) S 17,192 2,856 $ 1,532 S 14,864 1,864 $1,400 $ 10,121 $ (3,513) $ $181,124 1,141 486 7,946 $158,595 $ 1,746 $ 188,040 $352,182 $ 32,379 $ 19,324 $ $ 22,412 $ $ 29,998 $ $ 9,112 S $ 38,616 $ $ 22,690 $ $ 14,703 $ $ 28,764 $ $ 27,253 $ $ 24,419 $ $ 26,011 S 902 $ 24,492 $ 5,158 $ 31,158 $ 2,901 $ 32,213 $ 14,426 $ 30,177 $ 9,250 $ 26,737 $ 1,694 $ 31,084 $ 9,040 $ 33,278 $ 2,099 $ 32,657 $ 9,328 $ 29,794 $ 4,268 $ 38,431 $ 5,407 $ 27,640 $ 9,305 $ 28,657 $ 1,803 $ 36,425 $ 8,839 $ 27,720 S 10,944 $ 27,941 $ 5,775 $ 30,950 $ 12,750
