SAMPLE OPERATIONS BUDGET FLU VACCINATION CLINIC ****I need help with steps one and two...

70.2K

Verified Solution

Question

Accounting

SAMPLE OPERATIONS BUDGET FLU VACCINATION CLINIC

****I need help with steps one and two salaries employee benefits and net profit or loss only.***

I. Revenue and Income

Last Year's Budget

Step 1:

This Year's Budget

Step 2:

Revised Budget - Administering Both the Flu & COVID vaccine

A. Adult Patient Revenue

$30,000

36000

36000

B. Child Patient Revenue

18,000

18000

18000

Total Revenue

$48,000

54000

54000

II. Expenses

A. Salaries

$10,385

B. Vaccines

16,000

18540

18540

C. Syringes

1,600

1890

2520

D. Band-aids

2,200

2448

2448

E. Supplies

2,800

3660

3600

F. Employee Benefits (23%)

$2,388

G. Administration

1,450

1465

1464.5

H. Equipment Depreciation

500

505

505

I. Physical Plant Operations

1,275

1288

1287.75

J. Maintenance and Repairs

250

253

252.50

K. Building Depreciation

750

758

757.5

L. Laundry/Linen

313

316

316.13

M. Housekeeping

400

404

404

Total Expenses

$40,311

51262

Net Profit or Loss

$7,689

Step 1:

The following details about revenues and costs associated with running the flu vaccination clinic are available to you. Use this information to build this years budget.

  1. Last year, your flu vaccine clinic provided 1000 adults and 600 children with the flu vaccine. This year, you expect the number of adults that receive the flu vaccine from your clinic to increase by 20%, due to new services contracts your hospital has with a number of assisted living facilities.
  2. Revenue per patient receiving the flu vaccine was $30.00 last year and will remain the same per patient this year.
  3. Each dose of the flu vaccine cost $10.00 last year. There are 20 doses of the vaccine in each vial. This year that cost is expected to increase by 3%.
  4. The syringe to administer the flu vaccine cost $1.00 last year. Syringes are purchased 100 to a box. This year that cost will increase to $1.05 per syringe.
  5. After each flu shot, a band-aid is applied to the patients arm. Last year your organization bought regular and glow-in-the-dark band-aids. A regular band-aid costs $1.00 and a glow-in-the-dark band-aid costs $2.00. Band-aids are purchased by the box and come 20 to a box. The cost of band-aids will increase by 2% this year. Adults prefer the regular band-aids and children always request glow-in-the-dark band-aids.
  6. The cost of other supplies used for each patient was $1.75 last year and is expected to be $2.00 this year. (These other supplies include things like cotton balls, disinfectant wipes, and skin prep wipes.)
  7. Last year your organization had 2 nurses that staffed the vaccine clinic for 4 hours per day, 5 days per week, for 12 weeks. These nurses are salaried, and each were paid $45,000 per year. (When not working at the flu vaccine clinic, they work full-time for your hospital performing other duties. Full-time is defined as 8 hours per day, 5 days per week.) Their benefits cost the hospital 23% of their salary. (NOTE: The flu vaccination clinic is only charged for the portion of their time that the nurses work at the clinic and a year has 52 weeks. That means for last year they were charged for 12 out of 52 weeks for 20 hours per week per nurse or 12/52 weeks x 20/40 hrs. x $45,000 salary x 2 nurses = $10,385.) This year, the nurses got a 3% pay increase. It takes 15 minutes per patient to administer the flu vaccination and complete all necessary paperwork per patient. Make sure the hours your clinic is staffed is sufficient to cover the volume of patients you will be seeing this year. If not, you will need to add another nurse since each nurse can only work 4 hours per day and a total of 20 hours per week at the vaccine clinic. An additional nurse would earn the same salary and benefits as one of the current nurses.
  8. All other expenses are covered as part of the hospitals normal operating costs and a percentage of that expense is allocated to the flu vaccination clinic as shown in the sample budget. Allocated expenses are expected to increase 1% this year.

Step 2:

Once you have finished creating this years budget, your supervisor asks you to conduct a cost-feasibility analysis on a proposal to begin offering the COVID vaccine through the flu vaccination clinic. In order to complete this analysis, youll need to create a revised budget for administering both the flu and COVID vaccines at the flu vaccination clinic. Management provides you with the following assumptions:

  1. 50% of the adults will end up receiving the COVID vaccine at the same time as their flu vaccine.
  2. Giving the COVID vaccine will add 5 minutes to the time it takes the nurse to see the patient. This means that one nurse will be able to see 3 patients per hour for those patients receiving both the flu and COVID vaccine. For those patients only receiving the flu vaccine, one nurse can see 4 patients per hour.
  3. It will also require a second syringe be used to administer the COVID vaccine.
  4. You will have to stock the multidose vial of the Janssen (J&J) COVID vaccine that contains 5 doses per vial. (Through an agreement with the government, these multidose vials are being sent to your hospital at no charge. Your organization will also not receive any revenue for administering the COVID vaccine.) In addition, the flu vaccine clinic will only administer the Janssen (J&J) COVID vaccine, which means the patient will only require a single dose of the COVID vaccine.
  5. The space in which you are holding your flu vaccination clinic is only available for the 4 hours per day for the 12 weeks you have planned to run the clinic. Additional staff would need to be added if including the option of receiving the COVID vaccination would prevent all patients who wanted to receive vaccines from receiving them. If you have to add additional nursing staff, they would be compensated at the same rate and receive the same benefits that the current nurses are compensated. They would need to work a minimum of 4 hours on any day that they work at the clinic. They do not have to work 5 days per week for the 12 weeks though if the demand is not sufficient to support it. The space is large enough to accommodate only 3 nurses working at any given time.

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students