My job is to prepare the Income Statement (IS) of my company. Wanted to understand, is there any way QLIK view can capture the impact of updating each line when compared with Previous Income statement. Assume that below listed the Previous IS
$ Mils
Net Rev
100
Contribution Margin
25
Processing cost
-5
Fixed cost
-10
Profit Before Tax
10
Profit Margin
10%
Volume 1000 units
Note: Above listed line items has further break up of costs under each line items.
If my Contribution margin is up by 10 mils when compared with previous one, what will be my impact on Profit margin