Proprietary health care finance, prescription drug, funding optimization tools combined with financial reports, interactive charts and executive dashboards have been built utilizing DAX, Microsoft Power BI and accessible from Microsoft Azure's secure cloud platform.
The application uses client specific demographic data (i.e., salary, tier, plans, etc.) and corporate preference settings (i.e., tiers, tax rates, employer contributions) to develop multiple scenarios for strategic consideration.

The utility provides a slate of healthcare alternatives (unlimited) from which to select (or veto) using client specific demographic and cost data.
The cost for inpatient care, outpatient treatment, professional services and prescription drugs is contained  by organizations capable of applying leverage and extracting savings through negotiated provider contracts.

The in-depth comparative analysis developed evaluates network effectiveness from penetration, savings, cannibalization and fixed costs.
The underwriting process is the application of the law of large numbers using actual claims, membership data, pooling points, design changes and trend to develop the total costs
and tiered funding rates.

The application is the combination of underwriting methods and advanced time series forecasting techniques for use to fund, budget and negotiate.
Stop loss coverage that protects the employer against severity (specific) and frequency (aggregate) claims under an ASO arrangement may be direct with an insurance company or through some form of a captive.

The module integrates contract features such as lasering, deductibles, profit sharing, rates, etc., and graphically illustrates the optimal selection.
This module creates a transitional risk matrix comparing enrollment and cost by tier from the prior period to the current period in order to provide an explanation for the cost differential.

In addition, the application is used to create multiple potential enrollment scenarios and uses Monte Carlo simulation to model.
This module calculates the total cost for each plan design alternative using actual census data (i.e., salary, age, eligibility class, state, etc.) to illustrate costs for life and disability plan options.

The dashboard analysis graphics provide the comparative views for the preferred alternatives to the current structure.
This module has been designed to provide flexibility in the approaches toward cost allocation (i.e., defining the number and type of coverage tiers) and the best use of resources under constraints.

Its extensibility includes alternatives such as surcharges, wellness rewards and other methods of cost allocation.
This module measures the period over period change in trend separating the contributing factors (i.e., enrollment, cost sharing and utilization) to determine correct and actual cost drivers of trend.

Integrated are net present value calculations and multiple project finance views within the context of the portfolio of options.
About    Contact
Health Quant LLC is a Delaware corporation. All proprietary analytical models are powered by Microsoft using Data Analysis Expressions (DAX). © 2019 Health Quant LLC.  All rights reserved.