Ames_Inventory.xlsx
Ames Inventory
| Prod_No | Prod_Description | Unit_Cost | Unit_Mkt | Qty_On_Hand | Inv_Cost | Inv_Mkt |
| 52530155 | CEDAR STRAPPING PER/FT | 0.03 | 0.04 | 71,000 | 2,130.00 | 2,840.00 |
| 52210545 | 2X3 2&B PER LINEAL | 0.01 | 0.09 | 1,000 | 10.00 | 90.00 |
| 80100818 | 1/2" 90 DEGREE ELBOW COP | 0.19 | 0.29 | 1,100 | 209.00 | 319.00 |
| 80126308 | 1/2" CPVC PIPE STRAP | 0.24 | 0.39 | 1,250 | 300.00 | 487.50 |
| 52770015 | 2X8 2&B PER LINEAL | 0.31 | 0.40 | 10,000 | 31,000.00 | 4,000.00 |
| 80102918 | 1/2" TEE COPPER TO COP | 0.29 | 0.44 | 1,500 | 435.00 | 660.00 |
| 80126058 | 1/2" CPVC MALE ADAPTER | 0.33 | 0.49 | 860 | 283.80 | 421.40 |
| 80101018 | 1/2" 45 DEGREE ELBOW COP | 0.37 | 0.50 | 1,200 | 444.00 | 600.00 |
| 90010011 | HOSE HANGER | 0.43 | 0.99 | 300 | 129.00 | 297.00 |
| 24128712 | NEOLITE SKATE GUARDS | 1.01 | 1.19 | 450 | 454.50 | 535.50 |
| 30321663 | SCREW DRIVER 1/8 X 4 SL | 0.73 | 1.69 | 1,478 | 1,078.94 | 2,497.82 |
| 90509561 | PLASTIC WATERING CAN | 0.63 | 1.98 | 112 | 70.56 | 221.76 |
| 30322303 | SCREW DRIVER NO.3 PHILL | 1.22 | 2.29 | 587 | 716.14 | 1,344.23 |
| 90504061 | 54" EDGING TURF | 1.37 | 2.49 | 610 | 835.70 | 1,518.90 |
| 30321683 | SCREW DRIVER 1/4 X 6 SL | 1.47 | 2.59 | 1,248 | 1,834.56 | 3,232.32 |
| 80126008 | 1/2" CPVC PLASTIC PIPE | 2.41 | 2.79 | 9,600 | 23,136.00 | 26,784.00 |
| 24128812 | COOPER SPORTS BAG | 3.10 | 2.95 | 170 | 527.00 | 501.50 |
| 90501551 | 20" LEAF RAKE | 1.83 | 2.99 | 800 | 1,464.00 | 2,392.00 |
| 80106218 | 1/2" GATE VALVE COPPER | 2.30 | 2.99 | 1,300 | 2,990.00 | 3,887.00 |
| 80123968 | REDVGING TY 3"X3"X1" | 2.68 | 3.02 | 420 | 1,125.60 | 1,268.40 |
| 80123438 | ADAPTER FIBERCAST 3"X4" | 2.79 | 3.12 | 530 | 1,478.70 | 1,653.60 |
| 80124518 | DRAINAGE TY 3" | 2.79 | 3.12 | 610 | 1,701.90 | 1,903.20 |
| 80938748 | CHROME ANGLE 1/2X3/8 COM | 2.99 | 3.12 | 700 | 2,093.00 | 2,184.00 |
| 80938998 | CHROME ST 1/2"X 3/8"COMP | 2.99 | 3.12 | 450 | 1,345.50 | 1,404.00 |
| 30412903 | 8 PC METRIC HEX KEYS | 2.48 | 3.49 | 248 | 615.04 | 865.52 |
| 10631140 | CAKE PAN | 3.09 | 3.59 | 140 | 432.60 | 502.60 |
| 24121332 | MOUTH GUARD | 2.80 | 3.70 | 345 | 966.00 | 1,276.50 |
| 52484435 | PLYWOOD 4X8X 1/4 REJECT | 2.88 | 3.79 | 118 | 339.84 | 447.22 |
| 10631190 | LOAF PAN | 3.10 | 3.79 | 36 | 111.60 | 136.44 |
| 24128932 | NOSE & MOUTH GUARD | 3.49 | 3.85 | 300 | 1,047.00 | 1,155.00 |
| 93788411 | 1" GARDEN HOSE | 1.40 | 3.98 | 186 | 260.40 | 740.28 |
| 10311990 | DIET SCALE | 2.98 | 3.99 | 290 | 864.20 | 1,157.10 |
| 10134420 | VEGETABLE STEAMER | 3.12 | 3.99 | 50 | 156.00 | 199.50 |
| 30303413 | 8 OZ BALL PEIN HAMMER | 3.90 | 4.69 | 1,248 | 4,867.20 | 5,853.12 |
| 30324803 | ARC JOINT PLIERS 6" | 3.99 | 4.69 | 625 | 2,493.75 | 2,931.25 |
| 23973042 | MORA ICE DRILL EXTN | 3.32 | 4.80 | 75 | 249.00 | 360.00 |
| 52504005 | 5/16 SHEATHING | 3.94 | 4.80 | 5,000 | 19,700.00 | 24,000.00 |
| 90508191 | PISTOL GRIP NOZZLE | 1.63 | 4.99 | 815 | 1,328.45 | 4,066.85 |
| 60221676 | PNEUMATIC DOOR CLOSER | 2.10 | 4.99 | 205 | 430.50 | 1,022.95 |
| 180122158 | Y FITTING 4" | 3.21 | 5.09 | 1,390 | 4,461.90 | 7,075.10 |
| 30303403 | 12 OZ BALL PEIN HAMMER | 4.12 | 5.29 | 536 | 2,208.32 | 2,835.44 |
| 90507841 | 25' VINYL HOSE | 2.88 | 5.49 | 40 | 115.20 | 219.60 |
| 52484405 | PLYWOOD 4X8X 1/4 GIS | 4.88 | 5.69 | 500 | 2,440.00 | 2,845.00 |
| 10207220 | NAPKIN & RELISH HOLDER | 3.22 | 5.79 | 212 | 682.64 | 1,227.48 |
| 90501541 | 24" LEAF RAKE | 3.00 | 5.99 | 212 | 636.00 | 1,269.88 |
| 80123938 | NEOPRENE ROOF FLASH 3" | 4.14 | 5.99 | 210 | 869.40 | 1,257.90 |
| 10551340 | DISH DRAINER | 6.56 | 5.99 | 412 | 2,702.72 | 2,467.88 |
| 24112162 | CURLING SLIDERS | 5.18 | 6.49 | 310 | 1,605.80 | 2,011.90 |
| 52484415 | PLYWOOD 4X8X 1/2 GIS | 5.20 | 6.63 | 600 | 3,120.00 | 3,978.00 |
| 30030323 | LONG NOSE PLIERS 7" | 5.00 | 6.98 | 412 | 2,060.00 | 2,875.76 |
| 24195262 | SNOWSHOE HARNESS | 5.07 | 6.98 | 140 | 709.80 | 977.20 |
| 10803760 | 7 PC KITCHEN TOOL SET | 3.21 | 6.99 | 48 | 154.08 | 335.52 |
| 40225934 | MASONRY DRILL SET | 5.10 | 6.99 | 450 | 2,295.00 | 3,145.50 |
| 24130572 | BANANA PEEL SLIDER | 5.30 | 7.50 | 90 | 477.00 | 675.00 |
| 30934423 | DIAGONAL CUTTING PLIERS | 4.98 | 7.79 | 624 | 3,107.52 | 4,860.96 |
| 24139372 | WAX KIT | 5.94 | 7.95 | 235 | 1,395.90 | 1,868.25 |
| 23946372 | TEHO ROD AND REEL | 6.43 | 7.95 | 110 | 707.30 | 874.50 |
| 60100356 | BATH LOCK SET ALUMINUM | 6.00 | 7.98 | 55 | 330.00 | 438.90 |
| 10102710 | ALUMINUM TEAPOT 8 CUP | 5.99 | 7.99 | 144 | 862.56 | 1,150.56 |
| 52208805 | PANELLING PINE 4X8 | 6.12 | 8.00 | 108 | 660.96 | 864.00 |
| 52484425 | PLYWOOD 4X8X 3/4 GIS | 7.12 | 8.60 | 314 | 2,235.68 | 2,700.40 |
| 60100316 | BATH LOCK SET BRASS | 6.10 | 8.98 | 40 | 244.00 | 359.20 |
| 80102628 | R161D TUBING 1/2" -12' | 7.00 | 8.99 | 5,300 | 37,100.00 | 47,647.00 |
| 40240284 | FORMICA CUTTING BIT | 7.40 | 9.69 | 140 | 1,036.00 | 1,356.60 |
| 90501051 | 11" SPADING FORK | 4.82 | 9.99 | 714 | 3,441.48 | 7,132.86 |
| 90507851 | 50' VINYL HOSE | 5.12 | 9.99 | 30 | 153.60 | 299.70 |
| 90509981 | IMPULSE SPRINKLER | 5.12 | 9.99 | 900 | 4,608.00 | 8,991.00 |
| 70104177 | LATEX SEMI-GLOSS LILAC | 6.87 | 9.99 | 1,480 | 10,167.60 | 14,785.20 |
| 70104327 | LATEX SEMI-GLOSS YELLOW | 6.87 | 9.99 | 2,420 | 16,625.40 | 24,175.80 |
| 70104347 | LATEX SEMI-GLOSS ORANGE | 6.87 | 9.99 | 870 | 5,976.90 | 8,691.30 |
| 70104377 | LATEX SEMI-GLOSS GREEN | 6.87 | 9.99 | 1,870 | 12,846.90 | 18,681.30 |
| 70104397 | LATEX SEMI-GLOSS CARAMEL | 6.87 | 9.99 | 460 | 3,160.20 | 4,595.40 |
| 70104657 | LATEX SEMI-GLOSS PINK | 6.87 | 9.99 | 1,500 | 10,305.00 | 14,985.00 |
| 70104677 | LATEX SEMI-GLOSS APRICOT | 6.87 | 9.99 | 1,290 | 8,862.30 | 12,887.10 |
| 40240884 | ADJ EDGE GUIDE | 6.90 | 9.99 | 380 | 2,622.00 | 3,796.20 |
| 60100336 | BATH LOCK SET COPPER | 8.70 | 9.99 | 210 | 1,827.00 | 2,097.90 |
| 52204515 | PANELLING BIRCH 4X8 | 7.94 | 10.00 | 412 | 3,271.28 | 4,120.00 |
| 24100312 | COOPER HOCKEY HELMET | 8.42 | 10.95 | 95 | 799.90 | 1,040.25 |
| 90509931 | OSCILLATING SPRINKLER | 5.84 | 10.98 | 3,840 | 22,425.60 | 42,163.20 |
| 90506331 | 5 PIECE GARDEN TOOL SET | 6.80 | 10.98 | 408 | 2,774.40 | 4,479.84 |
| 40225014 | 6 PC WOODBORIN SET | 8.70 | 10.98 | 870 | 7,569.00 | 9,552.60 |
| 40226054 | 12 PC PILOT BIT SET | 8.70 | 10.98 | 740 | 6,438.00 | 8,125.20 |
| 10155170 | 4 PC CANISTER SET | 7.05 | 10.99 | 96 | 676.80 | 1,055.04 |
| 52204525 | PANELLING ROSEWOOD 4X8 | 9.40 | 12.00 | 364 | 3,421.60 | 4,368.00 |
| 90504761 | 6" EDGE TRIMMER | 6.17 | 12.98 | 914 | 5,639.38 | 11,863.72 |
| 30303343 | STRAIGHT CLAW HAMMER | 8.83 | 12.98 | 735 | 6,490.05 | 9,540.30 |
| 60112276 | MATCHING DOOR KNOCKERBLK | 9.40 | 12.98 | 90 | 846.00 | 1,168.20 |
| 10155150 | STEP-ON CAN | 8.40 | 12.99 | 132 | 1,108.80 | 1,714.68 |
| 60221496 | WHITE ENAMEL GRILL | 8.40 | 12.99 | 312 | 2,620.80 | 4,052.88 |
| 60221506 | BLACK ENAMEL GRILL | 8.40 | 12.99 | 262 | 2,200.80 | 3,403.38 |
| 24104312 | SNOW-JET MOBILE | 12.10 | 13.50 | 12 | 145.20 | 162.00 |
| 24133112 | HOCKEY NET SET | 10.60 | 13.95 | 200 | 2,120.00 | 2,790.00 |
| 40224984 | ROUTER BOX | 8.80 | 13.98 | - 0 | - 0 | - 0 |
| 10119040 | BLANCHER | 8.00 | 13.99 | 190 | 1,520.00 | 2,658.10 |
| 10155160 | 1 SHELF BREADBOX | 9.93 | 13.99 | 56 | 556.08 | 783.44 |
| 23903712 | FISH N FILLET BOARD | 10.73 | 14.95 | 120 | 1,287.60 | 1,794.00 |
| 24144812 | TRUNK SKI CARRIER | 10.73 | 14.95 | 110 | 1,180.30 | 1,644.50 |
| 34255003 | PARKER PROPANE KIT (7PC) | 8.40 | 14.98 | - 0 | - 0 | - 0 |
| 30324883 | ARC JOINT PLIERS 16" | 9.40 | 14.98 | 875 | 8,225.00 | 13,107.50 |
| 60100306 | CYLINDRICAL LOCK SET BLK | 11.20 | 14.98 | 170 | 1,904.00 | 2,546.60 |
| 60112296 | LION DOOR KNOCKER BR | 11.20 | 14.98 | 184 | 2,060.80 | 2,756.32 |
| 30412553 | 6 PC OPEN END WRENCH SET | 11.53 | 15.98 | 700 | 8,071.00 | 11,186.00 |
| 10226620 | CAKE DECORATING SET | 10.80 | 15.99 | 48 | 518.40 | 767.52 |
| 90507811 | 50' RUBBER HOSE | 8.08 | 16.98 | 200 | 1,616.00 | 3,396.00 |
| 30302903 | 4 PC CHISEL SET | 10.12 | 16.98 | 795 | 8,045.40 | 13,499.10 |
| 30309373 | HEAVY DUTY BRACE | 10.12 | 16.98 | 842 | 8,521.04 | 14,297.16 |
| 60200306 | CYLINDRICAL LOCK SET BR | 12.40 | 16.98 | 163 | 2,021.20 | 2,767.74 |
| 24108612 | ESKIMO TOBOGGAN 6FT | 15.87 | 17.95 | 45 | 714.15 | 807.75 |
| 90669611 | 3 CU FT WHEELBARROW | 9.00 | 17.98 | 47 | 423.00 | 845.06 |
| 30412753 | 6 PC BOX END WRENCH SET | 12.50 | 18.49 | 248 | 3,100.00 | 4,585.52 |
| 24106512 | HOCKEY PANTS | 14.80 | 18.95 | 125 | 1,850.00 | 2,368.75 |
| 40247034 | SET OF 6 ROTARY CUTTERS | 12.40 | 18.98 | 840 | 10,416.00 | 15,943.20 |
| 60112356 | MATCHING DOOR KNOCKER BR | 14.10 | 19.98 | 140 | 1,974.00 | 2,797.20 |
| 40270354 | MOLDING HEAD GUARD | 14.12 | 19.98 | 55 | 776.60 | 1,098.90 |
| 10310890 | MINCER | 14.14 | 19.99 | 86 | 1,216.04 | 1,719.14 |
| 40241754 | STEEL ROUTER TABLE | 14.12 | 21.98 | 60 | 847.20 | 1,318.80 |
| 130305603 | #4 SMOOTH PLANE | 14.12 | 22.98 | 804 | 11,352.48 | 18,475.92 |
| 80102618 | 1/2" SOFT TUBING 30'COIL | 16.80 | 23.98 | 6,000 | 100,800.00 | 143,880.00 |
| 30414283 | METRIC SOCKET SET 11 PC | 18.00 | 25.98 | 612 | 11,016.00 | 15,899.76 |
| 40241314 | ROUT-A-FORM PANTOGRAPH | 18.70 | 25.98 | 375 | 7,012.50 | 9,742.50 |
| 80935298 | HYDROMOULD SWING-SPOUT | 21.12 | 27.98 | 47 | 992.64 | 1,315.06 |
| 24140032 | MENS SNOSHOES | 27.41 | 32.95 | 75 | 2,055.75 | 2,471.25 |
| 24188432 | LADIES FIGURE SKATES | 28.15 | 32.95 | 80 | 2,252.00 | 2,636.00 |
| 60102066 | CLASSIC ENTRANCE SET BLK | 19.90 | 32.98 | 77 | 1,532.30 | 2,539.46 |
| 60102106 | CAPE COD ENTR SET BLK | 19.90 | 32.98 | 210 | 4,179.00 | 6,925.80 |
| 60102116 | CAPE COD ENTR SET BR | 21.40 | 34.88 | 154 | 3,295.60 | 5,371.52 |
| 90599912 | 18" BUSHWACKER TRIMMER | 21.40 | 34.98 | 43 | 920.20 | 1,504.14 |
| 10135060 | 192 OZ DUTCH OVEN | 27.60 | 39.98 | 230 | 6,348.00 | 9,195.40 |
| 40240664 | SHAPENER FOR 1/4" BITS | 29.60 | 39.98 | 135 | 3,996.00 | 5,397.30 |
| 60102086 | COLONIAL ENTRANCE SET BR | 32.08 | 44.89 | 155 | 4,972.40 | 6,957.95 |
| 80512778 | COMPACT DOUBLE BOWEL SNK | 36.18 | 46.98 | 112 | 4,052.16 | 5,261.76 |
| 40276054 | 21 PC MONO-CUTTER SET | 36.50 | 47.98 | 120 | 4,380.00 | 5,757.60 |
| 52720305 | 1X8 SHIPLAP PER MFBM | 41.00 | 50.00 | 32 | 1,312.00 | 1,600.00 |
| 52720615 | 2X4 RANDOM PER MFBM | 41.00 | 50.00 | 18 | 738.00 | 900.00 |
| 40277154 | ADJUSTABLE DADO | 36.57 | 51.98 | 145 | 5,302.65 | 7,537.10 |
| 80435438 | DUAL LEVER FAUCET-NO-SPR | 40.24 | 51.98 | 93 | 3,742.32 | 4,834.14 |
| 90069591 | 4 CU FT WHEELBARROW | 23.84 | 52.98 | (8) | (190.72) | (423.84) |
| 30302303 | MITRE BOX 21" | 41.23 | 54.95 | 600 | 24,738.00 | 32,970.00 |
| 60102096 | SEVILLE ENTRANCE SET BR | 38.70 | 54.98 | 300 | 11,610.00 | 16,494.00 |
| 10311800 | PASTA NOODLE MAKER | 24.88 | 54.99 | 64 | 1,592.32 | 3,519.36 |
| 80935428 | DUAL LEVER FAUCET -SPRAY | 44.24 | 58.98 | 116 | 5,131.84 | 6,841.68 |
| 30414313 | METRIC TOOL SET 3/8" DR | 47.00 | 59.98 | 130 | 6,110.00 | 7,797.40 |
| 10102840 | PRESSURE COOKER 8QT | 39.40 | 64.98 | 400 | 15,760.00 | 25,992.00 |
| 30364163 | TAP & DIE SET 41 PIECES | 49.60 | 69.98 | (12) | (595.20) | (839.76) |
| 40243224 | 2 SP ROTARY SANDER | 52.80 | 74.98 | 70 | 3,696.00 | 5,248.60 |
| 90081001 | SUPER CALLUM LEAF MULCH | 155.80 | 79.50 | 12 | 1,869.60 | 954.00 |
| 40220074 | 3/8" COMPACT DRILL PRESS | 62.00 | 79.98 | 140 | 8,680.00 | 11,197.20 |
| 40232194 | 12 SP AUTO SCROLLER SAW | 59.60 | 89.98 | 210 | 12,516.00 | 18,895.80 |
| 60217066 | ALUMINUM DOOR | 87.40 | 136.99 | 188 | 16,431.20 | 25,754.12 |
| 90585322 | 18" REEL MOWER | 137.80 | 259.99 | 88 | 12,126.40 | 22,879.12 |
| 90584072 | 22" SELF-PROPELLED MOW | 173.80 | 299.99 | 147 | 25,548.60 | 44,098.53 |
| 40270324 | RADIAL ARM SAW 10" HD | 381.20 | 499.98 | 30 | 11,436.00 | 14,999.40 |
maiezymq12
