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

Compute what will be total bid price, Your firm designs PowerPoint slides f...

Your firm designs PowerPoint slides for computer training classes, and you have just received a request to bid on a contract to produce the slides for an 8 session class. From prev

Explain brief business plan that highlight the financial, Imagine that you ...

Imagine that you are beginning the first social networking site, fast-food restaurant or pizzeria, and develop a brief business plan that highlight the financial, marketing and org

Explain what additional facts could cause the decision, Ema graduated from ...

Ema graduated from a very prestigious college and was in her second year of medical school. Ema's parents did not have the resources to help her pay for college. For the past six y

Process design, Task 1 Read: Chapter 4 of the Core learning material and su...

Task 1 Read: Chapter 4 of the Core learning material and supporting text chapters on Process Design. Task 2 Investigate: Consider the operations of your own organisation (or ano

Least cost methods, At any stage if there is a tie in the minimum cost so t...

At any stage if there is a tie in the minimum cost so that two or more routes have the same least cost of transportation then conceptually either of them may be selected. However a

Aggreate planning, Identify (a) the demand options for aggregate planning; ...

Identify (a) the demand options for aggregate planning; and (b) the capacity (supply) options for aggregate planning

Explain what should susan recommend, Susan Gilbert, a purchasing agent for ...

Susan Gilbert, a purchasing agent for Wisconsin Plastic Inc (WSI) is reviewing quotations from suppliers for a new plastic gear. Susan plans to either place an order for 12000 year

Explain the firm terminates steven, Last month, Steven Smith was hired as t...

Last month, Steven Smith was hired as the secretary for lawyer Wayne Wright, who has a drinking problem. Wayne's last secretary quit when Wayne tried to get her to go out with him

Explain what suggestions for improvement, You are the contracting officer's...

You are the contracting officer's representative (COR) of a program management support contract awarded to Easy Corp. It is the first year of a five-year contract. You have noti

Success of change initiatives is why many initiatives fail, Failure to anti...

Failure to anticipate and mitigate circumstances that might impede the success of change initiatives is why so many initiatives fail. From a business managers perspective, what doe

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