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, classification of linear programming on the basis of st...

classification of linear programming on the basis of structure

Discuss the internal factors as means of improving business, 1.Read the fol...

1.Read the following case:  'Mr Soft n Cool Gelato' is an Ice Cream business owned by Alfredo and Guido Corleone. Since they started the business 18 years ago the firm has expan

Explain what the term data redundancy means, Describe what the term "data r...

Describe what the term "data redundancy" means in database design. Explain if it is bad and if a normalized database design is always the best design. Discuss the pros and cons of

Explain organizational culture corporate responsibility, How do you think m...

How do you think management changed over the years in respect to the following? Organizational culture Corporate responsibility and ethics Culture and diversity conflicts

Explain create a more motivated workforce, How can job design be used to cr...

How can job design be used to create a more motivated workforce? Be specific.

Advantage of vogel approximation method, Advantage of Vogel Approximation ...

Advantage of Vogel Approximation Method a. This method is very systematic. b. This method takes lesser time in solving transportation problem. c. Less computation a

Process through bank supply its customer with cash on demand, 1. Think of f...

1. Think of four different processes by which a bank might supply its customers with cash on demand. Answer: Examples: over-the-counter at branches, by ATM dispensers in shoppin

Explain how can product development costs be minimized by, How can product ...

How can product development costs be minimized by entering the market late

List any three business areas in the umuc pizza shops, List three business ...

List three business areas and/or processes used in the UMUC Pizza shops that could be supported by an IT solution.

Explain what is tims best defense, Tim is a director and officer of United ...

Tim is a director and officer of United States Sales, Incorporated. Tim makes a marketing decision that results in a dramatic decrease in profits for United States Sales and its sh

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