Attachment_D_Inventory.xlsx

XLSX spreadsheet 24 KB Posted

Attached to
EROS Mail Room, Copy Center, & Warehouse Logistics
Solicitation number
140G0126Q0153
Issued by

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
DEPTDECEMBER 1, 2019 through DECEMBER 31, 2019
STOCK #DescriptionQty on HdPTD IssueUnit $Inven $PTD $
1CC00063-Hole, Blue, 8 1/2 x 11, 20 lb, Hammermill, ream200$3.59$71.80$ -
1CC00243-Hole, Blue, 8 1/2 x 11, ream220$6.99$153.78$ -
1CC00133-Hole, Goldenrod, 8 1/2 x 11, 20 lb, ream650$7.06$458.90$ -
1CC00103-Hole, Hammermill, 8 1/2 x 11, 24 lb, White, ream100$7.02$70.20$ -
1CC00073-Hole, Ivory, 8 1/2 x 11, 20 lb, Hammermill, ream200$5.59$111.80$ -
1CC0021Copy Paper, Blue, 8 1/2 x 11, 20 lb, ream390$4.78$186.42$ -
1CC0014Copy Paper, Buff, 8 1/2 x 11, 20 lb, ream160$4.78$76.48$ -
1CC0023Copy Paper, Goldenrod, 8 1/2 x 11, 20 lb, ream140$5.31$74.34$ -
1CC0022Copy Paper, Green, 8 1/2 x 11, 20 lb, ream70$5.89$41.23$ -
1CC0020Coverstock, Green, 8 1/2 x 11, ream190$6.18$117.42$ -
1CC0019Coverstock, Grey, 8 1/2 x 11, ream40$3.04$12.16$ -
1CC0018Coverstock, White, 8 1/2 x 11, ream20$8.99$17.98$ -
1CC0026Crystal Clear Cover, 8 1/2 x 11, .007 thick, 100 sheets/package (GBC:9742011G)10$17.57$17.57$ -
1CC0009Hammermill, 11 x 17, Tabloid Paper, 24 lb, 96 bright, 5 reams per case10$13.24$13.24$ -
1CC0027Hammermill, 32 lb, 8 1/2 x 11, Laser Jet Paper, High Gloss, ream60$8.50$51.00$ -
1CC0008Hammermill, 8 1/2 x 11, 24 lb, 98 bright, Copy Paper, ream3030$5.66$169.80$169.80
1CC0028Hammermill, 8 1/2 x 14, Legal-Size, 24 lb, 98 Bright, Order unit-ream20$7.58$15.16$ -
1CC0031Shredder bags, Plastic waste bags for Intimus shredders, 25 bags per box30$ -$ -$ -
1CC0005Spiral Binding, 1 1/2", Black, Order unit -10 count box (GBC: PC112BK)80$5.75$46.00$ -
1CC0004Spiral Binding, 1", Black, Order unit-50 count box (GBC: PC100BK)260$4.45$115.70$ -
1CC0002Spiral Binding, 1/2", Black, Order unit -100 count box (GBC: PC120BK)50$25.50$127.50$ -
1CC0001Spiral Binding, 1/4", Black, Order unit -100 count box (GBC: PC140BK)30$2.42$7.26$ -
1CC0003Spiral Binding, 3/4", Black, Order unit -100 count box (GBC: PC340BK)50$7.15$35.75$ -
1CC0011Spiral Bindings, 2", Black, Order unit-40/box (GBC: PC200BK)40$13.91$55.64$ -
1CC0025Spiral Bindings, 5/8, Black, Order unit-100/box (GBC: PC580BK)40$7.06$28.24$ -
1CC0012Sprial Bindings, 3/8", Black, Order unit-100/box (GBC: PC380BK)60$7.48$44.88$ -
1CC0029Staples for Bizhub C550, FS-504, #SK-602 14YK, Order unit-box10$79.00$79.00$ -
Variance$ -
DEPT 1Line ItemsInven $PTD $
TOTAL2734330$2,199.25$169.80
STOCK #DescriptionQty on HdPTD IssueUnit $Inven $PTD $
3MR0014-13" Red Cap #53 500/BX10$51.25$51.25$ -
3MR0014-24" Red Cap #1063 250/BX20$41.27$82.54$ -
3MR0013Bubbles, Large, 5/16 x 48 x 375' , Quantity-Each/Roll00$108.00$ -$ -
3MR0012Bubbles, Small, 12" x 3/16" x 750' 4 Rolls Per Bundle, Order Quantity-Bundle10$39.00$39.00$ -
3MR0035Craftsman's Knife Blade (Razor Blade Type) Package50$0.54$2.70$ -
3MR0022Envelope, Cushioned, 14 1/2 x 20 50/Box, Order unit-Box40$36.00$144.00$ -
3MR0019Envelope, Cushioned, 7 1/4 x 12, 100/Box, Order unit-Box30$21.00$63.00$ -
3MR0020Envelope, Cushioned, 9 1/2 x 14 1/2, 250/Box, Order unit-Box60$32.00$192.00$ -
3MR0003Flatmailer, 11 x 13 1/2, 100/Bundle or Box, Order unit-Box00$40.00$ -$ -
3MR0009Kraft Paper, 8 x 36 x 900', 40#, Roll, Order unit-Roll00$39.00$ -$ -
3MR0023Postage Tape, Half Pad, 15 Pads/Carton, Order unit-Carton30$21.95$65.85$ -
3MR0018Staples, Bostitch, 3/8", 5000/Box, Order unit- Box40$9.20$36.80$ -
3MR0026Tape, 2" Clear, 110 yd/roll, Order unit-Roll60$4.75$28.50$ -
3MR0021Tape, 2" Filament Tape, Order unit-Roll120$11.65$139.80$ -
3MR0025Tape, Filament, 1", Order unit-Roll130$3.70$48.10$ -
3MR0027Tape, Gummed Paper, 3" x 1000', 6 Rolls/Case, Order unit-Case10$96.00$96.00$ -
3MR0024Tape, Labelguard, 4", Order unit-Roll00$4.25$ -$ -
3MR0036Utility Knife Each30$2.87$8.61$ -
3MR0001WJ 20 Postal Meter Ink Cartridge00$48.95$ -$ -
Variance$ -
DEPT 3Line ItemsInven $PTD $
TOTAL19640$998.15$ -
Line ItemsQty on HdPTD IssueInven $PTD $
TOTALALL4640730$3,197.40$169.80
RETURNSTotal Variance$ -
OY4 2019-2020Line ItemsInven $Variance
BEGINNING PERIOD INVENTORY VALUE/LINE ITEMS46$3,176.70Adjustment
ENDING PERIOD INVENTORY VALUE/LINE ITEMS46$3,197.40$ -
DIFFERENCE of PERIOD INVEN VALUE/LINE ITEMS0$20.70
DECEMBER OY4 2019-2020 SCIENTIFIC & COMMERCIAL SYSTEMS CORP Logistics Departmental Inventory Values
DEPARTMENT
LINE ITEMSUnits on HandPTD IssueYTD IssueInven $PTD ExpenseOY4 Expense
1-Copy Center273433063$2,199.25$169.80$389.10
Inven/Sales value increase/decrease$ -$ -
3-Mailroom196400$998.15$ -$ -
Inven/Sales value increase/decrease$ -$ -
LINE ITEMSUnits on HandPTD IssueYTD IssueInven $PTD ExpenseOY4 Expense
TOTAL464073063$3,197.40$169.80$389.10

File details come from the government source that posted it. Updated .