Neural Camcast's production division is installing two production lines in different countries. The following cumulative actual costs, earned value, and planned value (in $ thousands) have been collected for each project for the first ten weeks. The projects final budgets are $800k for each project. + Project 1 Actual EV PV 20 45 45 30 93 60 95 119 130 105 187 210 160 217 230 200 247 248 268 285 268 298 339 328 338 409 378 388 484 458 Project 2 Actual 78 EV 60 168 112 228 162 258 210 441 PV 35 80 120 158 283 274 230 318 295 295 361 327 335 347 365 491 364 395 531 376 423 With this assignment you are also provided a spreadsheet with cumulative data for Projects 1 and 2. Input the appropriate values and your analysis as directed in the yellow cells within the spreadsheet. Week 1 2 3 4 5 6 7 8 9 10 USE THESE CULULATIVE VALUES FOR YOUR ANALYSES. The SPC/CPI Message tells you if you have an error in your SPI and/or CPI Project 1 Project 2 Actual Actual EV PV 20 30 60 105 160 45 93 119 130 187 210 217 230 200 247 248 268 285 268 298 339 328 338 409 378 388 484 458 45 95 SPI to 2 decimals Budget (K$) = Est Total Spending (K$)= Variance to Budget = Negative Variance is unfavorable 800 800 CPI to 2 decimals Error SPI/CPI Message Error Error Error Error Error Error Error Error Error Error 0 EV 78 168 112 228 162 258 210 283 274 60 PV 35 80 120 158 230 318 295 295 361 327 335 441 347 365 491 364 395 531 376 423 SPI to 2 decimals Budget (K$) = Est Total Spending (K$)= Variance to Budget = Negative Variance is unfavorable 800 800 CPI to 2 decimals Error SPI/CPI Message Error Error Error Error Error Error Error Error Error Error 0 Respond to the following: Enter A or B in the yellow box indicating Project 1 will A) Likely finish early to ontime or B) Will likely finish ontime to late. Input A or B in the yellow box indicating Project 2 will A) Likely finish early to ontime or B) Will likely finish ontime to late.