question archive You have been hired as the manager of a community health center
You have been hired as the manager of a community health center
Subject:Health SciencePrice: Bought3
You have been hired as the manager of a community health center. This
health center provides medical care to children. One of your first tasks is to develop a static annual budget for the health center. In fact, the Board of Directors wants to see your budget by Saturday at midnight. In order to develop an accurate static budget, you know you need to get some facts. You ask around to see what kind of information you can gather. This is what you find out: The center pays rent of $12,000 per month. The center has a number of full-time staff members: 4 physicians, 6 clinical staff members, and 8 administrative staff members. The center has to occasionally use part-time workers or pay overtime when patient volume is high. The center sees about 3,000 patients per month. Medical supply costs seem to run about $2 per patient.
Unfortunately, that's all that you can find out on such short notice. Nobody seems to have any more information. You know that this is not enough information to build a proper static budget, so you will need to make some assumptions to get the job done. You are comfortable with making assumptions because you know that it is OK to incorporate assumptions into a budget as long as you clearly identify the assumptions when you present the budget. You also know that it is important to make assumptions that are based on reliable information. Luckily, you recall that you have an HFMA membership and access to a variety of online databases with credible information!
Requirement:
Make an annual static budget for the health center described above using Excel.
Table 16-4 Static Budget Example for an Open Imaging Center
Static Budget Assumptions per Procedure:
Net Revenue Expenses: $400 per procedure =
Salaries & Employee Benefits: [various]
Supplies: [various]
Insurance-General: [Various]
Insurance-Malpractice: [Various]
Static Budget Totals"
# Procedures Performed: 1,000
Net Revenue Expenses: $400,000
Salaries & Employee Benefits: $150,000
Supplies: 25,000
Insurance—General: 5,000
Insurance—Malpractice: 10,000
Total Expenses: $340,000
Operating Income: $60,000
