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

Describe the growth in the service sector, Discuss the growth in the servic...

Discuss the growth in the service sector and the decline of manufacturing in the United States

Layout: Line balancing., Layout: Line balancing Kiko Teddy Bear is a manu...

Layout: Line balancing Kiko Teddy Bear is a manufacturer of stuffed teddy bears. Kiko would like to be able to produce 40 teddy bears per hour on its assembly line. The followin

How measures are interpreted with operations management, Your project to ob...

Your project to obtain charitable donations is now 30 days into a planned 40-day project. The project is divided into three activities. The first activity is designed to solicit in

Compute productivity indices and compare rises productivity, 1. Productivit...

1. Productivity is considered by many to be the essence of operations management - suggest reasons to support this assertion.  2. Using the figures in the table, if we use 2000

Explain how are scheduling and productivity related, Scheduling techniques ...

Scheduling techniques are designed to disaggregate the master production schedule into time-phased daily or hourly activities. A detailed production schedule must include when and

Explain what is the maximum revenue with a single shift, Given the followin...

Given the following data for Albert's fabricating production area: Fixed costs for one shift = $60,000 Unit variable cost = $7 Selling price = $12 Number of machines = 5 Number of

Explain matching supply with demand by cachon/terwiesch, From "Matching Sup...

From "Matching Supply with Demand" - Cachon/Terwiesch (Highway) While driving home for the holidays, you can't seem to get Little's Law out of your mind. You note that your aver

Explain what you believe is a terrific idea for a video game, To develop wh...

To develop what you believe is a terrific idea for a video game, you lease 50,000 square feet in an office building from Commercial Property, LLC, under a written five-year lease.

Calculate percentage of the time the inspector is idle, At a border vehicle...

At a border vehicles arrive at the rate of 9 per minute in a Poisson distribution. For simplicity in this problem assume that there is only one lane and one inspector who can inspe

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