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

Explain three process steps performed by three machines, Consider the follo...

Consider the following batch-flow process consisting of three process steps performed by three machines: STEP 1 Processing Time: 0.25 Min/Part Processing Time: 0.20 Min/Part Pro

Describe how the uniform commercial code, Explain how the Uniform Commercia...

Explain how the Uniform Commercial Code treats goods that were fraudulently obtained.estion here

Explain the logistics has such an important economic impact, Why or why not...

Why or why not the logistics has such an important economic impact

Explain mbo to improve the innovation process at gsli, Do you believe that ...

Do you believe that MBO is appropriate for an organization where the primary output is innovation? If not why not? If so, how would you apply MBO to improve the innovation process

Sceduling for the short term, what are the advantage to finite capacity sch...

what are the advantage to finite capacity scheduling ?

How maximize total advertising revenue, A local television station plans to...

A local television station plans to drop four Friday evening programs at the end of the season. Steve Botuchis, the station manager, developed a list of six potential replacement p

What are the terminal course objectives, Class, looking back over the Termi...

Class, looking back over the Terminal Course Objectives for this course, what are you looking forward to learning more about throughout your education and career?

Explain smucker''s has multiple product lines, Smucker's has multiple produ...

Smucker's has multiple product lines. Explain how well they fit with each other. Please give sources.

Explain the features of six sigma, Question 1: Explain the features o...

Question 1: Explain the features of Six Sigma. • shifts the paradigm quality as the cause of good business performance • The philosophy is to make fewer mistakes. • Is a

Explain what is the present value of the following annuities, What is the p...

What is the present value of the following annuities? a. $2,500 a year for 10 years discounted back to the present at 7% b. $70 a year for 3 years discounted back to the pres

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