Part IIb: Substantive analytical procedure - gross margin The Gross margin analysis presents the sales compared to the cost of sales in table and graph formats and can be used to perform a substantive analytical procedure to provide evidence over the occurrence and valuation of revenue as well as related costs of goods sold. Required: Analyze the gross margin for the dining sales revenue stream (note that there is no cost of sales for lodging). Set a reasonably precise expectation for the gross margin percentage by month and a threshold for differences that need to be investigated. Using the Gross margin analysis, establish the relationship between the revenues and the cost of sales for the different months and compare this with your expectation. Assuming that the acceptable difference between the recorded amount and expected value for any given month is $5,000, are there any differences that don't match your expectations that require inquiry of PSU Hotel management? Part IIc: Cutoff testing - date analysis The Date analysis enables us to understand the timing of revenue journal entries and to identify days that represent a higher risk for further testing. Required: Understand the timing of period-end revenue journal entries and consider the related cutoff risk using the Date analysis. Note that since you do not have any FY17 data, you only are able to complete partial cutoff procedures. For hotel sales and dining sales (separately): Review the credit activity in the last five days of the year. -The last five days of the Fiscal Year are June 26 - 30. How does this compare with the prior year? -Comparison of Hotel Sales and Dining Sales can be found in the "Difference" column