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 the facts on which economic order quantity is depend, Explain the f...

Explain the facts on which Economic Order Quantity is depend Economic Order Quantity depends on two costs:  (i) Inventory procurement costs which consists of expenditure con

Job shop organisation - operations function, Job Shop Organisation - Operat...

Job Shop Organisation - Operations Function Job shop systems generate special products or services to customer specification, with little likelihood that any particular produc

Line balancing, what do you understand by line balancing

what do you understand by line balancing

Explain definition of a project, Definition of a Project •Analyze how proje...

Definition of a Project •Analyze how project management supports the concept of strategic planning.

Hospital management requirement, The local hospital's emergency department ...

The local hospital's emergency department has 5 trauma bays. On average, patients requiring a trauma bay arrive every 50 minutes (with a coefficient of variation of 1, no seasonali

Explain strategy of wal-mart in china, Assess the strategy of Wal-Mart in C...

Assess the strategy of Wal-Mart in China where the company has recognized unions in all 62 stores, to its strategy in the U.S., which is to combat any type of union representation.

Explain what is the expected return of, Assume that you have $165,00 invest...

Assume that you have $165,00 invested in stock that is returning 11.50%,$85,000 invested in a stock is returning 22.75% and $235,000 invested in a stock that is returning 10.25%. W

Project, want help in mba project writing.what will be the price

want help in mba project writing.what will be the price

Explain how the components of the hawthorne study, Describe how the compone...

Describe how the components of the Hawthorne study are incorporated in current human resource functions? What was the main idea behind this study?

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