Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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.)
Row Labels Sum of Cost Sum of BegAccumDepr Sum of CurrentYearDepr Sum of EndAccumDepr Sum of EndBookValue Buildings $ 39,798,500 $ 5,303,276 $ 888,663 $ 6,191,939 $ 33,606,561 854 $ 2,640,290 $ 343,012 $ 58,955 $ 401,967 $ 2,238,323 972 $ 1,256,930 $ 163,293 $ 28,066 $ 191,360 $ 1,065,570 974 $ 3,607,820 $ 468,708 $ 80,559 $ 549,267 $ 3,058,553 977 $ 12,588,510 $ 1,635,430 $ 281,090 $ 1,916,520 $ 10,671,990 978 $ 803,180 $ 104,345 $ 17,934 $ 122,279 $ 680,901 979 $ 8,470 $ 1,100 $ 189 $ 1,290 $ 7,180 980 $ 6,518,990 $ 846,912 $ 145,563 $ 992,474 $ 5,526,516 988 $ 6,830 $ 887 $ 153 $ 1,040 $ 5,790 989 $ 3,840,360 $ 498,919 $ 85,752 $ 584,670 $ 3,255,690 1007 $ 2,706,350 $ 351,594 $ 60,430 $ 412,024 $ 2,294,326 1013 $ 2,399,320 $ 311,707 $ 53,575 $ 365,281 $ 2,034,039 1015 $ 52,210 $ 6,783 $ 1,166 $ 7,949 $ 44,261 1508 $ 870,860 $ 175,009 $ 19,445 $ 194,455 $ 676,405 1512 $ 2,498,380 $ 395,577 $ 55,786 $ 451,363 $ 2,047,017 Equipment $ 94,650 $ 75,528 $ 4,296 $ 79,824 $ 14,826 Furniture $ 13,996,590 $ 10,170,128 $ 1,727,877 $ 11,898,005 $ 2,098,585 Land $ 1,969,790 $ 25,000 $ 25,000 $ 1,944,790 Land Improvements $ 105,070 $ 43,254 $ 6,100 $ 49,354 $ 55,716 Grand Total $ 55,964,600 $ 15,592,186 $ 2,651,936 $ 18,244,122 $ 37,720,478 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,478Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started