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 4.8 Calculating the Revenue Budget for a Physician Practice HCPCS Output RVU Quantity Price Revenue New Patient Level I, Brief 99201 0.95 $67.31 112 $7,538.72 Level II, Limited 99202170 $120.45 165 $19,874.25 Level III, Moderate 992032.52 $178.54 402 $71,773.08 Level IV, Extended 99204 3.59 $254.35 109 $27,724.15 Level V, Comprehensive 992054 .58 $324.49 5 2 $16,873.48 Established Patient Level 1, Brief 99211 0.56 $39.68 269 $10,673.92 Level II, Limited 99212 0.99 $70.14 541 $37,945.74 Level III, Moderate 99213 1.39 $98.48 3,269 $321,931.12 Level IV. Extended 99214 2.17 $153.74 632 $97,163.68 Level V, Comprehensive 99215 3.18 $225.30 309 $69,617.70 Total 5,860 $681,115.84 TABLE 4.2 Major Diagnostic Categories, 2013 MDC Name Weights Arithmetic Mean LOS PRE Ungroupable 6.3640 12.5799 Nervous system 1.9867 4.3820 Eye 1.0524 3.0405 Ear, nose, and throat 1.2122 3.0879 4.5267 Respiratory system 1.5149 Circulatory system 2.9247 4.7412 1.7970 4.9200 Digestive system 1.9800 5.2758 Hepatobiliary system 2.2514 4.4476 Musculoskeletal system 1.4722 4.2819 Skin, subcutaneous tissue, and breast 1.7198 4.2803 Endocrine, nutritional, and metabolic systems 1.7033 4.2978 Kidney and urinary tract (continues) (continued TABLE 4.2 Major Diagnostic Categories, 2013. Weights Arithmetic MDC Name Mean LOS 1.2365 3.2013 12 Male reproductive system 1.5067 3.7088 13 Female reproductive system 0.8028 2.4737 Pregnancy and childbirth 2.3952 7.5429 Newborn and other neonates 1.8006 4.4130 Blood, blood-forming organs, and immunological disorders Myeloproliferative diseases and disorders 2.3737 5.8818 Infectious diseases and disorders 2.1707 5.7546 Mental diseases and disorders 1.0721 4.0964 Alcohol/drug use or induced mental disorders 0.9325 4.8167 Injuries, poison, and toxic effects of drugs 1.5398 3.9311 Burns 4.7773 8.1329 Factors influencing health status 1.2470 4.0566 24 Multiple significant trauma 3.4054 6.2656 25 Human immunodeficiency virus infection 2.3244 LOS, length of stay 5.9830 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 Chapter #Output Parvest and Reverse Budgets Table 4.2. Major Diagnostic Categories, 2013 of case your dat Washes Mens Cases MDCI 120524 47412 1.9 14122 42819 42801 MDC MIC pable Nervous MDC 2 MDCI ENT MDC 4 Respiratory MDC Circular MC Digestive MIXC7 MIX Musculo MDC MDC 10 Endocrine MDC 11 MDC 12 Male MDXC 13 Female MDXC 14 Pregnancy MIX 15 Newhom MDC 16 Rood MDXC 17 Myelo MDC IN infectious MDC 19 Mental MDC 20 Alcohol Drug MDC 21 Irry Poison MDC 22 Pirns MX21 wtor MDXC 24 Trama MDC 25 HIV 3.2013 O.RO 1.2006 UTA 7.5429 44120 SIS 35 09125 48167 19111 X1320 40866 4. TTT 1.2470 21248 Total Cases Table 5.3 Hospital Example Physician Example Table 5.4 Figure 5.2 Chapter 5 - Scratch Budgeting Table 1. udget for 5000 Table Lamps Object Code Type of laput 4010 M agement and clerical staf Suat salaries and wages Product per year hours per unit Quantity Input Pris 1000 550 000 30 000 $175.000 Budget 550.000 $125.000 SIX 4130 per employee salaries salaries $175.000 $175.000 5.00% 1.10% 58,750 $1.925 4210 Health insurance Retirement Unemployment Supplies Socket Mrr cond Shack Raluk W M any Office supplies SO 5000 5000 422 7.9 55 39 526,950 $1440 572.000 $250 $98,750 $4.500 57. 500 S1.00 $5.000 $26 $41.000 $1.500 $1,500 4250 5000 Repairs and maintenance Electricity board fet per unit board feel per unit board feet per unit per unit suare feet year per year per month per month path mamath per month per year per dare units nom labor expenses Wanawag Tale 5100 575 $200 51.200 S1 LO $2,400 4510 4610 4810 Depreciation Freight Other penses (glue stain... $25 $10.417 25956479 I $25.16 Outpat Sestistes Cost per lamp $100.19 Price (10% mark-up) $110.21 Create Budge answer the following: how did you calculate your revenue? How did you calculate the expenses? To answer that part, you will need to make some assumptions. How many services will be provided? Why do you think this will be the number of services? For example, if you choose the hospital services, I provided a scenario of an increase in the services and a staffing level. Are there other expenses that will increase due to this? You are welcome to use your own budget template. You can be creative. You can use your own experience. Just elaborate on your reasons why behind your budget. 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 4.8 Calculating the Revenue Budget for a Physician Practice HCPCS Output RVU Quantity Price Revenue New Patient Level I, Brief 99201 0.95 $67.31 112 $7,538.72 Level II, Limited 99202170 $120.45 165 $19,874.25 Level III, Moderate 992032.52 $178.54 402 $71,773.08 Level IV, Extended 99204 3.59 $254.35 109 $27,724.15 Level V, Comprehensive 992054 .58 $324.49 5 2 $16,873.48 Established Patient Level 1, Brief 99211 0.56 $39.68 269 $10,673.92 Level II, Limited 99212 0.99 $70.14 541 $37,945.74 Level III, Moderate 99213 1.39 $98.48 3,269 $321,931.12 Level IV. Extended 99214 2.17 $153.74 632 $97,163.68 Level V, Comprehensive 99215 3.18 $225.30 309 $69,617.70 Total 5,860 $681,115.84 TABLE 4.2 Major Diagnostic Categories, 2013 MDC Name Weights Arithmetic Mean LOS PRE Ungroupable 6.3640 12.5799 Nervous system 1.9867 4.3820 Eye 1.0524 3.0405 Ear, nose, and throat 1.2122 3.0879 4.5267 Respiratory system 1.5149 Circulatory system 2.9247 4.7412 1.7970 4.9200 Digestive system 1.9800 5.2758 Hepatobiliary system 2.2514 4.4476 Musculoskeletal system 1.4722 4.2819 Skin, subcutaneous tissue, and breast 1.7198 4.2803 Endocrine, nutritional, and metabolic systems 1.7033 4.2978 Kidney and urinary tract (continues) (continued TABLE 4.2 Major Diagnostic Categories, 2013. Weights Arithmetic MDC Name Mean LOS 1.2365 3.2013 12 Male reproductive system 1.5067 3.7088 13 Female reproductive system 0.8028 2.4737 Pregnancy and childbirth 2.3952 7.5429 Newborn and other neonates 1.8006 4.4130 Blood, blood-forming organs, and immunological disorders Myeloproliferative diseases and disorders 2.3737 5.8818 Infectious diseases and disorders 2.1707 5.7546 Mental diseases and disorders 1.0721 4.0964 Alcohol/drug use or induced mental disorders 0.9325 4.8167 Injuries, poison, and toxic effects of drugs 1.5398 3.9311 Burns 4.7773 8.1329 Factors influencing health status 1.2470 4.0566 24 Multiple significant trauma 3.4054 6.2656 25 Human immunodeficiency virus infection 2.3244 LOS, length of stay 5.9830 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 Chapter #Output Parvest and Reverse Budgets Table 4.2. Major Diagnostic Categories, 2013 of case your dat Washes Mens Cases MDCI 120524 47412 1.9 14122 42819 42801 MDC MIC pable Nervous MDC 2 MDCI ENT MDC 4 Respiratory MDC Circular MC Digestive MIXC7 MIX Musculo MDC MDC 10 Endocrine MDC 11 MDC 12 Male MDXC 13 Female MDXC 14 Pregnancy MIX 15 Newhom MDC 16 Rood MDXC 17 Myelo MDC IN infectious MDC 19 Mental MDC 20 Alcohol Drug MDC 21 Irry Poison MDC 22 Pirns MX21 wtor MDXC 24 Trama MDC 25 HIV 3.2013 O.RO 1.2006 UTA 7.5429 44120 SIS 35 09125 48167 19111 X1320 40866 4. TTT 1.2470 21248 Total Cases Table 5.3 Hospital Example Physician Example Table 5.4 Figure 5.2 Chapter 5 - Scratch Budgeting Table 1. udget for 5000 Table Lamps Object Code Type of laput 4010 M agement and clerical staf Suat salaries and wages Product per year hours per unit Quantity Input Pris 1000 550 000 30 000 $175.000 Budget 550.000 $125.000 SIX 4130 per employee salaries salaries $175.000 $175.000 5.00% 1.10% 58,750 $1.925 4210 Health insurance Retirement Unemployment Supplies Socket Mrr cond Shack Raluk W M any Office supplies SO 5000 5000 422 7.9 55 39 526,950 $1440 572.000 $250 $98,750 $4.500 57. 500 S1.00 $5.000 $26 $41.000 $1.500 $1,500 4250 5000 Repairs and maintenance Electricity board fet per unit board feel per unit board feet per unit per unit suare feet year per year per month per month path mamath per month per year per dare units nom labor expenses Wanawag Tale 5100 575 $200 51.200 S1 LO $2,400 4510 4610 4810 Depreciation Freight Other penses (glue stain... $25 $10.417 25956479 I $25.16 Outpat Sestistes Cost per lamp $100.19 Price (10% mark-up) $110.21 Create Budge answer the following: how did you calculate your revenue? How did you calculate the expenses? To answer that part, you will need to make some assumptions. How many services will be provided? Why do you think this will be the number of services? For example, if you choose the hospital services, I provided a scenario of an increase in the services and a staffing level. Are there other expenses that will increase due to this? You are welcome to use your own budget template. You can be creative. You can use your own experience. Just elaborate on your reasons why behind your budget