Charade.Clark-Boone-AC2016-3-5-Supplies_2021-07-16.accdb
| ProductID | Description | OnHand | Cost | Retail | VendorCode | Buyer | Reorder | Price |
| 1 | 1" Binder | 32 | ¤ 1.98 | ¤ 3.25 | A06 | 04 | 20 |
|
| 2 | 1.5" Binder | 11 | ¤ 2.67 | ¤ 4.49 | D13 | 04 | 20 |
|
| 3 | 2" Binder | 18 | ¤ 3.14 | ¤ 4.99 | D13 | 04 | 20 |
|
| 4 | 3" Binder | 52 | ¤ 4.55 | ¤ 7.49 | D13 | 04 | 15 |
|
| 5 | 2" Deluxe Binder | 19 | ¤ 4.87 | ¤ 5.99 | C03 | 04 | 15 |
|
| 6 | 0.5 mm pencil lead | 81 | ¤ 0.49 | ¤ 1.25 | A06 | 02 | 50 |
|
| 7 | 0.7 mm pencil lead | 44 | ¤ 0.52 | ¤ 1.35 | A06 | 02 | 50 |
|
| 8 | Economy mech pencil | 73 | ¤ 0.52 | ¤ 0.99 | C03 | 02 | 50 |
|
| 9 | Deluxe mech pencil | 67 | ¤ 1.57 | ¤ 2.49 | C03 | 02 | 50 |
|
| 10 | Precision mech pencil | 40 | ¤ 2.14 | ¤ 3.49 | D13 | 02 | 30 |
|
| 11 | Loose Leaf Paper 250 sheets | 53 | ¤ 1.24 | ¤ 2.49 | B05 | 07 | 60 |
|
| 12 | Loose Leaf Paper 350 sheets | 87 | ¤ 1.97 | ¤ 3.11 | B05 | 07 | 60 |
|
| 13 | Loose Leaf Paper500 sheets | 72 | ¤ 2.77 | ¤ 4.99 | B05 | 07 | 60 |
|
| 14 | Dividers - colored tab | 79 | ¤ 0.95 | ¤ 1.49 | C03 | 04 | 60 |
|
| 15 | Dividers - clear tab | 89 | ¤ 0.95 | ¤ 1.49 | C03 | 04 | 75 |
|
| 16 | File Folders - letter | 183 | ¤ 0.04 | ¤ 0.15 | B05 | 07 | 75 |
|
| 17 | File Folders - legal | 245 | ¤ 0.09 | ¤ 0.25 | B05 | 07 | 75 |
|
| 18 | File Folders - legal heavy | 144 | ¤ 0.17 | ¤ 0.55 | B05 | 07 | 75 |
|
| 19 | File Folders - letter heavy | 85 | ¤ 0.13 | ¤ 0.40 | B05 | 07 | 75 |
|
| 20 | Hanging File Folders - letter | 55 | ¤ 5.44 | ¤ 9.98 | B05 | 07 | 20 |
|
| 21 | Hanging File Folders - legal | 66 | ¤ 6.28 | ¤ 11.98 | B05 | 07 | 25 |
|
| 22 | Highlighter - yellow | 25 | ¤ 0.97 | ¤ 1.49 | A06 | 02 | 30 |
|
| 23 | Highlighter - blue | 47 | ¤ 0.97 | ¤ 1.49 | A06 | 02 | 30 |
|
| 24 | Highlighter - green | 68 | ¤ 0.97 | ¤ 1.49 | A06 | 02 | 30 |
|
| 25 | Highlighter - pink | 41 | ¤ 0.97 | ¤ 1.49 | A06 | 02 | 30 |
|
| 26 | Eraser | 541 | ¤ 0.54 | ¤ 0.99 | A06 | 02 | 300 |
|
| 27 | Eraser - large | 245 | ¤ 0.99 | ¤ 1.49 | A06 | 02 | 150 |
|
| 28 | Push Pins - clear | 547 | ¤ 1.54 | ¤ 2.49 | D13 | 01 | 300 |
|
| 29 | Push Pins - assorted | 351 | ¤ 1.62 | ¤ 2.39 | D13 | 01 | 300 |
|
| 30 | Thumb Tacks - plain | 341 | ¤ 5.24 | ¤ 9.99 | A06 | 01 | 300 |
|
| 31 | Thumb Tacks - brass | 64 | ¤ 6.53 | ¤ 11.29 | A06 | 01 | 100 |
|
| 32 | Thumb Tacks - colored | 124 | ¤ 5.98 | ¤ 10.49 | A06 | 01 | 100 |
|
| 33 | Disposable Pen - blue | 241 | ¤ 0.47 | ¤ 0.99 | A06 | 02 | 80 |
|
| 34 | Disposable Pen - blue, fine | 163 | ¤ 0.47 | ¤ 0.99 | A06 | 02 | 80 |
|
| 35 | Disposable Pen - black | 23 | ¤ 0.47 | ¤ 0.99 | A06 | 02 | 80 |
|
| 36 | Disposable Pen - red | 148 | ¤ 0.47 | ¤ 0.99 | A06 | 02 | 80 |
|
| 37 | Disposable Pen - red, fine | 75 | ¤ 0.47 | ¤ 0.99 | A06 | 02 | 80 |
|
| 38 | Deluxe Disposable Pen - blue | 62 | ¤ 0.68 | ¤ 1.49 | A06 | 02 | 50 |
|
| 39 | Deluxe Disposable Pen - black | 57 | ¤ 0.68 | ¤ 1.49 | A06 | 02 | 50 |
|
| 40 | Erasable Marker - black | 35 | ¤ 0.46 | ¤ 0.99 | D13 | 03 | 12 |
|
| 41 | Erasable Marker - blue | 68 | ¤ 0.46 | ¤ 0.99 | D13 | 03 | 12 |
|
| 42 | Erasable Marker - red | 57 | ¤ 0.46 | ¤ 0.99 | D13 | 03 | 12 |
|
| 43 | Erasable Marker - green | 108 | ¤ 0.46 | ¤ 0.99 | D13 | 03 | 12 |
|
| 44 | Paper Clips - small | 32 | ¤ 1.97 | ¤ 2.99 | A06 | 04 | 10 |
|
| 45 | Paper Clips - medium | 146 | ¤ 2.61 | ¤ 3.99 | A06 | 04 | 10 |
|
| 46 | Paper Clips - large | 56 | ¤ 3.08 | ¤ 4.99 | A06 | 04 | 10 |
|
| 47 | Paper Clips - coated | 61 | ¤ 2.86 | ¤ 4.49 | A06 | 04 | 15 |
|
| 48 | Elastic - narrow | 82 | ¤ 0.97 | ¤ 1.49 | B12 | 04 | 35 |
|
| 49 | Elastic - medium | 51 | ¤ 1.37 | ¤ 1.99 | B12 | 04 | 45 |
|
| 50 | Elastic - wide | 62 | ¤ 1.88 | ¤ 2.49 | B12 | 04 | 20 |
|
| 51 | Permanent Marker - fine, black | 114 | ¤ 0.61 | ¤ 1.25 | B05 | 03 | 45 |
|
| 52 | Permanent Marker - fine, blue | 60 | ¤ 0.61 | ¤ 1.25 | B05 | 03 | 45 |
|
| 53 | Permanent Marker - fine, red | 22 | ¤ 0.61 | ¤ 1.25 | B05 | 03 | 45 |
|
| 54 | Permanent Marker - fine, green | 87 | ¤ 0.61 | ¤ 1.25 | B05 | 03 | 45 |
|
| 55 | Permanent Marker - med, blue | 254 | ¤ 0.82 | ¤ 1.99 | B05 | 03 | 45 |
|
| 56 | Permanent Marker - med, black | 126 | ¤ 0.82 | ¤ 1.99 | B05 | 03 | 45 |
|
| 57 | Permanent Marker - med, red | 31 | ¤ 0.82 | ¤ 1.99 | B05 | 03 | 45 |
|
| 58 | Permanent Marker - med, green | 58 | ¤ 0.82 | ¤ 1.99 | B05 | 03 | 45 |
|
| 59 | White Board - small | 11 | ¤ 6.82 | ¤ 15.00 | D13 | 03 | 3 |
|
| 60 | White Board - large | 7 | ¤ 11.21 | ¤ 19.99 | D13 | 03 | 2 |
|
| 61 | Copy Paper - economy | 67 | ¤ 2.55 | ¤ 4.99 | B12 | 06 | 30 |
|
| 62 | Copy Paper - regular | 33 | ¤ 2.88 | ¤ 5.99 | B12 | 06 | 30 |
|
| 63 | Copy Paper - legal | 61 | ¤ 3.02 | ¤ 6.49 | B12 | 06 | 30 |
|
| 64 | Mailing Labels - 5014 | 34 | ¤ 10.09 | ¤ 19.99 | B12 | 06 | 15 |
|
| 65 | Mailing Labels - 5016 | 6 | ¤ 10.09 | ¤ 19.99 | B12 | 06 | 15 |
|
| 66 | Mailing Labels - 5020 | 88 | ¤ 10.09 | ¤ 19.99 | B12 | 06 | 15 |
|
| 67 | Mailing Labels - 5025 | 72 | ¤ 10.09 | ¤ 19.99 | B12 | 06 | 15 |
|
| 68 | Transparent Tape - regular | 355 | ¤ 0.66 | ¤ 1.49 | B12 | 04 | 100 |
|
| 69 | Transparent Tape - bonus pack | 72 | ¤ 1.45 | ¤ 2.99 | B12 | 04 | 50 |
|
| VendorCode | VendorName | Phone |
| A06 | Adams Stanley Corp. | 703-555-2748 |
| B05 | Bundy Supplies | 213-555-7832 |
| B12 | Boone Systems | 312-555-5743 |
| C03 | Carter-Linwood | 617-555-3433 |
| D13 | Dawson.com | 512-555-7878 |
SELECT Vendors.VendorName, Supplies.Description, Supplies.OnHand, Supplies.Reorder, [Reorder]-[OnHand] AS NumShort, [NumShort]+[Reorder] AS NumNeeded, Supplies.Cost, [NumNeeded]*[Cost] AS TotalCost
FROM Vendors INNER JOIN Supplies ON Vendors.[VendorCode] = Supplies.[VendorCode]
WHERE ((([Reorder]-[OnHand])>0))
ORDER BY Vendors.VendorName;
Chashie757
