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. Table 5.3 Hospital Example Physician Example Table 5.4 Figure 5.2 Chapter 5 - Scratch Badget Table 5.4 - Master Budget Adapted for a Hospital Department NOTE for Assignment This examples Employees Management and 2 Nursing) Please consider the nursing ratio red for the Diagnostic Group you choose Object Code Description Productivity Standard 4010 Management and clerical staff $175.000 1020 Nursing Salaries S56240 RN 515, 160 Nurse Assista 4110 FICA 620 SI 3000 + 1 45% unlimited 4120 Balth insurance $6,000 per cmployee 41 Retirement 5% of wages 4140 Unemployment 1.1% of wapes 4210 Clinical supplies SS50 N ent 4350 Omice supplies 52.00 Nant 4350 Space Allocation 4910 Marketing 25.100 4940 Travel professional meeting meals S5.000 Total Expenses Badget $175.OCO 9100 16704 18.000 13.490 1925 25.000 SM659 Stathis 50 bed in Unit Front -SW699 Table 4.2 Figure 4.2 Figure 4.3a Figure 4.3b Table & Figure 4.4 Table 4.6 Table 4.8 Table 4.9 PM Chapter 1 Churu Forest Revente Budgets Table 42. Major against Categories, 2013 as the number of cas for your budget MEC Wat Mamas MDCI Ungroupable Nervous 43820 1.9557 1.0524 49700 MDC MDC Muscule 2.2514 42819 1.219 MDC 10 Ende MDC 11 Ky MDC 12 Make MDC 13 Female MDC 14 any 4297 2015 1.2565 MDC 16 Blood MX17 Melo SIN 21207 MDC 19 Mental MDC 20 Alabel Drug MDC 22 Burt MDC 21 Factors MDC 24 Trama MDC 25 HIY 4.7773 1.2470 3,4054 2.3214 Tools 8.1329 40566 6.2656 7725 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 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 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. Table 5.3 Hospital Example Physician Example Table 5.4 Figure 5.2 Chapter 5 - Scratch Badget Table 5.4 - Master Budget Adapted for a Hospital Department NOTE for Assignment This examples Employees Management and 2 Nursing) Please consider the nursing ratio red for the Diagnostic Group you choose Object Code Description Productivity Standard 4010 Management and clerical staff $175.000 1020 Nursing Salaries S56240 RN 515, 160 Nurse Assista 4110 FICA 620 SI 3000 + 1 45% unlimited 4120 Balth insurance $6,000 per cmployee 41 Retirement 5% of wages 4140 Unemployment 1.1% of wapes 4210 Clinical supplies SS50 N ent 4350 Omice supplies 52.00 Nant 4350 Space Allocation 4910 Marketing 25.100 4940 Travel professional meeting meals S5.000 Total Expenses Badget $175.OCO 9100 16704 18.000 13.490 1925 25.000 SM659 Stathis 50 bed in Unit Front -SW699 Table 4.2 Figure 4.2 Figure 4.3a Figure 4.3b Table & Figure 4.4 Table 4.6 Table 4.8 Table 4.9 PM Chapter 1 Churu Forest Revente Budgets Table 42. Major against Categories, 2013 as the number of cas for your budget MEC Wat Mamas MDCI Ungroupable Nervous 43820 1.9557 1.0524 49700 MDC MDC Muscule 2.2514 42819 1.219 MDC 10 Ende MDC 11 Ky MDC 12 Make MDC 13 Female MDC 14 any 4297 2015 1.2565 MDC 16 Blood MX17 Melo SIN 21207 MDC 19 Mental MDC 20 Alabel Drug MDC 22 Burt MDC 21 Factors MDC 24 Trama MDC 25 HIY 4.7773 1.2470 3,4054 2.3214 Tools 8.1329 40566 6.2656 7725 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 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 Need help creating budget for... Physician Practice use Excel files Chapter 4 Table - 4.8 and Chapter 5 - Physician Example