Answered step by step
Verified Expert Solution
Link Copied!

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

  1. One comprehensive department budget that includes the individual line items as well as monthly budgeted total AND a yearly budgeted total.
    1. 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.
    2. 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.

image text in transcribed

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Dcaa Audits Widespread Problems With Audit Quality Require Significant Reform: Gao 09 1009t

Authors: U. S. Government Accountability Office

1st Edition

1287232027, 978-1287232025

More Books

Students also viewed these Accounting questions