Need help creating budget for... Physician Practice use Excel files Chapter 4 Table - 4.8 and Chapter 5 - Physician Example The spreadsheets for Chapter 4 has some examples to help calculate revenue. The worksheets for Chapter 5 have examples of expenses. Your task is to complete a budget for both Revenue and Expenses. You choose either a physician practice OR a hospital setting. Physician Practice use Excel files Chapter 4 Table - 4.8 and Chapter 5 - Physician Example Hospital Setting use Excel Files Chapter 4 Table 4.2 and Chapter 5 - Hospital Example Your submission should include an explanation of your selection. Please answer why you selected a Physician Budget or a Hospital Department Budget. You must also submit revenue and your expense calculations, any assumptions you made, all in a single Excel file Please take the approach that any acronyms will need a definition. Figure 4.36 Table & Figure 4.4 Table 4.6 Table 4.8 Tab Chapter 4 - Output Forecasts and Revenue Budgets Table 4.8 - Calculating the Revenue Budget for a Physician Practice HCPCS Price Quantity 99201 99200 99200 304 99205 1.70 2.52 Output New Patient Level 1 - Bricf Level Il Limited Level Ill. Moderate Level IV. Fxtended Level V. Comprehensive Established Patient Level! Hier Level ll. Limited Level III - Moderate Level IV. Extended Level V. Comprehensive 567,31 120.45 178.54 254.35 112 165 402 109 52 $751872 19874 25 71.773.08 2 7,724.15 167148 036 200 99211 9212 49213 19.68 10.14 98,48 153,74 235.10 1067192 17,945.74 321.931.12 92.161 60 $681 115.84 541 3.269 612 100 S80 217 29215 Total Table 5.3 Hospital Example Physician Example Table 5.4 Figure 5.2 Chapter . Scratch Budget Table 4. Master Budget for the Physician Practice Budget $175.000 95,600 NOTE for Anime This example has 3 Employees Management and I Nurse and I Billing Staff Please consider that using and ballers for a physican practice vary based on patients I nurse and I biller for the base volume of patients per week Your praction has 22.000 visits per month 18.00 20,760 4.00 Object Code Description Productivity (budget Standard 4010 Manapement and clerical staff 4020 Staff salaries and was 556,240 RN + $15,360 reception bill 4110 FICA 62% SIIV,000+ 1.45% unlimited 4120 Health S4.000 per employee 4130 Retirement 5% of wages 4140 Unemployment 1.1% of wares 4140 Tuition reimbursement $1,500 employee 4210 Clinical supplies SS.SO N iat 4750 Offices 52.00 per patient 410 Rent $1,500 per month +S600 IT 4330 Repairs and maintenance 4410 Electricity S200 square foot 4420 Cat 5200 per square foot 4430 Waand sewage S100 per month 4410 Telephone SISU per month 4510 Malactice insurance $5,000 4610 Depreciation 10% of investment, $40.000 4710 Interest Expense 5% of $40,000 4810 Bad date 1% of grow changes 4910 Marketing S100 per month 4920 Uniforms and landry SE241 4910 Housing 4910 Travel professional meetings meals $5,000 4950 CME $1,000 per year 4960) Other expenses 2.16 Total Expenses 1.2 2,160 1,200 5,000 2.000 5441,552 Statistics 90 patient visits per week 2 56574 0234320 $376,267 Profit 55.254 Need help creating budget for... Physician Practice use Excel files Chapter 4 Table - 4.8 and Chapter 5 - Physician Example The spreadsheets for Chapter 4 has some examples to help calculate revenue. The worksheets for Chapter 5 have examples of expenses. Your task is to complete a budget for both Revenue and Expenses. You choose either a physician practice OR a hospital setting. Physician Practice use Excel files Chapter 4 Table - 4.8 and Chapter 5 - Physician Example Hospital Setting use Excel Files Chapter 4 Table 4.2 and Chapter 5 - Hospital Example Your submission should include an explanation of your selection. Please answer why you selected a Physician Budget or a Hospital Department Budget. You must also submit revenue and your expense calculations, any assumptions you made, all in a single Excel file Please take the approach that any acronyms will need a definition. Figure 4.36 Table & Figure 4.4 Table 4.6 Table 4.8 Tab Chapter 4 - Output Forecasts and Revenue Budgets Table 4.8 - Calculating the Revenue Budget for a Physician Practice HCPCS Price Quantity 99201 99200 99200 304 99205 1.70 2.52 Output New Patient Level 1 - Bricf Level Il Limited Level Ill. Moderate Level IV. Fxtended Level V. Comprehensive Established Patient Level! Hier Level ll. Limited Level III - Moderate Level IV. Extended Level V. Comprehensive 567,31 120.45 178.54 254.35 112 165 402 109 52 $751872 19874 25 71.773.08 2 7,724.15 167148 036 200 99211 9212 49213 19.68 10.14 98,48 153,74 235.10 1067192 17,945.74 321.931.12 92.161 60 $681 115.84 541 3.269 612 100 S80 217 29215 Total Table 5.3 Hospital Example Physician Example Table 5.4 Figure 5.2 Chapter . Scratch Budget Table 4. Master Budget for the Physician Practice Budget $175.000 95,600 NOTE for Anime This example has 3 Employees Management and I Nurse and I Billing Staff Please consider that using and ballers for a physican practice vary based on patients I nurse and I biller for the base volume of patients per week Your praction has 22.000 visits per month 18.00 20,760 4.00 Object Code Description Productivity (budget Standard 4010 Manapement and clerical staff 4020 Staff salaries and was 556,240 RN + $15,360 reception bill 4110 FICA 62% SIIV,000+ 1.45% unlimited 4120 Health S4.000 per employee 4130 Retirement 5% of wages 4140 Unemployment 1.1% of wares 4140 Tuition reimbursement $1,500 employee 4210 Clinical supplies SS.SO N iat 4750 Offices 52.00 per patient 410 Rent $1,500 per month +S600 IT 4330 Repairs and maintenance 4410 Electricity S200 square foot 4420 Cat 5200 per square foot 4430 Waand sewage S100 per month 4410 Telephone SISU per month 4510 Malactice insurance $5,000 4610 Depreciation 10% of investment, $40.000 4710 Interest Expense 5% of $40,000 4810 Bad date 1% of grow changes 4910 Marketing S100 per month 4920 Uniforms and landry SE241 4910 Housing 4910 Travel professional meetings meals $5,000 4950 CME $1,000 per year 4960) Other expenses 2.16 Total Expenses 1.2 2,160 1,200 5,000 2.000 5441,552 Statistics 90 patient visits per week 2 56574 0234320 $376,267 Profit 55.254