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 benefits of free international trade, What are the benefits and dis...

What are the benefits and disadvantages of free international trade for the United States? Examples would be helpful also.

Supply Network, In a 1-2 page paper with a graphic as an appendix, identify...

In a 1-2 page paper with a graphic as an appendix, identify a supply network and evaluate the importance of operations management in moving this product through the supply chain to

Explain organizational complexity affect human behaviour, Given the multipl...

Given the multiple components (subsystems) of the organizational system model, organizations might be said to be complex. Drawing from your own work and organizational experiences

Explain when a firm is able to move to an assemble, When a firm is able to ...

When a firm is able to move to an assemble- To- Order capability from a make -To- Stock approach, there can be a substantial reduction in the number of things that must be tracked

Process design, Process Design New product is not realities unit they...

Process Design New product is not realities unit they are manufactured. Process design is necessary to manufacture new products. Process design is concerned with the overall

Explain cango is looking at ways to grow its business, CanGo is looking at ...

CanGo is looking at ways to grow its business. How should they approach the decision on how to do it?

Different approaches to innovation discussed organizations, Analyze the dif...

Analyze the different approaches to innovation discussed in this chapter to determine which approach you think would be the greatest value to the greatest number of organizations.

Explain what benefit would using the optimal order quantity, Garden Variety...

Garden Variety Flower Shop uses 760 clay pots a month. The pots are purchased at $2 each. Annual carrying costs per pot are estimated to be 30 percent of cost, and ordering costs a

Interdependent sub systems - operations function, Interdependent sub-system...

Interdependent sub-systems A striking feature of complex, open systems is that each comprises a set of highly interdependent sub-systems. For instance, the human body consist

Explain keeping your personal customer data the cloud, Some companies run t...

Some companies run their entire business by offering cloud services called Software as a Service (SaaS). There are several advantages for companies and individuals to use SaaS. But

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