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 linear programming problem graphically, Solve the following linear ...

Solve the following linear programming problem graphically by enumerating the corner points. MAX: 3X1 + 4X2 Subject to: X1 X2 4X1 + 6X2 X1, X2 > 0 First

Explain what are the four steps in the basic approach, What are the four st...

What are the four steps in the basic approach to process design that some companies use

Scheduling in mass continuous, Scheduling In Mass Continuous Schedul...

Scheduling In Mass Continuous Scheduling In Mass Continuous and Project Type Production System The scheduling aspects mentioned so far have been concerned with job shop

Explain the value of the business you selected, Know discuss what business ...

Know discuss what business you selected and the best possible method for determining the value of the business you selected. Explain your rationale

Explain what factors might inhibit hrd managers, What factors might inhibit...

What factors might inhibit HRD managers from developing a strategic planning approach to training? How might these factors be overcome?

Find the critical path, Using the information given in the following table:...

Using the information given in the following table: (A) Identify the critical path. (B) Determine expected project duration. Activities Precedes Duration Start a,b,c - a d 5 d f 6

Management consultant firm, After working for 30 years, Ramjee Somjee Dutt ...

After working for 30 years, Ramjee Somjee Dutt opted for VRS and started a courier company and did very well in the first four years. He was now looking for expansion of his busine

Describe what makes google successful, Research Google and develop a 3 page...

Research Google and develop a 3 page paper by answering the following questions: Need cite and reference. 1) Briefly describe the organization 2) What makes Google successful

Why is it vital for national health information management, Why is it impor...

Why is it important for national health information management organizations to agree on how to standardize paper and electronic medical forms?

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