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 is the reorder point, The injection moulding department of a ...

The injection moulding department of a company that operates 24x7 uses an average of 20 gallons of special lubricant per day. It takes two weeks for an order of lubricant to be del

Explain what order size would you recommend, A manager just received a new ...

A manager just received a new price list from a supplier. It will now cost $1.00 a box for order quantities of 801 or more boxes, $1.10 a box for 200 to 800 boxes, and $1.20 a box

Explain monitor and report project progress, How can the project baseline a...

How can the project baseline and the earned value approach for variance analysis be used to monitor and report project progress?

Calculate annual breakeven number of meals, The restaurant would serve dinn...

The restaurant would serve dinner Tuesday through Saturday. Brian has noticed a restaurant for lease. The restaurant has seven tables, each of which can seat four. Tables can be mo

Explain what are they and how do lenders use them, Hatten (2009) discusses ...

Hatten (2009) discusses the of credit. What are they and how do lenders use them? As you consider the possibility of being an entrepreneur, which of the 5 Cs is most important for

Manufacturing sector - operation strategy, Manufacturing Sector - Operation...

Manufacturing Sector - Operation Strategy 1. Manufacturing has become a global industry with worldwide markets and worldwide suppliers  2. Goods becoming commodity items -

Explain what is the expected value with perfect information, ABC Company, a...

ABC Company, a soft-drink vendor, has created a table of payoffs for three stocking decisions for three different states of nature: States of nature (Demand) Alternatives He

.., what steps of lacation selection?

what steps of lacation selection?

Describe confidence interval calculator, Practical Application Scenario ...

Practical Application Scenario To complete this scenario, use the Confidence Interval Calculator and the Area Gas Prices %u2013 Random Sample documents, provided in the Resource

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