Simulation

[charlotte_13]

I am looking in to the possibilities of having a user being able to do simulations in an item-level way. Would like users to be able to laborate with an existing price of an item and see the effect on different financials. The key issue is that every item can have different price changes, it's not like a what if prices are lowered by 10%, more like item A -5%, item B +7%...item Z -2%. I have found out that Inforiver offers this functionality, but curious to see if someone has solved it in some different way?

[Anonymous]

Hi @charlotte_13 ,

I think your calcualtion is based on your data model, please share a sample file with me and show me a screenshot with me. This will make it easier for me to find the solution.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[charlotte_13]

Hi,

What I'm looking for is basically a way for user to simulate on an item level. In my data model I have item no and existing price. Would like user to be able to manually change price in interval-40 - +40% on individual item level (i.e one item -30% another +15%) and see total effect on turnover, profit etc. Number of items very large so what-if parameter really not an option