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

Layout, what are the objectives that an operation should seek in order to e...

what are the objectives that an operation should seek in order to ensure a good layout?

Explain creating diverse teams is a challenge, Creating diverse teams is a ...

Creating diverse teams is a challenge. All of the following are important steps to include in a plan for bringing diversity to a team, except: a. The organization should publicly c

Explain compensated for the loss in purchasing power, Fourteen years ago, t...

Fourteen years ago, the U.S. Aluminium Corporation borrowed $9.9 million. Since then, cumulative inflation has been 98 percent (a compound rate of approximately 5 percent per year)

Explain the two types of linear programming discussed, Linear Programming C...

Linear Programming Concept paper. Submit a Linear Programming Concept Paper about the following 1. The two types of linear programming discussed. 2. Five examples of LP appli

Flow Time, You know that our average weekly sales are $2,500 and the flow t...

You know that our average weekly sales are $2,500 and the flow time is half day. Surely with this information, you should have no problem maintaining an inventory level of $400 to

Explain inventory turnover, Baker Mfg. inc. wish to compare its inventory t...

Baker Mfg. inc. wish to compare its inventory turnover to those of industry leaders, who have turnover of about 13 times per year and 8% of their assets invested in inventory. 1. B

Describe henry did tax work for joe electrician, Henry did tax work for Joe...

Henry did tax work for Joe electrician. Bill was $900, Hnery reduced it to $600. Joe did wrok for Henry at cost of $700. Henry gave Joe a check for $400, said remaining $300 was th

How conduct an analysis of american apparel, Conduct an analysis of America...

Conduct an analysis of American Apparel. Assess American Apparel's vertical integration, global strategy, and diversification. Compare American Apparel's approach to Google's

Least cost methods, At any stage if there is a tie in the minimum cost so t...

At any stage if there is a tie in the minimum cost so that two or more routes have the same least cost of transportation then conceptually either of them may be selected. However a

Explain what does the term product positioning refer to, What does the term...

What does the term product positioning refer to? A careful analysis of cross tabulations Shelf locations in major chain, grocery, and department stores Geographic segmenta

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