MPA625 M6D1: Life Cycle Costs & Sensitivity Analysis I need it in question/ answer formatEach part has to have at least 500 words. Part 1In this module, you have learned about the importance of Life C

MPA625 M6D1: Life Cycle Costs & Sensitivity Analysis

I need it in question/ answer format

Each part has to have at least 500 words.

Part 1

In this module, you have learned about the importance of Life Cycle Cost and Sensitivity Analyses in the decision-making process. In this discussion, you will identify and define the variables in the Life Cycle Cost (LCC) & Sensitivity Analysis of a given scenario. 

Respond to the following:

• Excluding energy and environmental conservation efforts, identify a scenario in your local or state government that would benefit from the LCC & Sensitivity Analysis.
• Identify the costs and other variables that may impact these analyses. Calculate the LCCs using Excel.
• Determine whether the purchase in your scenario is justifiable. Use your LCC & Sensitivity Analysis to support your position.

M6D2: Applying Trend Analyses Part 2

Throughout the course, you have learned that the method of analysis is determined by whether data is qualitative or quantitative. In this activity, you will discuss how this concept applies to selecting the appropriate forecast analysis technique. 

Respond to the following:

• Using the data in Table 30-1 (Table Below), use a scatterplot to create a simple regression trend analysis. Explain what the data shows.
• Based on the regression analysis, propose an expert opinion concerning the future of Misty Glen Tax Revenues. What do you think will happen?