Spreadsheet: 159124d1338504195-trim-formula-az-bud
Sheet: Budget With Drivers

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gross Allocation
 |  | 2013 Forecasted Estimates
 |  | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Annual Estimate |  | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct
 | Medicare Gross Revenue - OP
 | Medicaid Gross Revenue - OP
 | Medicaid HMO Gross Revenue - OP
 | Workers' Compensation Gross Revenue - OP
 | HMO and PPO Gross Revenue - OP
 | Medicare HMO Gross Revenue - OP
 | Commercial/Other Gross Revenue - OP
 | Self Pay/Charity Gross Revenue - OP
 | Gross Patient Revenue
 | DEDUCTIONS FROM REVENUE |  |  |  |  |  |  |  |  |  |  |  |  |  | Alocation | PCR
 | [PHONE]  Mcare Contr O/P - CY |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.2343757781245117
 | [PHONE]  [NAME] O/P - CY |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.005373233980907205
 | [PHONE]  Mcare HMO O/P |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0584892023429324
 | [PHONE]  [NAME] HMO Contrs O/P |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.06108469402463473
 | [PHONE]  Mgd Care Contrs O/P |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5246850403994157
 | Commercial/Other Gross Revenue - OP
 | [PHONE]  Charity Care O/P |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.03367023117634539
 | Self Pay Unins
 | [PHONE]  W/C O/P |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01643511915077418
 | [PHONE]  BC Contrs O/P |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.05808106001894591
 | [PHONE]  Champ - O/P |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.002037448452266503
 | [PHONE]  [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0001977728353870227
 | [PHONE]  Unins Disc - Contr Self - OP |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0001919470971310809
 | [PHONE]  Out-of-Network Contr OP |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.002596014403368051
 | [PHONE]  [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0001489411897729398
 | [PHONE]  [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.002435743968220395
 | Revenue Deductions
 | [PHONE]  [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.03103510181490019
 | [PHONE]  Bad Debt Recoveries |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.0001971908946307253
 | Bad Debts |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.03083791092026946
 | Net Patient Revenue
 | PCR
 | [PHONE]  Supp
 | [PHONE]  Oth Serv Rev
 | [PHONE] Interest Income
 | Other Operating Revenue
 | Net Revenue
 | Operating Expense
 | [PHONE] Prod Sal & Wag - Overtime
 | [PHONE]  Aides & orderlies - Overtime
 | [PHONE]  Cler & oth admin - Overtime
 | [PHONE]  Prod Sal & wages
 | [PHONE]  [NAME] Accrual
 | [PHONE]  Aides & orderlies - Reg pay
 | [PHONE]  Cler & Admin
 | [PHONE]  Cler & oth admin - Reg pay |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HR Rate
 | [PHONE]  [NAME] pay | 49000 | 49000 | 49000 | 49000 | 49000 | 49000 | 49000 | 49000 | 49000 | 49000 | 49000 | 49000 |  |  | Pay increase
 | Productive Labor
 | [PHONE]  Sick pay
 | [PHONE]  PTO - Accrual Replen
 | [PHONE]  PTO - PTO Taken
 | Non-productive Labor
 | Salaries & Wages
 | [PHONE]  Emp'ee Med Insur |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.009605752526686799
 | [PHONE]  Health Benefits Allocation |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01743045457459066
 | [PHONE]  Oth Emp'ee Benefits |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0008696432763173001
 | [PHONE]  Payroll Tax - FICA |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.03340143264655166
 | [PHONE]  Payroll Tax - fed unemploy |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0003236905111599131
 | [PHONE]  Payroll Tax - state unemploy |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.00123048317925568
 | [PHONE]  Pen, Retire,  ESOP (401k) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01344412120006102
 | [PHONE]  Workers' Excess Indemnity |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.001444994341115705
 | Benefits |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.07775057225573873
 | [PHONE]  [NAME]
 | [PHONE]  Drugs & pharm
 | [PHONE]  Forms & Comp paper
 | [PHONE]  Office & Dept. [NAME]
 | Supplies W/O Implants
 | Supplies
 | [PHONE]  Collect - Collect agency
 | [PHONE]  [NAME]
 | [PHONE]  Outside Consultant Serv
 | [PHONE]  Transcription Serv
 | Purchased Services
 | [PHONE]  Repairs - Inhouse
 | [PHONE]  Cellular Phones & Pagers
 | [PHONE]  Oth Mkting Exp.
 | [PHONE]  Malprac - Corporate Plan
 | [PHONE]  Subscriptions
 | [PHONE]  Oth Dues
 | Tot Dues & Subscriptions
 | [PHONE]  Licenses & Permits
 | [PHONE]  Outside Sem, Training
 | Tot Oth Operating Exp
 | [PHONE]  Business Meals & Entertain
 | [PHONE]  Travel & Lodging
 | [PHONE]  Airfare
 | Operating Expenses
 | EBITDA - Direct Costs
 | [PHONE] Prod. Clinical (Contra)
 | [PHONE] Prod. Other [NAME] (Contra)
 | [PHONE] Non-Prod. Clinical/Other Admin (Contra)
 | [PHONE] Allocated Benefits (Contra)
 | [PHONE] Office Admin Supplies (Contra)
 | [PHONE] Rent Expense (Contra)
 | [PHONE] Other Purchased Services (Contra)
 | [PHONE] Transcription Services (Contra)
 | [PHONE] Maintenance Contracts (Contra)
 | [PHONE] Utilities (Contra)
 | [PHONE] Other Marketing Exp. (Contra)
 | [PHONE] Malpractice - Corp/Oth (Contra)
 | [PHONE] Insurance - Other (Contra)
 | [PHONE] Other Misc. Operating (Contra)
 | Practice Allocations
 | EBITDA - Direct Costs incl. Practice Overhead
 | [PHONE] Other Misc. Oper. (Contra OH)
 | EBITDA - Fully Allocated
 | Total Physician FTEs
 | Total Staff FTEs - Staff
 | Total FTEs
 | Key Statistics/Indicators
 | 999580 Total Visits | 103
 | PCR (Includes Bad Debts) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Deductions/ Net Revenue Driver
 | Gross Revenue per Phys Visits |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fixed Calculation on Historical Averages
 | Gross Rev/WRVU
 | Net Rev/WRVU
 | SNIFF TEST Calculated Net Rev/WRVU
 | [PHONE] Worked RVUs |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gross Revenue [NAME] on LTM Actual
 | VISIT Ratio
 | WRVU/Visit
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Average Year over Year considering Budget
 | Growth Driver | 1.8