Attachment 09 - DLC Inventory Schedule Projection.xlsx
XLSX spreadsheet 24 KB Posted
- Solicitation number
- 36C79125R0001
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
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 Dates | Assistive Devices | Batteries | Accessories | Telehealth | Orthotic Softgoods2 | Assistive Listening Devices | Prosthetic Socks | Qtr. Avg All Commodities |
| Wednesday, October 26, 2022 | X | |||||||
| Friday, October 28, 2022 | X | |||||||
| Saturday, October 29, 2022 | X | |||||||
| Thursday, November 03, 2022 | X | |||||||
| Wednesday, November 16, 2022 | X | |||||||
| Tuesday, November 22, 2022 | X | |||||||
| Thursday, December 08, 2022 | X | |||||||
| Tuesday, December 13, 2022 | X | |||||||
| Thursday, December 15, 2022 | X | |||||||
| Friday, December 16, 2022 | X | |||||||
| Saturday, December 17, 2022 | X | |||||||
| Thursday, December 29, 2022 | ||||||||
| 1st Quarter Average | ERROR:#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 Counts | 1 | 2 | 2 | 2 | 2 | 1 | 1 | 11 |
| Inventory Dates | Assistive Devices | Batteries | Accessories | Telehealth | Orthotic Softgoods2 | Assistive Listening Devices | Prosthetic Socks | Qtr. Avg All Commodities |
| Thursday, January 05, 2023 | X | |||||||
| Thursday, January 12, 2023 | ||||||||
| Thursday, February 02, 2023 | X | |||||||
| Tuesday, February 14, 2023 | X | |||||||
| Friday, February 17, 2023 | X | |||||||
| Saturday, February 18, 2023 | X | |||||||
| Tuesday, February 28, 2023 | X | |||||||
| Thursday, March 02, 2023 | X | |||||||
| Thursday, March 30, 2023 | X | |||||||
| Thursday, March 30, 2023 | X | X | ||||||
| 2nd Quarter Average | ERROR:#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 Counts | 2 | 1 | 1 | 1 | 1 | 2 | 2 | 10 |
| Inventory Dates | Assistive Devices | Batteries | Accessories | Telehealth | Orthotic Softgoods2 | Assistive Listening Devices | Prosthetic Socks | Qtr. Avg All Commodities |
| Thursday, April 06, 2023 | X | |||||||
| Tuesday, April 18, 2023 | X | |||||||
| Thursday, April 20, 2023 | X | |||||||
| Thursday, May 04, 2023 | X | |||||||
| Friday, May 05, 2023 | X | |||||||
| Saturday, May 06, 2023 | X | |||||||
| Thursday, May 18, 2023 | X | |||||||
| Thursday, May 18, 2023 | X | |||||||
| Thursday, June 01, 2023 | X | |||||||
| Thursday, June 01, 2023 | X | |||||||
| Thursday, June 15, 2023 | X | |||||||
| Thursday, June 22, 2023 | X | |||||||
| 3rd Quarter Average | ERROR:#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 Counts | 2 | 2 | 1 | 1 | 2 | 2 | 2 | 12 |
| Inventory Dates | Assistive Devices | Batteries | Accessories | Telehealth | Orthotic Softgoods2 | Assistive Listening Devices | Prosthetic Socks | Qtr. Avg All Commodities |
| Thursday, July 06, 2023 | X | |||||||
| Thursday, July 13, 2023 | X | |||||||
| Tuesday, August 01, 2023 | X | |||||||
| Friday, July 28, 2023 | X | |||||||
| Saturday, July 29, 2023 | X | |||||||
| Thursday, August 03, 2023 | X | |||||||
| Wednesday, August 16, 2023 | X | |||||||
| 4th Quarter Average | ERROR:#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 Counts | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 7 |
| Total Cycle Counts YTD (Excluding Wall-to-Wall) | 6 | 6 | 5 | 5 | 6 | 6 | 6 | 40 |
| WALL-TO-WALL (SEP 4-15) | Assistive Devices | Batteries | Accessories | Telehealth | Orthotic Softgoods | Assistive Listening Devices | Prosthetic Socks | Column9 |
| Tuesday, September 05, 2023 | X | |||||||
| Friday, September 08, 2023 | X | |||||||
| Tuesday, September 12, 2023 | X | |||||||
| Thursday, September 14, 2023 | X | X | ||||||
| Friday, September 15, 2023 | X | |||||||
| Saturday, September 16, 2023 | X | |||||||
| 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 AVERAGE | ERROR:#DIV/0! |
&"-,Bold"&36FY 2023 INVENTORY SCHEDULE
&Z&F CURRENT AS OF &D
File details come from the government source that posted it. Updated .