The VBA macro for the analysis is the most important part while developing the spread sheet modelling for the drama price setting system. The first macro is used to generating the sales and profit graphs to show the complete analysis or trend of the sales per day and the profit per day. This output as forecasting enables the users to get the information of his effort in selling or buying the tickets or other things in business.
The second macro code is the most important code for completing the analysis perfectly as it gives the output of day by day ticket selling and profit performance and also the profit margin trend. The third macro code is for analysing or changing the variable parameters for forecasting the next few days or more day’s trend of ticket selling, kind of tickets selling and profit earned. The macro codes are very effective in modelling the simulation for the price, trend and profit earned with customer interest in demand. These three important macro codes are used here to analysing the pricing model. User can change any input variables as per his requirement. The output will be shown as ‘sales graph’ and ‘profit graph’.
This model for optimizing the prices and performance day by day for the Dramatic pricing setting system includes the best methodologies and also resulted in the positive. Simulation though variable parameters and changing as per the requirement is the good sign of evaluating the result and reach to the aim what the user need. This model results in the complete analysis for sales and profit margin as individual or total. The design team have the view that by changing the one parameter it will change the final output by which we can analyse the trend or effect of that input on the all variables. The best part is creating the multiple plots for viewing all the trends is good.
The modelling in different pages for each and every variable making the model a quite complex rather than showing all the variables on single page and all macros on one page and then result in another single page only. The models also have the problem of not correlating the data with the users. The other problem is to have more analysis part as per variable that is not in the model. This model can be improved by using some more functionality and design in it. Functions can be added as resulting in more variable output like forecasting analysis, trend observation of the model and correlation with the earlier tested data.