Create a script for a 5–10 minute video in which you propose a departmental financial plan for the upcoming year in the City of Acme, along with supporting data visualizations and discussions of economic principles and drivers behind

Create a script for a 5–10 minute video in which you propose a departmental financial plan for the upcoming year in the City of Acme, along with supporting data visualizations and discussions of economic principles and drivers behind the financial plan. For this assessment, you will use Excel to analyze and represent department data. The approach to learning and working with Excel software in this course is one you can apply to other technology tools in your life and career as well. Your goal for this assessment is to continue building your confidence in using a technology tool while conducting a department financial analysis. You will use Excel to organize quarterly and annual budgets, visualize this financial data using charts and graphs, and discuss the results of your financial analysis, including progress toward your department financial goal. Scenario You are the associate administrator of a large department in the City of Acme with an operating budget of 1.8 million dollars.
Using what you have learned about budgeting, Excel, and creating data visualizations, populate the Assessment 4 Template. Then create a 5–10 minute video in which you present your proposed budget to the department staff and leadership. For this assessment, complete the following steps: Create a proposed budget based on a professional financial analysis of a year-to-date budget. Use the Assessment 4 Template to review the current annual budget, then prepare a new proposed budget. Based on this data, how will you propose to update the budget for the next fiscal year? Consider the following before populating the cells for the next fiscal year: It is rumored there will be a 3 percent increase in cost of living. Consider budgeting this increase for personnel cost. Two-thirds of the computers were outdated and failed, requiring replacement during this budget year, which accounts for the increase at the 9-month mark. It’s up to you to decide whether to budget enough to replace the remaining one-third of the old computers still in use. You won’t need as many vehicles next year. If each vehicle is valued at about 36,475 dollars, consider a conservative amount to budget for next year. If you don’t add more vehicles, consider a substantial increase to Vehicle Maintenance for repairs next year. Please read the comments (notes) in the cells, indicated by red triangles in the upper right corner of the cells. You have the original budget, the nine-month budget (or year-to-date at nine months), and the empty budget spreadsheet for the next year. Create appropriate graphs to illustrate the findings of a professional financial analysis. Prepare graphs for the current year budget, the year-to-date budget, and the proposed budget. You may wish to display these graphs during your video, so it’s worth considering the audience for your video and how the graphs will appear during the presentation. You should use Excel to create these graphs in the Assessment 4 Template. Explain the results of a professional financial analysis, including overall progress and why the proposed budget is the best possible forecast for the new year. Make a video presentation using Kaltura (or another familiar video recording method that is compatible with the courseroom) in which you review your analysis and proposed budget. Discuss whether your final budget is conservative (meaning it would still work in a worst-case scenario) or aggressive (meaning that all budget metrics must be met to avoid a deficit next year). Make your recommendation for the proposed budget with your logic for the proposed increase or decrease in the new budget. Step 4: Explain how your selected graphs are the best choice to communicate financial information. Discuss the graphs that you chose to present the data from the three budgets in the Assessment 4 Template. How do they help the audience better understand the presented financial data? How are they better than other types of graphs you considered? Address the appropriate audience, using familiar, discipline-specific language and terminology. Are you speaking to the audience in the scenario (that is, department members and leadership) in your presentation? Is the language you are using appropriate for the scenario and your role as an assistant administrator? Are you using appropriate economic and finance terminology? Remember to submit the completed Assessment 4 Template and your 5–10 minute video presentation for this assessment. Scenario You are the associate administrator of a large department in the City of Acme with an operating budget of 1.8 million dollars. Your boss, the administrator, has asked you to create a presentation with graphs indicating next fiscal year’s proposed budget allocations.