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

Describe what will be the maximum inventory level, ABC Co manufactures a su...

ABC Co manufactures a subcomponent at the rate of 400 per day when required. Its annual demand for this item is 50000 unites. Assume 250 working days per year. Holding cost is $10

Define what do you think will happen to hrm in the future, What do you thin...

What do you think will happen to HRM in the future? What do you think of this prediction for HRM? Is it likely to come true? If so, why? If not, why not? Cited/References

Siting departments for process layout - service operations, Siting Departme...

Siting Departments for Process Layout - Service Operations In determining the relative position of service departments the costs of movement may be less important than other,

Explain should itt have to honor the policy that layoffs, Review the "You B...

Review the "You Be the Judge" case in chapter 9 entitled Demasse v. ITT Corporation. Answer the following questions about this case: Did the emplyee handbook create a contractual

Explain economic order quantity and total cost, Explain Economic Order Quan...

Explain Economic Order Quantity and Total Cost. Economic Order Quantity and Total Cost: The total sum of Inventory procurement cost and inventory carrying cost is total cost.

Compute panera breads strategy and its effectiveness, Evaluate Panera Bread...

Evaluate Panera Breads strategy and its effectiveness with executing the strategy within the competitive fast-casual restaurant marketplace. Discuss the pitfalls to this strategy a

Describe the graphical or the simplex lp method, Solve the following proble...

Solve the following problem using either the graphical or the simplex LP method. Max: 2X1 + 6X2 s.t. 2X1 + 2X2 ? 10 1X1 + 4X2 ? 8 X1, X2 > 0

Define state licensure requirements that an organization use, Discuss state...

Discuss state licensure requirements that an organization must comply with in order to become a Medicare Advantage Plan, any exceptions to the State licensure requirement, and any

Explain dedicated cell production in modern manufacturing, Explain about th...

Explain about the dedicated cell production in modern manufacturing environment. Dedicated cell production: Traditional production has been regarding the specialisation o

Ultimate objective, Ultimate Objective 1. Manufacturing costs: The ...

Ultimate Objective 1. Manufacturing costs: The unit cost of the product should  be estimated carefully and every effort should be made to stick to the cost standards. For

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