Applied Sciences Health Information Technology Homework

For this exercise, use the file titled  AB202022_Ch07_Practice with OPPS Reimbursement and Cost.xlsx  Download AB202022_Ch07_Practice with OPPS Reimbursement and Cost.xlsx (Please see attachment to directions). There are four tabs in this file: Example, ED Visit, Rural SCH, and Surgery. The first tab, Example, demonstrates how to calculate reimbursement and cost for an outpatient hospital claim. The remaining tabs provide three different claims, each with a different service type or focus. For each claim, use Addendum B ( https://www.cms.gov/Medicare/Medicare-Fee-for-Service-Payment/HospitalOutpatientPPS/Addendum-A-and-Addendum-B-Updates Links to an external site. ) to locate the reimbursement rates by CPT code. Calculate Medicare reimbursement, total charges, and total cost. Does the facility make a profit or incur a loss?