Appendix D Market Basket FY18-FY23.xlsx

This is a Market Basket projection spreadsheet for instant lottery ticket game production spanning fiscal years 2018 through 2023. The document outlines comprehensive forecasting data for a state lottery operation, detailing projected ticket quantities, game distributions, and retail values across nine price points ranging from $1.00 to $50.00. The analysis covers 295 total games distributed across six fiscal years, with cumulative ticket projections of approximately 761.87 million units. The market basket includes detailed breakdowns by ticket size (2.5X4 through 4X12 inches), number of games per price point, average ticket runs, and retail value allocations. Total retail value across the contract period is projected at $3.33 billion, with annual totals ranging from $483.82 million in FY18 to $621.2 million in FY23. The data indicates 236 primary games and 59 secondary games across the contract term.

The spreadsheet identifies separately priced required ticket and game features for both primary and secondary categories, including specialized printing requirements such as neon displays, metallic inks, holographic stock, scented inks, die-cut capabilities, and extended play marking systems. Maximum payout percentages vary by price point, ranging from 60 percent for $1.00 tickets to 80 percent for $50.00 tickets. The primary game category projects 609.496 billion in total value with 152.374 billion in secondary game value. The document provides detailed feature quantities measured in millions of games, enabling comprehensive cost modeling for the production of specialized lottery products with varying security features, finishing processes, and game mechanics throughout the six-year projection period.