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

Discussion, Review the week 6 info. in course material regarding the Apple ...

Review the week 6 info. in course material regarding the Apple iPhone supply chain. What issue/s do you think could be helped with a Pert/CPM plan for the supply chain? sk questi

Oprational strategies, 1.technology strategy 2.capacity strategy 3.facility...

1.technology strategy 2.capacity strategy 3.facility location strategy 4.process strategy 5.quality strategy

Explain mass customization and personalization, How can company use mass cu...

How can company use mass customization and personalization to decrease buyer power?

Explain is self-preservation a moral imperative, Is self-preservation a mor...

Is self-preservation a moral imperative or just a fact?

Explain the internal and external environments, Describe the internal and e...

Describe the internal and external environments of 2 real world companies using an environmental scan. What competitive advantages does each company have and what strategies are ea

Production planning and control - definition, Production Planning and Contr...

Production Planning and Control - Definition According to Alford  and Beatty " Production planning  and control  comprise  the planning  routing  scheduling  dispatching  an

Explain implement a back command as a single word, • Open the original proj...

• Open the original project zuul-better that you first encounter in this unit%u2019s required reading. Save it using a different name, in this format: zuul-last_name_first-initial.

Explain important part of strategic training, Why is evaluating training an...

Why is evaluating training an important part of strategic training?

Compute the schedule variance and cost performance index, A project to buil...

A project to build a new bridge seems to be going very well since the project is well ahead of schedule and costs seem to be running very low. A major milestone has been reached wh

Quality, Ques: What do you think happened to the quality, variety, availabi...

Ques: What do you think happened to the quality, variety, availability or cost of agricultural or manufactured products - or the level of competition? Ans: Quality increased; va

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