Reference no: EM133023273

A hospital has contracted with an HMO to provide acute care inpatient services for $1,000 per day, subject to a 10 percent withhold. The proposed budget for inpatient services is based upon expected utilization of 800 days per 1,000 members at $1,000 per day, or $800,000 per 1,000 members. The hospital risk pool will be split equally between the hospital and a primary care physician group. If only 700 days per 1,000 members were utilized in the first year, how much would the hospital be paid per 1,000 members? Use a spreadsheet to illustrate your solution to Question 4. Employ cell references and a logical function to permit solutions for different numbers of hospital days per 1000. Submit the spreadsheet file when asked