Question: There is concern that there might be some errors in the data for the Northeast. Prepare a fixed asset schedule (similar to requirement 1) for the Northeast by asset category. Identify the asset ID which has the error and explain the error involved. (Hint: Use the slicer. Dont worry about checking any calculations.)

(I can't find the errors...)

Row Labels Buildings 854 972 974 977 978 979 980 988 989 1007 1013 1015 1508 1512 Equipment 859 860 935 Sum of Cost Sum of BegAccumDepr Sum of CurrentYearDepr Sum of EndAccumDepr Sum of EndBookValue $ 39,798,500 $ 5,303,276 $ 888,663 $ 6,191,939 $ 33,606,561 $ 2,640,290 $ 343,012 $ 58,955 $ 401,967 $ 2,238,323 $ 1,256,930 $ 163,293 $ 28,066 $ 191,360 $ 1,065,570 $ 3,607,820 $ 468,708 $ 80,559 $ 549,267 $ 3,058,553 $ 12,588,510 $ 1,635,430 $ 281,090 $ 1,916,520 $ 10,671,990 $ 803,180 $ 104,345 $ 17,934 $ 122,279 $ 680,901 $ 8,470 $ 1,100 $ 189 $ 1,290 $ 7,180 $ 6,518,990 $ 846,912 $ 145,563 $ 992,474 $ 5,526,516 $ 6,830 $ 887 $ 153 $ 1,040 $ 5,790 $ 3,840,360 $ 498,919 $ 85,752 $ 584,670 $ 3,255,690 $ 2,706,350 $ 351,594 $ 60,430 $ 412,024 $ 2,294,326 $ 2,399,320 $ 311,707 $ 53,575 $ 365,281 $ 2,034,039 $ 52,210 $ 6,783 $ 1,166 $ 7,949 $ 44,261 $ 870,860 $ 175,009 $ 19,445 $ 194,455 $ 676,405 $ 2,498,380 $ 395,577 $ 55,786 $ 451,363 $ 2,047,017 $ 94,650 $ 75,528 $ 4,296 $ 79,824 $ 14,826 $ 8,750 $ 8,313 $ $ 8,313 $ 438 $ 5,180 $ 4,921 $ $ 4,921 $ 259 $ 690 $ 242 $ 127 $ 368 $ 322 $ 5,590 $ 1,859 $ 974 $ 2,832 $ 2,758 $ 6,400 $ 2,128 $ 1,115 $ 3,243 $ 3,157 $ 11,950 $ 3,973 $ 2,081 $ 6,055 $ 5,895 $ 2,150 $ 2,150 $ $ 2,150 $ $ 39,950 $ 37,953 $ $ 37,953 $ 1,998 $ 13,990 $ 13,990 $ $ 13,990 $ 946 947 948 1506 1509 1513 Furniture 853 861 862 973 975 976 981 982 983 984 985 986 987 990 991 992 993 994 995 $ 13,996,590 $ $ 120 $ $ 9,770 $ $ 5,870 $ $ 79,360 $ $ 488,190 $ $ 78,810 $ $ 20,510 $ $ 383,120 $ $ 8,160 $ $ 40,600 $ $ 30 $ $ 2,140 $ $ 205,300 $ $ 114,870 $ $ 703,890 $ $ 57,490 $ $ 385,480 $ $ 1,348,190 $ $ 364,350 $ $ 238,590 $ $ 539,600 $ $ 807,030 $ $ 1,049,100 $ $ 335,390 $ $ 35,020 $ $ 404,690 $ $ 620 $ $ 393,650 $ $ 316,080 $ $ 1,048,170 $ $ 388,490 $ $ 1,775,490 $ $ 137,490 $ $ 257,120 $ $ 191,270 $ 10,170,128 $ 91 $ 7,909 $ 4,514 $ 57,442 $ 353,357 $ 57,043 $ 14,845 $ 277,306 $ 6,217 $ 29,387 $ 23 $ 1,549 $ 148,598 $ 83,144 $ 509,482 $ 41,612 $ 279,014 $ 975,833 $ 263,720 $ 172,694 $ 390,568 $ 584,136 $ 759,349 $ 242,758 $ 25,348 $ 292,918 $ 449 $ 284,928 $ 228,782 $ 758,675 $ 281,193 $ 1,285,117 $ 99,517 $ 186,106 $ 138,443 $ 1,727,877 $ 16 $ 1,279 $ 730 $ 9,873 $ 60,733 $ 9,804 $ 2,552 $ 47,662 $ 1,069 $ 5,051 $ 4 $ 266 $ 25,540 $ 14,290 $ 87,567 $ 7,152 $ 47,956 $ 167,721 $ 45,327 $ 29,682 $ 67,129 $ 100,398 $ 130,513 $ 41,724 $ 4,357 $ 50,345 $ 77 $ 48,972 $ 39,322 $ 130,397 $ 48,330 $ 220,879 $ 17,104 $ 31,987 $ 23,795 $ 11,898,005 $ 107 $ 9,188 $ 5,245 $ 67,314 $ 414,090 $ 66,848 $ 17,397 $ 324,968 $ 7,286 $ 34,438 $ 27 $ 1,815 $ 174,138 $ 97,434 $ 597,050 $ 48,764 $ 326,970 $ 1,143,554 $ 309,047 $ 202,375 $ 457,696 $ 684,534 $ 889,862 $ 284,483 $ 29,704 $ 343,264 $ 526 $ 333,900 $ 268,104 $ 889,073 $ 329,523 $ 1,505,996 $ 116,621 $ 218,093 $ 162,238 $ 2,098,585 13 582 625 12,046 74,100 11,962 3,113 58,152 874 6,163 3 325 31,162 17,436 106,840 8,726 58,510 204,636 55,303 36,215 81,904 122,496 159,238 50,907 5,316 61,426 94 59,750 47,976 159,097 58,967 269,494 20,869 39,027 29,032 996 997 998 999 1000 1001 1002 1003 1004 1005 1008 1009 1010 1011 1012 1014 1016 1017 1018 1019 1020 1510 $ 1,364,770 $ $ 940 $ $ 2,310 $ $ 175,250 $ $ 640 $ $ 238,630 $ 987,834 $ 716 $ 1,672 $ 126,848 $ 488 $ 210,506 $ 169,784 $ 123 $ 287 $ 21,802 $ 84 $ 16,193 $ 1,157,617 $ 839 $ 1,959 $ 148,650 $ 571 $ 226,699 $ 207,153 101 351 26,600 69 11,932 Land $ 1,969,790 $ 855 $ 1,257,560 $ 1006 $ 110,930 $ 1507 $ 601,300 $ Land Improvements ! $ 105,070 $ 1511 $ 105,070 $ Grand Total $ 55,964,600 $ $ $ $ $ 43,254 $ 43,254 $ 15,592,186 $ 25,000 $ $ 25,000 $ $ 6,100 $ 6,100 $ 2,651,936 $ 25,000 $ $ 25,000 $ $ 49,354 $ 49,354 $ 18,244,122 $ 1,944,790 1,257,560 85,930 601,300 55,716 55,716 37,720,478