The above layout for the parameters for the modelling is shown above. These parameters are variable in nature and can be changed any time according to the requirement. The value of number of days for which we are going to analyse the process can be taken as per the requirement, costs for different parameters like circle, and stalls can be fixed as per the pricing model. Variable costs and fixed costs for the circles and stalls may vary depending on which day what is the need. We see the in this layout modelling the VBA or macro analysis has been done for simulating the result as entered. You can alter the number of days; you can change the prices per day. For simulation it is necessary to have the pre fixed design for what have to do or what not. All the formulas and output result information’s should be to the user.
This simulation will lead you to the price setting system page where you can get the information about the selling prices or sales per day with the cumulative revenue or cumulate purchasing costs and the overall profit. This is the first scree model the user will see while opening the excel sheet after clicking the start button. There are various key parameters by which the user can set accordingly.