the prison. Here are a few facts that you should know about the prison when your justifications. Round all of your projections to the nearest dollar amount preparing the operating budget. First, there are thirty staff members in the divi- 5. As the budget officer for Alexander State Prison you have to prepare the FY Hint: You can round numbers in Excel using the round function as well as the sion. Twenty-seven of the staff persons are equal in rank (guards). The warden creative in your responses and justify the changes. Use bullet points to relay stated, why do think these changes occurred (see Exhibit 3.5)? Be rational and 2018 budget estimates. Below you will find one portion of the budget history for budget officer and secretary are the last three staff members. Other than what is 2019 Operating Budget projections for the Security Division based on the FY "Decrease Decimal" function in the "Home" tool bar. Ten of the guards need training. Thus, training cost will in- crease by 34%. Energy costs are expected to rise 25% due to changes in global oil and gas prices. The cost of printing, pens, and pencils decreases by 2% from FY 2018. The cost of paper will increase by 5%. Telephone costs are expected to increase 4%. No new adding machine, but we need a new printer which will cost $500.00. Miscellaneous supplies will increase 25%. Operating Budget FY 2019 Object Code FY 2017 FY 2018 (proi.) Item Training Utilities (act.) $30,000.00 13,550.50 9,500.00 (est.) $34,500.00 15,176.56 10,925.00 1,200.00 155.02 2004 2005 2006 Printing Misc. Supplies 2007 960.00 2008 Pens and Pencils 150.50 2009 2010 per Adding Machine Telephone Printer 4,999.00 189.50 3,800.00 376.00 2011 4,200.50 4,347.52 0.00 2012 0.00 to be done in excel format Exhibit 3.5 Agency Salary Projection Report FY 2018 (General Fund) Agency: Police Department Division: Homicide Pension Health Total $3,500 $85,347.91 FICA $4,313.26 $1,008.75 $6,956.90 2,804.26 2,417.19 2,218.92 1.681.63 Title Director Salary $69,569 45,230 38,987 35,789 27.123 MED Captain Detective Detective Assistant TOTAL $216,698 $13,435.26 $3,142.12 $21,669.80 655.84 565.31 518.94 393.28 4,523.00 3,898.70 3,578.90 2.712.30 3,500 3,500 56,713.10 49,368.20 3,500 45,605.76 3.500 35.410.21 $17,500 $272,445.18 report allows the viewer to determine the exact cost associated with a position or an individual. Social security, Medicare, and retirement funds are based on formulas while health care cost for the individual employee is the same for everyone that has a particular characteristic, such as single, married with one dependent, and married with multiple dependents for health care benefits. Each of the employees listed here are current employees. The total cost included in Exhibit 3.5 is the total cost to the government. The employee contribution 5 considered a part of the entire budget. That is, the employee contribution is no considered in the FICA and Medicare columns because their contribution is ur timately deducted from their salary. With that said, it is not necessary to sho the contributions of both the employee and employer on a line item persone This Exhibit 3.5 Agency Salary Projection Report FY 2018 (General Fund) Agency: Police Department Division: Homicide Pension Health Total $3,500 $85,347.91 FICA $4,313.26 $1,008.75 $6,956.90 2,804.26 2,417.19 2,218.92 1.681.63 Title Director Salary $69,569 45,230 38,987 35,789 27.123 MED Captain Detective Detective Assistant TOTAL $216,698 $13,435.26 $3,142.12 $21,669.80 655.84 565.31 518.94 393.28 4,523.00 3,898.70 3,578.90 2.712.30 3,500 3,500 56,713.10 49,368.20 3,500 45,605.76 3.500 35.410.21 $17,500 $272,445.18 report allows the viewer to determine the exact cost associated with a position or an individual. Social security, Medicare, and retirement funds are based on formulas while health care cost for the individual employee is the same for everyone that has a particular characteristic, such as single, married with one dependent, and married with multiple dependents for health care benefits. Each of the employees listed here are current employees. The total cost included in Exhibit 3.5 is the total cost to the government. The employee contribution 5 considered a part of the entire budget. That is, the employee contribution is no considered in the FICA and Medicare columns because their contribution is ur timately deducted from their salary. With that said, it is not necessary to sho the contributions of both the employee and employer on a line item persone This