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

Define constraint its associated binary decision variables, Consider the fo...

Consider the following constraint and its associated binary decision variables: XA + XB + XC = 2. This constraint is an example of a mutually exclusive constraint.

Elements of operations management, Elements of Operations Management ...

Elements of Operations Management 1. Planning  This is the setting of appropriate courses of action to achieve the systems objectives.  2. Organising  This is the

Find cause the cost of capital to decrease, Due to changes in regulatory re...

Due to changes in regulatory requirements, the transactions costs associated with selling corporate securities increased by $1 per share. This change will Answer a. cause the co

Explain what are the privacy requirements under hipaa, What are the privacy...

What are the privacy requirements under HIPAA? Explain why confidentiality of health information has been a controversial public policy issue. Give a real world example. How can he

Explain which forceasting method do you prefer, Consider monthly demand for...

Consider monthly demand for the ABC Corporation as shown in Table 7-3. Forecast the monthly demand for year 6 using moving average, simple exponential smoothing, Holt's model, and

Explain medical facility does mris for sports injuries, A medical facility ...

A medical facility does MRIs for sports injuries. Occasionally a test yields inconclusive results and must be repeated. Using the following sample data and n = 195. SAMPLE 1 2 3 4

Linear Programming Problem, Solve the following Linear Programming Problem ...

Solve the following Linear Programming Problem using Simple method. Maximize Z= 3x1 + 2X2 Subject to the constraints: X1+ X2 = 4 X1 - X2 = 2 X1, X2 = 0

Game theory, Consider the following parlor game to be played between two pl...

Consider the following parlor game to be played between two players. Each player begins with three chips: one red, one white, and one blue. Each chip can be used only once. To beg

Explain leadership training and development, Leadership training and develo...

Leadership training and development throughout all levels of the organization. From your experience discuss the importance this component and why? Include examples

Explain the major components of hr planning and forecasting, Discuss the ma...

Discuss the major components of hr planning and forecasting efforts.

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