Cost allocation

Complete problem 11a concerning cost allocation on page 573 of Financial Management of Health Care Organizations (linked in Resources). Show all of your calculations in an Excel spreadsheet. Post your spreadsheet and ask related questions or offer comments about it.