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) by calculating the monthly totals and totals for each client. 2. The expenses are divided into labor and non-labor sections. a. 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. b. 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 your properly named file. Point Allocation (50 total points) . Preparing the Revenue: (10) Preparing the Labor Expenses: (10) Preparing the non-labor Expenses: (10) Projected net revenue for the budgeted year: (5) Ratio: Salary as percent of total expense: (5) Ratio: Salary as percent of total revenue: (5) Ratio: Physician and ANP labor percentage: (5)