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?
