Sample Taft Hartley Plan Audit.XLS

Health and Welfare Plan AuditPlan Year 2003 - 2004Plan Year 2004 - 2005For the Trustees of:United Association of Local 0000Month / Day / YearProprietary & Confidential © 2004 Benefitdecisions 125 South Wacker Drive Suite 2075 Chicago, IL 60606 • 312.606.4800 • 312.606.8101 fax www.benefitdecisions.com Local 0000Health and Welfare Plan AuditTable of ContentsSection 1 Executive SummarySection 2 Plan Performance Recap May through April Actual• Surplus/Decifit by Member ClassificationSection 3 Benefitdecsions' Plan ProjectionsJune through May • Underwriting Methodology• Projected Surplus/Decific by Member Classification• Hypothetical Breakeven Analysis• Contribution MatrixSection 4 Benefit Expense Recap• Member Subsidy Analysis• Benefit Cost AnalysisSection 5 Plan Observations• Plan Design• PPO NetworkSection 6 Prescription Drug Benefit Observations• Pharmacy Benefit Manager (PBM) Analysis• Rx Plan Design AlternativesSection 7 Renewal Recap• Reinsurance • Life InsuranceSection 8 Next Steps - Next 90 Days• Medical Benefit Utillization Analysis• PPO Network Analysis• PBM Network Analysis• Update Summary Plan Description • Provide recommendations for age banded rates, dollar bank withdrawal limits, COBRA ratesSection 9 Appendix• Plan Year 2002-2003 Cost Data• Plan Year 2003-2004 Cost Data• Plan Year 2004-2005 Cost DataLocal 0000Health and Welfare Plan AuditExecutive SummaryThe intent of this report is to evaluate the financial ...