Personnel Services and Operating Budgets Due 9/2917 at Noon

HELP????? For the opreating chart on the bottom, I could not space the chart to aligned with each category, I greatly apologize for that,

What it be possible for the person who is helping me with assignment, to space the categories so it is easier to calculate, if you have any questions just comment?????

THANK YOU SO MUCH

Instructions To Complete Assignment)...... Using EXCEL or a similar spreadsheet application: As the budget officer for the Roan State Prison you have to prepare the FY 2015 Operating Budget projections for the Security Division based on the FY based on the FY 2014 budget estimates. Below you will find one portion of the budget history for the prison. Here are a few facts that you should know about the prison when preparing the operating budget. First, there are thirty staff members in the divison. Twenty-eight of the staff persons are equal in rankl (guards). The warden, budget officer and secretary are the last three staff members. Other than what is stated, why do you think these changes occured? Be rational and creative in your responses and justify the changes. Use bullet points to relay your justifications. Round all of your projections to the nearest dollar amount. You can round numbers in Excel using the round function as well as the :Decrease Decimal" function in the "Home" tool bar

1. Ten of the guards need training. Thus, training cost will increase by 44%

2. Energy costs are expected to rise 20% due to changes in global oil oil and gas prices

3. The cost of printing, pens, and pencils decreases by 2% from FY 2014.

4. The cost of paper will increase by 5%.

5. Telephone costs are expected to increase 3%.

6. No new adding machine, but we need a new printer which will cost $500.00

7. Miscellaneous supplies will increase 25%.

Roan State Prison Security Division

Operating Budget

Object Code Iten FY 2013(act.) FY 2014 (est.) FY 2015(proj.)

2004 Training $30,000.00 $34,500.00

2005 Utilities 13,550.50 15,176.56

2006 Printing 9,500.00 10,925.00

2007 Misc. Supplies 960.00 1,200.00

2008 Pens and Pencils 150.50 155.02

2009 Paper 3,800.00 4,999.00

2010 Adding Machine 376.00 189.50 2011 Telephone 4,200.50 4,347.52

2012 Printer 0.00 0.00

TOTAL $62,537.50 $71,492.60