Promotion/MACP Option form Calculator

Promotion/MACP Option form Calculator

Pay Fixation in the New Pay Structure : The fitment of each employee in the new pay matrix is proposed to be done by multiplying his/her basic pay on the date of implementation by a factor of 2.57.

The figure so arrived at is to be located in the new pay matrix, in the level that corresponds to the employee’s grade pay on the date of implementation, except in cases where the Commission has recommended a change in the existing grade pay. If the identical figure is not available in the given level, the next higher figure closest to it would be the new pay of the concerned employee.

“5200-20200”, “PB2” => “9300-34800”, “PB3” => “15600-39100”, “PB4” => “37400-67000”);
$grade_pay_list = array(“1800”, “1900”, “2000”, “2400”, “2800”, “4200”, “4600”, “4800”, “5400”, “6600”, “7600”, “8700”, “8900”, “10000”);
$new_grade_pay_list = array(“PB1_1900” => “1900”,”PB1_2000″ => “2000”, “PB1_2400” => “2400”,”PB1_2800″ => “2800”,”PB2_4200″ => “4200”,”PB2_4600″ => “4600”,”PB2_4800″ => “4800”,”PB2_5400″ => “5400”,”PB3_5400″ => “5400A”,”PB3_6600″ => “6600”,”PB3_7600″ => “7600”, “PB4_8700” => “8700”,”PB4_8900″ => “8900”,”PB4_10000″ => “10000”);
$data_list = array(“PB1_1800” => array(“level” => “1”, “percent” => 2.57, “preset” => array(18000,18500,19100,19700,20300,20900,21500,22100,22800,23500,24200,24900,25600,26400,27200,28000,28800,29700,30600,31500,32400,33400,34400,35400,36500,37600,38700,39900,41100,42300,43600,44900,46200,47600,49000,50500,52000,53600,55200,56900)),
“PB1_1900” => array(“level” => “2”, “percent” => 2.57, “preset” => array(19900,20500,21100,21700,22400,23100,23800,24500,25200,26000,26800,27600,28400,29300,30200,31100,32000,33000,34000,35000,36100,37200,38300,39400,40600,41800,43100,44400,45700,47100,48500,50000,51500,53000,54600,56200,57900,59600,61400,63200)),
“PB1_2000” => array(“level” => “3”, “percent” => 2.57, “preset” => array(21700,22400,23100,23800,24500,25200,26000,26800,27600,28400,29300,30200,31100,32000,33000,34000,35000,36100,37200,38300,39400,40600,41800,43100,44400,45700,47100,48500,50000,51500,53000,54600,56200,57900,59600,61400,63200,65100,67100,69100)),
“PB1_2400” => array(“level” => “4”, “percent” => 2.57, “preset” => array(25500,26300,27100,27900,28700,29600,30500,31400,32300,33300,34300,35300,36400,37500,38600,39800,41000,42200,43500,44800,46100,47500,48900,50400,51900,53500,55100,56800,58500,60300,62100,64000,65900,67900,69900,72000,74200,76400,78700,81100)),
“PB1_2800” => array(“level” => “5”, “percent” => 2.57, “preset” => array(29200,30100,31000,31900,32900,33900,34900,35900,37000,38100,39200,40400,41600,42800,44100,45400,46800,48200,49600,51100,52600,54200,55800,57500,59200,61000,62800,64700,66600,68600,70700,72800,75000,77300,79600,82000,84500,87000,89600,92300)),
“PB2_4200” => array(“level” => “6”, “percent” => 2.57, “preset” => array(35400,36500,37600,38700,39900,41100,42300,43600,44900,46200,47600,49000,50500,52000,53600,55200,56900,58600,60400,62200,64100,66000,68000,70000,72100,74300,76500,78800,81200,83600,86100,88700,91400,94100,96900,99800,102800,105900,109100,112400)),
“PB2_4600” => array(“level” => “7”, “percent” => 2.57, “preset” => array(44900,46200,47600,49000,50500,52000,53600,55200,56900,58600,60400,62200,64100,66000,68000,70000,72100,74300,76500,78800,81200,83600,86100,88700,91400,94100,96900,99800,102800,105900,109100,112400,115800,119300,122900,126600,130400,134300,138300,142400)),
“PB2_4800” => array(“level” => “8”, “percent” => 2.57, “preset” => array(47600,49000,50500,52000,53600,55200,56900,58600,60400,62200,64100,66000,68000,70000,72100,74300,76500,78800,81200,83600,86100,88700,91400,94100,96900,99800,102800,105900,109100,112400,115800,119300,122900,126600,130400,134300,138300,142400,146700,151100)),
“PB2_5400” => array(“level” => “9”, “percent” => 2.57, “preset” => array(53100,54700,56300,58000,59700,61500,63300,65200,67200,69200,71300,73400,75600,77900,80200,82600,85100,87700,90300,93000,95800,98700,101700,104800,107900,111100,114400,117800,121300,124900,128600,132500,136500,140600,144800,149100,153600,158200,162900,167800)),
“PB3_5400” => array(“level” => “10”, “percent” => 2.57, “preset” => array(56100,57800,59500,61300,63100,65000,67000,69000,71100,73200,75400,77700,80000,82400,84900,87400,90000,92700,95500,98400,101400,104400,107500,110700,114000,117400,120900,124500,128200,132000,136000,140100,144300,148600,153100,157700,162400,167300,172300,177500)),
“PB3_6600” => array(“level” => “11”, “percent” => 2.57, “preset” => array(67700,69700,71800,74000,76200,78500,80900,83300,85800,88400,91100,93800,96600,99500,102500,105600,108800,112100,115500,119000,122600,126300,130100,134000,138000,142100,146400,150800,155300,160000,164800,169700,174800,180000,185400,191000,196700,202600,208700)),
“PB3_7600” => array(“level” => “12”, “percent” => 2.57, “preset” => array(78800,81200,83600,86100,88700,91400,94100,96900,99800,102800,105900,109100,112400,115800,119300,122900,126600,130400,134300,138300,142400,146700,151100,155600,160300,165100,170100,175200,180500,185900,191500,197200,203100,209200)),
“PB4_8700” => array(“level” => “13”, “percent” => 2.57, “preset” => array(118500,122100,125800,129600,133500,137500,141600,145800,150200,154700,159300,164100,169000,174100,179300,184700,190200,195900,201800,207900,214100)),
“PB4_8900” => array(“level” => “13A”, “percent” => 2.57, “preset” => array(131100,135000,139100,143300,147600,152000,156600,161300,166100,171100,176200,181500,186900,192500,198300,204200,210300,216600)),
“PB4_10000” => array(“level” => “14”, “percent” => 2.57, “preset” => array(144200,148500,153000,157600,162300,167200,172200,177400,182700,188200,193800,199600,205600,211800,218200)));

if(isset($_POST[‘calculate’]))
{
function get_closest_from_preset($val, $preset_list, $consider_equal = 0){
$return_value = $val;

for($i = 0; $i < count($preset_list); $i++){ if($consider_equal){ if((float)$preset_list[$i] >= (float)$val){
$return_value = $preset_list[$i];
break;
}
}
else if((float)$preset_list[$i] > (float)$val){
$return_value = $preset_list[$i];
break;
}
}

return $return_value;
}

$entry_pay = $_POST[‘entry_pay’];
$pay_band = $_POST[‘pay_band’];
$old_grade_pay = $_POST[‘grade_pay’];
$promotion_date = $_POST[‘promotion_date’];
$new_grade_pay = $_POST[‘new_grade_pay’];

$pay_in_payband = $entry_pay – $old_grade_pay;
$selected_data = $data_list[$pay_band . ‘_’ . $old_grade_pay];
$level = $selected_data[“level”];
$percent_raise = $selected_data[“percent”];
$preset = $selected_data[“preset”];
$new_grade_pay_val = (int)$new_grade_pay_list[$new_grade_pay];

//Option A
$opt_a_increase = round($entry_pay * $percent_raise);
$opt_a_basic_fixation = get_closest_from_preset($opt_a_increase, $preset, 1);
$opt_a_basic_fixation_increment = get_closest_from_preset($opt_a_basic_fixation, $preset);
$opt_a_selected_data = $data_list[$new_grade_pay];
$opt_a_level = $opt_a_selected_data[“level”];
$opt_a_preset = $opt_a_selected_data[“preset”];
$opt_a_new_basic_fixation = get_closest_from_preset($opt_a_basic_fixation_increment, $opt_a_preset, 1);
$opt_a_new_basic = get_closest_from_preset($opt_a_new_basic_fixation, $opt_a_preset);

//Option B
$opt_b_new_basic = $pay_in_payband + $new_grade_pay_val;
$opt_b_increase_1 = $entry_pay + (ceil(floor($entry_pay * .03) / 10) * 10);
$opt_b_increase_2 = ($opt_b_increase_1 + (ceil(floor($opt_b_increase_1 * .03) / 10) * 10)) – $old_grade_pay;
$opt_b_increase = $opt_b_increase_2 + $new_grade_pay_val;
$opt_b_revised = get_closest_from_preset(round($opt_b_increase * $percent_raise), $opt_a_preset, 1);
$opt_b_revised_final = get_closest_from_preset($opt_b_revised, $opt_a_preset);

//Option C
$opt_c_entry_increase = (ceil(floor($entry_pay * .03) / 10) * 10);
$opt_c_increase = $pay_in_payband + $new_grade_pay_val + $opt_c_entry_increase;
$opt_c_percent_raise = round($opt_c_increase * $percent_raise);
$opt_c_revised = get_closest_from_preset($opt_c_percent_raise, $opt_a_preset, 1);
$opt_c_revised_final = get_closest_from_preset($opt_c_revised, $opt_a_preset);
}
?>