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

PROJECT MANAGEMENT CPM/PERT CHAT, prepare CPM/PERT chat and determine the s...

prepare CPM/PERT chat and determine the shortest time this project can be completed (using crash time )

Disadvantages, What are the disadvantages of operation management?

What are the disadvantages of operation management?

What must an organization do to prepare for such a risk, Product contaminat...

Product contamination is a catastrophic event, both for the organization at fault and for the victims. Cases of product contamination frequently make the news. Find an example o

Explain should health care workers receive the flu vaccine, Should health c...

Should health care workers receive the flu vaccine? I f not why not?

Explain intangible assets and human capital, Companies are now more and mor...

Companies are now more and more interested in using intangible assets and human capital as a way to gain an advantage over competitors. True False

Explain counteract prejudice, Counteracting Prejudice One of the simplest a...

Counteracting Prejudice One of the simplest and most powerful ways to counteract prejudice and discrimination is to articulate and share stereotypes and preconceived notions. How c

Define factors that need to be considered in media selection, There are thr...

There are three factors that need to be considered in media selection and budgeting. These include A) Audience reach, availability of the product, no competition B) Audience

Develop an aggregate plan for helter industires, Helter Industires, a compa...

Helter Industires, a company that produces a line of women's bathing suits, hires temporaries to help produce its summer product demand. For the current four-month rolling schedule

Explain formulate and solve a linear optimization model, Klein Industries m...

Klein Industries manufactures three air compressors: small, medium, and large, which have unit profits of $20.50, $34, and $42 respectively. The monthly projected sales of small ar

Explain what are the legal and ethical risks, What are the legal and ethica...

What are the legal and ethical risks associated with the decision about hiring truck drivers at Zyedego

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