Scenario_2_MegaMill_AUP.pdf

PDF 399 KB Posted

Attached to
RFP #R005840 Financial Auditing and Related Services
Solicitation number
0000040206
Issued by
Sacramento County, San Francisco City, California

About this file

This document is a memorandum from the Mega Millions Consortium Multistate Lottery Association establishing agreed-upon procedures for member lottery annual reviews. The memorandum, issued by Joshua Johnston, Lead Director for the Mega Millions Consortium, on March 13, 2025, outlines mandatory review procedures for party lotteries conducting their fiscal year 2024-2025 annual examinations. The review period has been extended from March 31, 2025, to April 4, 2025, due to an upcoming game change. According to the Finance and Operations Procedures for Mega Millions (effective April 3, 2020), all required reviews must be completed and reports distributed no later than December 31, 2025. The primary modification to the procedures involves the expired prize reporting procedures outlined in Attachment 1, Section f, which now requires a sample size of only two draws from each selected month rather than a larger sample.

The memorandum contains three attachments detailing specific examination procedures for different lottery entities: Attachment 1 applies to individual member lottery operations and requires comprehensive testing including validation of draw activity reports, random selection of five draw dates, reconciliation of sales data across multiple reporting systems, verification of fixed prize calculations, comparison of settlement reports, inspection of expired prize data, analysis of cash option payments and investment purchases, and reconciliation of prize liability transfers. Attachments 2 and 3 establish similar but slightly modified procedures for the California Lottery and the Multi-State Lottery Association, respectively. All procedures emphasize reconciliation of financial data across multiple systems, verification of competitive bidding for investment purchases involving a minimum of three brokerage firms, and validation of all amounts reported to the Mega Millions Consortium. No pricing information, set-asides, or funding sources are included in this procedural memorandum.

View the file

Other files

Show all 11

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

To: Members of the Mega Millions Consortium Multistate Lottery Association

From: Joshua Johnston

Date: March 13, 2025

Re: Agreed Upon Procedures for Mega Millions

As the Mega Millions Lead Director, I hereby endorse the procedures required for party lotteries to conduct their annual reviews for Mega Millions. This authority is set out in the Mega Millions Members’ Finance and Operations Procedures for Mega Millions (effective 4/3/2020), Section 1.2.

There were no game changes during this review period; however, the expired prize reporting procedures in Attachment 1 section f have been adjusted. The sample size will only need to include 2 draws from each month selected.

Note: The review period has been extended from March 31, 2025 to April 4, 2025 due to the upcoming game change.

The Finance and Operations Procedures require these reviews to be complete and related reports distributed no later than December 31, 2025.

Attachment 1

a. Obtain from the (Your Lottery’s Name) the “Draw Activity” and the “Fixed Prize Analysis” for the period April 1, 2024 – April 4 , 2025 and attach those as Exhibits I and II, respectively. Prove the mathematical accuracy of the schedules and note any exceptions.

b. Randomly select five (5) draw dates from the period April 1, 2024 – April 4 , 2025.

c. For each draw date selected in step “b” above, compare the total amount of sales as shown on the daily sales report produced by the (Your Lottery’s Name)’s gaming system and the total amount of sales shown on the related daily sales report produced by Internal Control System (“ICS”), with the balance listed in the “sales” column for the respective draw date on the “Draw Activity” report attached as Exhibit I and ensure they are in agreement.

d. Calculate the total dollar amount of the fixed prizes for the draw dates selected in step “b” above, based on the total number of winners from the (Your Lottery’s Name)’s gaming system for each prize level and the prize structure of the Mega Millions fixed prizes (as defined in the official game rules). Compare the calculated expense with the amount listed in the “Actual Fixed Prizes” column for the respective draw date on the “Draw Activity” report attached as Exhibit I and ensure they are in agreement.

e. For each draw date selected in step “b” above, compare the amount of sales, actual fixed prizes, and share of fixed prizes shown on the “Draw Activity” report attached as Exhibit I to the amounts shown on the applicable Mega Millions Prize Settlement Reports and ensure they are in agreement.

f. For the period identified, randomly select two months and obtain the “Expired Prize

Settlement Report” distributed by the Virginia Lottery. For each of the two months selected, select 2 draws and obtain from the (Your Lottery Name) Internal Control System (ICS) the actual fixed prizes awarded, and the prizes unclaimed. Compare the ICS data back to the data reported from the Virginia Lottery for each draw of the subject months to ensure they are in agreement.

g. Compare the amounts shown as the total of the actual fixed prizes and the total of the share of fixed prizes on the “Draw Activity” report attached as Exhibit I to the applicable amounts shown on the “Fixed Prize Analysis” report attached as Exhibit II and ensure they are in agreement.

h. For the amount (if any) listed in the “Cash Options Amount” column of the “Draw

Activity” report attached as Exhibit I, obtain and compare the amount to the (Lottery Name)’s cash disbursement subsidiary records which summarize the funds disbursed to the prize winner.

i. For each purchase (if any) of investments associated with the jackpot prizes:

1. Review broker confirmations to verify that investments are funded in accordance with allowed investment vehicles per the multi-state rules, regulations or procedures.

2. Obtain the bid sheets and supporting documentation and verify the investments were purchased through a competitive bidding process involving a minimum of three brokerage firms.

3. Review the (Lottery Name)’s cash disbursement subsidiary records and confirm that the payment to the broker, plus the cash held by the Lottery for the initial cash payment, equals the “Cash Option Payment” on the settlement report applicable to that draw.

4. Obtain the Security Purchase report which lists the results of the security purchase and verify that the information reported to the group is accurate, including the annuity factor for the non-winning bidders.

j. Compare the total of the period transfers from/to (Your Lottery) to/from the Virginia

Lottery for settlement of the fixed prize liability as shown in the (Your Lottery’s Name)’s cash disbursement/cash receipt subsidiary records to the amount listed in the “Qtrly/Yrly Settlements Transfers In (Out)” column on the “Fixed Prize Analysis” report attached as Exhibit II and ensure they are in agreement.

k. Compare the balance listed as the (Your Lottery’s Name)’s receivable as of (period ending date as agreed to by member lotteries) for the fixed prizes as shown on the “Fixed Prize Analysis” report attached as Exhibit II to the (Your Lottery’s Name)’s financial accounting records and to the Mega Millions Prize Settlement Report as of (period ending date as agreed to by member lotteries) and ensure they are in agreement.

Attachment 2

a. Obtain from the California Lottery the “Draw Activity” for the period April 1, 2024 – April 4, 2025, and attach that as Exhibit I. Prove the mathematical accuracy of the schedule and note any exceptions.

b. Randomly select five (5) draw dates from the period April 1, 2024 – April 4, 2025.

as shown on the daily sales report produced by the California Lottery’s gaming system and the total amount of sales shown on the related daily sales report produced by the Internal Control System (“ICS”), with the balance listed in the “sales” column for the respective draw date on the “Draw Activity” report attached as Exhibit I and ensure they are in agreement.

d. For the amount (if any) listed in the “Cash Options Amount” column of the “Draw

Activity” report attached as Exhibit I, obtain and compare the amount to the California Lottery’s cash disbursement subsidiary records which summarize the funds disbursed to the prize winner.

e. For each purchase (if any) of investments associated with the jackpot prizes:

accordance with allowed investment vehicles per the multi-state rules, regulations or procedures; and

2. Obtain the bid sheets and supporting documentation and verify the investments were purchased through a competitive bidding process involving a minimum of three brokerage firms.

3. Review the California Lottery’s cash disbursement subsidiary records and confirm that the payment to the broker, plus the cash held by the Lottery for the initial cash payment, equals the “Cash Option Payment” on the settlement report applicable to that draw.

4. Obtain the Security Purchase report which lists the results of the security

Attachment 3

a. Obtain from the Multi-State Lottery Association the “Draw Activity” for the period April 1, 2024 – April 4, 2025, and attach that as Exhibit I. Prove the mathematical accuracy of the schedule and note any exceptions.

b. Randomly select five (5) draw dates from the period April 1, 2024 – April 4, 2025.

as shown on the daily sales report produced by the Multi-State Lottery Association Draw Reporting System and the total amount of sales shown on the related daily sales report produced by Centralized Automated Reporting System, with the balance listed in the “sales” column for the respective draw date on the “Draw Activity” report attached as Exhibit I and ensure they are in agreement.

d. For the amount (if any) listed in the “Cash Options Amount” column of the “Draw Activity” report attached as Exhibit I, obtain and compare the amount to the Multi- State Lottery Association’s cash disbursement subsidiary records which summarize the funds disbursed to the prize winner or specific member State Lottery and verify agreement.

e. For any cash disbursement to a specific member State Lottery, obtain further confirmation that the payment of the “Cash Options Amount” to the validated ticket winner was correctly and fully disbursed.

f. For each purchase (if any) of investments associated with the jackpot prizes:

accordance with allowed investment vehicles per the multi-state rules, regulations or procedures; and

2. Obtain the bid sheets and supporting documentation and verify the investments were purchased through a competitive bidding process involving a minimum of three brokerage firms.

3. Review the Multi-State Lottery Association’s cash disbursement subsidiary records and confirm that the payment to the broker, plus the cash held by the Multi-State Lottery Association for the initial cash payment, equals the “Cash Option Payment” on the settlement report applicable to that draw.

4. Obtain the Security Purchase report which lists the results of the security

Joshua Johnston Director, Washington’s Lottery Lead Director for the Mega Millions Consortium

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