MIS 1300 MOD 5
Shaungio74
MIS1300MOD402CONTOSO.SOLUTION.xlsx1.xlsxRevenue
| Contoso, Ltd. | |||
| Fourth Quarter Revenue | |||
| Revenue Source | October | November | December |
| Patient Insurance Companies | $ 267,433 | $ 242,389 | $ 272,887 |
| Medicare/Medicaid | $ 179,112 | $ 146,095 | $ 191,356 |
| Patient Copayments | $ 2,098 | $ 1,744 | $ 1,956 |
| Patient Self-Pay Payments | $ 3,477 | $ 2,902 | $ 5,229 |
| Total Revenue | $ 452,120 | $ 393,130 | $ 471,428 |
| Patients Treated | 2,529 | 2,307 | 2,351 |
Accounts
| Contoso, Ltd. | ||
| Accounts Receivable | ||
| Outstanding Balances as of December 31 | ||
| Patient | Amount | Invoice Date |
| Strande, Amy | $ 2,830 | 11/20/17 |
| Samant, Mandar | $ 3,890 | 10/10/17 |
| Allen, Michael | $ 587 | 10/25/17 |
| Bonifaz, Luis | $ 621 | 12/4/17 |
| Dewar, Craig | $ 354 | 10/30/17 |
| Gaffney, Lawrie | $ 875 | 11/8/17 |
| Jacobsen, Lola | $ 1,534 | 12/15/17 |
| Total | $ 10,691 | |
