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 %

PreviousNext