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

A trial balance discloses how many types of errors, A Trial Balance disclos...

A Trial Balance discloses how many types of errors? A Trial Balance discloses errors that are given below:   i)    An item posted double.   ii)   A mistake into posting.

Determine the overall project completion time, Question : (a) Under wha...

Question : (a) Under what conditions is PERT preferred to CPM in project management ? Illustrate your answer with examples of projects. (b) Several stages are involved in

Imagine which you just made manufacturing changes, Imagine that you just ma...

Imagine that you just made manufacturing changes to your product so it is now easily recyclable. How would you publicize these changes?

Explain several ways that companies learn from their mistake, What perceptu...

What perceptual problems do managers need to overcome with failures? How can these perceptual problems be minimized? 2. Describe the experiential learning process that companies, m

Explain responsibility towards importers and exporters, The U.S. State Depa...

The U.S. State Department has some responsibility towards Importers and Exporters. What are these responsibilities?

Explain terms national economy and manufacturing sector, As a library or in...

As a library or internet assignment, find the U.S. productivity rate (increase) last year for (a) national economy, (b) manufacturing sector, and (c) service sector.

Explain what are personality traits, 1. What are personality traits? Define...

1. What are personality traits? Define and discuss the Big Five personality traits. Define and discuss other personality traits that affect managerial behaviour. 2. Explain Rike

Explain exceed the amount invested in auto loans, A bank is attempting to d...

A bank is attempting to determine where its assets should be invested during the current year. At present, $500,000 is available for investment in bonds, home loans, auto loans, an

Explain the decision-making view, Describe the decision-making view and the...

Describe the decision-making view and the process view of operations management. Why are both views useful in studying the field of operations management?

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