Complete the following chart before answering the assessment questions. ***Please include formulas if using excel.

Basis for Charges Based on Patient Days (variable) Based on Bed Capacity (beds rented) (fixed) Dietary $ 600,000 Janitorial S 70,000 Laundry 300,000 Laboratory 450,000 Pharmacy 350,000 Repairs & Maintenance 30,000 General & Administrative 800,000 Rent 700,000 Billings & Collections 300,000 Totals $ 2,000,000 $1,600,000 During the year, Pediatrics charged each patient an average of $350 per patient day, had a capacity of 60 beds, and had revenue of $7,000,000 for the year. In addition, the Pediatric Department employed and paid the following personnel directly during the year: Annual Salaries Number Required Total Annual Salaries Supervising Nurses $80,000 4 $ 320,000 Nurses $50,000 10 500,000 Aides $20,000 20 400,000 Total $1,220,000 The Pediatric Department must follow minimum personnel requirements that are published by the Federal Department of Health and are based on the number of patient days that are available during the year. Available patient days are calculated by taking the number of beds times 365 days per year. Number of Number of Nurses Patient Days Available During the year Number of Supervising Nurses Aides Up to 21,900 days 20 10 4 21,900 to 25,915 days 24 12 4 25,916 to 30,100 days 28 14 5 Basis for Charges Based on Patient Days (variable) Based on Bed Capacity (beds rented) (fixed) Dietary $ 600,000 Janitorial S 70,000 Laundry 300,000 Laboratory 450,000 Pharmacy 350,000 Repairs & Maintenance 30,000 General & Administrative 800,000 Rent 700,000 Billings & Collections 300,000 Totals $ 2,000,000 $1,600,000 During the year, Pediatrics charged each patient an average of $350 per patient day, had a capacity of 60 beds, and had revenue of $7,000,000 for the year. In addition, the Pediatric Department employed and paid the following personnel directly during the year: Annual Salaries Number Required Total Annual Salaries Supervising Nurses $80,000 4 $ 320,000 Nurses $50,000 10 500,000 Aides $20,000 20 400,000 Total $1,220,000 The Pediatric Department must follow minimum personnel requirements that are published by the Federal Department of Health and are based on the number of patient days that are available during the year. Available patient days are calculated by taking the number of beds times 365 days per year. Number of Number of Nurses Patient Days Available During the year Number of Supervising Nurses Aides Up to 21,900 days 20 10 4 21,900 to 25,915 days 24 12 4 25,916 to 30,100 days 28 14 5