A Construction Project A maintenance building construction project also includes an external electrical generator and water tank. The first activity is to excavate which requires two weeks. Following excavation, the maintenance building will be built, and then both the generator and the water tank can be installed. These three activities, building, generator, and tank, require six, four, and two weeks, respectively. Once this set of three activities is completed, the tank and generator can be connected to the building, an activity that requires five weeks. After the maintenance building is built, maintenance equipment can also be installed inside the building and this activity takes four weeks. Painting the maintenance building is also required, following its construction, and this takes three weeks. Finally, after the maintenance equipment is installed and the connection is completed, it will take two weeks to inspect the new maintenance facility. Suppose the costs of the activities are: Activity Excavate Construct Building Install Generator Install Tank Connect Install Maintenance Paint Inspect Cost ($1000s) $50 $150 $120 $50 $40 $30 $30 $10 Suppose 5 weeks of the project have elapsed. The following work has occurred: Activity Percent Complete Actual Cost (1000s) Excavate $60 Construct Building $75 $100 $50 Install Generator Install Tank What is the estimated cost at completion and what percentage is this over or under budget? $536,000 and 10% over budget $499,000 and 12% over budget $499,000 and 4% over budget 100% 50% 75% 80% $480,000 and not over budget $429,000 and 12% under budget None of the answers are correct.

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question
A Construction Project
A maintenance building construction project also includes an external electrical
generator and water tank. The first activity is to excavate which requires two weeks.
Following excavation, the maintenance building will be built, and then both the
generator and the water tank can be installed. These three activities, building,
generator, and tank, require six, four, and two weeks, respectively.
Once this set of three activities is completed, the tank and generator can be
connected to the building, an activity that requires five weeks. After the maintenance
building is built, maintenance equipment can also be installed inside the building and
this activity takes four weeks. Painting the maintenance building is also required,
following its construction, and this takes three weeks. Finally, after the maintenance
equipment is installed and the connection is completed, it will take two weeks to
inspect the new maintenance facility.
Suppose the costs of the activities are:
Activity
Excavate
Construct Building
Install Generator
Install Tank
Connect
Install Maintenance
Paint
Inspect
Suppose 5 weeks of the project have elapsed. The following work has occurred:
Activity
Percent Complete
Actual Cost (1000s)
Excavate
$60
Construct Building
$75
$100
$50
Install Generator
Install Tank
Cost ($1000s)
$50
$150
$120
$50
$40
$30
$30
$10
What is
budget?
estimated cost at completion and what percentage this over or unc
$536,000 and 10% over budget
$499,000 and 12% over budget
$499,000 and 4% over budget
100%
50%
75%
80%
$480,000 and not over budget
$429,000 and 12% under budget
None of the answers are correct.
Transcribed Image Text:A Construction Project A maintenance building construction project also includes an external electrical generator and water tank. The first activity is to excavate which requires two weeks. Following excavation, the maintenance building will be built, and then both the generator and the water tank can be installed. These three activities, building, generator, and tank, require six, four, and two weeks, respectively. Once this set of three activities is completed, the tank and generator can be connected to the building, an activity that requires five weeks. After the maintenance building is built, maintenance equipment can also be installed inside the building and this activity takes four weeks. Painting the maintenance building is also required, following its construction, and this takes three weeks. Finally, after the maintenance equipment is installed and the connection is completed, it will take two weeks to inspect the new maintenance facility. Suppose the costs of the activities are: Activity Excavate Construct Building Install Generator Install Tank Connect Install Maintenance Paint Inspect Suppose 5 weeks of the project have elapsed. The following work has occurred: Activity Percent Complete Actual Cost (1000s) Excavate $60 Construct Building $75 $100 $50 Install Generator Install Tank Cost ($1000s) $50 $150 $120 $50 $40 $30 $30 $10 What is budget? estimated cost at completion and what percentage this over or unc $536,000 and 10% over budget $499,000 and 12% over budget $499,000 and 4% over budget 100% 50% 75% 80% $480,000 and not over budget $429,000 and 12% under budget None of the answers are correct.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.