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

Examine any new products in this marketplace, Assess how technology and the...

Assess how technology and the changing demands of customers have impacted the movie rental business. Suggest a strategy for Netflix's to prevent a new entrant into the marketplace

Scope, what are the scope of operation research

what are the scope of operation research

Explain what is the average cost to produce a cake, Alyssas Custom cakes cu...

Alyssas Custom cakes currently sells 4 birthday, 1 wedding and 2 specialty cakes each month for $55, $155, and $105 each, respectively. Alyssas current multifactor productivity rat

What does mean owns real estate in fee simple absolute, If someone owns rea...

If someone owns real estate in fee simple absolute, what does that mean?

Product layout., define the following key terms in product layout; product...

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

Appropriate control limits for the data, A quality team at Milburn Textiles...

A quality team at Milburn Textiles has been charged with setting up control charts to monitor a key dyeing process that has been improved and now stable.  The ideal temperature for

Define people to try to justify conduct by the argument, How common do you ...

How common do you think it is for people to try to justify their conduct by the argument that "Everybody's doing it"?

Short-term and long-term liabilities, In addition to the car lease, Leonard...

In addition to the car lease, Leonard and Rose each have a VISA card with an interest rate of 18.25% p.a. They currently have a balance of $1,205 and made payments of $3,537 in 201

Explain interested in obtaining a measure of overall perform, Cunningham Pe...

Cunningham Performance Auto, Inc. modifies 375 autos per year. The manager, Peter Cunningham, is interested in obtaining a measure of overall performance. He has asked you to provi

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