ScenarioThe Corporate Controller has called you into a planning session and asked you to help with the preparation of an income statement forecast for the coming three years. You both discuss the project and decide that the data you will need it is:The last 5 years of income statementsA forecast of economic data for key economic indicatorsThe basic assumptions the company is making in their business planInstructionsThe Corporate Controller would like you to use Excel to prepare a high-level, 3-year forecast (income statement format) incorporating the historical, economic forecast, and assumptions provided by the Corporate Controller. The Corporate Controller also states that the Board of Directors loves to see “pictures” of summary data rather than a “bunch of numbers.” The Corporate Controller suggests that on a separate tab in Excel to use the graphing function to display total revenues and expenses for the periods covered.Create and Excel spreadsheet with two tabs labeled:Tab 1: 3-Year Income Statement ForecastTab 2: GraphsOn Tab 1: 3-Year Income Statement Forecast, use the same income statement format and titles as the historical data provided.RUBRIC: FFCBA01234Did not SubmitNo PassCompetence ProficiencyMasteryNot SubmittedDid not provide a mid or high-level Excel spreadsheet that includes a thoroughly completed 3-year forecast; did not use income statement format for the forecast.Provided a sufficient high-level 3-year forecast; used income statement format.Provided a well-developed high-level 3-year forecast; used income statement format.Provided a detailed high-level 3-year forecast; used income statement format.Not SubmittedDid not include a summary of 5 years of data and assumptions from income statements.Included a basic summary of 5 years of data and assumptions from income statements.Included an expanded summary of 5 years of data and assumptions from income statements.Included a detailed summary of 5 years of data and assumptions from income statements.Not SubmittedDid not provide economic data for key economic indicators in the forecast.Provided basic economic data for the key economic indicators included in the forecast.Provided expanded economic data for key economic indicators included in the forecast.Provided comprehensive economic data for key economic indicators included in forecast.Not SubmittedDid not provide a separate Excel tab that includes a graph to display total revenues and expenses for the time periods covered in the forecast.Excel tab includes a basic graph to display total revenues and expenses for the time periods covered in the forecast.Excel tab includes a well-developed graph to display total revenues and expenses for the time periods covered in the forecast.Excel tab includes a detailed graph to display total revenues and expenses for the time periods covered in the forecast.Template with 3 tabs is attached

Option #1: KPIs and Critical Success Factors (CSFs) In Section 4.6 of the textbook, Kerzner (2017) sates “Without a good understanding of a KPI, project managers may end up with an improper selection process that works as follows: Everything that is easy to measure and count is identified. Sophisticated dashboards and reporting techniques for everything that is easy to measure and count are developed. Then project managers struggle to determine what to do with the information.” Kerzner (2017) adds “The nature of the project together with the agreed-upon definition of success and the CSFs determine which KPIs to use” (p. 139). For this assignment: Interview someone you know who is currently working on a project. Discuss the project success factors, what has been accomplished to date, what is left to be done, and what your interviewee thinks might increase performance on the project. Find out what types of metrics are being used and if, in the opinion of the interviewee, they are useful. In your written paper, consolidate what you learned in your interview and provide a synopsis of the information in less than one page. The interviewee may remain anonymous if requested. While the interviewee may remain anonymous, the organization should be an actual one with which you are familiar and noted in the paper. In the remainder of the paper, suggest whether the metrics being used are KRIs, RIs, PIs, or KPIs, and why, and if you were to recommend a change to more effectively report on the project what KRIs, RIs, PIs, or KPIs would you suggest. Paper Requirements: Be sure to properly organize your writing and include an introductory paragraph, headings/subheadings for the body of your work, discussion recommendations, and a conclusion. Format your entire paper in accordance with the CSU Global Writing Center (Links to an external site.) guidelines. Your paper should be at least five pages. The page count does not include the required title page and reference page, nor does the page count include any supplemental pages, should you use them, such as appendices. Prepare your work using at least one of this week's required readings and one outside reference (a peer-reviewed scholarly article published in the past five years). The CSU Global Library (Links to an external site.) is a good place to find these resources. The Library offers this Project Management Resource Guide (Links to an external site.) to assist you with research and writing. Option #2: KPI Wheel Your textbook authors present a KPI Wheel in Figure 4-10. In the section titled "Putting it all together - the KPI wheel," Kerzner (2017) described an interview process for using the KPI Wheel. Find three team members on the same project to help you with your assignment. Conduct an interview of the team members using the KPI Wheel. You may collect as much information as you wish, but you will need at least one KPI Wheel for each interviewee as part of your Appendix to the paper. So, at least three KPI Wheels will be in your Appendix. Do not just ask questions, but let the interview flow organically. In less than one page, explain the project, and the titles of the interviewees (you do not have to use their names, but name the organization and describe the project). Using current scholarly research discuss the purpose of the KPI Wheel. Next, discuss the use of the KPI Wheel to direct the interview. What did you learn about the practical application of collecting KPIs through this process? How did the interviewees' information agree or disagree among them, and why was that the case? How did the interviewees' information agree or disagree with current scholarly research? If you were to use this information to determine a set of KPIs, what additional information would you need, and how would you proceed? What KPIs would you suggest for the project and why? Paper Requirements: Be sure to properly organize your writing and include an introductory paragraph, headings/subheadings for the body of your work, discussion recommendations, and a conclusion. Format your entire paper in accordance with the CSU Global Writing Center (Links to an external site.) guidelines. Your paper should be at least five pages. The page count does not include the required title page and reference page, nor does the page count include any supplemental pages, should you use them, such as appendices. Prepare your work using at least one of this week's required readings and one outside reference (a peer-reviewed scholarly article published in the past five years). The CSU Global Library (Links to an external site.) is a good place to find these resources. The Library offers this Project Management Resource Guide (Links to an external site.) to assist you with research and writing. Select option 1 or option 2. Make sure you follow the paper requirements. This week's resources: Required Chapter 4 in Project management metrics, KPIs, and dashboards: A guide to measuring and monitoring project performance Presentation for Chapter 4 from Project management metrics, KPIs, and dashboards Part 2 Section 5.9 in the PMBOK® Guide Recommended Cruz Villazón, C., Sastoque Pinilla, L., Ramón Otegi Olaso, J, Toledo Gandarias, N, & López de Lacalle, N. (2020). Identification of key performance indicators in project-based organisations through the lean approach. Sustainability, 12(5977), 5977. https://doi.org/10.3390/su12155977 Unterhitzenberger, C., & Bryde, D. J. (2019). Organizational justice, project performance, and the mediating effects of key success factors. Project Management Journal, 50(1), 57-70. https://doi.org/10.1177/8756972818808984 Here it is:https://www.studypool.com/discuss/45916904/use-of-...Thames