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 what is the total cost of this policy, Rocky Mountain Tire Center s...

Rocky Mountain Tire Center sells 20,000 go-cart tires per year. The ordering cost for each order is $40, and the holding cost is 20% of the purchase price of the tires per year. Th

What is reliability is decriminator in cost of gps receivers, The DAGR GPS ...

The DAGR GPS receiver will have a 25% increase inreliability over the PLGR GPS receiver. Using the PLGR as an analogy, an analyst estimated that the DAGR would cost 25% more than t

Activities to a subsidiary in another country, Transferring some part of an...

Transferring some part of an organisation's activities to a subsidiary in another country is an example of  offshoring.

Explain maintain its strong brand images, impressive portfolio includes som...

impressive portfolio includes some of the strongest brand names in the world. Additionally, P&G must study its consumers, use long-term perspectives, employ product innovation and

Explain obstacles and the boat was operated properly, A water skier who bre...

A water skier who breaks his leg after a tumble while water skiing, where the lake was free of obstacles and the boat was operated properly, will probably fail to recover in an act

String diagram, String diagram is a simple tool for analyzing and desi...

String diagram is a simple tool for analyzing and designing work space such that movement can be minimized. The basic diagram is a scale plan or model on which a t

Explain spread harmful rumours gossips uses bad language, Sara spread harmf...

Sara spread harmful rumours gossips uses bad language and lack civility in relationship while at work/ in which of the following is sarah engaging in/1.proert deviance/ 2 productio

Why surprised by environmental changes, Why do you think many managers are ...

Why do you think many managers are surprised by environmental changes and hence are less able to help their organizations adapt?

Is focused factory concept applicable in service sector, Is the 'focused fa...

Is the 'focused factory' concept described by Skinner applicable in the service sector? Answer:  Yes, think of Schmenner's service-process matrix and the lower quadrant entitled

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