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

Define what would be the percentage increase in productivity, An operation ...

An operation produces 190 units per hour with a scrap rate of 10 percent. If we could eliminate the scrap completely, what would be the percentage increase in productivity per hour

Line balancing, what do you understand by line balancing?what happens if ba...

what do you understand by line balancing?what happens if balance does not exist?

Explain what are your recommendation to resolve this lawsuit, Scenario: Com...

Scenario: Commerce Clause ABC Freightways maintained its principal place of business in Arkansas. However, they provided trucking services in all states west of the Mississippi

Succession planning and workforce plan evaluation, Succession Planning and ...

Succession Planning and Workforce Plan Evaluation Develop a succession plan that addresses internal labour needs in the medium to long term, utilising succession planning princ

Explain accounting for health care organizations, What are some ways in whi...

What are some ways in which accounting for health care organizations (HCOs), especially not-for-profit (NFP) ones, tends to differ from accounting in other industries?

Define a small computer firm orders monitors for sale, A small computer fir...

A small computer firm orders monitors for sale. The annual demand is 1300 per year. The holding cost is 10 percent of the value of the monitors on hand. Each time they order it cos

Explain the liability of each party, Upon graduation from college, Bob, Car...

Upon graduation from college, Bob, Carol, Ted, and Alice formed Kotaku, LP, a limited partnership, to distribute video gaming software over the Internet. Bob and Carol each contrib

Describe the ways in which culture and technology coincide, Discuss the way...

Discuss the ways in which culture and technology coincide. Give an example from your own experience or the experience of others where culture and technology have impacted one anoth

Explain physical well-being of a manager of co-worker, All of the following...

All of the following are examples of protected opposition except: a. Threatening to file a formal complaint alleging discrimination b. Refusing to obey an order because of a reason

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