Hello this is supposed to be a budget projection for the next fiscal year, I am requesting that you fill in the blank spaces on the excel sheet in accordance with the "assumptions for the next fiscal year", supposedly planning a budget for a government fire department.

directly below is a link to the excel spreadsheet and below that is the discription and assumptions.

https://drive.google.com/open?id=0BxhVew7EHLY7V053ai1BQjVVZTA

Budget Justification Assignment In this assignment you should assume that you are the Fire Commissioner and are tasked to complete the budget request for your department for the next fiscal year.

Remember that this document will be the opportunity to explain my request so it should be detailed.

These are the assumptions for the next fiscal year: Because of a reassessment of commercial property, property taxes are expected to increase by $400,000. Interest and penalties and license fees are expected to remain constant over the next several years Because of an increase in the sales tax from 4 percent to 5 percent and the expected hosting of several large conventions, sales tax revenues are expected to increase by 20 percent. Because of the conventions just mentioned, fines and penalties should rise by 10 percent Because of the lotterys success in its first few months of operations, city officials expect the villages share of the lottery receipts to double Employees will receive a 5% pay raise Hospitalization will increase by 18% FICA and pension will maintain the same rate Travel and Operating Supplies will increase the rate of inflation (research the current rate of inflation) Rent will increase 10% Utilities will increase 3% Personal Services will remain unchanged

For the next fiscal year the Mayor has charged you with reducing the number of fires where households do not have smoke detectors. This current year your data tells you that 30% of households in Dearborn do not have smoke detectors. Your goal is to reduce that number to 20%.

In your budget request you should develop a plan on how to achieve this goal and account for the assumptions provided. Be sure to include where you obtained your information and clearly explain your plan. Be creative! This is your request. You make other assumptions not included here make sure they are explained. If your request is higher than the current budget you have to justify why the additional funding should be spent on the Fire Department.

Personal Budget Worksheet
Fund:	General Fund									Prepared by:
Function:	Fire Fighting									Approved by:
Department:	Fire Department									Date:
		Prior Year Actual			Current Year Est Actual			Budget Request
Code	Position Title	No	Rate	Amount	No	Rate	Amount	No	Rate	Amount	Remarks
101	Fire Commissioner	1	110,000	110,000	1	110,000	110,000			-
102	Battalion Fire Chief	3	90,000	270,000	3	90,000	270,000			-
104	Fire Captain	4	75,000	300,000	4	75,000	300,000			-
105	Fire Fighter	24	54,000	1,296,000	24	54,000	1,296,000			-
106	Fire Prevention Inspector	2	45,000	90,000	2	45,000	90,000			-
108	Fire Marshal	1	50,000	50,000	1	50,000	50,000			-
110	Clerk	3	25,000	75,000	3	25,000	75,000			-
Salaries	Total	38		$2,191,000	38		$2,191,000.00	0		$-
200	Hospitalization			$547,750			$547,750.00			$-
201	Pension			109,550			109,550.00			-
205	FICA			167,612			167,611.50			-
Benefits	Total			$824,912			$824,911.50			$-

Departmental Expenditure Request
Fund:	General Fund			Prepared by:
Function:	Fire Fighting			Approved by:
Department:	Fire Department			Date:
		Prior Year	Current Year	Budget
Code	Object	Actual	Budget	Request	Explanation
201	Personal Services	$816,525	$900,000
202	Travel	4,600	4,500
203	Operating Supplies	60,500	54,000
204	Capital Expenditures	62,470	75,000
205	Equipment	47,050	25,000
207	Rent	30,000	35,000
208	Utilities	26,576	27,500
	Total	$1,047,721	$1,121,000	$-

Revenues
Fund:	General Fund			Prepared by:
Function:	Fire Fighting			Approved by:
Department:	Fire Department			Date:
		Prior Year	Current Year	Budget
Acct #	Object	Actual	Budget	Request	Explanation
1110	Property Taxes	$5,436,720	$5,504,000
1112	Interest and penalties	38,486	38,000
1114	Sales Tax	872,680	900,000
1116	Fines and Penalties	64,842	70,000
1119	Share of lottery receipts	-	225,000
1121	License Fees	9,650	10,000
	Total	$6,422,378	$6,747,000	$-

XYZ Department
Budget Summary
		Prior Actual	Current Budget	Budget Request	Variance
Revenues
1110	Property Taxes				-
1112	Interest and penalties				-
1114	Sales Tax				-
1116	Fines and Penalties				-
1119	Share of lottery receipts				-
1121	License Fees				-
					-
					-
					-
	Revenue Total	$-	$-	$-	$-
Expenditures
	Salary				-
	Benefits				-
201	Personal Services				-
202	Travel				-
203	Operating Supplies				-
204	Capital Expenditures				-
205	Equipment				-
207	Rent				-
208	Utilities				-
					-
					-
					-
	Total Expenditures	$-	$-	$-	$-