457,603 Members | 1,388 Online Need help? Post your question and get tips & solutions from a community of 457,603 IT Pros & Developers. It's quick & easy.

# Help with formula

 P: 2 I need some help on computing this formula especially the best way to capture the data that is whether to use excel or ms access, then with the data compute the formula. The excercise is for bonus scheme calculation which is depended on various performance indicators. Global Incentive (GI) General Formula GI = {(By-1) * (P/N)} + {X * (COMa-COMm) * (WRpa+UFWpa+CEpa+MRpa+TApa) GI = Global Incentive that relate to the entire company By-1 = The base given by the average bonus for the previous year P/N = Aggregate performance on the various performance indicators. The performance is discrete, taking 1 if the actual performance has been achieved relative to the minimum performance standard or zero otherwise X = Maximum incentive fee payable in a given month and is a certain percentage (e.g 30%) of the difference between the actual and the minimum cash operating margin COMa and COMm = Respectively, the actual and minimum cash operating margin given by the difference between revenue collections (excluding deposits and grants) and operations expenditure on accrual basis WR = Working ratio given as % of total operating expenses as a proportion of actual billing UFW = Unaccounted for water given as the difference between water produced and water accounted (either sold or otherwise) CE = Connection efficiency given as a ratio of active connections as a proportion of total connections MR = Meter reading given as a ratio of meters read as a proportion of total connections TA = Total Arrears Pa = percentage increamental achievement given as Pa = Ia Im/It-Im Where Im = is the indicators minimum performance standard given as the average performance for the previous year It =is the indicators target performance for a given month Ia = is the indicators actual performance for a given month Thank you Patrick Sep 21 '08 #1 