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

Operation Management and POM QM sums , The assignment consists of 3 exercis...

The assignment consists of 3 exercises, and the marks for each question varies. Printouts provided with the prose solutions and explanation of the POM-QM solutions must be original

Explain elements necessary for the formation of a business, What are the th...

What are the three elements necessary for the formation of a business contract? What are the six defences to formation of a contract? Illustrate your definitions with examples of e

Explain what changes should be made in the wage, A father decides to put hi...

A father decides to put his two sons to work landscaping. The business involved going to a customer's home and providing landscaping services (cut gras, edge sidewalk, pull weeds i

Explain your personal professional strategy as globalization, What is your ...

What is your personal professional strategy to remain competitive in this environment as globalization increases?

Explain total quality improvement organizational downsizing, Analyze how ea...

Analyze how each has changed healthcare delivery on both the macro and micro levels. Provide specific examples of how both macro and micro impacts/changes: Total quality improvemen

Product layout - connected flow, Product Layout - Connected Flow Where...

Product Layout - Connected Flow Where the demand for a single product is sufficiently high to warrant truly continuous operation (mass production for discrete items such as, c

Plant layout, Outline the considerations for choice of location and the cri...

Outline the considerations for choice of location and the criteria for good layout?

Explain did intel use monopoly-like power, In your judgment is Intel a "mon...

In your judgment is Intel a "monopoly"? Did Intel use monopoly-like power; in other words, did Intel achieve its objectives by relying on power that it had due to its control of a

Explain what if anything should their supervisor do, Two employees speak Sp...

Two employees speak Spanish to each other at work. Because they often giggle or laugh, some of their co-workers and a few patients think that they are being made fun of, and they d

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