Attachment 09 - DLC Inventory Schedule Projection.xlsx

XLSX spreadsheet 24 KB Posted

Attached to
Amended DLS Material Handler Contract (VA-25-00000414) for warehouses DLS and SDC
Solicitation number
36C79125R0001
Issued by

About this file

The file is an Excel-based Inventory Schedule Projection for Fiscal Year 2023, detailing cycle count inventory dates for multiple product categories across four quarters. The inventory tracking covers eight distinct commodity types: Assistive Devices, Batteries, Accessories, Telehealth, Orthotic Softgoods, Assistive Listening Devices, Prosthetic Socks, and an additional Softgoods2 category. The document shows systematic inventory counting throughout the year, with varying frequency across quarters - ranging from 7 cycle counts in the 4th quarter to 12 cycle counts in the 3rd quarter, totaling 40 cycle counts for the year. Additionally, the schedule includes a Wall-to-Wall inventory period from September 4-15, 2023, which appears to be a comprehensive inventory check across all product categories. This inventory schedule is directly related to the Department of Veterans Affairs' Material Handler Contract (Solicitation Number 36C79125R0001) for DLS and SDC warehouses, suggesting it is a supporting document for inventory management within the contract's scope.

View the file

Other files

File Type Posted
Attachment 16 - Proposal Pricing Sheet-revised.xlsx XLSX spreadsheet
Attachment 12-QASP MHA-revised.pdf PDF
36C79125R0001 0001_1.docx DOCX document
OPPORTUNITIES-DESCRIPTION.docx DOCX document
S06 36C79125R0001 Amedment 0001.pdf PDF
QASP 36C79125DXXXX.pdf PDF
Material Handling Questions about RFP 36C79125R0001.pdf PDF
36C79125R0001_1.docx DOCX document
Attachment 13-Standard Warehouse Behavior and Prohibitions.pdf PDF
Attachment 15_Past Performance Questionnaire.pdf PDF
Attachment 01-Position Description for Material Handling.pdf PDF
Attachment 04 - SDC HDOS SOP.pdf PDF
Attachment 07 - SCA 2015-5419 Rev 26 CO.pdf PDF
Attachment 06 - SDC Warehouse Layout FY24.pdf PDF
Attachment 08 - SCA 2015-5017 Rev 26 IL.pdf PDF
Attachment 16 - Proposal Pricing Sheet.xlsx XLSX spreadsheet
Attachment 10 - Travel Request Form.docx DOCX document
Attachment 02 - DLC Warehousing SOP JAN 2024.pdf PDF
0-List of Attachments.pdf PDF
Attachment 05 - DLC Warehouse SQFT Layout.pptx PPTX presentation
Attachment 11 - 2024 Pay Calendar.pdf PDF
Attachment 12-Quality Assurance Surveillance Plan.pdf PDF
Attachment 14-Nondisplacement of Qualified Workers under Service Contracts.docx DOCX document
Attachment 03 - SDC EDOS SOP.pdf PDF
Show all 24

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

Invenotry Schedule FY23

Example of historical Inventory Schedule
Inventory DatesAssistive DevicesBatteriesAccessoriesTelehealthOrthotic Softgoods2Assistive Listening DevicesProsthetic SocksQtr. Avg All Commodities
Wednesday, October 26, 2022X
Friday, October 28, 2022X
Saturday, October 29, 2022X
Thursday, November 03, 2022X
Wednesday, November 16, 2022X
Tuesday, November 22, 2022X
Thursday, December 08, 2022X
Tuesday, December 13, 2022X
Thursday, December 15, 2022X
Friday, December 16, 2022X
Saturday, December 17, 2022X
Thursday, December 29, 2022
1st Quarter AverageERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
Total Cycle Counts122221111
Inventory DatesAssistive DevicesBatteriesAccessoriesTelehealthOrthotic Softgoods2Assistive Listening DevicesProsthetic SocksQtr. Avg All Commodities
Thursday, January 05, 2023X
Thursday, January 12, 2023
Thursday, February 02, 2023X
Tuesday, February 14, 2023X
Friday, February 17, 2023X
Saturday, February 18, 2023X
Tuesday, February 28, 2023X
Thursday, March 02, 2023X
Thursday, March 30, 2023X
Thursday, March 30, 2023XX
2nd Quarter AverageERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
Total Cycle Counts211112210
Inventory DatesAssistive DevicesBatteriesAccessoriesTelehealthOrthotic Softgoods2Assistive Listening DevicesProsthetic SocksQtr. Avg All Commodities
Thursday, April 06, 2023X
Tuesday, April 18, 2023X
Thursday, April 20, 2023X
Thursday, May 04, 2023X
Friday, May 05, 2023X
Saturday, May 06, 2023X
Thursday, May 18, 2023X
Thursday, May 18, 2023X
Thursday, June 01, 2023X
Thursday, June 01, 2023X
Thursday, June 15, 2023X
Thursday, June 22, 2023X
3rd Quarter AverageERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
Total Cycle Counts221122212
Inventory DatesAssistive DevicesBatteriesAccessoriesTelehealthOrthotic Softgoods2Assistive Listening DevicesProsthetic SocksQtr. Avg All Commodities
Thursday, July 06, 2023X
Thursday, July 13, 2023X
Tuesday, August 01, 2023X
Friday, July 28, 2023X
Saturday, July 29, 2023X
Thursday, August 03, 2023X
Wednesday, August 16, 2023X
4th Quarter AverageERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
Total Cycle Counts11111117
Total Cycle Counts YTD (Excluding Wall-to-Wall)665566640
WALL-TO-WALL (SEP 4-15)Assistive DevicesBatteriesAccessoriesTelehealthOrthotic SoftgoodsAssistive Listening DevicesProsthetic SocksColumn9
Tuesday, September 05, 2023X
Friday, September 08, 2023X
Tuesday, September 12, 2023X
Thursday, September 14, 2023XX
Friday, September 15, 2023X
Saturday, September 16, 2023X
OVERALL YEARLY AVERAGE (VA Standard of <= 90%)ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
WALL-TO-WALL AVERAGEERROR:#DIV/0!

&"-,Bold"&36FY 2023 INVENTORY SCHEDULE

&Z&F CURRENT AS OF &D

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