ModuleOnePrepareBudgetspart1assignment

Module One Prepare Budgets: Line-item, Program, PerformanceInstructionsPlease 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 spreadsheetsbelow 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.AssignmentMayor 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 budgetuse 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 yourprogram budget (i.e. collect six tons of paper during the first year of operation.The 3 excels listed above are attached to the postRubric GradingPAD 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.0pts 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.0pts 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.0pts This criterion is linked to a Learning OutcomeUse of data and assumptions 100.0pts 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.0pts 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.0pts This criterion is linked to a Learning OutcomeOverall presentation 100.0pts 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.0pts 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.0pts This criterion is linked to a Learning OutcomePAD PO2 – Formulate a public policy proposal. threshold:4.0pts 5.0pts Exceeds Expectations 4.0pts Mastered Expectations 3.0pts Meets Expectations — This criterion is linked to a Learning OutcomePAD PO3 – Justify the validity and reliability of a program. threshold:4.0pts 5.0pts Exceeds Expectations 4.0pts Mastered Expectations 3.0pts 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.0pts 5.0pts Exceeds Expectations 4.0pts Mastered Expectations 3.0pts 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.0pts 5.0pts Exceeds Expectations 4.0pts Mastered Expectations 3.0pts Meets Expectations 2.0pts Minimally Meets Expectations 1.0pts 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.0pts 5.0pts Exceeds Expectations 4.0pts Mastered Expectations 3.0pts Meets Expectations 2.0pts Minimally Meets Expectations 1.0pts Does Not Meet Expectations — Total Points:300.0 PreviousNext