Assignment and Question 1. Assume that it actually costs $2,000 per day for the hospital to provide a patient bed exclusive of any medical procedures. Given the $2,000 cost per day per patient and the payer mix and payer rates provided, calculate the charge rate required for the hospital to cover its costs (break even). 2. What other factors may complicate the setting of charge rates? Hint: Solve this problem via Excel. 1. Input the $2,000 cost per patient in a cell as the estimated charge rate. 2. Calculate collections for each of the six patient categories. Use the cell with the charge rate for the three categories where the percentage charge applies. 3. Sum the collections in the individual patient categories to get total collections. 4. Multiply the $2,000 cost rate by 100 patients to get the estimated total cost