5 Replies Latest reply: Oct 29, 2014 4:12 AM by Mafaz Jaufer RSS

    what if analysis?

      I want to create a what if analysis to find budget variance

      eg:

      Projection

      Load %

       

      I have Projection and I want with in those projection if I Load some amount of % what will happened to budget and if budget is lose

      or - figure what is the % of quantity I have to Load. can any one help me on above scenario? Thanks in advance!!

       

       

      MonthsbudgetProjectionLoaded
      JAN1000090009020
      FEB500004500044500
      MAR200002000019000
      APR200002000020000
      MAY400003950029500
      JUN300002850018500
      JUL1000097509720
      AUG500005000049000
      SEP300003000030000

       

      lets say I got a table as above and I want to know when the Projection is some value or qty when I increase or decrease Loaded in % I want to know what will happened to Budget is it a lost or profit also if it is a lost how much more I have to load every next month to achieve what was projected