develop the bid presentation to be made to the consortium.

You have recently joined New England HMO as a marketing analyst. The HMO has been approached by a co Show more You have recently joined New England HMO as a marketing analyst. The HMO has been approached by a consortium. Your task is to develop the bid presentation to be made to the consortium. Download and read the scenario. Download and use the spreadsheet for analysis. Present your analysis as a 3-page report in a Word document formatted in APA style. Develop the bid presentation as a 67 slide PowerPoint presentation. Name your documents as: LastnameFirstInitial_W1_A5.doc and LastnameFirstInitial_W1_A5.ppt. For example if your name is John Smith your documents will be named SmithJ_W1_A5.doc and SmithJ_W1_A5.ppt. Premium Development Case Study Premium Development Case Study Premium Development Case Study 2007 South University 2007 South University New England HMO New England HMO Select the appropriate input values and enter them in cells containing hyphens or zeroes. Once you do this the base case solution will appear. Select the appropriate input values and enter them in cells containing hyphens or zeroes. Once you do this the base case solution will appear. Select the appropriate input values and enter them in cells containing hyphens or zeroes. Once you do this the base case solution will appear. Select the appropriate input values and enter them in cells containing hyphens or zeroes. Once you do this the base case solution will appear. Select the appropriate input values and enter them in cells containing hyphens or zeroes. Once you do this the base case solution will appear. Select the appropriate input values and enter them in cells containing hyphens or zeroes. Once you do this the base case solution will appear. Select the appropriate input values and enter them in cells containing hyphens or zeroes. Once you do this the base case solution will appear. Select the appropriate input values and enter them in cells containing hyphens or zeroes. Once you do this the base case solution will appear. Select the appropriate input values and enter them in cells containing hyphens or zeroes. Once you do this the base case solution will appear. Note that the historical cost input data for facilities services is the per deim reimbursement rate for inpatient acute care the daily cost for skilled nursing facility care the daily cost for inpatient mental health care the per case cost for hospital-based surgery and the per visit cost for emergency room services. Note that the historical cost input data for facilities services is the per deim reimbursement rate for inpatient acute care the daily cost for skilled nursing facility care the daily cost for inpatient mental health care the per case cost for hospital-based surgery and the per visit cost for emergency room services. Note that the historical cost input data for facilities services is the per deim reimbursement rate for inpatient acute care the daily cost for skilled nursing facility care the daily cost for inpatient mental health care the per case cost for hospital-based surgery and the per visit cost for emergency room services. Note that the historical cost input data for facilities services is the per deim reimbursement rate for inpatient acute care the daily cost for skilled nursing facility care the daily cost for inpatient mental health care the per case cost for hospital-based surgery and the per visit cost for emergency room services. Note that the historical cost input data for facilities services is the per deim reimbursement rate for inpatient acute care the daily cost for skilled nursing facility care the daily cost for inpatient mental health care the per case cost for hospital-based surgery and the per visit cost for emergency room services. Note that the historical cost input data for facilities services is the per deim reimbursement rate for inpatient acute care the daily cost for skilled nursing facility care the daily cost for inpatient mental health care the per case cost for hospital-based surgery and the per visit cost for emergency room services. Note that the historical cost input data for facilities services is the per deim reimbursement rate for inpatient acute care the daily cost for skilled nursing facility care the daily cost for inpatient mental health care the per case cost for hospital-based surgery and the per visit cost for emergency room services. Note that the historical cost input data for facilities services is the per deim reimbursement rate for inpatient acute care the daily cost for skilled nursing facility care the daily cost for inpatient mental health care the per case cost for hospital-based surgery and the per visit cost for emergency room services. Note that the historical cost input data for facilities services is the per deim reimbursement rate for inpatient acute care the daily cost for skilled nursing facility care the daily cost for inpatient mental health care the per case cost for hospital-based surgery and the per visit cost for emergency room services. The historical utilization input data for facilities services is days per member acute care nursing home care and inpatient mental heatlh care; cases per member for inpatient surgery; and visits per member for emergency room care. The historical utilization input data for facilities services is days per member acute care nursing home care and inpatient mental heatlh care; cases per member for inpatient surgery; and visits per member for emergency room care. The historical utilization input data for facilities services is days per member acute care nursing home care and inpatient mental heatlh care; cases per member for inpatient surgery; and visits per member for emergency room care. The historical utilization input data for facilities services is days per member acute care nursing home care and inpatient mental heatlh care; cases per member for inpatient surgery; and visits per member for emergency room care. The historical utilization input data for facilities services is days per member acute care nursing home care and inpatient mental heatlh care; cases per member for inpatient surgery; and visits per member for emergency room care. The historical utilization input data for facilities services is days per member acute care nursing home care and inpatient mental heatlh care; cases per member for inpatient surgery; and visits per member for emergency room care. The historical utilization input data for facilities services is days per member acute care nursing home care and inpatient mental heatlh care; cases per member for inpatient surgery; and visits per member for emergency room care. The historical utilization input data for facilities services is days per member acute care nursing home care and inpatient mental heatlh care; cases per member for inpatient surgery; and visits per member for emergency room care. The historical utilization input data for facilities services is days per member acute care nursing home care and inpatient mental heatlh care; cases per member for inpatient surgery; and visits per member for emergency room care. KEY INPUT: KEY INPUT: KEY OUTPUT: KEY OUTPUT: Inflation adjustment Inflation adjustment 0.0% PMPM bid PMPM bid $ 31.08 Administrative expense percent Administrative expense percent 0.0% Premium rates: Premium rates: Profit/reserves percent Profit/reserves percent 0.0% Single $ Family $ OTHER INPUT AND MODEL-GENERATED DATA: OTHER INPUT AND MODEL-GENERATED DATA: OTHER INPUT AND MODEL-GENERATED DATA: OTHER INPUT AND MODEL-GENERATED DATA: PMPM Calculation: PMPM Calculation: Historical Historical Base Copay Adjustment Factors Copay Adjustment Factors Adjusted Inflation Adjusted Cost Data Utilization PMPM Cost Cost Utilization PMPM Cost PMPM Cost I. Medical Expenses I. Medical Expenses Facility Services: Facility Services: Inpatient: Acute $ 0.0000 $ 0.0000 0.0000 $ Skilled nursing Skilled nursing 0.0000 0.0000 0.0000 Mental health Mental health 0.0000 0.0000 0.0000 Substance abuse Substance abuse 0.41 1.0000 1.0000 0.41 Surgical procedures Surgical procedures 0.0000 0.0000 0.0000 Emergency room Emergency room 0.0000 0.0000 0.0000 Outpatient procedures Outpatient procedures 3.43 1.0000 1.0000 3.43 Total facility services PMPM amount Total facility services PMPM amount Total facility services PMPM amount $ 3.84 $ 3.84 $ 3.84 Physician Services: Physician Services: Primary care Primary care $ 0.0000 0.0000 $ Specialist care Specialist care Office visits Office visits 0.0000 0.0000 Surgical services Surgical services 9.00 0.9544 1.0000 8.59 All other services All other services 23.67 0.8659 0.9100 18.65 Total physician services PMPM amount Total physician services PMPM amount Total physician services PMPM amount $ 27.24 $ 27.24 Total medical PMPM amount Total medical PMPM amount $ 31.08 II. Other Expenses II. Other Expenses Administrative Administrative $ Reserves Total other expenses Total other expenses $ $ Total PMPM amount Total PMPM amount $ 31.08 III. Premium Rates III. Premium Rates Single Family Rate factor 0.000 0.000 Monthly premium rate $0.00 $0.00 Show less

Get 20% discount on your first order with us. Place an order and use coupon: GET20