EXAMPLE NIEMD TEMPLATE Souper Bowl IncDecember 31,I 21116 Disaggregated Revenue Analytics Purpose: The purpose of this memo is to doctu'nent plausible trends and expectations for disaggregated revenue data and to identify specific days and locations that warrant fmtber substantive investigation. Data: We obtained a listing of daily sales by location from the client's IT system. We tested the details for mathematical accuracy, as summarized in the table below: $$ Store Type 1 Store pe 2 ___ Procedures: Based on our risk assessment process, we identified the following assertions as signicant risks related to revenuesfsales: ' Recorded sales occurred. +- Sales are accurately recorded. ' Sales are recorded in the proper period. Because Souper Bowl's operations are solely in the state of Maine, we obtained disaggregated data that reports daily sales by store location and store type. Based on discussions with management and our review of the board of director minutes, we are unaware of any new store locations or other major changes to operations during the year. Therefore, we expect prior year to be a reasonable baseline expectation for this year's revenues (e.g., similar seasonal trends). Because the business can also be impacted by weather conditions, which vary by year, we also perform analyses that consider changes in weather patterns to predict expected changes from the prior year's sales. We performed several analytics to identify unusual trends compared to the prior year's sales, taking weather conditions into consideration. The purpose of these analytics is to identify specific observations (or specific sets of observations) to select for further substantive testing. The analytics that we performed are as follows