Spreadsheet: 159124d1338504195-trim-formula-az-bud
Sheet: Budget Starting Point

 | 2013 Forecasted Estimates
 | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Annual Estimate
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
[PHONE]  Mcare Contr O/P - CY |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.2343757781245117
[PHONE]  [NAME] O/P - CY |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.005373233980907205
[PHONE]  [NAME] HMO Contrs O/P |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.06108469402463473
[PHONE]  W/C O/P |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01643511915077418
[PHONE]  BC Contrs O/P |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.05808106001894591
[PHONE]  Champ - O/P |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.002037448452266503
[PHONE]  Mgd Care Contrs O/P |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5246850403994157
[PHONE]  Mcare HMO O/P |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0584892023429324
[PHONE]  [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0001977728353870227
Uninsured Deductions - IP |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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
[PHONE]  Charity Care O/P |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.03367023117634539
Revenue Deductions
[PHONE]  [NAME]
[PHONE]  Bad Debt Recoveries
Bad Debts
Net Patient Revenue
[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
[PHONE]  [NAME] pay | 49200 | 49200 | 49200 | 49200 | 49200 | 49200 | 49200 | 49200 | 49200 | 49200 | 49200 | 49200
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)
Gross Revenue per Phys Visits
Gross Rev/WRVU
Net Rev/WRVU
[PHONE] Worked RVUs
WRVU/Visit |  |  |  |  | 6.1