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

Desicion making chapter 1, analyze the decision tree in figure A.8 what is ...

analyze the decision tree in figure A.8 what is the expected payoff for the best alternative? first be sure to infer the missing probabilities

Explain what is the time between orders, The current order quantity for Pau...

The current order quantity for Paul's Pasta Pinwheels is 200 boxes. The order cost is $4 per order, the holding cost is $0.40 per box per year, and the annual demand is 500 boxes p

Explain strategy is a common term in business, Strategy is a common term in...

Strategy is a common term in business. Is it a concept and/or a construct? Explain. Define it as a concept and/or a construct.

Describe methods to diagnose employee stress, Discuss methods to diagnose e...

Discuss methods to diagnose employee stress and the specific OD (organizational development practitioner) interventions aimed at alleviating it in the workplace.

Use of confidence interval calculator and the area gas, To complete this sc...

To complete this scenario, use the Confidence Interval Calculator and the Area Gas Prices %u2013 Random Sample documents, provided in the Resources. The Minneapolis Star Tribune

What are the characteristics of service organisations, What are the charact...

What are the characteristics of service organisations? The characteristics of service organisations are as given below: a. Intangibility for illustrations no physical subs

Define the benefits to corporate america of having a global, Discuss the be...

Discuss the benefits to Corporate America of having a globally diverse workforce.

Explain the precedence relationships and the estimated times, A project con...

A project consists of activities A, B, C, D, E, F, and G. The precedence relationships and the estimated times to complete each activity are given below: Activity Preceding Activit

Factors for plant location choice - suitability of climate, Factors for pla...

Factors for plant Location choice - Suitability of Climate The climate has its own importance in the location of a plant because of two reasons. First there are certain indust

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