[Business Simulation] Summary Report Template (Excel)

Capsim Summary report.xlsx

0.73MB

This is a simulation summary report for the Capsim player. 

You should copy and paste the data into sheets which are colored with orange from your Rounds report provided by Capsim, and eliminate $ and (-) signs by using find and replacement function. Then, change the data type from general to numbers. For the finance sheet, the transpose function will help you not to type all the data manually. 

Before you start the simulation you can refer recommendation per strategy you choose. Since this is not perfect, if you want to change the recommendation contents, go for it, or ask me to update it through the comment. Please use strategy types only on the strategy set.  

After you move your data into the sheets, If you put which round you want to see on the sky blue colored cell, it will automatically change the overall charts and data. 

Pic 1.

If you put your decisions from your proforma, it will show your score. 

It will show the ideal position of each segment if you choose the round at the slicer. 

By filtering out the rounds, you can compare what you've done and what your competitor did. 

If you click the chart, you may see this icon. 

From here, you can choose which data you want to see. For instance, for the marketing sector, you can see price, unit sold, stock out, age, performance, size, reliability, sales budget, customer accessibility, promo budget, customer awareness, and customer satisfaction data.  

Again, reminder, this template does not contain perfect information or strategy, so please do not rely on this too much. Hope this could be helpful to you and good luck with your simulation. 

If you want to change some data on the protected sheets, please leave comments. :)