8 Replies Latest reply: Aug 18, 2017 2:53 AM by Anand Chouhan RSS

    How to calculate variance?

    Arshad Hussain

      Required

               

      Year2015-162016-17VarianceGrand Total
      HEADSUB HEADPaxFlightsPaxFlightsPaxFlightsPaxFlights
      A1--82,371354100%100%82,371354
      3--111,404457100%100%111,404457
      Head Total--193,775811100%100%193,775811
      B1--41,307255100%100%41,307255
      3--76,686753100%100%76,686753
      Head Total--117,9931,008100%100%117,9931,008
      C11,351,15816,0981,396,67014,9083%-7%2,747,82831,006
      21,948,87025,1102,283,29424,60617%-2%4,232,16449,716
      35,292,49745,8925,621,98947,4456%3%10,914,48693,337
      41,300,46510,0551,152,38310,415-11%4%2,452,84820,470
      Head Total9,892,99097,15510,454,33697,3746%0%20,347,326194,529
      Grand Total 9,892,99097,15510,766,10499,1939%2%20,659,094196,348

       

      Actual

                    

      Year2015-162015-162015-162015-162016-172016-172016-172016-17Grand TotalGrand TotalGrand TotalGrand Total
      HeadSub HeadPaxFlightsPax VarianceFlight VariancePaxFlightsPax VarianceFlight VariancePaxFlightsPax VarianceFlight Variance
      A1----82,371354--82,371354--
      A3----111,404457--111,404457--
      AHead Total----193,775811--193,775811--
      B1----41,307255--41,307255--
      B3----76,686753--76,686753--
      BHead Total----117,9931,008--117,9931,008--
      C11,351,15816,098--1,396,67014,908--2,747,82831,006--
      C21,948,87025,110--2,283,29424,606--4,232,16449,716--
      C35,292,49745,892--5,621,98947,445--10,914,48693,337--
      C41,300,46510,055--1,152,38310,415--2,452,84820,470--
      CHead Total9,892,99097,155--10,454,33697,374--20,347,326194,529--
      Grand Total 9,892,99097,155--10,766,10499,193--20,659,094196,348--