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

Production and Operation Management, What do you understand by “line balanc...

What do you understand by “line balancing”? What happens if balance doesn’t exist?

The study of global business is relevant to work company, Discuss the follo...

Discuss the following theory: The study of global business is relevant if you work or plan to work in a large multinational company, but it has little or no significance for indivi

Explain nnon-monetary motivation, Explain nNon-monetary motivation. No...

Explain nNon-monetary motivation. Non-monetary Motivation: The following are several of the techniques of providing motivation that are non-monetary in nature:- (i) Pra

Explain what is the net income for this firm, Lifeline, Inc., has sales of ...

Lifeline, Inc., has sales of $585,000, costs of $273,000, depreciation expense of $71,000, interest expense of $38,000, and a tax rate of 35 percent. What is the net income for thi

Operation function, meaning of operation function in operation management

meaning of operation function in operation management

Explain various elements of strategic leadership, 1. Discuss the various el...

1. Discuss the various elements of strategic leadership. 2. Do you believe that one's propensity to become a leader is an acquired skill or that the ability to be a leader is so

., define the following key terms in product layout;product interval,produ...

define the following key terms in product layout;product interval,product duration and assembly line balancing

Explain what is the maximum queue length, You are to simulate arrivals and ...

You are to simulate arrivals and departures from a fictional airport with a single runway which has a capacity of handling a total 6 aircraft at once (any mix of take-offs and land

Explain the elements in a hrmis, Describe the elements in a HRMIS and the r...

Describe the elements in a HRMIS and the role such a system plays in an organization's ability to meet its goals. If you are familiar with such a system, what information does it p

Estimate the mean and standard deviation, 1. How do variables and attribute...

1. How do variables and attributes differ?  2. Estimate the mean and standard deviation of the following measurements.

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