Please use the attached excel file for a few of the exam questions. The excel file includes tabs that provide info/data to answer several of the following exam questions.Attached Excel file—–>final exam file for students.xlsx  Note to ProctorUUse of the attached Excel file is allowable for use by students on the exam. Note to StudentsPlease include a response in the question text box to avoid receiving a question unanswered message when submitting the exam. Any response will work…a single word, your name, etc.Some of the exam questions are autograded. Please take time – if time permits – to confirm your calculations/answers.

Use the excel file provided in question 1 and the data included in the ‘Project Status’ tab to assess project performance at the end of period 6 and answer the following question.What is the CPI(cost performance index) for the project? (round to two decimal places. Example….1.1035 = 1.10)

What is total slack–or float–for an activity and how is total slack determined? 

Mayflower Technology is considering an investment in a project that will reduce costs in their production process.  Mayflower Technology  requires a 12% rate of return for all investments. Given the following project cash flow info— Period(year) Investment(outflow) Cash Inflow 0 $200,000   1   $40,000 2   $60,000 3   $70,000 4   $75,000 5   $70,000 The equipment has a life of  5 years and no additional cash flows are expected after year 5.  The project cash flows are also included in the excel file included in question 1.  Please look for a tab named NPV. a.  What is the net present value(NPV) of the project? (round your answer to the nearest $ with no decimals, commas, dollar signs) Example 35274.  If negative, place a minus sign in front of your answer) [BLANK-1] b.  Based solely on the NPV of the project, would you recommend to undertake the project?  (Enter Yes or No] [BLANK-2] c.  Assume the rate of return for the project increases to 16%.  What is the NPV of the project if the required rate of return is 16%? (round your answer to the nearest $ with no decimals, commas, dollar signs) Example 35274.  If negative, place a minus sign in front of your answer) [BLANK-3] d.  Given the NPV using the 16% required return, would you recommend to undertake the project? (enter Yes or No) [BLANK-4]

This question is a continuation of question 6. Use the task durations in question 6 and the project in the tab named NCP – 2 in the excel file provided in question 1 to answer the followng question. What is the critical path of the project in question 6?  Input answer as letters.  Example…ABCDEFG.  Input tasks in alpabetical order.  Do not include spaces or commas in your answer. [BLANK-1]

This question is a continuation of question 2. Use the task durations in question 2 and the project in the tab named NCP – ! in the excel file provided in question 1 to answer the followng question. What is the critical path of the project in question 2?  Input answer as letters.  Example…ABCDEFG.  Do not include spaces or commas in your answer. [BLANK-1]

This is a continuation of question 2.  Use the task durations in question 2 and the project in the tab named NCP – ! in the excel file provided in question 1 to answer the following questions. Suppose task D takes longer than expected by 4 days. What is the impact on the project…. 1.  The project duration will (increase or decrease) [BLANK-1] 2.  By how many days? [BLANK-2]

Please use the attached excel file for some of the exam questions.  The excel file includes tabs that provide info/data to answer several of the following exam questions. Attached Excel file—–>midterm exam file for students.xlsx  Note to ProctorU….use of the attached Excel file is allowable for use by students on the exam. Note to Students…..please include a response in the question 1 text box to avoid receiving a question unanswered message when submitting the exam. Any response will work…a single word, your name, etc. Some of the exam questions are autograded.  Please take time – if time permits – to confirm your calculations/answers.

Use the following task/activity durations and the project network in the tab named NCP – ! in the excel file provided in question 1 to answer the following question. What is project duration in days? Task durations are number of days. Task A duration… [adur] Task B duration… [bdur] Task C duration… [cdur] Task D duration…. [ddur] Task E duration… [edur] Task F duration… [fdur]  Info for students – Note that the project in the excel file’s tab NCP – 1 and the task durations in question 2 are used in the questions 3, 4, and 5.

This question is a continuation of question 2. Use the task durations in question 2 and the project in the tab named NCP – ! in the excel file provided in question 1 to answer the followng question. The total slack for task B is how many days? (Enter answer in whole numbers.  If total slack is a fraction or decimal. round the answer to the nearest whole number.) [BLANK-1]