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

Find average time agent work for a call center, A call center employs 1,000...

A call center employs 1,000 agents. Every month 50 employees leave the company and 50 new employees are hired. How long does the average agent work for this call center?

Capacity planning, why is capacity planning important in production and op...

why is capacity planning important in production and operations management?

Explain lincoln electric and southwest airlines, Compare and contrast Linco...

Compare and contrast Lincoln Electric and Southwest Airlines with regard to the following • Views of management regarding union representatives of their workers. •

Explain small proportion of unionized employees, Why would it be harder for...

Why would it be harder for heavily unionized organizations to settle on their bargaining targets than for those with a small proportion of unionized employees?

Long term capacity reduction, Long term Capacity Reduction Capacity pl...

Long term Capacity Reduction Capacity planning does not necessarily mean the expansion of the capacity. It may also mean reduction of the capacity which may be done in the fol

Internal business perspective - performance and productivity, Internal Busi...

Internal Business Perspective - Performance Measures Although customer based measures are important, they must be translated into internal performance measures that can be ach

Explain personal and professional lives, How can you see the integration an...

How can you see the integration and the modern management theory integrated into your own personal and professional lives? Pick only one theory for there are hundreds

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