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

Linear Programming, Solve the following Linear Programming Problem using Si...

Solve the following Linear Programming Problem using Simple method. Maximize Z= 3x1 + 2X2 Subject to the constraints: X1+ X2 = 4 X1+ X2 = 2 X1, X2 = 0

What way does a t1 use to achieve high throughput, What method does a T1 us...

What method does a T1 use to achieve high throughput over twisted pair wiring? a. frequency division multiplexing b. wavelength division multiplexing c. statistical multip

Sectors of the economy - manufacturing and service operation, Sectors of th...

Sectors of the Economy - Manufacturing and Service Operations Any operations system, if examined in sufficient detail, will be found to be unique. However, there are distinct

Explain about the just in time philosophy, Explain about the just in time p...

Explain about the just in time philosophy. Just in time (JIT): This philosophy requires which products must only be produced when there is an internal/external customer w

Line balancing, What do you understand by “line balancing”? What happens if...

What do you understand by “line balancing”? What happens if balance doesn’t exist?

Why babysitters not need technology to compete, Lawyers, babysitters, and c...

Lawyers, babysitters, and construction companys. But why wouldn't they need technology to compete?

LOCATION AND LAYOUT, WHAT WOULD BE A GOOD RESEARCH QUESTION ON THIS TOPIC F...

WHAT WOULD BE A GOOD RESEARCH QUESTION ON THIS TOPIC FOR A GROUP PROJECT

Explain district investigation of sexual harassment case, Peter Lewiston wa...

Peter Lewiston was terminated on July 15, 2004, by the governing board of the Pine Circle Unified School District (PCUSD) for violation of the district sexual harassment policy. Pr

Explain strategies should be considered if a small business, What strategie...

What strategies should be considered if a small business is setting prices for a product that is to be exported? How are these strategies different from those used in a domestic ma

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