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

Explain vroom model leadership, Compare and contrast, the three following l...

Compare and contrast, the three following leadership models: Vroom Model leadership, Fiedler`s Contingency Model and Hersey & Blanchard Situational Theory?

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 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

The transformation process model and systems thinkin, #qu1) Using the trans...

#qu1) Using the transformation process model and systems thinking concepts, explain the key operations TGL works. Pay particular attention to flow of materials and the role played

Explain what is the role of safety stock in an mrp system, 1) Discuss the m...

1) Discuss the meaning of MRP such as planned order release and scheduled order receipts? 2) Many practitioners currently update MRP weekly or biweekly. Would it be more valuabl

Define why is project management popular tool in recent year, Why is projec...

Why is project management popular tool in recent years?

Explain which depreciation method is preferable, 1. Your firm is considerin...

1. Your firm is considering an investment in a wind farm. Assume that the farm will cost $1 million per MW of installed capacity. The plan under consideration would deploy 10 GE 1.

Explain streaming video, Streaming Video: The Job Market for Graduates DQ V...

Streaming Video: The Job Market for Graduates DQ Video Document Discussion Topic What is your opinion of the interviewing tips given in the video? Which tips of your own would you

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

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