This is a Health Insurance Balanced Scorecard Report, it is one of reports that Balanced Scorecard Designer can generate for Health Insurance scorecard. With this software you can also design your own KPIs, Balanced Scorecards and metrics.


Health Insurance

Report includes: 1 month(s) 49 day(s), from 23.04.2008 to 11.06.2008

  Name Start value End value Dynamic Contains
Root Health Insurance 40,59 % 53,79 % + 13,2 %
Financial Perspective(54,8%, 18,21%Up)
Operations(64,2%, 4,17%Up)
Customer Perspective(34,9%, 28,63%Up)
Service(55,6%, 3,77%Up)

Graph for Health Insurance

Graph for Health Insurance

Data for Health Insurance

DatesValue
23.04.200840,59
30.04.200844,22
07.05.200869,34
14.05.200845,32
21.05.200852,86
28.05.200848,13
04.06.200857,78
11.06.200853,79

Financial Perspective

  Name Start value End value Dynamic Parent Contains
Root Financial Perspective 36,54 % 54,75 % + 18,21% Health Insurance
Indicators
New Business Premiums
IRR on new business
External Funds Under Manageemnt
Operating profit *
* - Information for this metric is limited in sample report Description These indicators are used to point towards the financial performance of various health insurance policies and the overall management of the business

Graph for Financial Perspective

Graph for Financial Perspective

Data for Financial Perspective

DatesValueWeight
23.04.200836,543
30.04.200862,873
07.05.200862,333
14.05.200829,723
21.05.200861,83
28.05.200832,473
04.06.200838,243
11.06.200854,753

New Business Premiums

  Name Start value End value Dynamic Measure units Optimization method Parent
Root New Business Premiums 3213,636 3286,468 + 72,83 million dollars Maximize Financial Perspective
Description premium related to covered business as well as for investment producrs

Graph for New Business Premiums

Graph for New Business Premiums

Data for New Business Premiums

DatesWeightMinMaxValue
23.04.20083239246683213,636
30.04.20083239246684347,084
07.05.20083239246683520,896
14.05.20083239246682851,752
21.05.20083239246683846,364
28.05.20083239246682521,732
04.06.20083239246682498,972
11.06.20083239246683286,468

IRR on new business

  Name Start value End value Dynamic Measure units Optimization method Parent
Root IRR on new business 19,482 18,432 -1,05 % Maximize Financial Perspective
Description It is the discount rate at which PV of cash inflows are equal to the PV of cash outflows

Graph for IRR on new business

Graph for IRR on new business

Data for IRR on new business

DatesWeightMinMaxValue
23.04.20082132019,482
30.04.20082132019,573
07.05.20082132017,634
14.05.20082132015,793
21.05.20082132013,686
28.05.20082132019,622
04.06.20082132017,382
11.06.20082132018,432

External Funds Under Manageemnt

  Name Start value End value Dynamic Measure units Optimization method Parent
Root External Funds Under Manageemnt 16916,3 13323,5 -3593 million dollars Maximize Financial Perspective
Description aggregate value of the total investment products

Graph for External Funds Under Manageemnt

Graph for External Funds Under Manageemnt

Data for External Funds Under Manageemnt

DatesWeightMinMaxValue
23.04.200821005000016916,3
30.04.200821005000036976,1
07.05.200821005000034930,2
14.05.200821005000017365,4
21.05.200821005000031137,8
28.05.200821005000015419,3
04.06.20082100500004541,1
11.06.200821005000013323,5

Operations

  Name Start value End value Dynamic Parent Contains
Root Operations 60,08 % 64,25 % + 4,17% Health Insurance
Indicators
Policies sold
Value of health policies sold
Policy Renewals
Premiums paid *
* - Information for this metric is limited in sample report Description number of policies sold, the value of policies sold, number of policies renewed as a percentage of policies sold, the number of lapses as a percentage of policies sold, the percentage of policies that lapse within the first two years, performance to quota, benefits paid as a percentage of premium, etc.

Graph for Operations

Graph for Operations

Data for Operations

DatesValueWeight
23.04.200860,083
30.04.200848,483
07.05.200874,453
14.05.200855,53
21.05.200849,443
28.05.200858,123
04.06.200876,273
11.06.200864,253

Policies sold

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Policies sold 1,7945 1,187 -0,607 millions Maximize Operations
Description Indicates the number of health insurance policies sold by the company

Graph for Policies sold

Graph for Policies sold

Data for Policies sold

DatesWeightMinMaxValue
23.04.200820,521,7945
30.04.200820,520,7445
07.05.200820,521,802
14.05.200820,521,739
21.05.200820,520,56
28.05.200820,521,637
04.06.200820,521,3145
11.06.200820,521,187

Value of health policies sold

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Value of health policies sold 27,400726 83,800162 + 56,4 million dollars Maximize Operations
Description Monetary value of health policies sold

Graph for Value of health policies sold

Graph for Value of health policies sold

Data for Value of health policies sold

DatesWeightMinMaxValue
23.04.200830,00110027,400726
30.04.200830,00110021,700783
07.05.200830,00110090,500095
14.05.200830,00110060,800392
21.05.200830,00110082,900171
28.05.200830,00110059,200408
04.06.200830,00110056,00044
11.06.200830,00110083,800162

Policy Renewals

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Policy Renewals 71,555 59,66 -11,9 % Maximize Operations
Description Indicates the percentage of policies renewed as a percentage of health policies sold

Graph for Policy Renewals

Graph for Policy Renewals

Data for Policy Renewals

DatesWeightMinMaxValue
23.04.20082107571,555
30.04.20082107573,505
07.05.20082107524,625
14.05.20082107553,225
21.05.20082107549,91
28.05.20082107514,485
04.06.20082107570,58
11.06.20082107559,66

Customer Perspective

  Name Start value End value Dynamic Parent Contains
Root Customer Perspective 6,24 % 34,87 % + 28,63% Health Insurance
Indicators
Customer Profile
Risks profile
Consumer Complaints
Access to insurance *
* - Information for this metric is limited in sample report Description Deals with the efficieny and convenience oif services provided to the customers

Graph for Customer Perspective

Graph for Customer Perspective

Data for Customer Perspective

DatesValueWeight
23.04.20086,242
30.04.200841,912
07.05.200859,692
14.05.200848,822
21.05.200863,622
28.05.200858,012
04.06.200870,112
11.06.200834,872

Customer Profile

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Customer Profile 1,171 1,711 + 0,54 millions Maximize Customer Perspective
Description Total number of customers to be covered by health insurance policies, their age,sex,ethnicity etc

Graph for Customer Profile

Graph for Customer Profile

Data for Customer Profile

DatesWeightMinMaxValue
23.04.200831101,171
30.04.200831102,107
07.05.200831105,158
14.05.200831103,268
21.05.200831109,172
28.05.200831101,909
04.06.200831108,218
11.06.200831101,711

Risks profile

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Risks profile 1,855 4,852 + 2,997 $ and % Maximize Customer Perspective
Description Indicates the type of health risks covered, size of the contract

Graph for Risks profile

Graph for Risks profile

Data for Risks profile

DatesWeightMinMaxValue
23.04.200831101,855
30.04.200831104,132
07.05.200831108,353
14.05.200831102,8
21.05.200831106,904
28.05.200831106,508
04.06.200831108,947
11.06.200831104,852

Consumer Complaints

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Consumer Complaints 773,6 2506,4 + 1733 # Maximize Customer Perspective
Description Different kinds of complaints including complaints for pricing, information etc

Graph for Consumer Complaints

Graph for Consumer Complaints

Data for Consumer Complaints

DatesWeightMinMaxValue
23.04.200825002900773,6
30.04.2008250029001882,4
07.05.2008250029001544
14.05.2008250029002384
21.05.2008250029001731,2
28.05.2008250029002561,6
04.06.2008250029001469,6
11.06.2008250029002506,4

Service

  Name Start value End value Dynamic Parent Contains
Root Service 51,79 % 55,56 % + 3,77% Health Insurance
Indicators
Claims processed
Claims pending
Average processing time
Hearings processed *
* - Information for this metric is limited in sample report Description These indicators give an idea of quality of service to citizens by the health insurance company

Graph for Service

Graph for Service

Data for Service

DatesValueWeight
23.04.200851,792
30.04.200812,182
07.05.200881,852
14.05.200849,932
21.05.200833,812
28.05.200846,762
04.06.200847,022
11.06.200855,562

Claims processed

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Claims processed 279800 1402100 +1,122E006 # Maximize Service
Description It describes the number of initial claims processed by the concerned department

Graph for Claims processed

Graph for Claims processed

Data for Claims processed

DatesWeightMinMaxValue
23.04.200831000003000000279800
30.04.200831000003000000909100
07.05.2008310000030000002556300
14.05.2008310000030000002135800
21.05.200831000003000000781500
28.05.2008310000030000001332500
04.06.2008310000030000001222300
11.06.2008310000030000001402100

Claims pending

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Claims pending 219000 269000 + 5E004 # Minimize Service
Description Mumber of initial claims pending in a FY

Graph for Claims pending

Graph for Claims pending

Data for Claims pending

DatesWeightMinMaxValue
23.04.20082100000600000219000
30.04.20082100000600000568500
07.05.20082100000600000250000
14.05.20082100000600000129000
21.05.20082100000600000534500
28.05.20082100000600000524000
04.06.20082100000600000439000
11.06.20082100000600000269000

Average processing time

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Average processing time 87,114 88,41 + 1,296 days Maximize Service
Description Average time taken for processing the initial claims in a FY

Graph for Average processing time

Graph for Average processing time

Data for Average processing time

DatesWeightMinMaxValue
23.04.20083759387,114
30.04.20083759376,494
07.05.20083759391,884
14.05.20083759377,25
21.05.20083759380,148
28.05.20083759391,182
04.06.20083759383,694
11.06.20083759388,41
Created by: AKS-Labs
Report created with Balanced Scorecard Designer at 16.05.2008 22:42:31

Copyright © 2000-2012 AKS-Labs. All rights reserved.