Date of Birth
Sl.no EMP ID Name Gender Age Relation EMAIL ID
( DD MM YYYY)
NO ADDITION
Contact Number GMC Sum Insurd DOJ (DD MM YYYY) Balance Days
GPA Sum insured
Project GTL Sum insured Remark 23-Sep-25
SL NO EMP ID Name Relation DOB DOL
1 QB10348 Nirupam Ghosh Self 10/21/1983 Friday, October 4, 2024
Madhumita Ghosh Wife 10/15/1989 Friday, October 4, 2024
Chataki Ghosh Mother 3/23/1960 Friday, October 4, 2024
2 QB10405 Kayyam Sai Supraj Self 4/2/1999 Tuesday, October 15, 2024
Padma Kayyam Mother 1/1/1981 Tuesday, October 15, 2024
Ravindar Kayyam Father 9/6/1976 Tuesday, October 15, 2024
3 QB10364 Rishabh Goel Self 10/30/1997 Friday, October 4, 2024
Alka Goel MOTHER 9/15/1973 Friday, October 4, 2024
Jitendra Goyal FATHER 3/31/1971 Friday, October 4, 2024
4 QB10803 Hariharan Gunaseelan Self 6/8/2002 Thursday, October 17, 2024
Nirmala Gunaseelan Mother 5/13/1975 Thursday, October 17, 2024
Gunaseelan Jambulingam Father 4/2/1969 Thursday, October 17, 2024
5 QB10868 Amit kumar Self 4/28/2000 Friday, October 25, 2024
Bebi Gupta Mother 2/4/1979 Friday, October 25, 2024
Vijay Prakash Father 1/1/1970 Friday, October 25, 2024
Remarks Premium Pro-rata
GMC Sum Insured Policy end date Balance days Rater Premium GST @ 18%
Resigned 600000 Wednesday, October 1, 2025 362 7836 7771.594521 1398.887014
Resigned 600000 Wednesday, October 1, 2025 362 7836 7771.594521 1398.887014
Resigned 600000 Wednesday, October 1, 2025 362 7836 7771.594521 1398.887014
Resigned 600000 Wednesday, October 1, 2025 351 7836 7535.441096 1356.379397
Resigned 600000 Wednesday, October 1, 2025 351 7836 7535.441096 1356.379397
Resigned 600000 Wednesday, October 1, 2025 351 7836 7535.441096 1356.379397
Resigned 600000 Wednesday, October 1, 2025 362 7836 7771.594521 1398.887014
Resigned 600000 Wednesday, October 1, 2025 362 7836 7771.594521 1398.887014
Resigned 600000 Wednesday, October 1, 2025 362 7836 7771.594521 1398.887014
Resigned 600000 Wednesday, October 1, 2025 349 7836 7492.50411 1348.65074
Resigned 600000 Wednesday, October 1, 2025 349 7836 7492.50411 1348.65074
Resigned 600000 Wednesday, October 1, 2025 349 7836 7492.50411 1348.65074
Resigned 600000 Wednesday, October 1, 2025 341 7836 7320.756164 1317.73611
Resigned 600000 Wednesday, October 1, 2025 341 7836 7320.756164 1317.73611
Resigned 600000 Wednesday, October 1, 2025 341 7836 7320.756164 1317.73611
Premium
Payable Policy No.
9170.481534 142202/48/2025/3406
9170.481534 142202/48/2025/3406
9170.481534 142202/48/2025/3406
8891.820493 142202/48/2025/3406
8891.820493 142202/48/2025/3406
8891.820493 142202/48/2025/3406
9170.481534 142202/48/2025/3408
9170.481534 142202/48/2025/3408
9170.481534 142202/48/2025/3408
8841.154849 142202/48/2025/3406
8841.154849 142202/48/2025/3406
8841.154849 142202/48/2025/3406
8638.492274 142202/48/2025/3406
8638.492274 142202/48/2025/3406
8638.492274 142202/48/2025/3406
134137.29
Emp Id Name Relationship New Dependent Name
Date of
Date of Birth Existing Error Data To be corrected as
Married
Remarks
Relationship correction
Employee ID correction
GMC Premium Calculation for various Sum Insure
Premium paid (Excl GST) 11,864,407
Total Sum Insured 908,400,000
Premium Per lakh 1,306
Sum Insured (Bracket) Per lakh Cost Multipler Premium Payable (Excl GST)
6 Lakhs 1,306 6 7,836
ium Calculation for various Sum Insured Category
Premium Payable (Incl GST) No. Of Families Premium Excl GST GST @18% Premium Incl GST
9,247 1,514 11,864,407 2,135,593 14,000,000
11,864,407 2,135,593 14,000,000
