Question: could you please use excell and show all work! a. (3 pts) Calculate EV and PV for each task and the total for the project

could you please use excell and show all work!

a. (3 pts) Calculate EV and PV for each task and the total for the project for each time period. b. (3 pts) Calculate the CV, SV, CPI and SPI, ETC and EAC for the project (don't need each task) at each of those time periods. c. (1 pt) What can you say about the health of the project? (Must discuss the variances here) 2. ( 3 pts) Rework the information for parts a and b of problem 1 using the 20/80% rule for the percent completion. Any change in the health

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!

Peaceful Cat Pet Foods is a new business owned by Wren Hammond. The first year of operations commenced on January 1, 2022. Company information: EIN: 98-0050036 Address: 1021 Old Plainfield Road,...

please show all work! either in excell or hand written. a. ( 3 pts) Calculate EV and PV for each task and the total for the project for each time period. b. (3 pts) Calculate the CV, SV, CPI and SPI,...

1.(7 pts) The following data was collected for Project Widget at Schuman Inc. Data was collected following weeks 3 (day 15) and 4 (day 20). Note: AC = Actual Costs in the table below. This problem...

DO NOT USE MICROSOFT PROJECT PLEASE! 1. (7 pts) The following data was collected for Project Widget at Schuman Works. Data was collected following weeks 10 and 20. Note: AC= Actual Costs in the table...

could you please slove for AC 5days in excel please a. (3 pts) Calculate EV and PV for each task and the total for the project for each time period. b. (3 pts) Calculate the CV, SV, CPI and SPI, ETC...

Bethesda Mining is a midsized coal mining company with 20 mines located in Ohio, Pennsylvania, West Virginia, and Kentucky. The company operates deep mines as well as strip mines. Most of the coal...

Task Pred. Duration (days) AC after 3 days $25 AC after 9 days 535 Budget | % complete after 3 days $40 75% 40% 48 0% 18 32 12 % complete after 9 days 100% 100% 100% 40% 90% 4 0 24 32 20 O E A,B B...

Note: AC = Actual Costs in the table below. All costs are in Thousands of dollars. Task Budget AC after 3 days $25 12 AC after 9 days $35 24 25 A B C Pred. Duration (days) - 5 - 6 A 4 A ,B 5 B 3 C...

Note: AC = Actual Costs in the table below. All costs are in Thousands of dollars. Task Pred. Duration (days) Budget AC after A - $40 $25 % complete after 3 days 75% 40% 0% 0 AC after 9 days $35 24...

Earned Value Calculation Objectives of this assignment: Demonstrate ability to calculate earned value indicators Demonstrate ability to interpret earned value indicators Assignment: 1. Within this...

Violins-by-Zain produces student-grade violins for beginning violin students. The company produced 2,000 violins in its first month of operations. At month-end, 600 finished violins remained unsold....

In the after-school club, Dena, Shawn, and Amanda knit scarves that are all the same size with yellow, white, and blue yarn. Dena's scarf is yellow, Shawn's scarf is yellow, and Amanda's scarf is...

Which of the following statements is true about the current exchange rate? Multiple choice question. It is the exchange rate at the end of the trading day on the balance sheet date. It is the spot...

The first scenario will be a Verbal Judo scenario in which your scenario follows the standard Verbal Judo interaction: You need to ask somebody to modify their behavior either to do something or to...

6. Explain the strengths of a dialectical approach.

4. How have other fields contributed to the study of intercultural communication?

1. Becoming Culturally Conscious. One way to understand your cultural position within the United States and your own cultural values, norms, and beliefs is to examine your upbringing. Answer the...