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

Forward scheduling - scheduling techniques, Forward Scheduling - Scheduling...

Forward Scheduling - Scheduling Techniques Forward scheduling means assigning customers orders or job to various work centers based on the as early as possible approach. Thus

Define the break-even point for each range, A manager must decide how many ...

A manager must decide how many machines of a certain type to purchase. Each machine can process 100 customers per day. One machine will result in a fixed cost of $2000 per day, whi

Explain what protocols should be considered, What protocols, if any, should...

What protocols, if any, should be considered in this needs assessment?

Which amendment has had the most impact throughout history, What are the fa...

What are the facts of the case? What is the key constitutional issue presented? Do you agree or disagree with Angel Raich's postion? Review the amendments to the U.S. Constituti

Operation Management and POM QM sums , The assignment consists of 3 exercis...

The assignment consists of 3 exercises, and the marks for each question varies. Printouts provided with the prose solutions and explanation of the POM-QM solutions must be original

Explain what is your assessment of the health of the project, On day 51, a ...

On day 51, a project has an earned value of $600, an actual cost of $650, and a planned cost of $560. Compute the SV, CV, and CPI for the project. What is your assessment of the he

Define what is divine command theory, What is Divine Command theory? Given ...

What is Divine Command theory? Given the power gap between God and humanity how do we make the moral demands work? How do we make Divine command theory work?

Define what kind of industries does a localization strategy, What kind of i...

What kind of industries does a localization strategy makes sense? Why? When does a global standardization strategy make most sense? Why?

Logistics., explain the role of product characteristics on the logistics de...

explain the role of product characteristics on the logistics decision

Find how much does the airport need to set aside now to pay, Orlando Intern...

Orlando International Airport plans to extend passenger capacity of its existing terminal to accommodate its forecasted growth. A new terminal would be needed once the state's busi

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