Excel 2
Past&Projected
| Clemenson Imaging | ||||
| Patient Count and Hours Tracking | ||||
| Past and Projected Values, 2013–2017 | ||||
| Month | Image | Patients | Total Hours | # of Employees |
| Jan 2013 | MRI | 500 | 1800 | 4 |
| Feb 2013 | Ultrasonography | 750 | 2400 | 5 |
| Mar 2013 | MRI | 1000 | 3000 | 3 |
| Apr 2013 | CT Scan | 500 | 1800 | 4 |
| May 2013 | MRI | 750 | 2400 | 3 |
| Jun 2013 | Ultrasonography | 1000 | 3000 | 4 |
| Jul 2013 | Angiography | 1000 | 3000 | 2 |
| Aug 2013 | CT Scan | 750 | 1800 | 2 |
| Sep 2013 | MRI | 500 | 2400 | 2 |
| Oct 2013 | Ultrasonography | 1000 | 2400 | 5 |
| Nov 2013 | Angiography | 750 | 2400 | 4 |
| Dec 2013 | CT Scan | 500 | 2400 | 3 |
| Jan 2014 | MRI | 1000 | 1800 | 2 |
| Feb 2014 | Ultrasonography | 1000 | 3000 | 3 |
| Mar 2014 | Angiography | 500 | 3000 | 4 |
| Apr 2014 | CT Scan | 750 | 1800 | 2 |
| May 2014 | MRI | 750 | 2400 | 2 |
| Jun 2014 | Ultrasonography | 750 | 3000 | 3 |
| Jul 2014 | Angiography | 500 | 3000 | 3 |
| Aug 2014 | CT Scan | 1000 | 1800 | 4 |
| Sep 2014 | MRI | 750 | 1800 | 5 |
| Oct 2014 | Ultrasonography | 750 | 2400 | 5 |
| Nov 2014 | Angiography | 1000 | 2400 | 3 |
| Dec 2014 | CT Scan | 750 | 2400 | 4 |
| Jan 2015 | MRI | 500 | 2400 | 3 |
| Feb 2015 | Ultrasonography | 1000 | 1800 | 4 |
| Mar 2015 | Angiography | 1000 | 1800 | 3 |
| Apr 2015 | CT Scan | 1000 | 1800 | 5 |
| May 2015 | MRI | 750 | 3000 | 5 |
| Jun 2015 | Ultrasonography | 750 | 3000 | 2 |
| Jul 2015 | Angiography | 500 | 3000 | 3 |
| Aug 2015 | CT Scan | 500 | 2400 | 3 |
| Sep 2015 | MRI | 750 | 1800 | 4 |
| Oct 2015 | Ultrasonography | 1000 | 2400 | 4 |
| Nov 2015 | Angiography | 1000 | 2400 | 5 |
| Dec 2015 | CT Scan | 500 | 2400 | 2 |
| Jan 2016 | MRI | 750 | 3000 | 3 |
| Feb 2016 | Ultrasonography | 750 | 3000 | 4 |
| Mar 2016 | Angiography | 1000 | 3000 | 3 |
| Apr 2016 | CT Scan | 500 | 2400 | 3 |
| May 2016 | MRI | 750 | 2400 | 2 |
| Jun 2016 | Ultrasonography | 750 | 2400 | 3 |
| Jul 2016 | Angiography | 1000 | 3000 | 4 |
| Aug 2016 | CT Scan | 750 | 2400 | 3 |
| Sep 2016 | MRI | 750 | 2400 | 4 |
| Oct 2016 | Ultrasonography | 750 | 3000 | 4 |
| Nov 2016 | Angiography | 1000 | 3000 | 3 |
| Dec 2016 | CT Scan | 500 | 1800 | 4 |
| Jan 2017 | MRI | 1000 | 1800 | 3 |
| Feb 2017 | Ultrasonography | 1000 | 1800 | 2 |
| Mar 2017 | Angiography | 1000 | 2400 | 3 |
| Apr 2017 | CT Scan | 750 | 2400 | 2 |
| May 2017 | MRI | 750 | 3000 | 4 |
| Jun 2017 | Ultrasonography | 1000 | 3000 | 2 |
| Jul 2017 | Angiography | 1000 | 3000 | 3 |
| Aug 2017 | CT Scan | 500 | 2400 | 3 |
Criteria
| Criteria Range | ||||
| Month | Image | Patients | Total Hours | # of Employees |
Expense Info
| Clemenson Imaging | |||
| Expense Report Information | |||
| Last Name | First Name | Date | Amount |