Describe how to do in excel, Operation Management

Assignment Help:

Can you show how to do in excel?

Bowman Builders manufactures steel storage sheds for commercial use, Joe Bowman, president of Bowman Builders, is contemplating producing sheds for home use. The activities necessary to build an experimental model and related data are given in the accompanying table.

(a) What is the project completion date?
(b) Formulate an LP problem to crash this project to 10 weeks.

NORMAL CRASH
NORMAL CRASH COST COST IMMEDIATE
ACTIVITY TIME TIME ($) ($) PREDECESSORS
A 3 2 1,000 1,600 ---
B 2 1 2,000 2,700 ---
C 1 1 300 300 ---
D 7 3 1,300 1,600 A
E 6 3 850 1,000 B
F 2 1 4,000 5,000 C
G 4 2 1,500 2,000 D, E
Can you show how to do in excel


Related Discussions:- Describe how to do in excel

Explain what is the minimum number of workstations, An assembly line with a...

An assembly line with a number of tasks is to be balanced. The sum of the task times is 62 minutes. The line will operate for 6 hours per day. What is the minimum number of worksta

Explain social media in checking references, I will need at least one page ...

I will need at least one page with cites and references; (use of social media in checking references)

Structural adjustment - factor affecting productivity, Structural Adjustmen...

Structural Adjustments - Factors Affecting Productivity Improvement Structural adjustment relates to the composition of society, the industries in which people work, fashions

Describe why it is both a business pressure, Explain why IT is both a busin...

Explain why IT is both a business pressure and an enabler of response activities that counter business pressures?

What is meant by perpetual inventory system?, Ask question #What is meant b...

Ask question #What is meant by perpetual inventory system?Minimum 100 words accepted#

Explain the three steps in completing a job analysis, As an entrepreneur, h...

As an entrepreneur, how would you go about doing a job analysis for the first employee you are going to hire in your new business? What are the three steps in completing a job anal

Depict the project network using aon, Task time estimates for a production ...

Task time estimates for a production line setup project at Robert Klassens Ontario factory are as follows: Activity Time (in hours) Immediate Predecessors A 6.0 B 7.2 C 5.0 A D 6.0

Explain in a state where contributory negligence applies, In a state where ...

In a state where contributory negligence applies, a motorist that is about 10% responsible for a collision with another motorist, who sues the other motorist for negligence, will l

Explain private employees to prevent drug, Should urine testing, or other t...

Should urine testing, or other types of testing, be permitted among public and private employees to prevent drug and alcohol abuse? why or why not?

Explain should you raise or lower price, If elasticity is -2, price is $10,...

If elasticity is -2, price is $10, and marginal cost is $8, should you raise or lower price?

Write Your Message!

Captcha
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