What If Analyst

nevilledhamsiri — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: What If Analyst

Frank_Hartmann — Fri, 06 Oct 2017 18:54:32 GMT

Did you already read this?

What If analysis.doc

Re: What If Analyst

nevilledhamsiri — Sat, 07 Oct 2017 14:41:54 GMT

Thanks Frank

Neville

topic Re: What If Analyst in QlikView

What If Analyst

Re: What If Analyst

Re: What If Analyst