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.

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