In this sheet the user is able to step through each day of the simulation up until the performance. Information is displayed only about the current day and the previous day. The user can opt to manually input prices (in the yellow boxes) for the stalls and the circle for each day and see the resulting demand and ticket sales (calculated using the demand formulae). Alternatively the user can click the optimise button. The model will then calculate the optimal prices for both the stalls and the circle for that particular day (see macro specification). The sheet displays the total number of sales and the resulting profit for each day (shown in red). The sheet also displays a chart which shows costs and profits to date.
To move forwards through the simulation the user can press the relevant arrow button which will run a macro.All the information from this sheet is stored in the ‘report sheet’. At the end of the simulation, the user is shown a summary which displays total costs, revenue and profit. The user can select the ‘see report’ button and be taken to the report sheet in order to see an overall breakdown of ticket prices, costs, revenue and profit for each day.