this is marketing related with finance, based on how to increase roi through the executive game
junior1387
execgameworksheet-1.xlsSheet1
| step 1 | P0 | P1 | #change | %change | given | totalchange |
| econ | 100 | 100 | 0 | 0 | 1.4 | 0 |
| seas | 100 | 95 | -5 | -0.05 | 1 | -0.05 |
| ourprice | 25.6 | 25 | -0.6 | -0.0234375 | -5 | 0.1171875 |
| comprice | 25.6 | 26 | 0.4 | 0.015625 | 2 | 0.03125 |
| ourmart | 200000 | 195000 | -5000 | -0.025 | 0.25 | -0.00625 |
| compmark | 200000 | 300000 | 100000 | 0.5 | -0.1 | -0.05 |
| total change | 0.0421875 | |||||
| MPP0 | 109720 | |||||
| changP0P1 | 4628.8125 | |||||
| MPP1 | 114348.8125 | |||||
| step 2 | stockout | |||||
| MPP0 | 109720 | |||||
| salesp0 | 100000 | |||||
| 9720 | ||||||
| sales loss | 5832 | |||||
| adjMPP1 | 108516.8125 | |||||
| step 3 | did you like the results? | |||||
| step 4 | ||||||
| adjMPP1 | 108517 | |||||
| FGI | 12750 | |||||
| need to produce | 95767 | |||||
| step 5 | ||||||
| rmi | $1,200,000 | |||||
| cpu | $6.31 | |||||
| pfg | 190174.326465927 | |||||
| step 6 | ||||||
| plcP1 | 104643 | |||||
| OT | 146500.2 | |||||
| effic | 0.9151782728 | |||||
| step 7 | ||||||
| produce | 100,000 | |||||
| leftover pfg | 90,174 | for period 2 | ||||
| step 8 | P1 | P2 | #change | %change | given | totalchange |
| econ | 100 | 95 | -5 | -0.05 | 1.4 | -0.07 |
| seas | 95 | 115 | 20 | 0.2105263158 | 1 | 0.2105263158 |
| total change | 0.1405263158 | |||||
| adjMPP1 | 108517 | |||||
| estMP2 | 123766.494210526 | |||||
| leftover pfg | 90,174 | for period 2 | ||||
| min order P2 | 33,592 | |||||
| cpu | $6.31 | |||||
| ordermin | $211,968.64 | |||||
| step 9 | ||||||
| plcP1 | 104643 | depreciation | ||||
| do nothing | 101268.26325 | 2% | ||||
| 3374.73675 | inflation | |||||
| status quo | $ 236,231.57 | 1.25% | ||||
| add units | 1000 | |||||
| cost | $ 70,000.00 | |||||
| total inv | $ 306,231.57 | |||||
| step 10 | ||||||
| produce | 100,000 | |||||
| cost main | $ 75,000.00 | $ 0.75 | maintenance |
