Dear Friends!
Following predetermined data present a scenario where final outcome(profits) were achieved when the other variables are fixed to their given levels. Using What if analyst, I need to see the variations that may have on expenses, commissions, claims & profits, if the Revenue is increased by 15%. Appreciate If I am presented with clearly outlined steps with applied expressions so that I will be able to grasp the basic of this analysis! Please refer the data below!
Thanks
Neville
| | | | | | | | |
| CENTERS | REVENUE | EXPENSES | COMMISSIONS | CLAIMS | PROFIT/LOSS | |
| XYZ | 250,000 | 50,000 | 25,000 | 75,000 | 100,000 | | |
| ABC | 350,000 | 45,000 | 35,000 | 65,000 | 205,000 | | |
| AXY | 450,000 | 55,000 | 32,500 | 70,000 | 292,500 | | |
| MPC | 350,000 | 35,000 | 25,000 | 60,000 | 230,000 | | |
| | | | | | | | |
| Note: | | | | | | | |
| If revenue is increased by 15%,what could be the impact on expenses,commissions,claims & profits? |
| | | | | | | | |
| | | | | | | | |
