Applied Sciences homework help

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
You introduce the budget and comment on the budget process; provide a detailed explanation of how you determined individual budget lines and amounts; and draw pertinent conclusions about the budget and budget process. 85.0 pts
You introduce the budget and comment on the budget process; explain how you determined individual budget lines and amounts; and draw appropriate conclusions about the budget and budget process.
100.0 pts
This criterion is linked to a Learning OutcomeUse of data and assumptions 100.0 pts
You successfully incorporate all assumptions and data from the assignment and include information about average salaries gleaned from the district report card; no apparent errors. 85.0 pts
You incorporate most, if not all, assumptions and data from the assignment and include information about average salaries gleaned from the district report card; one or two minor errors.
100.0 pts
This criterion is linked to a Learning OutcomeOverall presentation 100.0 pts
Your discussion of the budget process and individual budget lines is set forth in a clear, thoughtful manner. It is well-written and insightful (writing demonstrates a sophisticated clarity, conciseness, and correctness); includes thorough details and relevant data and information; and is extremely well-organized. 85.0 pts
Your discussion of the budget process and individual budget lines is set forth in a thoughtful manner. It is well-written (writing is accomplished in terms of clarity and conciseness and contains only a few errors); includes sufficient details and relevant data and information; and is well-organized.
100.0 pts
This criterion is linked to a Learning OutcomePAD PO2 – Formulate a public policy proposal.
threshold: 4.0 pts 5.0 pts
Exceeds Expectations 4.0 pts
Mastered Expectations 3.0 pts
Meets Expectations
—
This criterion is linked to a Learning OutcomePAD PO3 – Justify the validity and reliability of a program.
threshold: 4.0 pts 5.0 pts
Exceeds Expectations 4.0 pts
Mastered Expectations 3.0 pts
Meets Expectations
—
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 5.0 pts
Exceeds Expectations 4.0 pts
Mastered Expectations 3.0 pts
Meets Expectations
—
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 5.0 pts
Exceeds Expectations 4.0 pts
Mastered Expectations 3.0 pts
Meets Expectations 2.0 pts
Minimally Meets Expectations 1.0 pts
Does Not Meet Expectations
—
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 5.0 pts
Exceeds Expectations 4.0 pts
Mastered Expectations 3.0 pts
Meets Expectations 2.0 pts
Minimally Meets Expectations 1.0 pts
Does Not Meet Expectations
—
Total Points: 300.0
PreviousNext