Database
WAREHOUSE_LOC RECNUM DESCRIPTION AVG_COST QUANTITY ITEM LOCATION LOT EXT_COST STATE
BLANCO 12395 97.7 OD x 28 ACCESS HOLE COVER 0.004 32 4935282 I 155 0 0.13 NY
BLANCO 12879 1/2-20 X 6.00 HHCS GR 5 PLN 2.610 46 70111 TOY210 46 120.06 NY
BLANCO 2825 CONNECTOR, FEMALE 0.160 400 3018888* TOY272 11427 64.00 NY
BLANCO 3330 7/8-14 TUBE NUT, BRASS 0.770 10 3038033 TOY172 17453 7.70 NY
BLANCO 13026 #8-32 LOCK NUT 0.050 23590 70646 D 035 53049 1179.50 NY
BLANCO 9690 5/16-18 X 1 1/4 HHCS GR5 0.080 1010 3924205 TOY177 58226 80.80 NY
BLANCO 9639 7.20/7.35 ID x 14.82/15.00 OD 0.070 56700 3923261 D 148 58658 3969.00 NY
BLANCO 8058 M8-1.25 x 50MM HEXAGON HEAD 0.110 501 3900710 TOY073 62919 55.11 NY
LAMESA 19128 17.577MM ID FLATWASHER 0.230 200 3926780 A 058 66673 46.00 NY
LAMESA 18989 M10-1.5 X 45MM HHCS CL9.8 0.080 300 3922606 E 063 69477 24.00 NY
PERRY 23025 M8-1.25X117MM HEX FL BOLT 9.8 0.720 150 3935190 A 001 70176 108.00 NY
BLANCO 2053 1/4-14 X 1/2 PHIL PAN HD SMS 0.210 1368 26114 Q 371 80712 287.28 NY
BLANCO 8533 10-1.5 X 35MM 12PT C/S 0.110 23400 3903834 OOO008 82405 2574.00 NY
BLANCO 9229 M8-1.25 x 56.51MM HFHC SCREW 0.002 5063 3920345 O 318 90260 10.13 NY
PERRY 22547 M12-1.75 x 20MM HEXAGON HEAD 0.410 1200 3028373 A 001 90391 492.00 NY
BLANCO 1145 5/8-18 X 7.010/6.950 CYLINDER 0.830 72 151349 TOY085 92798 59.76 NY
BOERNE 14415 5/8-18 REGULAR HEXAGON NUT 0.060 614 S-210 AA 009 94916 36.84 MI
LAMESA 18850 1/2 – 14 NPTF ELBOW HOSE 1.290 22 3916863 E 008 95370 28.38 NY
BOERNE 14389 5/16-24 X 1.25 HHCS GR5 PLN 0.040 607 S-142 AA 022 95886 24.28 MI
BOERNE 14140 1/2-14 PLAIN HOSE COUPLING 2.000 9 156042 AA 010 97499 18.00 MI
BOERNE 14182 M6-1 x 18MM HEX HEAD CAP SCREW 0.012 445 3019998 AA 002 98219 5.34 MI
BOERNE 14131 5/8-18 X 3.25 HHCS GR5 PLN 0.360 50 138043 AA 016 99293 18.00 MI
BLANCO 12108 10.2M X 18.8M X 3.0 THK LOCK 0.190 604 409065 Q 038 99422 114.76 NY
BLANCO 12968 10-32 X 3/8 PAN HEAD CAP SCREW 0.010 2978 70208* O 057 101836 29.78 NY
BOERNE 14314 1/4-18 x 3/4-16 Male Adapter 1.740 80 43765-A AA 011 102620 139.20 MI
BLANCO 6006 44.46MM DIA TUBE CLAMP 2.030 122 3282083 TOY156 102652 247.66 NY
BLANCO 10407 M8-1.25 x 22MM HFHC SCREW w/ 0.150 593 3941976 O 222 103046 88.95 NY
BLANCO 14013 SC 3/8″ (3/4″IL) STK BLK 0.020 505 SC0375 Q 337 103217 10.10 NY
BOERNE 14447 SC 5/8″ (3/4″IL) STK BLK 0.030 1882 SC0625 AA 012 103219 56.46 MI
BLANCO 1309 WASHER, SPRING PTFP 0.020 515 171057* TOY094 103676 10.30 NY
BOERNE 14114 3/8-24 X 1.75 HHCS GR 5 PLN 0.180 627 106549 AA 021 103882 112.86 MI
BOERNE 14413 7/8-9 HEAVY HEXAGON NUT 0.220 36 S-203 AA 009 103909 7.92 MI
BOERNE 14454 SC 3-1/2″ -24 (1-1/2″IL) B/R 0.650 348 SC3500 AA 004 104044 226.20 MI
BLANCO 14014 SC 0.437-1/2″ IL STOCK BLACK 0.020 3216 SC0437 P 287 104046 64.32 NY
BOERNE 14448 SC 3/4″ 12 (3/4″IL) B/R 0.030 6779 SC0750 AA 014 104048 203.37 MI
BOERNE 14347 1-1/4″ STD BLK CAP 0.650 10 PF11 AA 004 104231 6.50 MI
BLANCO 817 SCREW, SOCKET HEAD CAP 0.020 738 134442* TOY087 105466 14.76 NY
BLANCO 13589 1/4-20 X 1 1/4 SHCS 0.050You have been asked to analyze the report below.The company policy is that no single inventory product should have more than 300,000 items in stock. The company has a total of 4,175 different products in inventory based on following set of dataWeek 2 Inventory-Database.xlsx. The report was generate to show those products that had more than 300,000 items in stock.Discuss your observations about this data keeping in mind what this data tells you about possibletrends,future predictions, bias,and/or materiality of the exceptions to the policy found. What other tests would you have run on the data and whatimprovements do you feel may be needed to the system, policy, internal controls, etc. Be sure to provide detail and examples.