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

Determine that the trade offs of operation system is correct, Determine tha...

Determine that the Trade offs of operations systems is correct You may wish to ponder this trade-offs for a moment and ask the question: is this correct? Consider an organisat

What are some instances that would explain strategic groups, What are some ...

What are some examples that would explain strategic groups?

Explain personal and professional lives, How can you see the integration an...

How can you see the integration and the modern management theory integrated into your own personal and professional lives? Pick only one theory for there are hundreds

Explain a difference between ethics and business ethics, Is there a differe...

Is there a difference between ethics and business ethics?

Explain contract formation process that he now faces, You are currently an ...

You are currently an intern working for the largest law firm in Alabama. Your mentor and senior attorney introduces you to a new client, Dick Jefferson, the owner of House Doctor,

Substitute favourable market unfavourable market build, Karen Villagomez, p...

Karen Villagomez, president of Wright Industries, is considering whether to build a manufacturing plant in the Ozarks. Her decision is summarized in the following table: Alternativ

What is objective function, FestiveMeadow3308 Baseballs (z1) requires 3 ...

FestiveMeadow3308 Baseballs (z1) requires 3 minutes/unit for cutting and 2 minutes/unit for glueing. Basketballs (z2) requires 2 minutes/unit for cutting and 4 minutes/unit for

Determine the dominant operations performance objectives, 1. When an organi...

1. When an organisation is stepping up production or availability of a service what are the dominant operations performance objectives?  Answer: This is a very difficult questio

Explain what are the two major types of labour arbitration, What are the tw...

What are the two major types of labour arbitration "interest" and "right"? Explain each.

Optimal order interval, would you recommend changing to the optimal order i...

would you recommend changing to the optimal order interval?

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