A6 WV Consumables.xlsx

This is a consumables inventory spreadsheet for the West Virginia Lottery Commission covering the 2024-2026 period with 47 weeks remaining on the current purchase order (PO#4500306268). The document tracks lottery ticket stock and playslip inventory across nine product lines, including Mega Millions, Lotto America, Cash Pop, Keno, Powerball, Cash 25, Daily 3/4, and Millionaire For Life. Current quantities on hand range from 11,124 units for general ticket stock to 990,000 units for Cash Pop, with average weekly shipments varying from 611 to 5,000 units depending on the product. The spreadsheet indicates supply coverage periods ranging from 18.2 weeks for general ticket stock to 534.3 weeks for Cash Pop, demonstrating significant variance in consumption rates across lottery products.

The document reflects actual usage data comparing two one-year periods (05/2024-05/2025 and projected 05/2025-05/2026), enabling the state to forecast consumables requirements and optimize inventory management. Pack sizes for ticket stock range from 250 to 500 units depending on the product type. The spreadsheet contains multiple error references in the "Weeks to cover on current PO qty" column, suggesting incomplete data or formula issues that would require resolution for accurate supply planning. This inventory data serves as a baseline for the West Virginia Lottery's central gaming system solution procurement, informing vendors of current consumables demand and supporting capacity planning for the modern retail system implementation.