Question: This was all the information that was provided. Please help if you can, thanks Allocating Shared Costs: Assume that you are a cost accountant at

This was all the information that was provided. Please help if you can, thanks  This was all the information that was provided. Please help if
you can, thanks Allocating Shared Costs: Assume that you are a cost
accountant at Basic Hospital. You have received the following e-mail. From: The
Controller@Basic Hospital.com To: CostAccountant@Basic Hospital.com Hello! In the past we have used
the direct method to allocate service department costs to our revenue producing
departments; however, I just attended a conference where one of the presenters
demonstrated how the step method can produce significantly different departmental cost calculations.
I don't know how much it would matter at Basic if we
used the step down method, but this person at the conference had
me convinced that it could matter quite a bit. As soon as
I got back from the conference I got into the system and
downloaded the attached summary reports (tab delimited) needed to allocate costs from
supporting departments to the producing departments for 2020. Please put together a

Allocating Shared Costs: Assume that you are a cost accountant at Basic Hospital. You have received the following e-mail. From: The Controller@Basic Hospital.com To: CostAccountant@Basic Hospital.com Hello! In the past we have used the direct method to allocate service department costs to our revenue producing departments; however, I just attended a conference where one of the presenters demonstrated how the step method can produce significantly different departmental cost calculations. I don't know how much it would matter at Basic if we used the step down method, but this person at the conference had me convinced that it could matter quite a bit. As soon as I got back from the conference I got into the system and downloaded the attached summary reports (tab delimited) needed to allocate costs from supporting departments to the producing departments for 2020. Please put together a report that shows the allocation using each method (direct and step) as well as a table that shows the differences (totals and as a percentage of support dept. cost) across the two allocation methods. For the step method, let's first allocate the departments that provide the most service to other support departments. Also, let's use the 12 month average of FTEs and square footage for assignment where applicable. Otherwise use the annual totals. Finally, please show me the differences for each department manager, as I'd like to know who will be affected the most if we switch to the step method Thank you cost accountant! The Controller Upload the following files to complete this assignment: (1) A Microsoft Excel Workbook named "allocation". The workbook should have 3 worksheets labeled "Direct "Step" and "Differences. The worksheets will contain the schedules used to allocate the cost from the support departments to the producing departments in the first two worksheets. In the third worksheet, summarize the differences between the two methods by department and manager. In addition, the workbook will also have one or more additional worksheets that are used to hold the source data (ie, the information in the files attached to this assignment) and perform interim calculations. Name worksheets that hold source data "sourcedata1," "sourcedata2" and "sourcedata3Worksheets that contain interim calculations should be named "calc1," "calc2" and so on. The worksheets should be organized in the following order. Direct, Step, Differences, calc worksheets, sourcedata worksheets (2) A PDF report that incorporates all 3 tables from the "Direct: "Step," and "Differences worksheets (in this order). After each allocation schedule, provide a written description of the schedule that explains the allocation technique and how it is applied at Basic Hospital to arrive at cost by department. After the "Differences" table, explain why the differences occur, using the department with the biggest difference as an example, Department Dpt Current Dept. Manager Medical Records 06-1000 Cohen Accounting 06-1001 Dillon General Services 06-1002 Blasco Human Resources 06-1003 Smith Patient Accounts 06-1004 Cohen Urology 02-1005 Kline Orthopaedics 02-1006 Dreyfus Opthamology 02-1007 Kramer Oncology 02-1008 James Obstetrics 02-1009 Plammot Neurology 02-1010 Barnes Maternity 02-1011 Plammot Intensive Care Unit 02-1012 Wellston General Surgery 02-1013 Piedmont Gastroenterology 02-1014 Rax Cardiology 02-1015 Jills Burn Center 02-1016 Cordona Emergency 02-1017 Jackson Support Dept. Allocation base Medical Records Total Nursing Hours Accounting Total Direct Cost General Services Square Footage Human Resources Total FTES Patient Accounts Total Patient Revenue Dpt Month Year sq. footage FTEs Nursing Hours Total Patient Revenue Direct Cost 02-1005 1 2020 2400 6 7344 "1,285,200" 424116 02-1005 2 2020 2400 7 7812 "1,210, 860" 423801 02-1005 3 2020 24007 8064 "1,177,344" 376750.08 02-1005 2020 2400 6 7488 "1,063,296" 340254.72 02-1005 5 2020 2400 5 5820 "931, 200" 307296 02-1005 6 2020 2400 5 6480 "1, 121,040" 358732.8 02-1005 7 2020 2400 5 6360"909, 480" 281938.8 02-1005 8 2020 2400 5 6600"970, 200" 339570 02-1005 9 2020 2400 5 5940"968, 220" 300148.2 02-1005 2020 2400 5 5760 "1,013, 760" 314265.6 02-1005 11 2020 2400 5 5640"908, 040" 299653.2 02-1005 12 2020 2400 5 6000 "852,000" 289680 02-1006 1 2020 1800 5 6540"987,540" 335763.6 02-1006 2 2020 1800 5 5880 1981, 960" 324046.8 02-1006 3 2020 1800 5 6240 "1,029, 600" 308880 02-1006 4 2020 1800 5 5820 "820, 620" 287217 02-1006 5 2020 1800 5 6240 "923, 520" 286291.2 02-1006 6 2020 18005 6360"979, 440" 333009.6 02-1006 7 2020 18005 6420 "1,020,780" 316441.8 02-1006 8 2020 18005 6600 1,016, 400" 355740 02-1006 9 2020 1800 5 6480 1,017,360" 345902.4 02-1006 10 2020 1800 5 5580"864,9001 268119 02-1006 11 2020 1800 5 6540 "1, 111,800" 355776 02-1006 12 2020 1800 5 6240886, 0801 283545.6 02-1007 1 2020 1500 4464 1736, 560" 235699.2 02-1007 2 2020 2500 4 4320 "604,800 187488 02-1007 13 2020 1500 4 4992 "698,880 244608 02-1007 4 2020 1500 4 4560"779,760 272916 02-1007 5 2020 1500 4 4846"732, 048" 234255.36 02-1007 6 2020 2500 4 5088 "890, 400" 302736 02-1007 2020 2500 4 4896 "856, 800" 257040 02-1007 2020 1500 4 5280 "855,360" 282268.8 co 02-1006 9 02-1006 10 02-1006 11 02-1006 12 02-1007 02-1007 02-1007 3 02-10074 02-1007 5 02-1007 02-1007 02-1007 02-1007 02-1007 10 02-1007 11 02-1007 12 02-1008 02-1008 02-1008 02-1008 02-1008 02-1008 6 02-1008 7 02-1008 8 02-1008 9 02-1008 10 02-1008 11 02-1000 112 02-1009 1 02-1009 2 02-1009 3 02-1009 4 2020 1800 5 2020 1800 5 2020 1800 5 2020 1800 5 2020 15004 2020 1500 4 2020 1500 4 2020 1500 4 2020 15004 2020 1500 4 2020 1500 4 2020 15004 2020 1500 4 2020 15004 2020 15004 2020 1500 4 2020 25009 2020 2500 8 2020 2500 8 2020 2500 9 2020 25009 2020 2500 9 2020 2500 101 2020 2500 2020 2500 9 2020 2500 2020 25008 2020 2500 8 2020 3300 2 2020 3300 2 2020 3300 2 2020 3300 2 6480 "1,017,360" 345902.4 5580"864,900" 268119 6540"1,111, 800" 355776 6240"886,080" 283545.6 4464"736,560" 235699.2 4320"604,800" 187488 4992 "698, 880" 244608 4560"779,760" 272916 4848"732,048" 234255.36 5088 1890, 400" 302736 4896 1856, 800" 257040 5280"855,360" 282268.8 4656 "824, 112" 280198.08 4944 "791, 040" 268953.6 4992 1743, 808" 245456.64 5232 805728 249775.68 10908 "1, 614,384" 532746.72 8736 "1,380, 288" 469297.92 8640 ",442, 880" 476150.4 9936 "1,530, 144" 474344.64 11772 , 648,080" 527385.6 10476 "1, 676, 160" 586656 11040 1,633,920" 522854.4 10044 91,596, 996 511038.72 1124 1,579,608 537066.72 9696 "1,502, 880M 526008 9600 "1, 430, 400486336 9984 1557504 529551.36 2852 W395, 136 122492.16 2328 "372) 480" 122918.4 2232 "377, 208" 116934.48 2352"423) 360" 135475.2 9 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 02-1009 02-1009 02-1009 02-1009 02-1009 02-1009 02-1009 02-1009 02-1010 02-1010 02-1010 02-1010 02-1010 02-1010 02-1010 02-1010 02-1010 02-1010 02-1010 02-1010 02-1011 02-1011 02-1011 02-1011 02-1011 02-1011 02-1011 02-1011 02-1011 02-1011 02-1011 02-1011 2020 3300 2 2020 3300 2 2020 3300 2 2020 3300 2 2020 3300 2 2020 3300 2 2020 3300 2 2020 3300 2 2020 1300 4 2020 13004 2020 1300 4 2020 1300 4 2020 13004 2020 1300 4 2020 1300 4 2020 1300 4 2020 1300 4 2020 1300 4 2020 1300 4 2020 1300 4 2020 4000 15 2020 4000 14 20204000 13 2020 4000 14 2020 4000 2020 4000 2020 4000 13 2020 4000 12 2020 4000 13 2020 4000 14 2020 4000 13 2020 4000 12 2424 387,840" 131865.6 2160 "341, 280" 102384 2568 "428,856" 150099.6 2592 "417, 312" 137712.96 2520 "385,560" 131090.4 2376 "406,296" 121888.8 2640"401,280" 132422.4 2568 431424 138055.68 4992 "838,656" 276756.48 4320 "695,520" 229521.6 4560"738, 720" 236390.4 4800"724,800" 217440 4512 "780,576" 257590.08 4800 "768,000" 245760 4752 1731, 808" 256132.8 4800 "715,200" 228864 4848 "790, 224" 244969.44 5232 "784, 800" 251136 4848":824, 160" 263731.2 4944 781152 242157.12 19080 "2,919, 2401 963349.2 15288 "2,415,504" 724651.2 14508 "2,031, 120" 690580.8 15120 "2, 313, 360" 740275.2 16536 M2, 943, 408" 941890.56 15960 2,729, 1601 873331.2 15288 "2,751, 840" 88058 8.8 18 392 "2, 142, 720" 749952 17004 "2,873, 676" 1005786.6 17808 12, 528, 736" 783908.16 16848 12, 813, 616" 872220.96 12960 2060 640 700617.6 13 14 02-1012 1 02-1012 2 02-1012 3 02-1012 4 02-1012 5 02-1012 6 02-1012 7 02-1012 8 02-1012 9 02-1012 10 02-1012 11 02-1012 12 02-1013 1 02-1013 2. 02-1013 3 02-1013 4 02-1013 5 02-1013 6 02-1013 7 02-1013 8 02-1013 9 02-1013 10 2020 2000 9 2020 2000 8 2020 2000 8 2020 2000 9 2020 2000 9 2020 2000 9 2020 2000 9 2020 2000 9 2020 2000 10 2020 2000 10 2020 2000 10 2020 2000 11 2020 1200 7 2020 1200 7 2020 1200 8 2020 1200 2020 12008 2020 1200 9 2020 12009 2020 12008 2020 12000 2020 1200 9 11448 "1,785,888" 571484.16 9984 "1,467, 648" 440294.4 9696 "1,609,536" 482860.8 10044 "1,647,216" 510636.96 9936 "1,768,608" 601326.72 9828 "1,552, 824" 512431.92 9828 "1,670,760" 517935.6 11880 "2,007,720" 682624.8 13200 "2,296,800" 712008 11280 "1,714,560" 600096 11520 "1,762,560" 581644.8 14124 2344584 703375.2 7728 "1,143,744" 343123.2 8904 "1,362, 312" 449562.96 8928 "1,321, 344" 462470.4 9216 "1, 391,616" 473149.44 8736 "1,432,704" 472792.32 9936 "1,609, 632" 515082.24 11016 "1,751, 544" 595524.96 9216 "1, 299, 456" 428820.48 11124 "1,590,732" 477219.6 9828 "1,444,716" 476756.28 02-1013 11 02-1013 12 02-1014 1 02-1014 2 02-1014 3 02-1014 4 02-1014 5 02-1014 6 02-1014 7 02-1014 8 02-1014 9 02-1014 10 02-1014 11 02-1014 12 02-1015 1 02-1015 2 02-1015 3 02-1015 4 02-10155 02-10156 02-1015 7 02-1015 8 02-1015 02-1015 10 02-1015 11 02-1015 12 02-1016 1 02-1016 2 02-1016 3 02-1016 4 02-1016 5 02-1016 02-1016 7 02-1016 8 02-1016 2020 1200 9 2020 1200 8 2020 1800 12 2020 1800 13 2020 1800 12 2020 1800 13 2020 1800 14 2020 1800 13 2020 1800 13 2020 1800 12 2020 1800 11 2020 1800 10 2020 1800 11 2020 1800 11 2020 29009 2020 2900 10 2020 29009 2020 2900 10 2020 29009 2020 2900 10 2020 290010 2020 2900 10 2020 2900 10 2020 2900 11 2020 2900 10 2020 2900 10 2020 18008 2020 18008 2020 1800 2020 18008 2020 18008 2020 1800 8 2020 1800 2020 1800 7 2020 18008 10476 "1,791,396" 573246.72 8736 1476384 516734.4 13680 "2,421,360" 799048.8 16380 "2,882,880" 1009008 13968 "1,983,456" 634705.92 17160 "2,900,040" 1015014 16800 "2,553, 600" 817152 15912 "2,530,008" 834902.64 15600 "2,776, 800" 916344 15552 "2,659, 392" 797817.6 14388 "2,258,916" 722853.12 11040 "1,622,880" 551779.2 13068 "1,829,520" 622036.8 11880 1912680 612057.6 11124 "1, 668,600" 584010 12000 "1,908,000" 591480 11880 "1,960,200" 686070 12840 "2, 144, 280" 707612.4 11664 "1,796, 256" 538876.8 11880 "1,983,960" 654706.8 12720 "2, 136, 960" 747936 11760 "2, 116, 800" 656208 11760 "1,893,360" 586941.6 13596 "2,338,512" 771708.96 11160 "1,618, 200" 517824 12120 1721040 585153.6 9120"1,331, 520" 439401.6 10272", 509,984" 528494.4 9216 "1,456, 128" 451399.68 9216 "1,428, 480" 457113.6 9600 "1,593, 600" 557760 10176 "1,628, 160" 553574.4 7812 "1, 171, 800" 410130 7896 "1, 334, 424" 440359.92 9696 "1,570, 752" 486933.12 02-1016 9 2020 1800 8 02-1016 10 2020 1800 9 02-1016 11 2020 1800 10 02-1016 12 2020 1800 11 02-1017 1 2020 4000 20 02-1017 2. 2020 4000 18 02-1017 3 2020 4000 19 02-1017 4 2020 4000 19 02-1017 5 2020 4000 17 02-1017 6 2020 4000 16 02-1017 7 2020 4000 15 02-10178 2020 4000 14 02-1017 9 2020 4000 13 02-1017 10 2020 4000 12 02-1017 11 2020 4000 13 02-1017 12 2020 4000 14 06-1000 1 . 2020 2500 14 06-1000 2 2020 2500 13 06-1000 3 2020 2500 12 06-1000 4 2020 2500 13 9696 "1,570,752" 486933.12 10908 "1,930, 716" 579214.8 12480 "1,996, 800" 678912 13992 2322672 743255.04 22800 "4,058, 400" 1217520 21600 "3,650, 400" 1095120 23484 "4,203,636" 1345163.52 24168 "3, 746,040" 1273653.6 21624 "3,849,072" 1308684.48 18432 "3,244,032" 1102970.88 16380 "2,293, 200" 733824 17472 "2,550,912" 892819.2 17004 "2,584,608" 878766.72 13824 "2,294,784" 757278.72 15912 "2,354,976" 824241.6 16128 2548224 840913.92 0 109018 0 128869 77424 134004 TI 0 0 5 6 7. 8 9 10 11 12 1 2 3 4. 11 7 06-1000 06-1000 06-1000 06-1000 06-1000 06-1000 06-1000 06-1000 06-1001 06-1001 06-1001 06-1001 06-1001 06-1001 06-1001 06-1001 06-1001 06-1001 06-1001 06-1001 06-1002 06-1002 06-1002 06-1002 06-1002 06-1002 06-1002 06-1002 06-1002 06-1002 06-1002 06-1002 06-1003 06-1003 06-1000 2020 2500 14 0 2020 2500 14 0 2020 2500 14 0 2020 2500 14 0 2020 2500 13 0 2020 2500 13 0 2020 2500 14 2020 2500 13 40 2020 2000 5 0 2020 2000 5 0 2020 2000 5 0 2020 2000 5 2020 2000 5 0 2020 2000 5 0 2020 2000 5 2020 2000 5 2020 2000 50 2020 2000 6 0 2020 2000 6 2020 2000 6 2020 3500 20 2020 3500 20 2020 3500 20 2020 3500 20 2020 3500 20 2020 3500 19 2020 350019 2020 3500 20 2020 3500 22 0 2020 3500 20 0 2020 3500 22 2020 3500 24 2020 3000 12 D 2020 3000 12 2020 3000 12 9 10 11 12 1 2 3 4 5 6 7 8 75726 74886 87808 151830 74152 141024 84896 125385 48930 27120 29895 52135 50585 43975 38925 29005 29830 58842 66708 66054 112840 116940 228780 168900 217320 138738 123595 144440 189772 179060 207746 156432 100704 92208 79560 10 2 3 0 0 0 0 0 0 0 06-1003 06-1003 06-1003 06-1003 06-1003 06-1003 06-1003 06-1003 06-1003 06-1003 06-1004 06-1004 06-1004 06-1004 06-1004 06-1004 06-1004 06-1004 06-1004 06-1004 c) turn o r- co o o o o o o un co co on H 2020 3000 12 2020 3000 12 2020 3000 12 2020 3000 11 2020 3000 12 2020 3000 13 2020 3000 14 2020 3000 15 2020 3000 16 2020 3000 15 2020 3500 30 2020 3500 31 2020 3500 32 2020 3500 32 2020 3500 33 2020 3500 34 2020 3500 37 2020 3500 34 2020 3500 36 2020 4500 39 79560 107184 122352 101695 63072 149032 105098 169005 95856 105795 326040 368404 339040 242176 230736 406334 386317 293930 324396 415311 0 0 0 - 06-1004 06-1004 11 12 2020 4500 35 2020 4500 33 90 286650 190938 1 Allocating Shared Costs: Assume that you are a cost accountant at Basic Hospital. You have received the following e-mail. From: The Controller@Basic Hospital.com To: CostAccountant@Basic Hospital.com Hello! In the past we have used the direct method to allocate service department costs to our revenue producing departments; however, I just attended a conference where one of the presenters demonstrated how the step method can produce significantly different departmental cost calculations. I don't know how much it would matter at Basic if we used the step down method, but this person at the conference had me convinced that it could matter quite a bit. As soon as I got back from the conference I got into the system and downloaded the attached summary reports (tab delimited) needed to allocate costs from supporting departments to the producing departments for 2020. Please put together a report that shows the allocation using each method (direct and step) as well as a table that shows the differences (totals and as a percentage of support dept. cost) across the two allocation methods. For the step method, let's first allocate the departments that provide the most service to other support departments. Also, let's use the 12 month average of FTEs and square footage for assignment where applicable. Otherwise use the annual totals. Finally, please show me the differences for each department manager, as I'd like to know who will be affected the most if we switch to the step method Thank you cost accountant! The Controller Upload the following files to complete this assignment: (1) A Microsoft Excel Workbook named "allocation". The workbook should have 3 worksheets labeled "Direct "Step" and "Differences. The worksheets will contain the schedules used to allocate the cost from the support departments to the producing departments in the first two worksheets. In the third worksheet, summarize the differences between the two methods by department and manager. In addition, the workbook will also have one or more additional worksheets that are used to hold the source data (ie, the information in the files attached to this assignment) and perform interim calculations. Name worksheets that hold source data "sourcedata1," "sourcedata2" and "sourcedata3Worksheets that contain interim calculations should be named "calc1," "calc2" and so on. The worksheets should be organized in the following order. Direct, Step, Differences, calc worksheets, sourcedata worksheets (2) A PDF report that incorporates all 3 tables from the "Direct: "Step," and "Differences worksheets (in this order). After each allocation schedule, provide a written description of the schedule that explains the allocation technique and how it is applied at Basic Hospital to arrive at cost by department. After the "Differences" table, explain why the differences occur, using the department with the biggest difference as an example, Department Dpt Current Dept. Manager Medical Records 06-1000 Cohen Accounting 06-1001 Dillon General Services 06-1002 Blasco Human Resources 06-1003 Smith Patient Accounts 06-1004 Cohen Urology 02-1005 Kline Orthopaedics 02-1006 Dreyfus Opthamology 02-1007 Kramer Oncology 02-1008 James Obstetrics 02-1009 Plammot Neurology 02-1010 Barnes Maternity 02-1011 Plammot Intensive Care Unit 02-1012 Wellston General Surgery 02-1013 Piedmont Gastroenterology 02-1014 Rax Cardiology 02-1015 Jills Burn Center 02-1016 Cordona Emergency 02-1017 Jackson Support Dept. Allocation base Medical Records Total Nursing Hours Accounting Total Direct Cost General Services Square Footage Human Resources Total FTES Patient Accounts Total Patient Revenue Dpt Month Year sq. footage FTEs Nursing Hours Total Patient Revenue Direct Cost 02-1005 1 2020 2400 6 7344 "1,285,200" 424116 02-1005 2 2020 2400 7 7812 "1,210, 860" 423801 02-1005 3 2020 24007 8064 "1,177,344" 376750.08 02-1005 2020 2400 6 7488 "1,063,296" 340254.72 02-1005 5 2020 2400 5 5820 "931, 200" 307296 02-1005 6 2020 2400 5 6480 "1, 121,040" 358732.8 02-1005 7 2020 2400 5 6360"909, 480" 281938.8 02-1005 8 2020 2400 5 6600"970, 200" 339570 02-1005 9 2020 2400 5 5940"968, 220" 300148.2 02-1005 2020 2400 5 5760 "1,013, 760" 314265.6 02-1005 11 2020 2400 5 5640"908, 040" 299653.2 02-1005 12 2020 2400 5 6000 "852,000" 289680 02-1006 1 2020 1800 5 6540"987,540" 335763.6 02-1006 2 2020 1800 5 5880 1981, 960" 324046.8 02-1006 3 2020 1800 5 6240 "1,029, 600" 308880 02-1006 4 2020 1800 5 5820 "820, 620" 287217 02-1006 5 2020 1800 5 6240 "923, 520" 286291.2 02-1006 6 2020 18005 6360"979, 440" 333009.6 02-1006 7 2020 18005 6420 "1,020,780" 316441.8 02-1006 8 2020 18005 6600 1,016, 400" 355740 02-1006 9 2020 1800 5 6480 1,017,360" 345902.4 02-1006 10 2020 1800 5 5580"864,9001 268119 02-1006 11 2020 1800 5 6540 "1, 111,800" 355776 02-1006 12 2020 1800 5 6240886, 0801 283545.6 02-1007 1 2020 1500 4464 1736, 560" 235699.2 02-1007 2 2020 2500 4 4320 "604,800 187488 02-1007 13 2020 1500 4 4992 "698,880 244608 02-1007 4 2020 1500 4 4560"779,760 272916 02-1007 5 2020 1500 4 4846"732, 048" 234255.36 02-1007 6 2020 2500 4 5088 "890, 400" 302736 02-1007 2020 2500 4 4896 "856, 800" 257040 02-1007 2020 1500 4 5280 "855,360" 282268.8 co 02-1006 9 02-1006 10 02-1006 11 02-1006 12 02-1007 02-1007 02-1007 3 02-10074 02-1007 5 02-1007 02-1007 02-1007 02-1007 02-1007 10 02-1007 11 02-1007 12 02-1008 02-1008 02-1008 02-1008 02-1008 02-1008 6 02-1008 7 02-1008 8 02-1008 9 02-1008 10 02-1008 11 02-1000 112 02-1009 1 02-1009 2 02-1009 3 02-1009 4 2020 1800 5 2020 1800 5 2020 1800 5 2020 1800 5 2020 15004 2020 1500 4 2020 1500 4 2020 1500 4 2020 15004 2020 1500 4 2020 1500 4 2020 15004 2020 1500 4 2020 15004 2020 15004 2020 1500 4 2020 25009 2020 2500 8 2020 2500 8 2020 2500 9 2020 25009 2020 2500 9 2020 2500 101 2020 2500 2020 2500 9 2020 2500 2020 25008 2020 2500 8 2020 3300 2 2020 3300 2 2020 3300 2 2020 3300 2 6480 "1,017,360" 345902.4 5580"864,900" 268119 6540"1,111, 800" 355776 6240"886,080" 283545.6 4464"736,560" 235699.2 4320"604,800" 187488 4992 "698, 880" 244608 4560"779,760" 272916 4848"732,048" 234255.36 5088 1890, 400" 302736 4896 1856, 800" 257040 5280"855,360" 282268.8 4656 "824, 112" 280198.08 4944 "791, 040" 268953.6 4992 1743, 808" 245456.64 5232 805728 249775.68 10908 "1, 614,384" 532746.72 8736 "1,380, 288" 469297.92 8640 ",442, 880" 476150.4 9936 "1,530, 144" 474344.64 11772 , 648,080" 527385.6 10476 "1, 676, 160" 586656 11040 1,633,920" 522854.4 10044 91,596, 996 511038.72 1124 1,579,608 537066.72 9696 "1,502, 880M 526008 9600 "1, 430, 400486336 9984 1557504 529551.36 2852 W395, 136 122492.16 2328 "372) 480" 122918.4 2232 "377, 208" 116934.48 2352"423) 360" 135475.2 9 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 02-1009 02-1009 02-1009 02-1009 02-1009 02-1009 02-1009 02-1009 02-1010 02-1010 02-1010 02-1010 02-1010 02-1010 02-1010 02-1010 02-1010 02-1010 02-1010 02-1010 02-1011 02-1011 02-1011 02-1011 02-1011 02-1011 02-1011 02-1011 02-1011 02-1011 02-1011 02-1011 2020 3300 2 2020 3300 2 2020 3300 2 2020 3300 2 2020 3300 2 2020 3300 2 2020 3300 2 2020 3300 2 2020 1300 4 2020 13004 2020 1300 4 2020 1300 4 2020 13004 2020 1300 4 2020 1300 4 2020 1300 4 2020 1300 4 2020 1300 4 2020 1300 4 2020 1300 4 2020 4000 15 2020 4000 14 20204000 13 2020 4000 14 2020 4000 2020 4000 2020 4000 13 2020 4000 12 2020 4000 13 2020 4000 14 2020 4000 13 2020 4000 12 2424 387,840" 131865.6 2160 "341, 280" 102384 2568 "428,856" 150099.6 2592 "417, 312" 137712.96 2520 "385,560" 131090.4 2376 "406,296" 121888.8 2640"401,280" 132422.4 2568 431424 138055.68 4992 "838,656" 276756.48 4320 "695,520" 229521.6 4560"738, 720" 236390.4 4800"724,800" 217440 4512 "780,576" 257590.08 4800 "768,000" 245760 4752 1731, 808" 256132.8 4800 "715,200" 228864 4848 "790, 224" 244969.44 5232 "784, 800" 251136 4848":824, 160" 263731.2 4944 781152 242157.12 19080 "2,919, 2401 963349.2 15288 "2,415,504" 724651.2 14508 "2,031, 120" 690580.8 15120 "2, 313, 360" 740275.2 16536 M2, 943, 408" 941890.56 15960 2,729, 1601 873331.2 15288 "2,751, 840" 88058 8.8 18 392 "2, 142, 720" 749952 17004 "2,873, 676" 1005786.6 17808 12, 528, 736" 783908.16 16848 12, 813, 616" 872220.96 12960 2060 640 700617.6 13 14 02-1012 1 02-1012 2 02-1012 3 02-1012 4 02-1012 5 02-1012 6 02-1012 7 02-1012 8 02-1012 9 02-1012 10 02-1012 11 02-1012 12 02-1013 1 02-1013 2. 02-1013 3 02-1013 4 02-1013 5 02-1013 6 02-1013 7 02-1013 8 02-1013 9 02-1013 10 2020 2000 9 2020 2000 8 2020 2000 8 2020 2000 9 2020 2000 9 2020 2000 9 2020 2000 9 2020 2000 9 2020 2000 10 2020 2000 10 2020 2000 10 2020 2000 11 2020 1200 7 2020 1200 7 2020 1200 8 2020 1200 2020 12008 2020 1200 9 2020 12009 2020 12008 2020 12000 2020 1200 9 11448 "1,785,888" 571484.16 9984 "1,467, 648" 440294.4 9696 "1,609,536" 482860.8 10044 "1,647,216" 510636.96 9936 "1,768,608" 601326.72 9828 "1,552, 824" 512431.92 9828 "1,670,760" 517935.6 11880 "2,007,720" 682624.8 13200 "2,296,800" 712008 11280 "1,714,560" 600096 11520 "1,762,560" 581644.8 14124 2344584 703375.2 7728 "1,143,744" 343123.2 8904 "1,362, 312" 449562.96 8928 "1,321, 344" 462470.4 9216 "1, 391,616" 473149.44 8736 "1,432,704" 472792.32 9936 "1,609, 632" 515082.24 11016 "1,751, 544" 595524.96 9216 "1, 299, 456" 428820.48 11124 "1,590,732" 477219.6 9828 "1,444,716" 476756.28 02-1013 11 02-1013 12 02-1014 1 02-1014 2 02-1014 3 02-1014 4 02-1014 5 02-1014 6 02-1014 7 02-1014 8 02-1014 9 02-1014 10 02-1014 11 02-1014 12 02-1015 1 02-1015 2 02-1015 3 02-1015 4 02-10155 02-10156 02-1015 7 02-1015 8 02-1015 02-1015 10 02-1015 11 02-1015 12 02-1016 1 02-1016 2 02-1016 3 02-1016 4 02-1016 5 02-1016 02-1016 7 02-1016 8 02-1016 2020 1200 9 2020 1200 8 2020 1800 12 2020 1800 13 2020 1800 12 2020 1800 13 2020 1800 14 2020 1800 13 2020 1800 13 2020 1800 12 2020 1800 11 2020 1800 10 2020 1800 11 2020 1800 11 2020 29009 2020 2900 10 2020 29009 2020 2900 10 2020 29009 2020 2900 10 2020 290010 2020 2900 10 2020 2900 10 2020 2900 11 2020 2900 10 2020 2900 10 2020 18008 2020 18008 2020 1800 2020 18008 2020 18008 2020 1800 8 2020 1800 2020 1800 7 2020 18008 10476 "1,791,396" 573246.72 8736 1476384 516734.4 13680 "2,421,360" 799048.8 16380 "2,882,880" 1009008 13968 "1,983,456" 634705.92 17160 "2,900,040" 1015014 16800 "2,553, 600" 817152 15912 "2,530,008" 834902.64 15600 "2,776, 800" 916344 15552 "2,659, 392" 797817.6 14388 "2,258,916" 722853.12 11040 "1,622,880" 551779.2 13068 "1,829,520" 622036.8 11880 1912680 612057.6 11124 "1, 668,600" 584010 12000 "1,908,000" 591480 11880 "1,960,200" 686070 12840 "2, 144, 280" 707612.4 11664 "1,796, 256" 538876.8 11880 "1,983,960" 654706.8 12720 "2, 136, 960" 747936 11760 "2, 116, 800" 656208 11760 "1,893,360" 586941.6 13596 "2,338,512" 771708.96 11160 "1,618, 200" 517824 12120 1721040 585153.6 9120"1,331, 520" 439401.6 10272", 509,984" 528494.4 9216 "1,456, 128" 451399.68 9216 "1,428, 480" 457113.6 9600 "1,593, 600" 557760 10176 "1,628, 160" 553574.4 7812 "1, 171, 800" 410130 7896 "1, 334, 424" 440359.92 9696 "1,570, 752" 486933.12 02-1016 9 2020 1800 8 02-1016 10 2020 1800 9 02-1016 11 2020 1800 10 02-1016 12 2020 1800 11 02-1017 1 2020 4000 20 02-1017 2. 2020 4000 18 02-1017 3 2020 4000 19 02-1017 4 2020 4000 19 02-1017 5 2020 4000 17 02-1017 6 2020 4000 16 02-1017 7 2020 4000 15 02-10178 2020 4000 14 02-1017 9 2020 4000 13 02-1017 10 2020 4000 12 02-1017 11 2020 4000 13 02-1017 12 2020 4000 14 06-1000 1 . 2020 2500 14 06-1000 2 2020 2500 13 06-1000 3 2020 2500 12 06-1000 4 2020 2500 13 9696 "1,570,752" 486933.12 10908 "1,930, 716" 579214.8 12480 "1,996, 800" 678912 13992 2322672 743255.04 22800 "4,058, 400" 1217520 21600 "3,650, 400" 1095120 23484 "4,203,636" 1345163.52 24168 "3, 746,040" 1273653.6 21624 "3,849,072" 1308684.48 18432 "3,244,032" 1102970.88 16380 "2,293, 200" 733824 17472 "2,550,912" 892819.2 17004 "2,584,608" 878766.72 13824 "2,294,784" 757278.72 15912 "2,354,976" 824241.6 16128 2548224 840913.92 0 109018 0 128869 77424 134004 TI 0 0 5 6 7. 8 9 10 11 12 1 2 3 4. 11 7 06-1000 06-1000 06-1000 06-1000 06-1000 06-1000 06-1000 06-1000 06-1001 06-1001 06-1001 06-1001 06-1001 06-1001 06-1001 06-1001 06-1001 06-1001 06-1001 06-1001 06-1002 06-1002 06-1002 06-1002 06-1002 06-1002 06-1002 06-1002 06-1002 06-1002 06-1002 06-1002 06-1003 06-1003 06-1000 2020 2500 14 0 2020 2500 14 0 2020 2500 14 0 2020 2500 14 0 2020 2500 13 0 2020 2500 13 0 2020 2500 14 2020 2500 13 40 2020 2000 5 0 2020 2000 5 0 2020 2000 5 0 2020 2000 5 2020 2000 5 0 2020 2000 5 0 2020 2000 5 2020 2000 5 2020 2000 50 2020 2000 6 0 2020 2000 6 2020 2000 6 2020 3500 20 2020 3500 20 2020 3500 20 2020 3500 20 2020 3500 20 2020 3500 19 2020 350019 2020 3500 20 2020 3500 22 0 2020 3500 20 0 2020 3500 22 2020 3500 24 2020 3000 12 D 2020 3000 12 2020 3000 12 9 10 11 12 1 2 3 4 5 6 7 8 75726 74886 87808 151830 74152 141024 84896 125385 48930 27120 29895 52135 50585 43975 38925 29005 29830 58842 66708 66054 112840 116940 228780 168900 217320 138738 123595 144440 189772 179060 207746 156432 100704 92208 79560 10 2 3 0 0 0 0 0 0 0 06-1003 06-1003 06-1003 06-1003 06-1003 06-1003 06-1003 06-1003 06-1003 06-1003 06-1004 06-1004 06-1004 06-1004 06-1004 06-1004 06-1004 06-1004 06-1004 06-1004 c) turn o r- co o o o o o o un co co on H 2020 3000 12 2020 3000 12 2020 3000 12 2020 3000 11 2020 3000 12 2020 3000 13 2020 3000 14 2020 3000 15 2020 3000 16 2020 3000 15 2020 3500 30 2020 3500 31 2020 3500 32 2020 3500 32 2020 3500 33 2020 3500 34 2020 3500 37 2020 3500 34 2020 3500 36 2020 4500 39 79560 107184 122352 101695 63072 149032 105098 169005 95856 105795 326040 368404 339040 242176 230736 406334 386317 293930 324396 415311 0 0 0 - 06-1004 06-1004 11 12 2020 4500 35 2020 4500 33 90 286650 190938 1

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!