Question

In: Operations Management

Consider the following data: Initiation Planning Analysis Design Implementation Testing Closure # Months estimated to complete...

Consider the following data:

Initiation Planning Analysis Design Implementation Testing Closure
# Months estimated to complete

2

6

8

6

18

6

2

Budgeted Cost $

2000

6000

12000

12000

80000

36000

4000

% work completed

100%

100%

80%

0%

0%

0%

0%

Actual Cost $

4000

8000

16000

20000


We are tracking the amount of work completed after 22 months. For the data given, find the Schedule Variance at the end of 22 months.

a.

-14400 $

b.

30400 $

c.

- 30400 $

d.

14400 $

Solutions

Expert Solution

Answer

a-14400 $

Explanation

Schedule variance measures performance of the works in relation to budgeted costs

SV = BCWP ? BCWS

Planned Value or BCWS is the total cost of the work scheduled as of reporting date

Earned value or BCWP is the total cost of the work completed as of reporting date.

Step 1

We calculate the amount of work that should have been completed according to budget by given date and express it in dollar value.

Budgeted cost of work scheduled, P

= 2000+6000+12000+12000

=$ 32000

Step 2

Then we calculate the value of completed work based on budget (not based on actual data)

Budgeted cost of work performed, EV

=summation (percent of work completed* budgeted cost for the work completed)

=1.0* 2000+1.0*6000+0.8*12000+0.0*12000

=$17600

Step 3

As per budget, work with value of $ 32000 should have been completed. The actual worth of work completed according to the budget is only $17600

Schedule Variance = Earned Value – Planned Value

=$17600-$ 32000

=-14400

SV is negative. Project is behind the schedule


Related Solutions

Develop a report utilizing the Project Management Life Cycle (PMLC) model ((initiation, planning, execution, and closure),...
Develop a report utilizing the Project Management Life Cycle (PMLC) model ((initiation, planning, execution, and closure), and reporting it to your client. Also, prepare a summary analysis of the project. The project has approached the halfway point, thus your client has requested a milestone review of the project. The project has approached the halfway point, thus your client has requested a milestone review of the project. You might consider using a project management software such as MS Project to demonstrate...
Explain SDLC agile model each phases. 1. Planning 2. Analysis 3. Design 4.Implementation 5.Testing 6.Maintenence
Explain SDLC agile model each phases. 1. Planning 2. Analysis 3. Design 4.Implementation 5.Testing 6.Maintenence
3. [2.1,2.2] Consider software projects flowing through three main activities: requirement planning, development, and testing/implementation. Three...
3. [2.1,2.2] Consider software projects flowing through three main activities: requirement planning, development, and testing/implementation. Three different types of resource-types (employees) are needed at each step: analysts for requirement planning; programmers for code development and testers for system testing. There are 2 analysts, 1 developer and 3 testers. Software projects arrive at the rate of 4 per month (30 days). A project typically takes 10 days for requirement planning, 6 days for code development, and 16 days for testing/implementation. (a)...
Discuss the systems development life cycle as applied to project management: Initiation, Planning, Acquisition or design...
Discuss the systems development life cycle as applied to project management: Initiation, Planning, Acquisition or design and development, Implementation, Operations/Maintenance, Disposition/Disposal. Define a specific area and identify a specific component within that area that greatly contributes to the overall quality of a well-designed, well management and well-used EHR that complements positive health care outcomes."
Focuses on the design, development, implementation, and testing of a Python program using Jupyter Notebook only...
Focuses on the design, development, implementation, and testing of a Python program using Jupyter Notebook only to solve the problem described below. You will write a program that simulates an Automatic Teller Machine (ATM). For this program, your code can have of user-defined functions only. However, the program must not call on any external functions or modules to handle any of the input, computational, and output requirements. Note, the program can be completed without the use of user-defined functions. Requirements:...
Koshy Company is planning a cash budget for the next three months. Estimated sales revenue is:...
Koshy Company is planning a cash budget for the next three months. Estimated sales revenue is: Month Revenue Month Revenue January $175,000 March $125,000 February 150,000 April 100,000 Month Sales Revenue Month Sales Revenue All sales are on credit; 60 percent is collected during the month of sale, and 40 percent is collected during the next month. Cost of goods sold is 80 percent of sales. Payments for merchandise sold are made in the month following the month of sale....
Complete the analysis of variance table for the following data. Treat it as a two way...
Complete the analysis of variance table for the following data. Treat it as a two way Block Design.  (Use α = 0.05). In each cee there are 2 observations. For example in cell 1,1 they are 13 and 1 DATA Source A Means I II III Source B Level 1 13, 11 9, 15 8, 10 11 Source B Level 2 15,13 9, 7 6, 4 9 Means 13 10 7 Grand Mean = 10 ANOVA TABLE Sources D.F. S.S. M.S....
Complete the analysis of variance table for the following data. Treat it as a two       way...
Complete the analysis of variance table for the following data. Treat it as a two       way Block Design.  (Use α = 0.05). In each cell there are 2 observations, except for         the last cell, which has only one observation. DATA             Source A Means I II III Source B Level 1 20    18 12    14 9    11 14 Source B Level 2 12    10 10      8 8 9.6 Means 15 11 9.33 Grand Mean = 12 ANOVA TABLE Sources D.F. S.S. M.S. F Source A Source B...
Complete the analysis of variance table for the following data. Treat it as a two way...
Complete the analysis of variance table for the following data. Treat it as a two way Block Design.  (Use α = 0.05). In each cee there are 2 observations. For example in cell 1,1 they are 13 and 1 DATA Source A Means I II III Source B Level 1 13, 11 9, 15 8, 10 11 Source B Level 2 15,13 9, 7 6, 4 9 Means 13 10 7 Grand Mean = 10 ANOVA TABLE Sources D.F. S.S. M.S....
Cash Budget Wilson's Retail Company is planning a cash budget for the next three months. Estimated...
Cash Budget Wilson's Retail Company is planning a cash budget for the next three months. Estimated sales revenue is as follows: Month Sales Revenue Month Sales Revenue January $300,000 March $200,000 February 205,000 April 185,000 All sales are on credit; 60 percent is collected during the month of sale, and 40 percent is collected during the next month. Cost of goods sold is 80 percent of sales. Payments for merchandise sold are made in the month following the month of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT