Please answer the below question in the Excel spreadsheet. I submitted this ques
ID: 2422340 • Letter: P
Question
Please answer the below question in the Excel spreadsheet. I submitted this question before, but the answer, which I received, was not in Excel. I need the answer in the Excel with right formulas, which work. Use Excel to do the calculations. Please list all the variables, and then in the answer cell, enter the correct formula.
Given an activity in an advertising project whose planned cost was $12,000 but actual cost to date is $10,000 so far and the value completed is only 70 percent, calculate the cost and schedule variances. Will the client be pleased or angry? Explain.
Show work and Answers on an Excel spreadsheet.
Explanation / Answer
Schedule Variance = Earned Value - Planned Value = 12000*70% - 12000 = -$3600
Cost Variance = Earned Value - Actual Cost = 12000*70% - 10000 = -$1600
No, the client will not be please as the variances indicate "Overbudget" for the client. At the same time, the actual value derived is less than the valued planned,