Preparing Budgets and Budget Decisions
Module One Prepare Budgets: Line-item, Program, Performance
Instructions
Please read the assignment (below) in its entirety prior to completing this assignment. The Excel spreadsheet templates for completing this assignment are located in this module. The Appendix spreadsheets below the forms are for reference purposes only and include include formulas for calculating various amounts and percentages. When you have completed the Excel spreadsheet(s), copy and paste the content into a Word document.
Assignment
Mayor Stacy Luckett has appointed you to head the newly created Recycle Department for the City of Bradley. Your first task is to prepare a series of budgets for you department. More specifically, the major has given you $450,000 in FY 2014 and $500,000 in FY 2015 to run the department. Using the excel spreadsheet templates located below this assignment, prepare a budget estimate for FY 2014 and a budget projection for FY 2015 using a simple line-item, program, and performance budget format.
· Q1A - Line Item Budget: In your line-item budget use the categories (personnel, operating, and capital outlay) that are listed in the text to create a line item budget. You can spend the funds any way you see fit. However, remember that personnel costs usually consume the majority of the budget.
· Q1B - Program Budget: Consider the different types of activities (divisions) that a recycling department would be engaged in (recycling glass, paper, plastic, aluminum, etc.) Your goals and/or objectives should be slightly modified in the second year to show growth in one area and a decrease in another area.
· Q1C - Performance Budget: Set some specific goals that you can attain for either one of the divisions that you created in your program budget (i.e. collect six tons of paper during the first year of operation.
The 3 excels listed above are attached to the post
Rubric Grading
PAD 3204 MODULE 1 this is how the professor grades you must meet this criterion preferably in the 100-90 %
|
PAD 3204 MODULE 1 WEDNESDAY ASSIGNMENT (1) |
|||||||
|
Criteria |
Ratings |
Pts |
|||||
|
This criterion is linked to a Learning OutcomeBudget narrative |
|
100.0 pts |
|||||
|
This criterion is linked to a Learning OutcomeUse of data and assumptions |
|
100.0 pts |
|||||
|
This criterion is linked to a Learning OutcomeOverall presentation |
|
100.0 pts |
|||||
|
This criterion is linked to a Learning OutcomePAD PO2 - Formulate a public policy proposal. threshold: 4.0 pts |
|
-- |
|||||
|
This criterion is linked to a Learning OutcomePAD PO3 - Justify the validity and reliability of a program. threshold: 4.0 pts |
|
-- |
|||||
|
This criterion is linked to a Learning OutcomePAD PO6 - Analyze and develop planning strategies in response to homeland security issues including public relations, terrorism and emergency management. threshold: 4.0 pts |
|
-- |
|||||
|
This criterion is linked to a Learning OutcomePAD PO7 - Employ a series of strategies, including quality assurance, and critical thinking to manage activities ranging from normal to special assignments. threshold: 4.0 pts |
|
-- |
|||||
|
This criterion is linked to a Learning OutcomePAD PO8 - Identify components of a public agency financial system and explain how each fits into the overall organizational structure threshold: 4.0 pts |
|
-- |
|||||
|
Total Points: 300.0 |
Module One Prepare Budgets: Line
-
item, Program, Performance
Instructions
Please read the assignment (below) in its entirety prior to completing this assignment. The Excel spreadsheet templates for c
ompleting this assignment are located
in this module. The Appendix spreadsheets
below the forms are for reference purposes only and
include include formulas for calculating various amounts and
percentages.
When you have completed the Excel spreadsheet(s), copy and paste the content into a Word document.
Assignment
Mayor Stacy Luckett has appointed you to head the newly created Recycl
e Department for the City of Bradley. Your first task is to prepare a series of budgets for
you department. More specifically, the major has given you $450,000 in FY 2014 and $500,000 in FY 2015 to run the department.
Using the excel spreadsheet
templates
located below this assignment, prepare a budget estimate for FY 2014 and a budget projection for FY 2015 using a simple line
-
item, program, and
performance budget format.
·
Q1A
-
Line Item Budget
:
In your line
-
item budget
use the categories (personnel, ope
rating, and capital outlay) that are listed in the text to create a line item
budget. You can spend the funds any way you see fit. However, remember that personnel costs usually consume the majority of t
he budget.
·
Q1B
-
Program Budget:
Consider the differ
ent types of activities (divisions) that a recycling department would be engaged in (recycling glass, paper, plastic,
aluminum, etc.) Your goals and/or objectives should be slightly modified in the second year to show growth in one area and a
decrease in a
nother area.
·
Q1C
-
Performance Budget
: Set some specific goals that you can attain for either one of the divisions that you created in your
program budget (i.e. collect six
tons of paper during the first year of operation.
T
he
3 excels listed above are attached to the post
Rubric
Grading
PAD 3204 M
ODULE 1 this is how the professor grades you must meet this criterion preferably in the 100
-
90
%
PAD 3204 MODULE 1 WEDNESDAY ASSIGNMENT (1)
Criteria
Ratings
Pts
Module One Prepare Budgets: Line-item, Program, Performance
Instructions
Please read the assignment (below) in its entirety prior to completing this assignment. The Excel spreadsheet templates for completing this assignment are located
in this module. The Appendix spreadsheets below the forms are for reference purposes only and include include formulas for calculating various amounts and
percentages. When you have completed the Excel spreadsheet(s), copy and paste the content into a Word document.
Assignment
Mayor Stacy Luckett has appointed you to head the newly created Recycle Department for the City of Bradley. Your first task is to prepare a series of budgets for
you department. More specifically, the major has given you $450,000 in FY 2014 and $500,000 in FY 2015 to run the department. Using the excel spreadsheet
templates located below this assignment, prepare a budget estimate for FY 2014 and a budget projection for FY 2015 using a simple line-item, program, and
performance budget format.
Q1A - Line Item Budget: In your line-item budget use the categories (personnel, operating, and capital outlay) that are listed in the text to create a line item
budget. You can spend the funds any way you see fit. However, remember that personnel costs usually consume the majority of the budget.
Q1B - Program Budget: Consider the different types of activities (divisions) that a recycling department would be engaged in (recycling glass, paper, plastic,
aluminum, etc.) Your goals and/or objectives should be slightly modified in the second year to show growth in one area and a decrease in another area.
Q1C - Performance Budget: Set some specific goals that you can attain for either one of the divisions that you created in your program budget (i.e. collect six
tons of paper during the first year of operation.
The 3 excels listed above are attached to the post
Rubric Grading
PAD 3204 MODULE 1 this is how the professor grades you must meet this criterion preferably in the 100-90 %
PAD 3204 MODULE 1 WEDNESDAY ASSIGNMENT (1)
Criteria Ratings Pts