Question: Use the spreadsheet below to finish this assignment. You need to interpret the project progress based on the information. For this exercise, you only need

Use the spreadsheet below to finish this assignment. You need to interpret the project progress based on the information. For this exercise, you only need to look at the datasets and see how each project performs in terms of schedule and cost control. Calculating the BAC and EAC is not required. When you answer the question, please make sure that you evaluate each project separately. Thank you!

Use the spreadsheet below to finish this

Data Set 1 \begin{tabular}{|r|r|r|r|r|r|} \hline \multicolumn{1}{|l|}{ Week } & \multicolumn{1}{l|}{ EV } & \multicolumn{1}{l|}{ PV } & \multicolumn{1}{l|}{ AC } & \multicolumn{1}{l|}{ SPI } & \multicolumn{1}{l|}{ CPI } \\ \hline 1 & 5 & 6 & 6 & 0.83 & 0.83 \\ \hline 2 & 15 & 20 & 20 & 0.75 & 0.75 \\ \hline 3 & 20 & 25 & 25 & 0.80 & 0.80 \\ \hline 4 & 45 & 45 & 45 & 1.00 & 1.00 \\ \hline 5 & 55 & 52 & 50 & 1.06 & 1.10 \\ \hline 6 & 65 & 57 & 55 & 1.14 & 1.18 \\ \hline 7 & 80 & 70 & 60 & 1.14 & 1.33 \\ \hline 8 & 90 & 80 & 67 & 1.13 & 1.34 \\ \hline 9 & 100 & 95 & 100 & 1.05 & 1.00 \\ \hline 10 & 102 & 105 & 118 & 0.97 & 0.86 \\ \hline 11 & 120 & 130 & 130 & 0.92 & 0.92 \\ \hline 12 & 140 & 150 & 145 & 0.93 & 0.97 \\ \hline 13 & 170 & 175 & 155 & 0.97 & 1.10 \\ \hline 14 & 195 & 200 & 225 & 0.98 & 0.87 \\ \hline 15 & 220 & 225 & 250 & 0.98 & 0.88 \\ \hline 16 & 245 & 255 & 265 & 0.96 & 0.92 \\ \hline 17 & 280 & 300 & 325 & 0.93 & 0.86 \\ \hline 18 & 325 & 350 & 380 & 0.93 & 0.86 \\ \hline 19 & 380 & 440 & 460 & 0.86 & 0.83 \\ \hline 20 & 440 & 525 & 550 & 0.84 & 0.80 \\ \hline \end{tabular} Data Set 2 \begin{tabular}{r|r|r|r|r|r|} \multicolumn{1}{l}{ Week } & \multicolumn{1}{l|}{ EV } & \multicolumn{1}{l}{ PV } & \multicolumn{1}{l|}{ AC } & \multicolumn{1}{l|}{ SPI } & \multicolumn{1}{l}{ CPI } \\ \hline 1 & 5 & 5 & 6 & 1.00 & 0.83 \\ \hline 2 & 15 & 15 & 20 & 1.00 & 0.75 \\ \hline 3 & 20 & 21 & 25 & 0.95 & 0.80 \\ \hline 4 & 45 & 45 & 55 & 1.00 & 0.82 \\ \hline 5 & 55 & 52 & 68 & 1.06 & 0.81 \\ \hline 6 & 65 & 57 & 73 & 1.14 & 0.89 \\ \hline 7 & 80 & 70 & 90 & 1.14 & 0.89 \\ \hline 8 & 90 & 80 & 95 & 1.13 & 0.95 \\ \hline 9 & 100 & 95 & 100 & 1.05 & 1.00 \\ \hline 10 & 102 & 105 & 118 & 0.97 & 0.86 \\ \hline 11 & 120 & 130 & 135 & 0.92 & 0.89 \\ \hline 12 & 140 & 150 & 160 & 0.93 & 0.88 \\ \hline 13 & 170 & 175 & 190 & 0.97 & 0.89 \\ \hline 14 & 195 & 200 & 235 & 0.98 & 0.83 \\ \hline 15 & 220 & 225 & 255 & 0.98 & 0.86 \\ \hline 16 & 245 & 255 & 275 & 0.96 & 0.89 \\ \hline 17 & 280 & 300 & 325 & 0.93 & 0.86 \\ \hline 18 & 325 & 350 & 380 & 0.93 & 0.86 \\ \hline 19 & 380 & 385 & 460 & 0.99 & 0.83 \\ \hline 20 & 440 & 445 & 550 & 0.99 & 0.80 \\ \hline \end{tabular} Data Set 3 \begin{tabular}{|r|r|r|r|r|r|} \hline \multicolumn{1}{|l|}{ Week } & \multicolumn{1}{l|}{ EV } & \multicolumn{1}{l|}{ PV } & \multicolumn{1}{l|}{ AC } & \multicolumn{1}{l|}{ SPI } & \multicolumn{1}{l|}{ CPI } \\ \hline 1 & 5 & 5 & 4 & 1.00 & 1.25 \\ \hline 2 & 15 & 15 & 12 & 1.00 & 1.25 \\ \hline 3 & 20 & 21 & 21 & 0.95 & 0.95 \\ \hline 4 & 45 & 45 & 49 & 1.00 & 0.92 \\ \hline 5 & 55 & 52 & 53 & 1.06 & 1.04 \\ \hline 6 & 65 & 57 & 65 & 1.14 & 1.00 \\ \hline 7 & 80 & 70 & 85 & 1.14 & 0.94 \\ \hline 8 & 90 & 80 & 95 & 1.13 & 0.95 \\ \hline 9 & 100 & 95 & 100 & 1.05 & 1.00 \\ \hline 10 & 102 & 105 & 105 & 0.97 & 0.97 \\ \hline 11 & 120 & 130 & 120 & 0.92 & 1.00 \\ \hline 12 & 140 & 150 & 130 & 0.93 & 1.08 \\ \hline 13 & 170 & 175 & 150 & 0.97 & 1.13 \\ \hline 14 & 195 & 200 & 175 & 0.98 & 1.11 \\ \hline 15 & 220 & 225 & 215 & 0.98 & 1.02 \\ \hline 16 & 245 & 255 & 248 & 0.96 & 0.99 \\ \hline 17 & 280 & 300 & 290 & 0.93 & 0.97 \\ \hline 18 & 325 & 350 & 350 & 0.93 & 0.93 \\ \hline 19 & 380 & 385 & 380 & 0.99 & 1.00 \\ \hline 20 & 440 & 445 & 450 & 0.99 & 0.98 \\ \hline \end{tabular} Data Set 4 \begin{tabular}{|r|r|r|r|r|r|} \hline \multicolumn{1}{|l|}{ Week } & \multicolumn{1}{l|}{ EV } & \multicolumn{1}{l|}{ PV } & \multicolumn{1}{l|}{ AC } & \multicolumn{1}{l|}{ SPI } & \multicolumn{1}{l|}{ CPI } \\ \hline 1 & 5 & 4 & 4 & 1.25 & 1.25 \\ \hline 2 & 15 & 12 & 12 & 1.25 & 1.25 \\ \hline 3 & 20 & 20 & 21 & 1.00 & 0.95 \\ \hline 4 & 45 & 45 & 49 & 1.00 & 0.92 \\ \hline 5 & 55 & 52 & 53 & 1.06 & 1.04 \\ \hline 6 & 65 & 57 & 67 & 1.14 & 0.97 \\ \hline 7 & 80 & 70 & 85 & 1.14 & 0.94 \\ \hline 8 & 90 & 80 & 95 & 1.13 & 0.95 \\ \hline 9 & 100 & 95 & 100 & 1.05 & 1.00 \\ \hline 10 & 102 & 105 & 105 & 0.97 & 0.97 \\ \hline 11 & 120 & 130 & 120 & 0.92 & 1.00 \\ \hline 12 & 140 & 150 & 130 & 0.93 & 1.08 \\ \hline 13 & 170 & 190 & 150 & 0.89 & 1.13 \\ \hline 14 & 195 & 215 & 175 & 0.91 & 1.11 \\ \hline 15 & 220 & 250 & 215 & 0.88 & 1.02 \\ \hline 16 & 245 & 280 & 248 & 0.88 & 0.99 \\ \hline 17 & 280 & 330 & 290 & 0.85 & 0.97 \\ \hline 18 & 325 & 380 & 350 & 0.86 & 0.93 \\ \hline 19 & 380 & 445 & 380 & 0.85 & 1.00 \\ \hline 20 & 440 & 530 & 450 & 0.83 & 0.98 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Welcome! Please read this page (in particular) very carefully. Instructions You need to understand how to send your assignments (deliverables) to your instructor. The tabs (bottom of each sheet) in...

Study Guide Healthcare Statistics By Jacqueline K. Wilson, RHIA About the Author Jacqueline K. Wilson is a Registered Health Information Administrator (RHIA) who has more than ten years of experience...

You will examine scenarios regarding specific practices and techniques relating to project management in particular estimating cost and monitoring and controlling including status reporting. This...

this is the questionplease help me thanksits a project about renovation one level of a building. project management case . This is a renovation project On the basis of group work as a personal...

What is the difference between cost variance and schedule variance? Describe the four performance indexes mentioned in chapter 11 of the text? Define control schedule process, list the control...

This assignment does not have a decision for you to make. You must perform an earned value analysis (EVA) of two project phases and assess their performance based on the EVA results. After completing...

Welcome! Please read this page (in particular) very carefully. Instructions You need to understand how to send your assignments (deliverables) Instructor: to your instructor. The tabs (bottom of each...

OPERATIONS MANAGEMENT ASSIGNMENT 6 1 Human resources, project management and operations management are all equally vital to a business's success. Each of these focuses on different areas of the...

You are the international sales manager for Aladdin Rugs, Inc., a multinational company headquartered in the United States. At the end of every month, you receive reports from the national sales...

When a contract becomes impossible or impracticable to perform, which remedy would a business person preferrescission or reformation? Explain your answer. In the United States, when a party alleges...

Which of the following audit objectives relates to the management assertion of existence? Group of answer choices A transaction is recorded in the proper period. A transaction actually occurred ( i ....

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...