Question

In: Accounting

You have been hired as the manager of a community health center. This health center provides...

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!

You go home to review your old Health Services Finance text to see if there is anything there that can help you. You find Chapter 16 and begin to read. Luckily, you come across Table 16-4 (page 185) which shows you what a typical static budget looks like. It's all coming back to you now!....You need to show your Revenue, your Expenses, and your Net Income. You open a new Excel file and begin.

Static budget assumption per procedure Static budget totals
# Procedure performed 1,000
Net expenses $400 per procedure $400,000

Expenses:

Salaries & employee benefits

Supplies

Insurance – general

Insurance – malpractice

Depreciation - Building

Depreciation – Equipment

Total expenses

[Various]

[Various]

[Various]

[Various]

[Various]

[Various]

$150,000

25,000

    5,000

10,000

50,000

100,000

$340,000

Operating Income $ 60,000

Requirement: Create an annual static budget for the health center described above using Excel. Submit the budget using the link provided below.

Solutions

Expert Solution

As given in the question, 3000 patients are expected per month

As an annual static Budget is being prepared, total Patients (Annual)= 3000*12=36000

Assumptions (Annual Amounts)

-Physician's Salary $10000*12= $120,000 * 4 Physicians = $480,000

-Clinical Staff Salary  $8000*12= $96,000 * 6 Physicians = $576,000

-Administrative Staff Salary $6000*12= $72,000 * 8 Physicians = $576,000

-Revenue per Patient $200

-Part Time Staff Payment $6000*12= $72,000

-Insurance of Community Health Centre $100,000

-Depreciation of Building $1,000,000

-Depreciation of Equipment $500,000

ANNUAL STATIC BUDGET

Revenue 36000*200 $7,200,000

Expenses

-Physician's Salary $480,000

-Clinical Staff Salary $576,000

-Administrative Staff Salary $576,000

-Part Time Staff Payment $72,000

-Insurance of Community Health Centre $100,000

-Depreciation of Building $1,000,000

-Depreciation of Equipment $500,000

OPERATING INCOME $3,896,000


Related Solutions

You have just been hired as a community health program planner by a local city. The...
You have just been hired as a community health program planner by a local city. The city has noticed that childhood obesity rates have been steadily increasing and would like you to develop programs to help decrease childhood obesity in the city. You notice that the city does not have physical activity programs. Which model/framework would you use to develop such a program? Explain your answer.
You have been hired to be the campaign manager for a candidate for Governor of the...
You have been hired to be the campaign manager for a candidate for Governor of the State of Texas. As campaign manager, you need to develop the campaign plan based on the four of the five (do not worry about campaign organization) components of a modern campaign. Please address the following ... Candidate: A description of the qualifications (personal and professional) of the fictional candidate you will be working for. Create the biography for your candidate, including name, experience, history...
You have been hired as an informatician at a state health department. The health department is...
You have been hired as an informatician at a state health department. The health department is developing systems to receive laboratory and clinical case reports from clinical settings, such as hospitals and doctor's offices. Your state has had an immunization registry in operation for several years and has been successful in getting cooperation from healthcare settings to send data to the system. What standard vocabulary is used to code a vaccine name and how is this vocabulary different from the...
You have been hired as an informatician at a state health department. The health department is...
You have been hired as an informatician at a state health department. The health department is developing systems to receive laboratory and clinical case reports from clinical settings, such as hospitals and doctor's offices. Your state has had an immunization registry in operation for several years and has been successful in getting cooperation from healthcare settings to send data to the system What is the difference between the information required to report the administration of an immunization and the information...
You have just been hired as the manager of a four-star city center hotel. Your prices are 20 per cent
You have just been hired as the manager of a four-star city center hotel. Your prices are 20 per cent cheaper than comparable competitors. You have decided to increase your prices by 15–20 per cent. What are the implications of this decision?
You have been hired to promote the work of a local organization that provides services to...
You have been hired to promote the work of a local organization that provides services to troubled teenagers. Before beginning your job, you have been told that the organization cannot engage in advertising due to the sources of its funding. What other promotional options can you use in spite of the lack of budget?
You have been hired as the new Loan Department Manager in a bank that has been...
You have been hired as the new Loan Department Manager in a bank that has been having troubles in the loan department as identified by the federal auditors. You task is to clean the procedures, the lending policies and reduce the problematic loans so that profitability is restored and the CAMELS score improves. Please take me through the process and set up clear policies and procedures
You have been hired as the new Loan Department Manager in a bank that has been...
You have been hired as the new Loan Department Manager in a bank that has been having troubles in the loan department as identified by the federal auditors. You task is to clean the procedures, the lending policies and reduce the problematic loans so that profitability is restored and the CAMELS score improves. Please take me through the process and set up clear policies and procedures
imagine you have graduated from UCD, you have been hired by a business as a Manager...
imagine you have graduated from UCD, you have been hired by a business as a Manager over a specific function. You have six direct reports assigned to you. Today is your first day on the job. Your Manager has asked to meet with you late today – she has stated that in your meeting late this afternoon she would like to have you review your plan with her on how you will lead and manage your department. You know that...
imagine you have graduated from UCD, you have been hired by a business as a Manager...
imagine you have graduated from UCD, you have been hired by a business as a Manager over a specific function. You have six direct reports assigned to you. Today is your first day on the job. Your Manager has asked to meet with you late today – she has stated that in your meeting late this afternoon she would like to have you review your plan with her on how you will lead and manage your department. You know that...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT