Chat with us, powered by LiveChat Assignmentinstruction1.docx - STUDENT SOLUTION USA

ASSIGNMENT

BUDGETING / SPREADSHEET

Based on the text below, create a budget on an excel spreadsheet. Assume the role as the newly appointed Recycle Department head for Jefferson City and your first task is to create a budget for your department.

Mayor McClain has appointed you to head the newly created Recycle Department for the Jefferson City. Your first task is to prepare a series of budgets for your department. More specifically, the mayor has given you $500,000 in FY 2020 and $550,000 in FY 2021 to run the department. Using the Excel worksheet templates for chapter 1, prepare a budget estimate for FY 2020 and a budget projection for FY 2021 using a simple line item, program, and performance budget format allocating the funds that are listed above.

(a) Line-Item Budget: In your line-item budget, use the categories (personnel, operating, and capital outlay) that are listed in the text. You are free to spend the funds any way that you see fit. However, remember that personnel costs usually consume the majority of a budget.

(b) 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.(c) Performance Budget: Set some specific goals that you can attain for either one of the divisions that you created in your performance budget (i.e., collect 6 tons of paper during the first year of operation).

Suggestion: In addition to staff, a Recycling Department may need the following: recycling bins, aluminum compressors, trucks, marketing brochures, and trailers to hold the recyclable materials.

error: Content is protected !!