Our company offers a single product known as MEDSHIELD... It is a Medical Expense Supplemental Benefit that is solicited by Group Health Insurance Agents/Brokers (Producers) to employers who offer their employees group health insurance.
With our key employee no longer with company, we need programing for revisions/enhancing/future updates to our current EXCEL Rate Calculator ***Includes:** Various Rates / Primary Plan Data / Proposal format / Deductible charts / Group census / Claims Example.
Currently there are two calculators, one for our Producers with limited access and one for our UA Officers with full access. We would like to have one calculator with passcode to get full access assigned by UAA as needed.
Hard copy data (RATES) consist of 10-12 pages of a couple hundred possible different rates based on age(s) of employees & benefits chosen. Our policy is increasing our benefit options and we will need to adjust rates accordingly.
The link below is an example of current Rate Calculator. No one knows the formulas or passcodes to allow access to revise -- it is critical that we either create a new Rate Calculator or break into this one and enhance & revise.
<[url removed, login to view]>
**Completion of project needed before end of June.** Will directly correspond with winning bidder all information available regarding the MEDSHIELD RATE CALCULATOR to move forward with this project once bid is accepted.
(open for suggestions of better software)