Attachment_D_Inventory.xlsx
XLSX spreadsheet 24 KB Posted
- Solicitation number
- 140G0126Q0153
About this file
This is an inventory attachment documenting departmental stock levels for the Earth Resources Observation and Science Center (EROS) as of December 1-31, 2019. The inventory lists 46 line items across two departments: the Copy Center (Department 1) with 27 items valued at $2,199.25, and the Mailroom (Department 3) with 19 items valued at $998.15, for a total inventory value of $3,197.40. Copy Center inventory includes various colored copy papers, coverstock, binding supplies, and related office products, while Mailroom inventory comprises shipping and packaging materials such as bubble wrap, cushioned envelopes, kraft paper, and tape products in multiple formats and sizes.
The inventory report tracks quantities on hand, period-to-date (PTD) issues, unit costs, and inventory values. During the December period, only Department 1 had activity with 30 units issued, generating $169.80 in PTD expenses and $389.10 in year-to-date (OY4) expenses. The overall inventory value increased by $20.70 from the beginning period value of $3,176.70, with no variances recorded. This inventory snapshot serves as a baseline reference for the Mail Room, Copy Center, and Warehouse Logistics services solicitation (140G0126Q0153), which is set-aside for Women-Owned Small Businesses and covers a base period from September 1, 2026 through August 31, 2027, with four optional one-year renewal periods.
View the file
Other files
Show all 23
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Sheet1
| Attachment D: Inventory | |||||||
| DEPT | DECEMBER 1, 2019 through DECEMBER 31, 2019 | ||||||
| STOCK # | Description | Qty on Hd | PTD Issue | Unit $ | Inven $ | PTD $ | |
| 1 | CC0006 | 3-Hole, Blue, 8 1/2 x 11, 20 lb, Hammermill, ream | 20 | 0 | $3.59 | $71.80 | $ - |
| 1 | CC0024 | 3-Hole, Blue, 8 1/2 x 11, ream | 22 | 0 | $6.99 | $153.78 | $ - |
| 1 | CC0013 | 3-Hole, Goldenrod, 8 1/2 x 11, 20 lb, ream | 65 | 0 | $7.06 | $458.90 | $ - |
| 1 | CC0010 | 3-Hole, Hammermill, 8 1/2 x 11, 24 lb, White, ream | 10 | 0 | $7.02 | $70.20 | $ - |
| 1 | CC0007 | 3-Hole, Ivory, 8 1/2 x 11, 20 lb, Hammermill, ream | 20 | 0 | $5.59 | $111.80 | $ - |
| 1 | CC0021 | Copy Paper, Blue, 8 1/2 x 11, 20 lb, ream | 39 | 0 | $4.78 | $186.42 | $ - |
| 1 | CC0014 | Copy Paper, Buff, 8 1/2 x 11, 20 lb, ream | 16 | 0 | $4.78 | $76.48 | $ - |
| 1 | CC0023 | Copy Paper, Goldenrod, 8 1/2 x 11, 20 lb, ream | 14 | 0 | $5.31 | $74.34 | $ - |
| 1 | CC0022 | Copy Paper, Green, 8 1/2 x 11, 20 lb, ream | 7 | 0 | $5.89 | $41.23 | $ - |
| 1 | CC0020 | Coverstock, Green, 8 1/2 x 11, ream | 19 | 0 | $6.18 | $117.42 | $ - |
| 1 | CC0019 | Coverstock, Grey, 8 1/2 x 11, ream | 4 | 0 | $3.04 | $12.16 | $ - |
| 1 | CC0018 | Coverstock, White, 8 1/2 x 11, ream | 2 | 0 | $8.99 | $17.98 | $ - |
| 1 | CC0026 | Crystal Clear Cover, 8 1/2 x 11, .007 thick, 100 sheets/package (GBC:9742011G) | 1 | 0 | $17.57 | $17.57 | $ - |
| 1 | CC0009 | Hammermill, 11 x 17, Tabloid Paper, 24 lb, 96 bright, 5 reams per case | 1 | 0 | $13.24 | $13.24 | $ - |
| 1 | CC0027 | Hammermill, 32 lb, 8 1/2 x 11, Laser Jet Paper, High Gloss, ream | 6 | 0 | $8.50 | $51.00 | $ - |
| 1 | CC0008 | Hammermill, 8 1/2 x 11, 24 lb, 98 bright, Copy Paper, ream | 30 | 30 | $5.66 | $169.80 | $169.80 |
| 1 | CC0028 | Hammermill, 8 1/2 x 14, Legal-Size, 24 lb, 98 Bright, Order unit-ream | 2 | 0 | $7.58 | $15.16 | $ - |
| 1 | CC0031 | Shredder bags, Plastic waste bags for Intimus shredders, 25 bags per box | 3 | 0 | $ - | $ - | $ - |
| 1 | CC0005 | Spiral Binding, 1 1/2", Black, Order unit -10 count box (GBC: PC112BK) | 8 | 0 | $5.75 | $46.00 | $ - |
| 1 | CC0004 | Spiral Binding, 1", Black, Order unit-50 count box (GBC: PC100BK) | 26 | 0 | $4.45 | $115.70 | $ - |
| 1 | CC0002 | Spiral Binding, 1/2", Black, Order unit -100 count box (GBC: PC120BK) | 5 | 0 | $25.50 | $127.50 | $ - |
| 1 | CC0001 | Spiral Binding, 1/4", Black, Order unit -100 count box (GBC: PC140BK) | 3 | 0 | $2.42 | $7.26 | $ - |
| 1 | CC0003 | Spiral Binding, 3/4", Black, Order unit -100 count box (GBC: PC340BK) | 5 | 0 | $7.15 | $35.75 | $ - |
| 1 | CC0011 | Spiral Bindings, 2", Black, Order unit-40/box (GBC: PC200BK) | 4 | 0 | $13.91 | $55.64 | $ - |
| 1 | CC0025 | Spiral Bindings, 5/8, Black, Order unit-100/box (GBC: PC580BK) | 4 | 0 | $7.06 | $28.24 | $ - |
| 1 | CC0012 | Sprial Bindings, 3/8", Black, Order unit-100/box (GBC: PC380BK) | 6 | 0 | $7.48 | $44.88 | $ - |
| 1 | CC0029 | Staples for Bizhub C550, FS-504, #SK-602 14YK, Order unit-box | 1 | 0 | $79.00 | $79.00 | $ - |
| Variance | $ - | ||||||
| DEPT 1 | Line Items | Inven $ | PTD $ | ||||
| TOTAL | 27 | 343 | 30 | $2,199.25 | $169.80 | ||
| STOCK # | Description | Qty on Hd | PTD Issue | Unit $ | Inven $ | PTD $ | |
| 3 | MR0014-1 | 3" Red Cap #53 500/BX | 1 | 0 | $51.25 | $51.25 | $ - |
| 3 | MR0014-2 | 4" Red Cap #1063 250/BX | 2 | 0 | $41.27 | $82.54 | $ - |
| 3 | MR0013 | Bubbles, Large, 5/16 x 48 x 375' , Quantity-Each/Roll | 0 | 0 | $108.00 | $ - | $ - |
| 3 | MR0012 | Bubbles, Small, 12" x 3/16" x 750' 4 Rolls Per Bundle, Order Quantity-Bundle | 1 | 0 | $39.00 | $39.00 | $ - |
| 3 | MR0035 | Craftsman's Knife Blade (Razor Blade Type) Package | 5 | 0 | $0.54 | $2.70 | $ - |
| 3 | MR0022 | Envelope, Cushioned, 14 1/2 x 20 50/Box, Order unit-Box | 4 | 0 | $36.00 | $144.00 | $ - |
| 3 | MR0019 | Envelope, Cushioned, 7 1/4 x 12, 100/Box, Order unit-Box | 3 | 0 | $21.00 | $63.00 | $ - |
| 3 | MR0020 | Envelope, Cushioned, 9 1/2 x 14 1/2, 250/Box, Order unit-Box | 6 | 0 | $32.00 | $192.00 | $ - |
| 3 | MR0003 | Flatmailer, 11 x 13 1/2, 100/Bundle or Box, Order unit-Box | 0 | 0 | $40.00 | $ - | $ - |
| 3 | MR0009 | Kraft Paper, 8 x 36 x 900', 40#, Roll, Order unit-Roll | 0 | 0 | $39.00 | $ - | $ - |
| 3 | MR0023 | Postage Tape, Half Pad, 15 Pads/Carton, Order unit-Carton | 3 | 0 | $21.95 | $65.85 | $ - |
| 3 | MR0018 | Staples, Bostitch, 3/8", 5000/Box, Order unit- Box | 4 | 0 | $9.20 | $36.80 | $ - |
| 3 | MR0026 | Tape, 2" Clear, 110 yd/roll, Order unit-Roll | 6 | 0 | $4.75 | $28.50 | $ - |
| 3 | MR0021 | Tape, 2" Filament Tape, Order unit-Roll | 12 | 0 | $11.65 | $139.80 | $ - |
| 3 | MR0025 | Tape, Filament, 1", Order unit-Roll | 13 | 0 | $3.70 | $48.10 | $ - |
| 3 | MR0027 | Tape, Gummed Paper, 3" x 1000', 6 Rolls/Case, Order unit-Case | 1 | 0 | $96.00 | $96.00 | $ - |
| 3 | MR0024 | Tape, Labelguard, 4", Order unit-Roll | 0 | 0 | $4.25 | $ - | $ - |
| 3 | MR0036 | Utility Knife Each | 3 | 0 | $2.87 | $8.61 | $ - |
| 3 | MR0001 | WJ 20 Postal Meter Ink Cartridge | 0 | 0 | $48.95 | $ - | $ - |
| Variance | $ - | ||||||
| DEPT 3 | Line Items | Inven $ | PTD $ | ||||
| TOTAL | 19 | 64 | 0 | $998.15 | $ - | ||
| Line Items | Qty on Hd | PTD Issue | Inven $ | PTD $ | |||
| TOTAL | ALL | 46 | 407 | 30 | $3,197.40 | $169.80 | |
| RETURNS | Total Variance | $ - | |||||
| OY4 2019-2020 | Line Items | Inven $ | Variance | ||||
| BEGINNING PERIOD INVENTORY VALUE/LINE ITEMS | 46 | $3,176.70 | Adjustment | ||||
| ENDING PERIOD INVENTORY VALUE/LINE ITEMS | 46 | $3,197.40 | $ - | ||||
| DIFFERENCE of PERIOD INVEN VALUE/LINE ITEMS | 0 | $20.70 | |||||
| DECEMBER OY4 2019-2020 SCIENTIFIC & COMMERCIAL SYSTEMS CORP Logistics Departmental Inventory Values | |||||||
| DEPARTMENT | |||||||
| LINE ITEMS | Units on Hand | PTD Issue | YTD Issue | Inven $ | PTD Expense | OY4 Expense | |
| 1-Copy Center | 27 | 343 | 30 | 63 | $2,199.25 | $169.80 | $389.10 |
| Inven/Sales value increase/decrease | $ - | $ - | |||||
| 3-Mailroom | 19 | 64 | 0 | 0 | $998.15 | $ - | $ - |
| Inven/Sales value increase/decrease | $ - | $ - | |||||
| LINE ITEMS | Units on Hand | PTD Issue | YTD Issue | Inven $ | PTD Expense | OY4 Expense | |
| TOTAL | 46 | 407 | 30 | 63 | $3,197.40 | $169.80 | $389.10 |
File details come from the government source that posted it. Updated .