MS Office Integration Project
JadaNelson1
SC_EX365_2021_1-3a_JadaNelson_1.xlsxDocumentation
| Wellpoint Medical Clinic | |
| INTEGRATE EXCEL, ACCESS, WORD, AND POWERPOINT DATA | |
| Author: | Jada Nelson |
| Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. | |
Department
| Revenue and Bonuses | |||||||||||
| Last updated: | |||||||||||
| Quarterly Revenue | Statistics | ||||||||||
| Actual Revenue | Department | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Trend | Total | % of Total | Average | Maximum | Minimum |
| General Medicine | 121749.5 | 126672.6 | 130152.7 | 127829.75 | |||||||
| Laboratory | 55,827.25 | 49,623.20 | 44,339.75 | 43,973.35 | |||||||
| Radiology | 37,330.70 | 34,667.74 | 32,084.48 | 31,974.90 | |||||||
| Wellness | 23,307.55 | 23,802.25 | 23,001.73 | 23,782.10 | |||||||
| Total | 238215 | 234765.79 | 229578.66041869 | 227560.1 | |||||||
| Bonuses Earned | |||||||||||
| Paid to Date | Bonuses | Quarter 1 | Trend | Total | |||||||
| Amount Eligible | $0.00 | ||||||||||
| Share Amount | $1,250.00 | $1,250.00 | $1,250.00 | $1,250.00 | $5,000.00 | ||||||
| Net Bonus | $0.00 | ||||||||||
| Bonus Percentage | 35% | ||||||||||
| Projected Revenue | |||||||||||
| Projections | Department | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Trend | Total | ||||
| General Medicine | 130880.7125 | 136173.045 | 139914.1525 | 137416.98125 | 544384.89125 | ||||||
| Laboratory | 58618.6125 | 52104.36 | 46556.7375 | 46172.0175 | 203451.7275 | ||||||
| Radiology | 39383.8885 | 36574.4657 | 33849.1264 | 33733.5195 | 143541.0001 | ||||||
| Wellness | 25288.69175 | 25825.44125 | 24956.8775042787 | 25803.5785 | 101874.589004279 | ||||||
| Total | 254171.90525 | 250677.31195 | 245276.893904279 | 243126.09675 | 993252.207854279 | ||||||
| What-If Assumptions | |||||||||||
| Revenue +/- | Department | Increase % | |||||||||
| General Medicine | 7.5% | ||||||||||
| Laboratory | 5.0% | ||||||||||
| Radiology | 5.5% | ||||||||||
| Wellness | 8.5% | ||||||||||
Studies
| Providers Participating in Health Studies |
| Participation in Recent Studies |
