(Jim is concerned 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. Don't worry about checking any calculations.)

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