Copperline Healthcare Case

I need the attached case problems ansswered as well as the attached spreadsheet completed. Thanks