Construct a tracking gantt chart using ms project

Assignment Help Operation Research
Reference no: EM131135822

1. Use the following information to construct a "Tracking Gantt" chart using MS Project.

Activities Duration Preceding
A 5 days none
B 4 days A
C 3 days A
D 6 days B, C
E 4 days
F 2 days D, E

Highlight project status on day 14 using the tracking option and assuming that all tasks to date have been completed on time. Print/capture the output file.

2. Using the information in Problem 1, highlight the project's status on day 14 but assume that activity D has not yet begun. What would the new tracking Gantt chart show? Print/capture the output file.

3. Use the following table to calculate project schedule variance based on the units listed. (Figures are in thousands.)

Schedule Variance Work Units

 

A

B

C

D

E

F

Total

Planned Value

20

15

10

25

20

20

110

Earned Value

10

10

10

20

25

25

 

Schedule variance

 

 

 

 

 

 

 

4. Using the data in the table below, complete the table by calculating the cumulative planned and cumulative actual monthly budgets through the end of June. Complete the earned value column on the right. Assume the project is planned for a 12-month duration and $250,000 budget.

Activity                        Jan     Feb               Mar Apr         May Jun      Plan % C Value

Staffing                        8        7                                              15      100_______

Blueprinting                              4        6                                    10      100_______

Prototype

Development                                     2        8                           10      70 _______

Full Design                                                   3        8        10     21      67________

Construction                                                          2        30     32      25________

Transfer                                                                           10     10      0

Monthly Plan ____________________________________________________

Cumulative _______________________________________________

Monthly Actual             10      15      6        14      9       40

Cumul. Actual____________________________________________________________

5. Using the data from Problem 4, calculate the following values:

Schedule Variances

Planned Value (PV)

Earned Value (EV)
Schedule Performance Index (SPI)
Estimated Time to Completion

Cost Variances
Actual Cost of Work Performed (AC)
Earned Value (EV)
Cost Performance Index (CPI)
Estimated Cost to Completion

Verified Expert

This task deals with the construction of Gantt chart and the workings of schedule performance index along with schedule variances and cost variances. Earned value method relies on a key measure known as the earned value (also known as the “budgeted cost of worked performed” or BCWP). This measure enables one to compute performance indices for cost and schedule, which tell how well the project is doing relative to its original plans. These indices also enable one to forecast how the project will do in the future.

Reference no: EM131135822

Questions Cloud

Write paper that includes security concerns for enterprise : Write a 2 to 3-page paper that includes the Security concerns for the enterprise, suggestions for additional information to be documented with examples and consideration of network bandwidth capacity considerations in the design documents.
What potential constitutional issues arise at sentencing : Compare and contrast sentencing guidelines and mandatory minimum sentences. Identify three aims of both sentencing guidelines and mandatory minimum sentences. What potential constitutional issues arise at sentencing? Use the internet to research a..
Explain why the results differ between the two cases : Show that licensing can be beneficial for firm 1 in this case and therefore increase innovation incentives. Explain why the results differ between the two cases.
Determine the changes to the balance sheet income statement : determine the changes to the balance sheet, income statement, job cost ledger, and equipment ledger as the result of leasing a $55,000 dump truck (Dump Truck 11). The lease extends for five years at which time the dump truck may be purchased for $5,0..
Construct a tracking gantt chart using ms project : Construct a Tracking Gantt chart using MS Project - calculate project schedule variance based on the units listed. (Figures are in thousands.)
The role of communication in your daily job : Revise the following interview questions to make them more effective. In a brief paragraph for each, explain why you have revised the question as you have.
Characterize the equilibrium number of varieties : Characterize the equilibrium number of varieties (at which all monopolistically competitive variety producers make zero profits) and compare this number with the answers to the previous two parts. Explain the sources of differences between the equ..
The managing director of your company explaining : Prepare a report for the managing director of your company explaining how costs may be classified by their behaviour, with particular reference to the effects both on total and on unit costs.
One sample t test computations : One-Sample T-Test Computations Thirty anorexic girls were treated with cognitive behavioral therapy (CBT). They were weighed before and after the treatment. The weight gains, which are positive scores, and weight losses, which are negative scores, ar..

Reviews

Write a Review

Operation Research Questions & Answers

  Describe analytical hierarchy process (ahp) analysis

Define the Analytical Hierarchy Process (AHP) Analysis. Also I need your assist in building an AHP analysis sheet.

  How to submit homework xcxzcxzczx how to submit homework

xcxzcxzczx how to submit homework how to submit homework how to submit homework how to submit homework how to submit

  In this module you will discover how businesses react to

in this module you will explore how businesses react to changing economic times and the influence this has on

  Explore the styles of conflict resolution

I need help to describe the 5 style of conflict resolution.

  Describe maxwell manufacturing makes two models

Maxwell Manufacturing makes two models of felt tip marking pens. Requirements for each lot of pens are given below. Flip top Model Tiptop Model Available.

  A new teacher in a coffee shop

Imagine you meet a new teacher in a coffee shop. You tell her that you just completed a course in child development, and she asks you what you learned that could help her in her new job as a teacher.

  Characteristics of operation research

What are the characteristics of operation research

  What is this minimized cost

Given these facts, how many devices should be shipped from each warehouse to each distributor per month, in order for AppleBerry to minimize its costs? What is this minimized cost?  Set this up as a spreadsheet using Solver.

  Compute core competencies

How can you determine a core competency. I need help to discuss the determination of core competencies.

  Why does akamai need to geographically disperse

Why does Akamai need to geographically disperse its servers to deliver its customers' Web content. If you wanted to deliver software content over the Internet, would you sign up for Akamai's service. Why or why not.

  Construct the appropriate math model

Analyze data using response tables. Plot main and interaction effects and construct the appropriate math model using the response table & Excel.

  Explain the starbucks''s entry into china

Can you think of an example of an organization that appears to have done a good job at assessing the cost and benefit of entry into a new market.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd