- 1 (132 KiB) Viewed 38 times
Me Home Insert Draw Page Layout Formulas Data Review View Help y X LG Calibri 11 ν Α Α' == v Paste Di lili Accounting $ %) While THI Β Ι Ο V V v av Αν v Conditional Formatting Format as Table Cell Styles Styles Undo Clipboard Font Alignment Number 124 vX fx =SUM(C24:F24) D E F G Н Paid to > с $1,250.00 $16,237.55 35% $1,250.00 $15,996.11 $1,250.00 $11,615.38 $1,250.00 $11,509.41 $5,000.00 $55,358.44 A B 4 9 Share Amount 5 Net Bonus 6 Bonus Percentage 17 18 19 Department 20 General Medicine 21 Laboratory 22 Radiology 23 & Wellness 24 Total Trend Projections Projected Revenue Quarter 1 Quarter Quarter 3 Quarter 4 $ 121,749.50 $ 126,672.60 $ 130,152.70 $ 127,829.75 55,827.25 49,623.20 44,339.75 43,973.35 37,330.70 34,667.74 32,084.48 31,974.90 23,307.55 23,802.25 23,001.73 23,782.10 $ 238,215.00 $ 234,765.79 $ 229,578.66 $ 227,560.10 Total $ 506,404.55 193,763.55 136,057.82 93,893.63 $ 930,119.55 25 26 27 28 29 30 Revenue +/- What-If Assumptions Department Increase % General Medicine 8.8% Laboratory 5.0% Radiology 5.5% Documentation Department Analysis x Accessibility. Investigate Ready Studies +