Answered step by step
Verified Expert Solution
Question
1 Approved Answer
One comprehensive department budget that includes the individual line items as well as monthly budgeted total AND a yearly budgeted total. You will want to
- One comprehensive department budget that includes the individual line items as well as monthly budgeted total AND a yearly budgeted total.
- You will want to include separate lines for salaries, fringe benefits, overtime, and each of the items from the operational budget. Each of these should be allocated by month, with a total for the year.
- Budgeted line items should be on the left hand side of the budget (in rows) with each month of the year, and the yearly total, listed as separated columns. In other words, when looking at your spreadsheet, you should be able to easily determine how much you are going to spend on each line item for the month of July, for example, as well as how much you will spend that entire month. In addition, it should be clear how much you will spend on fringe benefits for the entire year.
OPERATIONAL BUDGET FOR THE YEAR 2021-22 July August September October November December January February March April May TOAL Budge Expense ted- $ Fixed Variable Fixed Variable Fixed Variable Fixed Variable Fixed Variable Fixed Variable Fixed Variable Fixed Variable Fixed Variable Fixed Variable Fixed Variable Fixed Variable Telephone 2000 56,67 110,00 56,67 59,50 56,67 60,69 70,84 63,73 70,84 63,73 70,84 64,37 70,84 65,01 70,84 66,31 70,84 66,31 70,84 67,30 70,84 67,30 736,71 754,26 Supplies 1050 22,50 65,00 22,50 23,63 22,50 24,10 28,13 25,30 28,13 25,30 28,13 25,56 28,13 25,81 28,13 26,33 28,13 26,33 28,13 26,72 28,13 26,72 292,50 320,79 100001 0,00 833,33 0,00 875,00 0,00 892,50 0,00 937,12 0,00 937,12 0,00 946,49 0,00 955,96 0,00 975,08 0,00 975,08 0,00 989,70 0,00 989,70 0 ,00 10307,07 Equipment 22000 0,00 1833,33 0,00 1925,00 0,00 1963,50 0,00 2061,67 0,00 2061,67 0,00 2082,29 0,00 2103,11 0,001 2145,17 0,001 2145,17 0,00 2177,35 0,00 2177,35 0 ,00 22675,61 Copy machine 5000 0,00 416,67 0,00 437,50 0,00 446,25 0,00 468,57 0,00 468,57 0,00 473,251 0,00 477,98 0,001 487,54 0,001 487,54 0,001 494,86 0,00 494,86 0 ,00 5153,60 Education 5000 0,00 416,67 0,00 437,50 0,00 446,25 0,00 468,57 0,00 468,57 0,00 473,25 0,00 477,98 0,00 487,54 0,00 487,54 0,00 494,86 0,00| 494,86 0 ,00 5153,60 Total Expenses 45050 79,17 3675,00 79,17 3758,13 79,17 3833,29 98,96 4024,96 98,96 4024,96 98,96 4065,21 98,96 4105,86 98,96 4187,97 98,96 4187,97 98,96 4250,79 98,96 4250,79 1029,21 44364,93 Personal Budget for 201-2022 position Current salary July August September October Novembe Decembe January February March April May June Total Director 82000 8541,671 8541,67 8 541,671 8968,75 8968,751 8968,75 8968,751 8968,75 8968,751 8968,751 8968,75 8968,75 106343,75 Assistant director 74000 | 7708,33 7708,33 7708,33 8093,75 8093,75 8093,75 8093,75 8093,75 8093,75 8093,75 8093,75 8093,75 95968,75 Receptionist/ Clerk 31000 3229,17 3229,17 L 3229,17 3390,63 3390,63 3390,63 3390,631 3390,63 3390,63 3390,631 3390,63 3390,63| 40203,13 Analyst/Coder/abstractors 46000 4791,671 4791,67 4791,671 5031,25 5031,25 5031,25 5031,25 5031,25 5031,25 5031,25 5031,25 5031,25 59656,2 Analyst/Coder/abstractors 48500 5052,08 5052,08 5052,081 5304,69] 5304,69 5304,691 5304,691 5304,69 5304,69 5304,691 5304,69| 5304,69 62898,44 HIM Clerk 30000 3125,00 3125,00 3125,00 3281,25 3281,25 3281,25 3281,25 3281,25 3281,25 3281,25 3281,25 3281,25 38906,25 Transcriptonist 45000 4687,50 4687,50 4687,501 4921,88 4921,88 4921,88 4921,88 4921,88 4921,88 4921,88 4921,88 4921,88 58359,38 Transcriptonist 47000 4895,83| 4895,83 4895,831 5140,63 5140,63 5140,63 5140,63| 5140,63 5140,63| 5140,631 5140,63 5140,63 60953,13 Part-time HIM Clerk 16500 1718,75 1718,75 1718,75 1804,69 1804,69 1804,69 1804,69 1804,69 1804,69 1804,69 1804,69 1804,69 21398,44 43750,00 43750,00 43750,00 45937,50 45937,50 45937,50 45937,50 45937,50 45937,50 45937,50 45937,50 45937,50 544687,50 Line Items Total salaries: $435750 Line Items Total salaries and fringe benefits: $544687,5 Over time Salary=9x$4000 $36000 Total=$544687,5+$36000 $580687,5 CASE STUDIES IN HEALTH INFORMATION MANAGEMENT o Capital Equipment Budget Instructions: Complete the HIM de department's capital equipment budget for the Note: The only major equipment request is to replace your current dictation Administration has distributed budget requests to each departmen Ing a due date of one month sach department at General Hospital with a memo indicat- Instructions state that the capital budoet is er based, requiring 14 expenditures. You have listed some justifications for a new digit Figure 6-3. You need to complete the capital expenditure approval forms administration with your budget. Based," requiring justification of any proposed capital acons for a new digital dictation system for the upcoming year in cure approval form shown in Figure 6-4 and return it to As the HIM director, you know that after administration's review of subm foreseen as most important will be approved and funded. For your capital budget as if it had been approved. nistration's review of submitted department budgets, only those be approved and funded. For this exercise, include the dictation system in TABLE 6-35 Capital Equipment Information Capital Equipment Item: New Dictation System Cost for system $ 65,000.00 Annual income produced $20,000.00 Depreciation over five years OPERATIONAL BUDGET FOR THE YEAR 2021-22 July August September October November December January February March April May TOAL Budge Expense ted- $ Fixed Variable Fixed Variable Fixed Variable Fixed Variable Fixed Variable Fixed Variable Fixed Variable Fixed Variable Fixed Variable Fixed Variable Fixed Variable Fixed Variable Telephone 2000 56,67 110,00 56,67 59,50 56,67 60,69 70,84 63,73 70,84 63,73 70,84 64,37 70,84 65,01 70,84 66,31 70,84 66,31 70,84 67,30 70,84 67,30 736,71 754,26 Supplies 1050 22,50 65,00 22,50 23,63 22,50 24,10 28,13 25,30 28,13 25,30 28,13 25,56 28,13 25,81 28,13 26,33 28,13 26,33 28,13 26,72 28,13 26,72 292,50 320,79 100001 0,00 833,33 0,00 875,00 0,00 892,50 0,00 937,12 0,00 937,12 0,00 946,49 0,00 955,96 0,00 975,08 0,00 975,08 0,00 989,70 0,00 989,70 0 ,00 10307,07 Equipment 22000 0,00 1833,33 0,00 1925,00 0,00 1963,50 0,00 2061,67 0,00 2061,67 0,00 2082,29 0,00 2103,11 0,001 2145,17 0,001 2145,17 0,00 2177,35 0,00 2177,35 0 ,00 22675,61 Copy machine 5000 0,00 416,67 0,00 437,50 0,00 446,25 0,00 468,57 0,00 468,57 0,00 473,251 0,00 477,98 0,001 487,54 0,001 487,54 0,001 494,86 0,00 494,86 0 ,00 5153,60 Education 5000 0,00 416,67 0,00 437,50 0,00 446,25 0,00 468,57 0,00 468,57 0,00 473,25 0,00 477,98 0,00 487,54 0,00 487,54 0,00 494,86 0,00| 494,86 0 ,00 5153,60 Total Expenses 45050 79,17 3675,00 79,17 3758,13 79,17 3833,29 98,96 4024,96 98,96 4024,96 98,96 4065,21 98,96 4105,86 98,96 4187,97 98,96 4187,97 98,96 4250,79 98,96 4250,79 1029,21 44364,93 Personal Budget for 201-2022 position Current salary July August September October Novembe Decembe January February March April May June Total Director 82000 8541,671 8541,67 8 541,671 8968,75 8968,751 8968,75 8968,751 8968,75 8968,751 8968,751 8968,75 8968,75 106343,75 Assistant director 74000 | 7708,33 7708,33 7708,33 8093,75 8093,75 8093,75 8093,75 8093,75 8093,75 8093,75 8093,75 8093,75 95968,75 Receptionist/ Clerk 31000 3229,17 3229,17 L 3229,17 3390,63 3390,63 3390,63 3390,631 3390,63 3390,63 3390,631 3390,63 3390,63| 40203,13 Analyst/Coder/abstractors 46000 4791,671 4791,67 4791,671 5031,25 5031,25 5031,25 5031,25 5031,25 5031,25 5031,25 5031,25 5031,25 59656,2 Analyst/Coder/abstractors 48500 5052,08 5052,08 5052,081 5304,69] 5304,69 5304,691 5304,691 5304,69 5304,69 5304,691 5304,69| 5304,69 62898,44 HIM Clerk 30000 3125,00 3125,00 3125,00 3281,25 3281,25 3281,25 3281,25 3281,25 3281,25 3281,25 3281,25 3281,25 38906,25 Transcriptonist 45000 4687,50 4687,50 4687,501 4921,88 4921,88 4921,88 4921,88 4921,88 4921,88 4921,88 4921,88 4921,88 58359,38 Transcriptonist 47000 4895,83| 4895,83 4895,831 5140,63 5140,63 5140,63 5140,63| 5140,63 5140,63| 5140,631 5140,63 5140,63 60953,13 Part-time HIM Clerk 16500 1718,75 1718,75 1718,75 1804,69 1804,69 1804,69 1804,69 1804,69 1804,69 1804,69 1804,69 1804,69 21398,44 43750,00 43750,00 43750,00 45937,50 45937,50 45937,50 45937,50 45937,50 45937,50 45937,50 45937,50 45937,50 544687,50 Line Items Total salaries: $435750 Line Items Total salaries and fringe benefits: $544687,5 Over time Salary=9x$4000 $36000 Total=$544687,5+$36000 $580687,5 CASE STUDIES IN HEALTH INFORMATION MANAGEMENT o Capital Equipment Budget Instructions: Complete the HIM de department's capital equipment budget for the Note: The only major equipment request is to replace your current dictation Administration has distributed budget requests to each departmen Ing a due date of one month sach department at General Hospital with a memo indicat- Instructions state that the capital budoet is er based, requiring 14 expenditures. You have listed some justifications for a new digit Figure 6-3. You need to complete the capital expenditure approval forms administration with your budget. Based," requiring justification of any proposed capital acons for a new digital dictation system for the upcoming year in cure approval form shown in Figure 6-4 and return it to As the HIM director, you know that after administration's review of subm foreseen as most important will be approved and funded. For your capital budget as if it had been approved. nistration's review of submitted department budgets, only those be approved and funded. For this exercise, include the dictation system in TABLE 6-35 Capital Equipment Information Capital Equipment Item: New Dictation System Cost for system $ 65,000.00 Annual income produced $20,000.00 Depreciation over five years
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started