The table for this problem describes the various activities of a construction project in a chemical plant.
Question:
The table for this problem describes the various activities of a construction project in a chemical plant.
(a) Set up and solve an LP model using Excel to crash this project to 22 days. What is the total crashing cost?
(b) Assuming each activity can only be crashed in whole days, what is the earliest completion of this project? What is the total associated crash cost?
Transcribed Image Text:
Immediate Standard Time Standard Crash Time Activity Predecessors (days) Cost (days) Crash Cost A 4 $2,000 2 $2,600 $3,500 $3,300 $4,300 $3,900 A 6 5 A 8. 6 $1,200 $1,700 $1,800 $2,200 B 5 4 C, D 3 2 F E 7 $2,200 5 $3,600 $ 900 $1,200 $1,550 $1,700 G 5 4 H F, G 4 3 DE
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 50% (8 reviews)
18 a To set up an LP model using Excel to crash this project to ...View the full answer
Answered By
Maurat Ivan
I have been working in the education and tutoring field for the past five years, and have gained a wealth of experience and knowledge in this area. I have a bachelor's degree in education, and have completed additional coursework in teaching and tutoring.
In my previous roles, I have worked as a teacher in both private and public schools, teaching a variety of subjects including math, science, and English. I have also worked as a private tutor, providing one-on-one tutoring to students in need of additional support and guidance.
In my current role, I work as an online tutor, providing virtual tutoring services to students around the world. I have experience using a variety of online tutoring platforms and technologies, and am comfortable working with students of all ages and skill levels.
I am passionate about helping students succeed and reach their full potential, and I believe that my education and tutoring experience make me an excellent candidate for a tutoring job at SolutionInn. I am confident that my knowledge, skills, and experience will enable me to provide top-quality tutoring services to students on the SolutionInn platform.
0.00
0 Reviews
10+ Question Solved
Related Book For
Managerial Decision Modeling Business Analytics With Spreadsheet
ISBN: 9781501515101
4th Edition
Authors: Nagraj Balakrishnan, Barry Render, Ralph Stair, Charles Munson
Question Posted:
Students also viewed these Business questions
-
In Exercises 1-3, set up and solve an appropriate system of linear equations to answer the questions. 1. Grace is three times as old as Hans, but in 5 years she will be twice as old as Hans is then....
-
Set up and solve the Huckel secular equations for the n electrons of NO-3. Express the energies in terms of the Coulomb integrals ao and aN and the resonance integral 13. Determine the delocalization...
-
Set up and solve an appropriate system of linear equations to answer the questions. Describe all possible values of a, b, c, and d that will make each of the following a valid addition table. a) b) 2...
-
Tern Corporation, a calendar year C corporation, is solely owned by Jessica Ramirez. Terns only business since its incorporation in 2011 has been land surveying services. In Terns state of...
-
At high temperatures, a dynamic equilibrium exists between carbon monoxide, carbon dioxide, and solid carbon. At 850oC, Kc is 0.153. a. What is the value of Kp? b. If the original reaction system...
-
Peter is a professor of mathematics at State University. His lifetime avocation has been sailing, and he owns an oceangoing sailing vessel. He plans to retire in five years and spend the remainder of...
-
At \(t=0\), electron 1 is shot out of an accelerator at a speed of \(2.0 \times 10^{3} \mathrm{~m} / \mathrm{s}\). At \(t=1.0 \mu \mathrm{s}\), electron 2 is shot out of the accelerator and travels...
-
Amy Lloyd is interested in leasing a new Saab and has contacted three automobile dealers for pricing information. Each dealer offered Amy a closed-end 36-month lease with no down payment due at the...
-
For this exercise, instead of using the values in the challenge, ask the user for the number of shares, the share price, and the percent commission.For this exercise, instead of using the values in...
-
On January 1, 2017, Bretz, Inc., acquired 60 percent of the outstanding shares of Keane Company for $573,000 in cash. The price paid was proportionate to Keane's total fair value although at the date...
-
What is an activity? What is an immediate predecessor?
-
Complete the designated calculations for the following subsets of activities. Each subset is independent of the other subsets in the problem. (a) Activity H has an EFT of 12 days. Activity I has an...
-
Linearly polarized light of angular frequency w is incident on a one-electron ?atom? whose wave function can be approximated by the ground state of a three-dimensional isotropic harmonic oscillator...
-
Tony Stark has hired as you an implementation consultant to oversee the implementation and rollout of Binary Augmented Retro Framing (BARF) to replace an obsolete VR training system for SHIELD. The...
-
At a level of 7 , 8 5 8 units, Lydia, Inc., a company that makes shovels, has total fixed costs of $ 3 5 9 , 4 3 1 and total variable costs of $ 3 3 6 , 0 5 6 for delivery. What would the total...
-
The following items are taken from the adjusted trial balance prepared as of December 3 1 , 2 0 1 7 . All accounts have normal balances. List of items taken from the adjusted trial balance. Cash $ 4...
-
In this opening Discussion you are to describe the differences between the supply chains for the retail business of Walmart and Dell. Think about this: What makes two organizations a bit different?...
-
Determining the effect of a transaction on the accounts is a desired outcome of which step of the recording process?
-
This problem in part (a) is known as the "Flower of Thymaridas," named after a Pythagorean of the fourth century B.C. (a) Given the n numbers a1, a2, ... an, solve for x1, x2, ..., xn in the...
-
Phosgene, COCl2, is a toxic gas used in the manufacture of urethane plastics. The gas dissociates at high temperature. At 400oC, the equilibrium constant Kc is 8.05 104. Find the percentage of...
-
Discuss how output from a marketing information system (MIS) might differ from the output of a typical marketing research department.
-
Discuss some of the likely problems facing the marketing manager in a small firm who plans to search the Internet for information on competitors marketing plans.
-
Explain the key characteristics of the scientific method and show why these are important to managers concerned with research.
-
What is the first responsibility of the Operations Level Responder at a hazmat incident?
-
Which tool can provide a single unified management experience in Azure for enterprises to govern, monitor, operate, and analyze backups at scale?
-
Assess Capital One network cyber-security policy to determine if the policy is able to minimize risks and vulnerabilities.
Study smarter with the SolutionInn App