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

What is operations management, Q: What is operations management?  A: Ope...

Q: What is operations management?  A: Operations management is the planning, organising and control of systems which produce goods and services. It is one of the most important

Explain analysis in determining project risk, Evaluate the use of statistic...

Evaluate the use of statistical analysis in determining project risk and how it might be applied to the human factors of a project

How many stamping machines are required, Bloomsday Outfitters produces T-sh...

Bloomsday Outfitters produces T-shirts for road races. They need to acquire some new stamping machines to produce 30,000 good T-shirts per month. Their plant operates 200 hours per

Game theory, Consider the following parlor game to be played between two pl...

Consider the following parlor game to be played between two players. Each player begins with three chips: one red, one white, and one blue. Each chip can be used only once. To beg

Operations scheduling in job shop type production, Operations Scheduling in...

Operations Scheduling in job shop type production Operations scheduling is the organizing function of an operations manager. This function of the operation manager is most impor

Explain deprivation of food, Which of the following independent variables a...

Which of the following independent variables are appropriate for a quasi-experimental design and why? 1. Blood type, 2. Reading group, 3. Level of abuse, 4. Math strategy, 5. Depri

Explain b2b marketing, Is B2B marketing really any different than B2C marke...

Is B2B marketing really any different than B2C marketing? Many believe that B2B marketing may actually be much more manageable than B2C marketing. How do you feel about that percep

Explain revealed its batna, During a negotiation, the union proposes a 25 c...

During a negotiation, the union proposes a 25 cent per hour wage increase across the board. Management says it cannot afford that. Management has just: A. Reached an impasse B. Est

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