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

International, what factors have contributed to the importance of internati...

what factors have contributed to the importance of international markets on operations management

Explain important characteristics of the human service model, What are the ...

What are the 2 most important characteristics of the human service model?

Explain the united states constitution, The United States Constitution: Ans...

The United States Constitution: Answer is the oldest written constitution in force in a major nation created the four branches of government established the common law created the

Define what mechanisms are related to the organizations swot, Define what m...

Define what mechanisms are related to the organization's SWOT in order to unfreeze, change, and refreeze (Lewin's theory of change) HR/business practices across the global organiza

Explain violated the confidentiality agreement, Paranzino claims she deposi...

Paranzino claims she deposit $200,000 in a bank but was given a receipt for only $100,000, but she did not notice the mistake until later. She sued the bank, but attended court ord

Driven process where interventions start immediately, 100-day workout is th...

100-day workout is the term given to an execution driven process where interventions begin immediately, not after a protracted period.

Explain bottleneck operation by adding a new machine, A small firm intends ...

A small firm intends to increase the capacity of a bottleneck operation by adding a new machine. Two alternatives, A and B, have been identified, and the associated costs and reven

Explain handling of electronic evidence, Discuss how the improper handling ...

Discuss how the improper handling of electronic evidence can adversely affect a criminal case. In your response explain the precautions that should be taken when investigators are

Tqm, benefit from total quality management in operations management

benefit from total quality management in operations management

Relation of process design to types of process flow, Relation of Process De...

Relation of Process Design to Types of Process Flow There is a definite relationship between the production process and process flow. For continuous manufacturing the methods an

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