Monthly Plan Performance Report

This report provides an analysis of the monthly performance of a medical plan, including budget, expenses, and loss ratios for the year 202x.

0 10 20 30 40 50 60 70 80 90 Budget ($) Total Expenses ($) YTD Loss Ratio (%) Monthly Plan Performance Report Sample Client – Medical Report Paid Period: January 1, 202x to December 31, 202x 6.21% Plan Loss Ratio YTD $711,500 Total Budget $755,700 Total Expenses

Month Budget ($) Total Expenses ($) YTD Loss Ratio (%) Analysis January 50,000 48,000 4.00% Stayed within budget, maintaining a surplus. February 52,000 51,500 2.88% Slight increase in expenses, but controlled. March 53,000 55,000 3.77% Expenses exceeded budget slightly. April 55,000 57,200 5.45% Overspending trend emerging. May 56,000 60,000 7.14% Expenses continue to rise above budget. June 58,000 62,500 8.62% Higher expenses impacting financial balance. July 60,000 63,800 9.67% Budget overruns becoming consistent. August 62,000 66,000 10.87% Increased expenses continue. September 63,500 68,200 11.85% Cost control measures needed. October 65,000 71,000 13.46% Spending is significantly over budget. November 67,000 74,500 15.38% High YTD loss ratio; review required. December 70,000 78,000 17.14% Year ends with substantial overspending. Monthly Plan Performance Report Sample Client – Medical Report

Monthly Plan Performance Report Sample Client – Medical Report Category Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Employee 12 15 18 20 22 25 27 30 32 35 37 40 Employee + Spouse 12 15 18 20 22 25 27 30 32 35 37 40 Family 12 15 18 20 22 25 27 30 32 35 37 40 Total Expenses ($) 12 15 18 20 22 25 27 30 32 35 37 40 Total Members 12 15 18 20 22 25 27 30 32 35 37 40

Monthly Plan Performance Report Sample Client – Medical Report Category Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Basic Health Coverage 10 12 15 18 20 22 25 27 30 32 35 37 Dental Plan 8 10 12 14 15 17 18 20 22 23 25 27 Vision Plan 5 6 7 8 9 10 11 12 13 14 15 16 Life Insurance 12 14 16 18 20 22 24 26 28 30 32 34 Disability Insurance 20 22 25 28 30 32 35 37 40 42 45 48 Wellness Program 6 7 8 9 10 11 12 13 14 15 16 17 Mental Health Support 4 5 6 7 8 9 10 11 12 13 14 15 Prescription Coverage 15 17 18 20 22 24 25 27 28 30 32 34 Monthly Total Fixed Expenses 80 93 107 122 134 147 160 173 187 199 214 228 YTD Total Fixed Expenses 26 26 26 26 26 26 26 26 26 26 26 26

Monthly Plan Performance Report Sample Client – Medical Report Rank Active (Yes/No) Relationship Age Range Primary Health Condition Category Paid Medical ($) Paid Rx ($) Paid Total ($) Over Specific ($) 1 Yes Employee 50-55 Cardiac Issues 180,500 2,100 182,600 82,600 2 Yes Spouse 45-50 Cancer 155,300 5,600 160,900 60,900 3 Yes Employee 40-45 Diabetes 132,000 8,200 140,200 40,200 4 Yes Child 10-15 Genetic Disorder 98,750 3,500 102,250 2,250 5 Yes Employee 55-60 Neurological Disorder 85,200 2,900 88,100 0 6 Yes Spouse 50-55 Cancer 75,800 6,500 82,300 0 7 Yes Employee 45-50 Autoimmune Disease 65,400 1,800 67,200 0 8 Yes Child 5-10 Severe Asthma 53,200 4,200 57,400 0 9 Yes Employee 35-40 Kidney Disease 47,900 2,400 50,300 0 10 Yes Spouse 55-60 Heart Surgery 40,500 3,200 43,700 0 Total Gross Paid Claims for High Cost Claimants $933,550 $40,400 $973,950 $185,950