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

Explain what decision should be made by the optimist, Company must decide h...

Company must decide how many lots of chocolate muffin premix to order for its three stores. Information on pricing, sales, and inventory costs has led to the following payoff table

What is objective function, FestiveMeadow3308 Baseballs (z1) requires 3 ...

FestiveMeadow3308 Baseballs (z1) requires 3 minutes/unit for cutting and 2 minutes/unit for glueing. Basketballs (z2) requires 2 minutes/unit for cutting and 4 minutes/unit for

Explain support of senior management, Project failure can result from all o...

Project failure can result from all of the following causes EXCEPT- A. Support of senior management B. Changes in scope are not agreed upon by all parties involved C. Too

Describe why operational efficiency is so important, Explain why operationa...

Explain why operational efficiency is so important to Net Income, Return on Capital and Income.

Explain how does national culture affect strategy, How does national cultur...

How does national culture affect strategy? To what extent do different approaches to strategy, different ways of thinking about strategy, reflect different underlying cultural assu

Explain challenges that often plague entrepreneurs, There are two "most com...

There are two "most common causes" of business failure. What are those two causes and, more importantly, how can an entrepreneur overcome these two challenges that often plague ent

Computation to receive credit, Your company has a market share of 25%. The ...

Your company has a market share of 25%. The total market size is $100 million. Your contribution margin (the ratio of the contribution per unit over the price per unit) is 20%. You

Explain total annual inventory costs, The Ambrosia Bakery makes cakes for f...

The Ambrosia Bakery makes cakes for freezing and subsequent sale. The bakery, which operates five days a week, 52 weeks a year, can produce cakes at the rate of 116 cakes per day.

Explain what different kinds of management challenges, 1. What different ki...

1. What different kinds of management challenges these four CEOs faced as they took control of managing their different companies?

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