Analyze the aging accounts receivable schedule for the Hospital Accounts Receivable Problem. Based on your analysis, determine if the hospital billing department is doing a good job managing their accounts receivable. Next, please state whether you would give the billing department staff a bonus or a reprimand and explain why

130 Days 3160 Days 61-90 Days >90 Days Total Payer By Total Dollars Medicare Medicaid Big HMO Other Total By Percent Medicare Medicaid Big HMO Other Total $2,500,000 900,000 2,000,000 500,000 $5,900,000 $1,000,000 900,000 2,000,000 500,000 $4,400,000 $1,500,000 900,000 0 500,000 $2,900,000 $0 300,000 0 500,000 $800,000 $5,000,000 3,000,000 4,000,000 2,000,000 $14,000,000 50% 30% 50% 25% 42% 20% 30% 50% 25% 31% 30% 30% 0% 25% 21% 0% 10% 0% 25% 6% 100% 100% 100% 100% 100% 130 Days 3160 Days 61-90 Days >90 Days Total Payer By Total Dollars Medicare Medicaid Big HMO Other Total By Percent Medicare Medicaid Big HMO Other Total $2,500,000 900,000 2,000,000 500,000 $5,900,000 $1,000,000 900,000 2,000,000 500,000 $4,400,000 $1,500,000 900,000 0 500,000 $2,900,000 $0 300,000 0 500,000 $800,000 $5,000,000 3,000,000 4,000,000 2,000,000 $14,000,000 50% 30% 50% 25% 42% 20% 30% 50% 25% 31% 30% 30% 0% 25% 21% 0% 10% 0% 25% 6% 100% 100% 100% 100% 100%