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

Characteristics of continuous or flow production, Characteristics of Contin...

Characteristics of Continuous or Flow Production Flow of Material: The flow of materials is continuous and there is little or no queuing at any stage of processing. Mac

Explain importance of strategic management, In light of the various theorie...

In light of the various theories of Strategic Management and Competition touched on in this course (e.g., the Resource Model of the Firm, internal/external analysis, SWOT, Value Ch

Explain what contract type puts more risk on the buyer, What are the differ...

What are the different types of contracts and how do they impact risk? What contract type puts more risk on the buyer? What contract type puts more risk on the seller?

How investment to double, To the closest year, how long will it take a $200...

To the closest year, how long will it take a $200 investment to double if it earns 7 percent interest? How long will it take if it earns 18 percent?

Explain it is important that lean six sigma efforts, It is important that L...

It is important that Lean Six Sigma efforts be linked specifically to strategic goals of the organization.

Explain planning is the fundamental management function, 1. Planning is the...

1. Planning is the fundamental management function. Discuss how organizing and planning are related. 2. Using two examples, describe the different approaches used by companies/m

Explain best decision based on an expected monetary value, The product desi...

The product design group of Flores Electrick Supplies, Inc., has determined that it needs to design a new series of switches. It must decide on one of three design strategies. The

Explain how is the search industry changing, How is the search industry cha...

How is the search industry changing? What forces seem most likely to bring about major change to the industry within the next three to five years?

Compute deposit at the end of each year, On the day his son was born, a fat...

On the day his son was born, a father decided to establish a fund for his son's college education. The father wants the son to be able to withdraw $4000 from the fund on his 18th b

What needed to accurately predict capacity, 1) A process oriented layout wi...

1) A process oriented layout will minimize the total time spent on setting up machines? 2) By increasing the capacity of an operation you improve its efficiency. 3) Standard

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