Instructions You have five physician-practice clients for your World Outpatient clinic. Each physician practice sends you all of their clients. For the purposes of budgeting, we will assume the...

Instructions

1. You have five physician-practice clients for your World Outpatient clinic. Each physician practice sends you all of their clients. For the purposes of budgeting, we will assume the varying amounts of listed gross revenue for each month a client sends patients to the clinic. Please note that each client starts with the clinic at different times during the year.
   Complete the revenue part of the budget worksheet (Budget Assignment Worksheet.xlsx
   
   download) by calculating the monthly totals and totals for each client.


2. The expenses are divided into labor and non-labor sections.
   
   
   
   
   1. For the labor expenses, you are given the needed information to calculate total individual and clinic labor costs. Use 2,080 as the number of hours a full-time employee works.
   
   
   2. For the non-labor expenses, you are given the total available to budget. Allocate those total dollars to each non-labor expense with the percentages your manager has provided.
   
   
   
   


3. Note, in all cases, any calculations must be shown in the Excel file.


4. Submit yourproperly named file.