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

Describe making better business decision, Making Better Business Decision: ...

Making Better Business Decision: Do you provide the quizzes/exams questions for this book? **You didn't answer my questions a Yes or No would have been sufficient. Please answer th

Why a small business owner consider the demographics, Why should the small ...

Why should the small business owner consider the demographics of an area when choosing a location for opening a new business? Name some sources of demographic information that are

How differentiation affect the shape of the organization, How do centraliza...

How do centralization, standardization, and horizontal differentiation affect the shape of the organization? In what ways can the informal organization and the norms and values of

Explain how the ebq change if the set-up costs is reduced, How would the EB...

How would the EBQ change if the set-up costs were reduced by 50 percent, and the holding costs were reassessed by 40 percent, taking account of the opportunity costs of capital at

Process design, Task 1 Read: Chapter 4 of the Core learning material and su...

Task 1 Read: Chapter 4 of the Core learning material and supporting text chapters on Process Design. Task 2 Investigate: Consider the operations of your own organisation (or ano

Define why it is vital to understand the impact of culture, Contrast the dy...

Contrast the dynamics between dominant cultures and subcultures either in a work setting or in society. Explain why it is important to understand the impact of culture

Explain the behaviors often incorporated by entrepreneurial, For years, Dav...

For years, David and Evie Wexler of The Little Guys Home Electronics had many ideas about how to improve the home electronics store in which they were working, but could not put th

Decreasing value a demerit of reducing project scope, Why is decreasing val...

Why is decreasing value a disadvantage of reducing project scope to accelerate a project?

What order quantity will minimize the total inventory cost, Question: Y...

Question: You are the Operations Manager at Alien University and one of your responsibility is to manage the supplies of the University. One of your supplier has given you quan

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