The above shown picture is the layout of the price setting system in spread sheet modelling. This part contains the most valuable information about the future analysis of the cumulative revenue and cumulative profit. The analysis shows that at the end of 16 days the total number of sold seats were 250 but out of them circle seats were only 41 and stall seats were 149. The profit margin is around 24.3 percent in the complete business.
We can set the automatic maximization process for the each day for optimizing the prices and the seats sold per day. We will generate the sales and profit graph for the total seats sold in the last 15 days. These days can be changed and the estimation can be done for the more days on basis of initial input or past result obtained. We observe that the cumulative generated revenue for the 250 seats is 14,275 GBP and the total incurring cost for the process is 10,800 GBP which shows that the earn profit is around 3,475 GBP which is sufficient for 15 days.
The user can change the various parameters to see the different result. And if the user wants to see the sales for the last 15 days then he can click on ‘generate sales graph’ and the macro will run and will redirect to the sales graph as an output where on the screen user will see the total and day by day sales growth.
If the user wants to know about the total and individual profit generated by selling of tickets will click on ‘generate profitability graph’ where the user will be able to see the output as generated profit. Also the user can calculate the profit margin individual and cumulative.
This table also helps us in generating the performance wise report for each 15 days.