Although you may not yet have all the information you need to complete the interactive budget- planning Excel workbook, you should download it now. As you continue through this unit or click on the hyperlinks in the workbook, you will come upon more of the information you need.
The workbook has three worksheets (tabs). When you complete the revenue worksheet and the expenses worksheet, the summary worksheet (shown below) will be generated simultaneously.
The following static budget-planning worksheet lists the typical sources of revenue and expenses for a six-chair safety net dental clinic. Before entering your own figures, download the file so that you will be able to compare the analysis of the financial impact of different decisions, assumptions, and costs specific to your situation, and also save the workbook. For example, decisions about the fee schedule and sliding fee schedule, the payer mix, and the productivity targets will affect your patient-care revenue and clinic expenses.
Interactive Budget-Planning Workbook—Summary
(This table is static, the downloadable workbook is interactive.)
|I. PATIENT-CARE REVENUE||I. Start-up costs|
|Medicaid||$382,356||Construction or remodeling cost||$628,875|
|Other public program contracts||$28,652||Supplies, instruments and small equipment||$70,590|
|Full||$42,237||START-UP COSTS TOTAL||$1,126,905|
|Sliding fee schedule||$46,189||II. Operating expenses|
|Indemnity (fee-for-service)||$70,395||Fringe benefits||$108,883|
|Managed Care - PPO||$32,604||Personnel total||$544,414|
|Capitation patient care income||$53,352|
|PATIENT CARE REVENUE TOTAL||$762,242||B. Miscellaneous operating expenses|
|II. NON-PATIENT CARE REVENUE||Equipment maintenance||$13,800|
|Grants and contracts||$245,000||Housekeeping||$6,600|
|NON-PATIENT-CARE REVENUE TOTAL||$281,500||Rent/mortgage||$30,408|
|Miscellaneous operating expenses subtotal||$333,882|
|The Bottom Line|
|Non-Patient-Care Revenue||$281,500||TOTAL START-UP EXPENSES||$1,126,905|
|Patient-Care Revenue||$762,242||TOTAL ANNUAL OPERATING EXPENSES||$878,296|