Create Budget Spreadsheet

pp610_unit7_zero_budget_template.xls

Home >Business & Finance homework help >Create Budget Spreadsheet

SUMMARY


Fiscal Year	Projected Revenues	Projected Expenditures	Projected Net Cost	Actual Revenues	Actual Expenditures	Actual Net Cost
January	Total	Total	$0.00	$0.00	$0.00	$0.00
Februrary	Total	Total	$0.00	$0.00	$0.00	$0.00
March	Total	Total	$0.00	$0.00	$0.00	$0.00
April	Total	Total	$0.00	$0.00	$0.00	$0.00
May	Total	Total	$0.00	$0.00	$0.00	$0.00
June	Total	Total	$0.00	$0.00	$0.00	$0.00
July	Total	Total	$0.00	$0.00	$0.00	$0.00
August	Total	Total	$0.00	$0.00	$0.00	$0.00
September	Total	Total	$0.00	$0.00	$0.00	$0.00
October	Total	Total	$0.00	$0.00	$0.00	$0.00
November	Total	Total	$0.00	$0.00	$0.00	$0.00
December	Total	Total	$0.00	$0.00	$0.00	$0.00
Total	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
FUND TYPE (check one)
General
Special Revenue
Enterprise
Internal Service
Debt Service
RESTRICTED/UNRESTRICTED
(Specify "R" or "U")

JAN

CRAC Zero Based Budget Template
Expenditures				Revenues
Category	Budgeted $	Actual $	%	Source	Budgeted $	Actual $	%
Salaries				Taxes
Benefits				Licenses, Permits, Franchises, and Fines
Building Occupancy				Money and Property
Management & general				Rents and Concessions
Audit				Intergovernmental Revenues
Office supplies				Charges for Services
Postage/Printing				Prior Year Fund Balance
Computer				Total Revenue			100%
Staff training
Equipment maintenance
Insurance
Social Services
Vehicle maintenance
Utilities
Legal Services
Equipment
Special events
Communications
Transportation and Travel
Debt
Contingencies
Fixed Assets
Capital Assets
Loan Disbursements
Total Expenditures			100%

FEB

CRAC Zero Based Budget Template
Expenditures				Revenues
Category	Budgeted $	Actual $	%	Source	Budgeted $	Actual $	%
Salaries				Taxes
Benefits				Licenses, Permits, Franchises, and Fines
Building Occupancy				Money and Property
Management & general				Rents and Concessions
Audit				Intergovernmental Revenues
Office supplies				Charges for Services
Postage/Printing				Prior Year Fund Balance
Computer				Total Revenue			100%
Staff training
Equipment maintenance
Insurance
Social Services
Vehicle maintenance
Utilities
Legal Services
Equipment
Special events
Communications
Transportation and Travel
Debt
Contingencies
Fixed Assets
Capital Assets
Loan Disbursements
Total Expenditures			100%

MAR

CRAC Zero Based Budget Template
Expenditures				Revenues
Category	Budgeted $	Actual $	%	Source	Budgeted $	Actual $	%
Salaries				Taxes
Benefits				Licenses, Permits, Franchises, and Fines
Building Occupancy				Money and Property
Management & general				Rents and Concessions
Audit				Intergovernmental Revenues
Office supplies				Charges for Services
Postage/Printing				Prior Year Fund Balance
Computer				Total Revenue			100%
Staff training
Equipment maintenance
Insurance
Social Services
Vehicle maintenance
Utilities
Legal Services
Equipment
Special events
Communications
Transportation and Travel
Debt
Contingencies
Fixed Assets
Capital Assets
Loan Disbursements
Total Expenditures			100%

APRIL

CRAC Zero Based Budget Template
Expenditures				Revenues
Category	Budgeted $	Actual $	%	Source	Budgeted $	Actual $	%
Salaries				Taxes
Benefits				Licenses, Permits, Franchises, and Fines
Building Occupancy				Money and Property
Management & general				Rents and Concessions
Audit				Intergovernmental Revenues
Office supplies				Charges for Services
Postage/Printing				Prior Year Fund Balance
Computer				Total Revenue			100%
Staff training
Equipment maintenance
Insurance
Social Services
Vehicle maintenance
Utilities
Legal Services
Equipment
Special events
Communications
Transportation and Travel
Debt
Contingencies
Fixed Assets
Capital Assets
Loan Disbursements
Total Expenditures			100%

MAY

CRAC Zero Based Budget Template
Expenditures				Revenues
Category	Budgeted $	Actual $	%	Source	Budgeted $	Actual $	%
Salaries				Taxes
Benefits				Licenses, Permits, Franchises, and Fines
Building Occupancy				Money and Property
Management & general				Rents and Concessions
Audit				Intergovernmental Revenues
Office supplies				Charges for Services
Postage/Printing				Prior Year Fund Balance
Computer				Total Revenue			100%
Staff training
Equipment maintenance
Insurance
Social Services
Vehicle maintenance
Utilities
Legal Services
Equipment
Special events
Communications
Transportation and Travel
Debt
Contingencies
Fixed Assets
Capital Assets
Loan Disbursements
Total Expenditures			100%

JUNE

CRAC Zero Based Budget Template
Expenditures				Revenues
Category	Budgeted $	Actual $	%	Source	Budgeted $	Actual $	%
Salaries				Taxes
Benefits				Licenses, Permits, Franchises, and Fines
Building Occupancy				Money and Property
Management & general				Rents and Concessions
Audit				Intergovernmental Revenues
Office supplies				Charges for Services
Postage/Printing				Prior Year Fund Balance
Computer				Total Revenue			100%
Staff training
Equipment maintenance
Insurance
Social Services
Vehicle maintenance
Utilities
Legal Services
Equipment
Special events
Communications
Transportation and Travel
Debt
Contingencies
Fixed Assets
Capital Assets
Loan Disbursements
Total Expenditures			100%

JULY

CRAC Zero Based Budget Template
Expenditures				Revenues
Category	Budgeted $	Actual $	%	Source	Budgeted $	Actual $	%
Salaries				Taxes
Benefits				Licenses, Permits, Franchises, and Fines
Building Occupancy				Money and Property
Management & general				Rents and Concessions
Audit				Intergovernmental Revenues
Office supplies				Charges for Services
Postage/Printing				Prior Year Fund Balance
Computer				Total Revenue			100%
Staff training
Equipment maintenance
Insurance
Social Services
Vehicle maintenance
Utilities
Legal Services
Equipment
Special events
Communications
Transportation and Travel
Debt
Contingencies
Fixed Assets
Capital Assets
Loan Disbursements
Total Expenditures			100%

AUG

CRAC Zero Based Budget Template
Expenditures				Revenues
Category	Budgeted $	Actual $	%	Source	Budgeted $	Actual $	%
Salaries				Taxes
Benefits				Licenses, Permits, Franchises, and Fines
Building Occupancy				Money and Property
Management & general				Rents and Concessions
Audit				Intergovernmental Revenues
Office supplies				Charges for Services
Postage/Printing				Prior Year Fund Balance
Computer				Total Revenue			100%
Staff training
Equipment maintenance
Insurance
Social Services
Vehicle maintenance
Utilities
Legal Services
Equipment
Special events
Communications
Transportation and Travel
Debt
Contingencies
Fixed Assets
Capital Assets
Loan Disbursements
Total Expenditures			100%

SEPT

CRAC Zero Based Budget Template
Expenditures				Revenues
Category	Budgeted $	Actual $	%	Source	Budgeted $	Actual $	%
Salaries				Taxes
Benefits				Licenses, Permits, Franchises, and Fines
Building Occupancy				Money and Property
Management & general				Rents and Concessions
Audit				Intergovernmental Revenues
Office supplies				Charges for Services
Postage/Printing				Prior Year Fund Balance
Computer				Total Revenue			100%
Staff training
Equipment maintenance
Insurance
Social Services
Vehicle maintenance
Utilities
Legal Services
Equipment
Special events
Communications
Transportation and Travel
Debt
Contingencies
Fixed Assets
Capital Assets
Loan Disbursements
Total Expenditures			100%

OCT

CRAC Zero Based Budget Template
Expenditures				Revenues
Category	Budgeted $	Actual $	%	Source	Budgeted $	Actual $	%
Salaries				Taxes
Benefits				Licenses, Permits, Franchises, and Fines
Building Occupancy				Money and Property
Management & general				Rents and Concessions
Audit				Intergovernmental Revenues
Office supplies				Charges for Services
Postage/Printing				Prior Year Fund Balance
Computer				Total Revenue			100%
Staff training
Equipment maintenance
Insurance
Social Services
Vehicle maintenance
Utilities
Legal Services
Equipment
Special events
Communications
Transportation and Travel
Debt
Contingencies
Fixed Assets
Capital Assets
Loan Disbursements
Total Expenditures			100%

NOV

CRAC Zero Based Budget Template
Expenditures				Revenues
Category	Budgeted $	Actual $	%	Source	Budgeted $	Actual $	%
Salaries				Taxes
Benefits				Licenses, Permits, Franchises, and Fines
Building Occupancy				Money and Property
Management & general				Rents and Concessions
Audit				Intergovernmental Revenues
Office supplies				Charges for Services
Postage/Printing				Prior Year Fund Balance
Computer				Total Revenue			100%
Staff training
Equipment maintenance
Insurance
Social Services
Vehicle maintenance
Utilities
Legal Services
Equipment
Special events
Communications
Transportation and Travel
Debt
Contingencies
Fixed Assets
Capital Assets
Loan Disbursements
Total Expenditures			100%

DEC

CRAC Zero Based Budget Template
Expenditures				Revenues
Category	Budgeted $	Actual $	%	Source	Budgeted $	Actual $	%
Salaries				Taxes
Benefits				Licenses, Permits, Franchises, and Fines
Building Occupancy				Money and Property
Management & general				Rents and Concessions
Audit				Intergovernmental Revenues
Office supplies				Charges for Services
Postage/Printing				Prior Year Fund Balance
Computer				Total Revenue			100%
Staff training
Equipment maintenance
Insurance
Social Services
Vehicle maintenance
Utilities
Legal Services
Equipment
Special events
Communications
Transportation and Travel
Debt
Contingencies
Fixed Assets
Capital Assets
Loan Disbursements
Total Expenditures			100%