Determine what shipping number\'s (items) have a replacement cost LESS than cost

Question

Determine what shipping number's (items) have a replacement cost LESS than cost. Add a column and calculate the amount each of those items that should be written down. Replacement Cost is on a per unit basis. To calculate the write down to replacement cost you need to use both the per unit amounts and the inventory quantity. (using Excel or any auditing software like ACL)

SHIPPING NUMBER LAST SALE NUMBER SOLD UNIT COST INVENTORY QUANTITY SELLING PRICE REPLACEMENT COST EXTENDED COST FB102 1/29/2009 10 121.93 0 196.00 0.00 0.00 FB103 3/31/2009 463 148.18 3 223.00 0.00 444.54 FB104 12/29/2009 71 152.51 13 228.00 0.00 1982.63 FB105 8/27/2009 176 292.49 23 460.00 0.00 6727.27 FB106 12/29/2009 343 289.01 145 457.00 0.00 41906.45 FB107 12/30/2009 252 263.09 39 429.00 0.00 10260.51 FB110 12/27/2009 292 362.83 14 590.00 0.00 5079.62 FB111 12/30/2009 134 341.45 121 568.00 0.00 41315.45 FB112 12/30/2009 77 367.70 62 595.00 0.00 22797.40 FB113 12/30/2009 454 447.13 73 638.00 0.00 32640.49 FB114 12/30/2009 517 441.78 9 633.00 0.00 3976.02 FB115 12/31/2009 396 410.38 128 604.00 0.00 52528.64 FJ310 4/29/2009 5 2170.63 3 2430.00 0.00 6511.89 FJ311 5/28/2009 0 2220.37 11 2430.00 0.00 24424.07 FJ312 7/28/2009 3 2215.79 8 2430.00 0.00 17726.32 FJ313 9/30/2009 10 2205.00 19 2430.00 0.00 41895.00 FJ320 5/26/2009 102 3742.82 1 6103.00 0.00 3742.82 FJ321 6/27/2009 34 3841.48 4 6193.00 0.00 15365.92 FJ322 7/27/2009 358 3784.82 4 6149.00 0.00 15139.28 FJ323 12/29/2009 146 3780.12 6 6149.00 0.00 22680.72 FJ330 5/26/2009 333 4804.40 11 7546.00 0.00 52848.40 FJ331 7/31/2009 397 4721.45 8 7462.00 0.00 37771.60 FJ332 8/26/2009 296 4777.79 24 7524.00 0.00 114666.96 FJ333 8/26/2009 25 4767.39 2 7513.00 0.00 9534.78 FM201 2/26/2009 195 2316.29 3 3640.00 0.00 6948.87 FM202 9/27/2009 126 2401.82 9 3640.00 0.00 21616.38 FM203 12/27/2009 135 2389.41 8 3640.00 0.00 19115.28 FM210 12/28/2009 82 2772.81 39 4488.00 0.00 108139.59 FM211 12/26/2009 26 2756.30 0 4472.00 0.00 0.00 FM212 12/29/2009 342 2727.30 37 4437.00 0.00 100910.10 FM220 12/28/2009 529 3274.61 37 5324.00 0.00 121160.57 FM221 12/29/2009 489 3171.33 175 5225.00 0.00 554982.75 FM222 12/30/2009 407 3260.78 1 5313.00 0.00 3260.78 FM230 12/27/2009 438 3653.55 54 5720.00 0.00 197291.70 FM231 12/30/2009 22 3567.77 73 5610.00 0.00 260447.21 FM232 12/31/2009 29 3682.16 86 5731.00 0.00 316665.76 FM250 12/27/2009 426 5173.13 141 8525.00 0.00 729411.33 FM251 12/27/2009 375 5261.64 161 8635.00 0.00 847124.04 FM252 12/27/2009 461 5245.38 43 8619.00 0.00 225551.34 FT470 12/26/2009 327 1807.17 119 2838.00 0.00 215053.23 FT471 12/27/2009 479 1856.93 14 2893.00 0.00 25997.02 FT472 12/28/2009 418 1879.10 18 2915.00 0.00 33823.80 FT473 12/30/2009 354 1856.93 20 2893.00 0.00 37138.60 FT480 12/27/2009 66 2695.40 59 4290.00 0.00 159028.60 FT481 12/28/2009 25 2740.50 4 4340.00 0.00 10962.00 FT482 12/28/2009 407 2769.43 13 4367.00 0.00 36002.59 FT483 12/29/2009 357 2740.50 130 4340.00 0.00 356265.00 FT490 10/29/2009 412 4515.53 10 6578.00 0.00 45155.30 FT491 12/29/2009 361 4120.86 21 6496.00 0.00 86538.06 FT492 12/29/2009 353 4535.72 74 6600.00 0.00 335643.28 FT493 12/31/2009 491 4535.72 2 6600.00 0.00 9071.44 R102000 11/14/2009 81 71.64 17 78.52 1217.88 R102100 10/4/2009 868 118.21 19 119.33 2245.99 R102400 11/14/2009 513 104.29 128 105.28 13349.12 R102600 12/29/2009 1040 128.70 88 135.83 11325.60 R104400 11/26/2009 642 103.66 69 104.64 7152.54 R105600 10/14/2009 672 208.41 124 210.40 25842.84 R110300 12/18/2009 968 190.71 19 192.53 3623.49 R110600 12/15/2009 742 683.52 72 690.03 49213.44 R11200 12/3/2009 797 200.08 15 201.98 3001.20 R114200 11/1/2009 162 822.18 10 830.01 8221.80 R119600 11/4/2009 461 106.42 171 107.43 18197.82 R121700 11/28/2009 377 128.29 73 129.51 9365.17 R123900 10/17/2009 460 50.69 19 53.95 963.11 R126100 12/6/2009 329 33.29 67 33.60 2230.43 R126200 10/30/2009 542 946.20 58 955.21 54879.60 R129800 7/31/2009 407 72.38 153 73.07 11074.14 R137300 10/20/2009 172 785.19 79 792.67 62030.01 R137600 10/15/2009 823 165.77 176 167.35 29175.52 R144600 10/4/2009 447 67.11 85 67.74 5704.35 R146400 11/6/2009 249 723.00 42 729.88 30366.00 R151000 10/20/2009 526 413.36 121 417.30 50016.56 R151700 12/26/2009 914 186.07 12 187.84 2232.84 R151800 12/28/2008 0 145.11 27 146.49 3917.97 R152300 10/29/2009 916 19.39 34 19.58 659.26 R153100 10/17/2009 760 8.45 41 8.53 346.45 R15800 2/26/2009 0 150.87 19 152.31 2866.53 R158300 11/19/2009 200 936.41 89 945.33 83340.49 R160400 12/22/2009 302 304.36 15 307.26 4565.40 R162600 10/29/2009 29 37.80 4 38.04 151.20 R163600 10/6/2009 450 29.40 26 31.51 764.40 R163700 11/27/2009 29 11.55 0 13.01 0.00 R167500 10/23/2009 89 29.40 21 29.66 617.40 R167800 12/24/2008 0 29.40 63 29.91 1852.20 R168100 11/1/2009 684 21.00 180 21.45 3780.00 R168800 7/28/2009 1040 25.20 146 25.03 3679.20 R169100 10/28/2009 479 33.60 63 33.62 2116.80 R171900 11/8/2009 125 17.85 0 19.28 0.00 R173000 12/8/2009 933 34.65 13 35.43 450.45 R173600 10/15/2009 766 24.15 298 24.62 7196.70 R173800 5/28/2009 353 48.30 144 49.03 6955.20 R174800 6/27/2009 134 6.30 64 6.66 403.20 R175900 11/14/2009 1044 38.85 46 39.18 1787.10 R182300 12/6/2009 793 33.60 58 36.49 1948.80 R182800 12/16/2008 0 42.00 89 44.69 3738.00 R189200 10/15/2009 876 51.45 66 51.80 3395.70 R189400 12/9/2009 192 8.40 1 8.45 8.40 R190900 11/15/2009 439 23.10 25 24.90 577.50 R191100 11/6/2009 501 50.40 7 51.16 352.80 R192900 11/27/2009 849 5.25 47 5.05 246.75 R195900 11/16/2009 654 23.10 121 24.94 2795.10 R196300 10/27/2009 672 40.95 2 41.42 81.90 R197900 11/25/2009 172 11.55 14 11.86 161.70 R19900 10/20/2009 935 93.82 28 97.73 2626.96 R201100 11/24/2009 1018 3.15 36 3.95 113.40 R201300 12/11/2009 115 37.80 52 38.20 1965.60 R202600 10/28/2009 855 1.05 183 1.30 192.15 R206300 11/14/2009 37 12.60 3 12.75 37.80 R20900 12/2/2009 994 430.24 6 443.63 2581.44 R210700 5/26/2009 252 40.95 8 41.75 327.60 R210800 11/29/2008 0 11.55 18 11.56 207.90 R211100 10/14/2009 727 39.90 229 40.04 9137.10 R211300 10/20/2009 35 13.65 4 13.99 54.60 R211600 12/6/2009 984 32.55 397 33.23 12922.35 R212000 10/7/2009 617 34.65 45 35.18 1559.25 R21600 12/12/2009 541 150.64 55 163.71 8285.20 R216800 12/7/2008 0 30.45 1 31.14 30.45 R221300 11/2/2009 762 43.05 241 47.68 10375.05 R222800 12/31/2009 357 35.70 85 35.88 3034.50 R227800 5/26/2009 517 1.05 38 0.68 39.90 R228500 11/23/2009 358 47.25 59 47.25 2787.75 R230600 10/31/2009 932 51.45 3 53.65 154.35 R230700 11/5/2009 210 42.00 2 43.35 84.00 R233400 10/20/2009 700 3.15 113 3.53 355.95 R234700 10/8/2009 155 50.40 1 52.17 50.40 R235400 12/6/2009 693 2.10 278 2.34 583.80 R236600 10/18/2009 5 10.50 0 10.71 0.00 R239800 11/28/2008 0 35.70 60 37.73 2142.00 R240500 11/19/2009 37 29.40 15 29.85 441.00 R241200 10/16/2009 486 3.15 25 2.89 78.75 R247400 11/15/2009 579 38.85 114 39.54 4428.90 R247700 11/5/2009 417 50.40 64 50.55 3225.60 R249900 12/29/2009 173 8.40 0 8.98 0.00 R250000 10/27/2009 95 44.10 7 45.03 308.70 R250100 11/17/2009 106 23.10 1 24.26 23.10 R250600 11/25/2009 38 43.05 9 43.44 387.45 R250800 12/29/2009 454 31.50 8 31.97 252.00 R251900 10/5/2009 100 24.15 29 24.25 700.35 R256100 10/9/2009 1 38.85 0 39.04 0.00 R258500 11/28/2009 37 29.40 19 29.16 558.60 R26100 11/27/2009 674 65.87 39 66.49 2568.93 R261200 10/19/2009 82 28.35 3 28.22 85.05 R263200 12/31/2009 13 7.35 1 7.13 7.35 R263400 12/1/2009 1 15.75 0 17.19 0.00 R265600 10/12/2009 47 13.65 18 13.38 245.70 R270900 12/1/2009 106 26.25 6 26.35 157.50 R272100 10/17/2009 25 5.25 3 5.14 15.75 R275600 12/27/2009 17 50.40 6 56.01 302.40 R275700 10/27/2009 78 43.05 6 43.83 258.30 R276900 11/17/2009 54 44.10 4 44.89 176.40 R277800 8/26/2009 354 14.70 10 15.19 147.00 R278500 11/19/2009 70 48.30 1 50.56 48.30 R280100 11/19/2009 15 11.55 1 11.46 11.55 R281900 12/25/2009 104 1.05 11 0.53 11.55 R282300 12/19/2009 72 44.10 2 45.02 88.20 R286000 12/22/2009 24 40.95 1 41.24 40.95 R291700 12/10/2009 59 36.75 2 37.20 73.50 R299000 12/9/2009 61 45.15 6 45.68 270.90 R30100 10/13/2009 142 249.12 55 252.99 13701.60 R31900 12/5/2009 585 89.07 23 97.16 2048.61 R33600 10/10/2009 257 709.89 24 747.14 17037.36 R33900 12/26/2009 497 475.59 19 480.12 9036.21 R35700 11/21/2009 947 136.79 46 138.10 6292.34 R36000 10/15/2009 670 17.44 47 18.83 819.68 R37200 10/12/2009 290 29.07 1 29.35 29.07 R37600 10/30/2009 932 163.82 74 165.38 12122.68 R38000 10/15/2009 991 42.49 25 43.29 1062.25 R3900 10/7/2009 315 182.05 25 195.20 4551.25 R39800 4/29/2009 361 647.20 1 697.78 647.20 R44700 12/22/2009 743 69.48 4 70.14 277.92 R46900 11/20/2009 954 617.85 364 375.98 224897.40 R47300 11/30/2009 448 417.63 32 411.64 13364.16 R49700 12/11/2009 663 179.22 267 180.93 47851.74 R50500 10/12/2009 931 324.46 310 327.55 100582.60 R59200 11/2/2009 831 7.53 205 7.60 1543.65 R59600 12/30/2009 519 44.10 23 41.67 1014.30 R65800 7/27/2009 77 53.38 20 53.66 1067.60 R66100 12/25/2009 702 60.24 12 59.68 722.88 R69000 12/22/2009 454 89.71 61 90.57 5472.31 R69400 10/18/2009 403 138.18 103 138.69 14232.54 R71500 10/15/2009 488 778.24 164 785.65 127631.36 R73100 11/25/2009 115 7.91 24 7.44 189.84 R73200 12/13/2009 108 243.24 39 245.56 9486.36 R75200 12/21/2009 25 33.93 11 32.71 373.23 R77700 11/16/2009 52 105.16 1 97.37 105.16 R78400 10/19/2009 2 441.49 1 416.32 441.49 R78600 11/30/2009 307 1046.99 79 1029.71 82712.21 R79400 11/10/2009 164 135.32 64 130.40 8660.48 R800 9/30/2009 173 150.14 29 152.11 4354.06 R80500 10/17/2009 426 48.88 89 49.34 4350.32 R80700 11/20/2009 350 117.27 35 118.39 4104.45 R81100 12/3/2009 124 112.22 7 117.28 785.54 R81300 10/6/2009 204 173.62 75 175.27 13021.50 R82800 8/26/2009 22 140.07 75 141.40 10505.25 R83400 11/8/2009 37 150.18 0 151.61 0.00 R90300 11/21/2009 1023 262.91 11 265.41 2892.01 R91100 11/21/2009 475 10.89 196 11.12 2134.44 R93600 12/25/2009 945 177.61 100 179.30 17761.00 R9400 10/24/2009 293 196.46 30 198.33 5893.80 R94600 10/9/2009 477 102.24 36 103.21 3680.64 R96600 11/2/2009 846 891.36 11 899.84 9804.96 R99900 12/31/2009 708 520.66 8 525.62 4165.28 WB102 4/24/2009 0 0.00 0 0.00 0.00 WB105 11/22/2009 0 151.20 220 0.00 33264.00 WB110 12/31/2009 0 103.95 165 0.00 17151.75 WB112 12/27/2009 0 154.35 165 0.00 25467.75 WJ310 6/28/2009 0 0.00 0 0.00 0.00 WJ320 6/5/2009 0 0.00 0 0.00 0.00 WJ330 6/11/2009 0 0.00 0 0.00 0.00 WM201 6/24/2009 0 0.00 0 0.00 0.00 WM210 11/21/2009 0 1739.85 55 0.00 95691.75 WM220 12/11/2009 0 1282.05 110 0.00 141025.50 WM230 12/6/2009 0 1856.40 385 0.00 714714.00 WM250 12/15/2009 0 577.50 55 0.00 31762.50 WT470 11/15/2009 0 1547.70 11 0.00 17024.70 WT480 12/23/2009 0 370.65 55 0.00 20385.75 WT490 12/1/2009 0 2682.75 66 0.00 177061.50

Explanation / Answer

SHIPPING NUMBER

Following items are having replacement costs lower than cost and need adjustment

SHIPPING NUMBER

LAST SALE NUMBER SOLD UNIT COST INVENTORY QUANTITY SELLING PRICE REPLACEMENT COST EXTENDED COST Write down per unit to adjust the cost to replacement cost Total Write down required for each item R168800 7/28/2009 1040 25.2 146 25.03 3679.2 -0.17 -24.82 R192900 11/27/2009 849 5.25 47 5.05 246.75 -0.2 -9.4 R227800 5/26/2009 517 1.05 38 0.68 39.9 -0.37 -14.06 R241200 10/16/2009 486 3.15 25 2.89 78.75 -0.26 -6.5 R258500 11/28/2009 37 29.4 19 29.16 558.6 -0.24 -4.56 R261200 10/19/2009 82 28.35 3 28.22 85.05 -0.13 -0.39 R263200 12/31/2009 13 7.35 1 7.13 7.35 -0.22 -0.22 R265600 10/12/2009 47 13.65 18 13.38 245.7 -0.27 -4.86 R272100 10/17/2009 25 5.25 3 5.14 15.75 -0.11 -0.33 R280100 11/19/2009 15 11.55 1 11.46 11.55 -0.09 -0.09 R281900 12/25/2009 104 1.05 11 0.53 11.55 -0.52 -5.72 R46900 11/20/2009 954 617.85 364 375.98 224897.4 -241.87 -88040.68 R47300 11/30/2009 448 417.63 32 411.64 13364.16 -5.99 -191.68 R59600 12/30/2009 519 44.1 23 41.67 1014.3 -2.43 -55.89 R66100 12/25/2009 702 60.24 12 59.68 722.88 -0.56 -6.72 R73100 11/25/2009 115 7.91 24 7.44 189.84 -0.47 -11.28 R75200 12/21/2009 25 33.93 11 32.71 373.23 -1.22 -13.42 R77700 11/16/2009 52 105.16 1 97.37 105.16 -7.79 -7.79 R78400 10/19/2009 2 441.49 1 416.32 441.49 -25.17 -25.17 R78600 11/30/2009 307 1046.99 79 1029.71 82712.21 -17.28 -1365.12 R79400 11/10/2009 164 135.32 64 130.4 8660.48 -4.92 -314.88 Total write down required for 21 items to adjust from cost to replacement cost         (90,104)

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.