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

Personal use assets, Rose  considers herself  a relatively conservative inv...

Rose  considers herself  a relatively conservative investor  and  the  score  from her investor profile questionnaire categorizes her as an "income and moderate growth" investor. S

Calculate the economic order quantity, A local nursery greens uses 1560 bag...

A local nursery greens uses 1560 bags of plant food annually. Green works 52 weeks per year. It costs $10 to place an order for plant food. The annual holding cost rate is $5 per b

Explain compensation of expatriates, For a company with overseas operations...

For a company with overseas operations, some critical concerns for success are the identification, selection, and compensation of expatriates. Answer True or False

Explain gauge reproducibility and repeatability, Describe gauge reproducibi...

Describe gauge reproducibility and repeatability. How does gauge R and R apply to a six sigma project?

Define what can we learned about business and ethics, Details what can we l...

Details what can we learned about business, ethics, and society.

Managerial decession making history, #question.what is the history of manag...

#question.what is the history of managerial decession making ? .

Mass customisation - operation strategy, Mass Customisation - Operation Str...

Mass Customisation - Operation Strategy This example of mass customisation is rather limited in scope to denim trousers. A customer who wishes to purchase a jacket of a partic

Explain the elements of an organizations environment, Describe the elements...

Describe the elements of an organization's external environment. Why is it important to understand the external environment?

What happen to the degree of objective risk, If a corporation doubles the n...

If a corporation doubles the number of exposure units, what may be said to happen to the degree of objective risk? Explain your answer and state the basic principle illustrated.

Characteristics of continuous or flow production, Characteristics of Contin...

Characteristics of Continuous or Flow Production Flow of Material: The flow of materials is continuous and there is little or no queuing at any stage of processing. Mac

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