Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-11470

Superheat - Billing Summary Report - Premium is not calculating correctly

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
    • Environment:
      Production
    • Bug Type:
      Functional
    • Bug Severity:
      Critical
    • Module:
      BenAdmin - Report
    • Reported by:
      Client
    • Company:
      All Clients/Multiple Clients
    • Item State:
      Production Complete - Closed
    • Sprint:
      WT Sprint 41

      Description

      Please review the Billing Summary Report in Production - Client Name - Superheat FGH. This needs to be corrected as soon as possible, this is affecting the client and they as many other clients use this report to submit their volume and counts to their Life carriers to pay their premiums.

      The following plan premiums are not calculating correctly:
      Plan 1:
      Basic Life - Basic Life - Lincoln Financial Group
      Rate Name: 2016 - 2018 Basic Life-Basic Life
      Report shows $3,134.56, but when you manually calculate it the premium comes out to be $3,134.05 (volume*rate/coverage divisor) (16072050.00*0.1950/1000). There is a difference of $0.51.

      Plan 2:
      Plan: Basic AD&D-Basic AD&D-Lincoln Financial Group
      Rate Name: 2016 - 2018 Basic AD&D-Basic AD&D
      Report shows $401.33, but when you manually calculate it the premium comes out to be $400.83 (volume*rate/coverage divisor) (16033050.00*0.0250/1000). There is a difference of $0.50.

      Plan 3:
      Plan: Voluntary Child Life-Voluntary Child Life-Lincoln Financial Group
      Rate Name: 2016 - 2018 Vol Child life-Child Life
      Report shows $75.62, but when you manually calculate it the premium comes out to be $75.73 (volume*rate/coverage divisor) (380000.00*0.1993/1000). There is a difference of $0.11.

      This is also similar to WT 9738.

      Deborah Mascot
      lisa davison

        Attachments

        1. 1.png
          1.png
          74 kB
        2. 2.png
          2.png
          72 kB
        3. 3.png
          3.png
          57 kB
        4. 4.png
          4.png
          97 kB
        5. BasicAD&D_ratCal_OK.jpg
          BasicAD&D_ratCal_OK.jpg
          159 kB
        6. BasicLife_ratCal_OK.jpg
          BasicLife_ratCal_OK.jpg
          166 kB
        7. BillingSummaryReport.xls
          12 kB
        8. FW 1211 Sprint - Development Approval.msg
          51 kB
        9. Superheat - Billing Summary Report - Calc is not correct - Basic Life_Basic ADD.PNG
          Superheat - Billing Summary Report - Calc is not correct - Basic Life_Basic ADD.PNG
          113 kB
        10. Superheat - Billing Summary Report - Calc is not correct - Child Life.PNG
          Superheat - Billing Summary Report - Calc is not correct - Child Life.PNG
          57 kB
        11. VolChildLife_ratCal_OK.jpg
          VolChildLife_ratCal_OK.jpg
          156 kB
        12. WT-11470_Discrepancy.xlsx
          21 kB
        13. WT-11470.jpg
          WT-11470.jpg
          256 kB
        14. WT-11470 - Superheat - Billing Summary Report_Test Scenarios.xls
          10 kB

          Issue Links

            Activity

            prasanna Prasanna Karlekar (Inactive) logged work - 11/Oct/17 01:00 AM
            • Time Spent:
              1h
               

              Stored Procedure debug

            prasanna Prasanna Karlekar (Inactive) logged work - 11/Oct/17 07:30 PM
            • Time Spent:
              2.25h
               

              Issue verification - Stored Procedure debug
              Script to pull the affected records
              JIRA update

            prasanna Prasanna Karlekar (Inactive) logged work - 17/Oct/17 10:30 PM
            • Time Spent:
              1.5h
               

              Code analysis for round up issue fix

            prasanna Prasanna Karlekar (Inactive) logged work - 24/Oct/17 12:00 AM
            • Time Spent:
              0.75h
               

              JIRA update on queries

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 25/Oct/17 02:09 PM - edited
            • Time Spent:
              6h
               

              Existing implementation analysis

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 26/Oct/17 02:06 PM
            • Time Spent:
              7.75h
               

              Analysis of existing implementation and changes required
              Code changes

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 27/Oct/17 02:03 PM
            • Time Spent:
              9h
               

              Code changes
              Unit testing
              Internal discussion
              Code changes merge

            prasanna Prasanna Karlekar (Inactive) logged work - 28/Oct/17 12:00 AM
            • Time Spent:
              0.75h
               

              Discussion on output provided by Billing Summary report

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 30/Oct/17 12:36 PM
            • Time Spent:
              8h
               

              Code changes and Unit testing
              JIRA update and Review request

            prasanna Prasanna Karlekar (Inactive) logged work - 31/Oct/17 06:00 PM
            • Time Spent:
              1.5h
               

              Code review
              Discussion on Billing Report

            priya.handepatil Priya Handepatil (Inactive) logged work - 02/Nov/17 01:03 PM
            • Time Spent:
              1h
               

              Analysis
              Interna;l discussion with Developer

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 03/Nov/17 05:09 AM
            • Time Spent:
              0.25h
               

              internal discussion with QA

            priya.handepatil Priya Handepatil (Inactive) logged work - 07/Nov/17 11:24 AM
            • Time Spent:
              2h
               

              Analysis
              Testing
              Cost Calculations
              JIra updates

            sanjana.jadhav Sanjana Jadhav (Inactive) logged work - 12/Nov/17 07:32 AM - edited
            • Time Spent:
              2h
               

              Analysis
              Jira update
              Testing on stage

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 14/Nov/17 05:30 AM
            • Time Spent:
              0.5h
               

              Verified reopened points on stage
              JIRA Update
              Discussion with QA

            meghana.joshi Meghana Joshi (Inactive) logged work - 13/Dec/17 10:19 AM
            • Time Spent:
              4h
               

              Analysis
              Test Scenarios Writing

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 14/Dec/17 04:52 AM
            • Time Spent:
              0.25h
               

              Internal discussions with QA

            sanjana.jadhav Sanjana Jadhav (Inactive) logged work - 15/Dec/17 06:01 AM
            • Time Spent:
              0.5h
               
              <No comment>
            sanjana.jadhav Sanjana Jadhav (Inactive) logged work - 16/Dec/17 06:01 AM
            • Time Spent:
              0.5h
               
              <No comment>
            prasadp Prasad Pise (Inactive) logged work - 29/Dec/17 12:24 PM
            • Time Spent:
              2h
               

              Understanding and testing on production

              People

              Assignee:
              Yamilka.Coca Yamilka Coca (Inactive)
              Reporter:
              Yamilka.Coca Yamilka Coca (Inactive)
              Account Executive:
              Yamilka Coca (Inactive)
              Developer:
              Parmeshwar Jumbad (Inactive)
              QA:
              Sanjana Jadhav (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Pre-Prod Due Date:
                Production Due Date:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 35h Original Estimate - 35h
                  35h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 51.5h
                  51.5h