UNIT_SELLING PRICE_LAST_S PRODUCT# QTY_ON_HAND UNIT_COST DATE_LAST_SALE ALE 2197 33 38.94 2018-07-14 103.80 35194 344 81.73 2018-11-16 280.80 80763 49 92.93 2018-07-19 81.62 62297 298 54.16 2018-09-10 156.55 46545 113 49.48 2018-11-28 97.98 49722 277 39.72 2018-09-17 103.18 17060 357 62.07 2018-07-01 151.97 82196 78.41 2018-11-28 235.92 98261 273 63.74 2018-12-08 176.20 90859 402 194.10 2018-06-27 525.14 86394 343 10.80 2018-11-27 12.39 47116 245 95.80 2018-10-04 265.30 90949 225 12.89 2018-07-23 23.62 64936 364 32.39 2018-10-07 57.38 59757 18 106.47 2017-09-27 113.10 62999 459 87.44 2018-09-01 105.38 36577 185 74.06 2018-11-13 129.55 44293 498 46.35 2018-09-01 23.53 39745 163 47.53 2018-10-31 48.23 44606 294 85.88 2018-04-11 80.58 18490 130 90.77 2018-07-10 317.42 25818 107 43.48 2018-12-12 118.18 44537 161 95.45 2018-07-28 248.92 15914 220 88.08 2018-09-22 97.45 36151 3 83.27 2018-04-28 115.68 97651 137 67.20 2018-12-04 164.07 55155 285 83.75 2018-09-30 281.17 22409 52 104.57 2018-10-24 291.96 82524 91 37.55 2018-11-06 113.76 32949 105 120.35 2018-04-28 190.06 32257 423 83.36 2018-12-10 249.90 35921 233 69.22 2018-09-30 131.00 76299 303 83.35 2018-10-20 252.66 95607 422 34.67 2018-10-20 29.56 26738 178 92.86 2018-05-17 247.84 91012 414 47.45 2018-12-15 41.79 14529 403 94.52 2018-07-25 86.94 77249 334 21.64 2018-11-22 52.84 18096 291 33.33 2018-12-17 100.79 68315 240 96.15 2018-09-03 146.58 26764 249 56.02 2018-09-12 156.88 25003 400 74.90 2018-11-10 165.22 86912 382 19.39 2018-09-21 23.26 39339 35 99.42 2018-08-07 290.5641108 211 68.74 2017-08-11 41.66 61964 282 91.74 2018-08-30 275.17 86804 356 20.70 2018-07-06 16.15 72936 415 83.39 2018-07-29 155.85 71037 148 22.18 2018-09-21 20.68 49500 229 67.40 2018-11-08 106.64 28095 149 53.98 2018-10-11 149.54 89939 137 29.63 2018-09-15 30.53 22029 296 22.56 2018-07-07 74.95 54512 216 14.37 2018-07-30 16.66 52278 346 10.47 2017-12-21 16.89 86321 117 78.09 2018-10-06 269.97 43072 187 31.58 2018-12-16 39.71 77814 450 49.24 2018-10-04 73.62 36881 364 8.93 2018-07-01 28.89 44869 309 182.82 2018-01-25 540.26 47046 411 56.85 2018-08-04 116.76 24862 69 41.52 2018-09-23 137.86 15442 235 98.98 2018-09-05 70.13 32786 148 38.30 2018-08-28 24.76 58969 394 21.66 2018-12-04 43.08 99249 99.27 2018-07-15 296.64 98329 313 19.39 2018-12-19 11.35 32222 203 26.45 2018-11-21 41.80 59757 486 18.67 2018-08-03 15.41 10774 154 149.83 2018-10-29 357.75 47680 105 58.10 2018-07-31 154.21 64453 228 89.44 2018-07-24 302.16 70070 46 15.00 2018-08-11 30.29 59234 199 28.05 2018-11-21 77.89 68319 110 40.79 2018-06-27 109.47 51693 306 106.17 2018-07-03 267.89 32886 474 9.59 2018-08-02 25.55 69303 441 105.34 2018-07-07 72.46 92739 323 85.93 2018-08-13 288.80 16417 378 109.51 2018-04-06 76.00 22257 298 12.34 2018-12-20 29.12 86298 153 9.97 2018-08-26 8.50 37343 184 23.37 2018-12-16 78.95 92975 18 13.72 2018-11-16 34.87 12481 60 46.21 2017-08-23 96.87 91450 229 33.96 2018-11-05 28.67 88198 431 17.05 2018-08-17 58.84 76341 434 49.95 2018-11-10 55.60 34044 126 11.09 2018-10-09 30.51 75723 214 168.28 2018-05-02 567.37 72126 300 105.44 2018-12-16 357.5481617 441 51.56 2018-10-07 100.67 27875 25 27.48 2018-08-26 40.47 35166 374 15.88 2018-08-17 47.05 75844 13 97.06 2018-01-28 233.24 94223 272 8.03 2018-08-05 22.58 10898 382 91.02 2018-10-12 308.25 90490 145 34.53 2018-07-06 91.34 27485 254 26.81 2018-11-10 93.51 72382 463 142.19 2018-12-02 367.91 49429 245 88.17 2018-10-04 160.64 46099 395 98.17 2018-12-14 199.36 19281 30 27.98 2018-07-16 38.12 42904 468 88.32 2018-09-03 249.26 70061 478 66.64 2018-09-07 218.09 42935 268 55.41 2018-11-09 175.12 64419 230 98.08 2018-07-30 117.96 48657 437 71.71 2018-07-04 148.77 65121 172 49.18 2018-07-21 55.63 65258 391 57.76 2017-09-04 169.23 69415 181 40.86 2018-10-29 41.85 75630 243 62.12 2018-12-25 165.42 78461 439 40.16 2018-07-08 27.98 37609 400 65.80 2018-08-23 81.56 56144 235 104.72 2018-11-02 181.71 24684 321 68.05 2018-12-14 181.04 17623 441 104.55 2018-12-16 125.23 65116 410 10.73 2018-09-19 11.92 78093 65 67.29 2018-11-18 72.84 46161 311 126.80 2018-04-24 260.82 86069 304 104.02 2018-11-02 251.60 67422 308 81.64 2018-08-01 65.49 91050 139 59.92 2018-12-02 117.81 15727 303 37.57 2018-09-12 48.33 67629 486 86.22 2017-11-30 236.75 58643 478 23.03 2018-08-18 37.12 43210 296 26.26 2018-11-26 15.14 41752 15 71.51 2018-12-02 59.99 92444 442 90.53 2018-09-18 120.06 48007 388 118.78 2017-10-29 220.42 95905 205 25.88 2018-10-23 61.71 32973 451 89.61 2018-12-10 169.06 20065 467 18.74 2018-07-31 37.85 37580 408 47.43 2018-08-05 72.24 19006 432 32.16 2017-11-07 91.50 70492 142 15.01 2018-08-14 38.94 31665 444 62.62 2018-12-24 166.50 58497 397 70.26 2018-09-16 209.0218992 356 106.60 2018-12-06 211.16 43911 209 155.61 2017-07-26 290.89 46547 77 86.97 2018-10-08 192.42 54703 91 52.51 2018-09-28 157.92 12142 461 53.21 2018-08-03 177.24 47205 228 40.04 2018-07-04 123.54 10956 369 19.42 2018-11-28 53.01 27084 277 42.61 2018-11-24 98.32 93536 43 94.30 2018-08-29 215.42 59704 306 9.11 2018-11-10 15.35 49482 219 93.38 2018-11-03 249.87 40049 131 186.36 2018-02-10 387.11 74547 130 104.95 2018-07-30 213.80 52750 495 61.39 2018-12-22 127.40 18207 472 50.65 2018-08-10 69.42 62452 391 48.30 2018-11-26 147.40 52838 32 77.91 2017-10-12 108.42 85240 264 104.65 2018-09-30 234.92 15341 62 46.60 2018-11-22 47.87 63940 373 42.15 2018-10-05 53.33 18507 406 74.70 2018-08-20 126.96 13227 451 74.97 2018-06-14 99.84 42063 209 36.31 2018-07-04 66.30 54596 460 89.70 2018-11-27 99.95 46817 230 62.69 2018-09-06 35.85 78239 267 61.94 2018-07-01 182.62 85125 137 70.71 2017-07-14 88.92 46188 201 58.79 2018-12-22 124.24 87988 252 42.66 2018-07-22 134.04 46731 141 66.63 2018-11-29 231.95 47923 19 70.28 2018-08-31 197.68 23222 274 136.14 2017-11-27 340.50 80323 116 78.31 2018-09-12 246.02 87637 75 86.52 2018-10-11 263.77 60087 330 38.68 2018-11-04 128.76 63389 38 68.76 2018-09-07 134.98 59730 249 81.03 2018-04-17 191.87 60186 114 77.40 2018-08-11 51.24 70823 195 78.77 2018-10-26 183.22 30996 269 30.15 2018-09-22 33.69 87002 154 29.42 2018-12-13 73.86 89444 262 127.64 2017-09-20 243.44 50153 380 74.28 2018-10-06 157.34 1880 448 65.99 2018-10-25 217.37 48405 152 82.01 2018-11-19 156.61 92762 50 58.84 2018-09-08 192.25 57595 446 34.91 2017-08-10 38.5913600 428 106.66 2018-09-03 224.23 38850 484 52.37 2018-11-05 134.31 99733 48 82.13 2018-09-02 73.00 51173 381 98.64 2018-10-16 273.61 13403 289 163.64 2017-08-05 147.23 73644 464 16.22 2018-10-28 11.36 23461 377 102.50 2018-12-19 224.92 74383 489 12.52 2018-10-06 8.20 38468 350 14.16 2018-11-01 35.54 18668 201 106.90 2018-03-04 158.97 12406 200 24.80 2018-08-31 78.10 92488 476 20.73 2018-11-21 42.99 72276 289 40.66 2018-11-26 116.89 58485 29.66 2018-10-18 97.18 53534 122 112.54 2017-08-31 121.04 49525 114 30.28 2018-11-16 47.81 67302 220 95.67 2018-10-29 248.09 76574 383 42.84 2018-08-15 38.52 43263 346 16.76 2018-07-25 21.14 58429 438 56.83 2017-09-02 70.43 74695 455 22.88 2018-08-09 29.66 88418 71.52 2018-07-01 205.68 59825 148 37.91 2018-11-19 61.47 58284 103 54.03 2018-08-14 180.07 75562 246 173.73 2018-05-07 397.12 12459 457 45.65 2018-11-13 58.58 42234 213 80.90 2018-07-23 251.42 91125 477 68.75 2018-07-04 91.81 47864 383 27.43 2018-09-14 74.93 34351 136 32.98 2017-11-04 49.09 45588 301 89.17 2018-10-01 149.17 86187 404 29.59 2018-10-13 82.9 88145 456 35.37 2018-11-15 52.00 67799 439 13.88 2018-07-10 18.91 89389 396 196.48 2018-08-13 273.53 60815 310 101.02 2018-07-01 205.76 13821 297 17.95 2018-11-22 47.75 82855 442 32.32 2018-10-25 23.43 87965 143 57.45 2018-11-11 87.61 57117 147 8.55 2018-02-09 15.17 98663 248 17.74 2018-11-08 40.44 91020 57 8.10 2018-07-04 17.86 15270 93 64.87 2018-12-24 97.53 17163 26 91.80 2018-07-12 260.86 15221 236 174.75 2018-05-09 302.27 59224 256 78.03 2018-09-15 266.59 52075 51 92.09 2018-08-16 93.20Instructions: Please answer all of the questions below. Be sure to show your work wherever possible! Part 1: Total value of Inventory to appear on the Balance Sheet (before any adjustments): |:| Part 2: Total samples to select for testing: |:| Show calculation here: Part 3: 20 items you will select to count to test for the Existence assertion List the Product# and carrying value of each item here: Part 4: Percentage coverage of total inventory with your 20 samples from Part 3: :I Show calculation here: Part 5: Slow moving items test a - Find all items not sold within the last fiscal year (2018) and calculate a write clown of 75% as per company policy. List the Product#, date of last sale, and carrying value ofeach item here: Note: There is space for40 here; you may need to add/delete rows. Date of Last Sale Carrying Value b - Write down required (75%) :I Show summary calculation here: Part 6: Lower of cost and net realizable value test a - Find all items whose latest selling prices was less than their carrying value and write these items down to their net realizable value. List the Product #, unit cost, and latestsales price here, and show any other relevant calculations here' Note: There is space for 1 00 here; you may need to add/delete rows. Last Unit Selling Product # Unit Cost Price \fb - Amount of write down required: Show summary calculation here: Part 7: Journal entry to record Parts #5 & #6: a - What would be the journal entry required to process the adjustments? Show journal entryes) here (ignore account numbers , just use account descriptions) b - Analysis - do we need to extrapolate (or project) these misstatements to the entire population (as we did in Assignment #10)? If yes, show calculation here. If no, explain why here. Part 8: Assuming management makes the adjustment, what will be the NEW Inventory value that will appear on the 3/5? Part 9: Analysis: How will these adjustments impact the overall nancial condition of the company {as shown on the Financial Statements)? How might the users react to this? How (if at all] will this affect our audit