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 sample means and sample ranges have been computed, Checkout time at...

Checkout time at a supermarket is monitored using a range and mean chart. Six samples which contain 20 observations per sample have been collected and the sample means and sample r

Explain what charles schwab & pfizer works, Read the Ask Chuck & a New Kind...

Read the Ask Chuck & a New Kind of Structure Case Applications on pages 283 & 284. Describe what Charles Schwab & Pfizer Works are doing. Discuss what role organizational structure

Explain manufacturing sector and service sector, As a library or Internet a...

As a library or Internet assignment, find the US productivity rate (increase) last year for the (a) national economy, (b) manufacturing sector, and (c) service sector. Where can yo

She is liable then provide and explanation of the amount., Brittany current...

Brittany currently attends college and runs her new business, Pampered Pets, a sole proprietorship she created in her sophomore year. Since Brittany is a student, she does not have

Explain where will the bottleneck in the system be, The process for renewin...

The process for renewing a driver's license at the Archer County Courthouse is as follows. First, the clerk fills out the application; then the clerk takes the driver's picture; an

Explain improving operations, What would you recommend to the company if th...

What would you recommend to the company if they asked you to advise them in improving their operations?

How a factory can produce high-quality products, Can a factory be fast, dep...

Can a factory be fast, dependable, flexible, produce high-quality products, and still provide poor service from a customer's perspective?

Depict the project network using aon, Task time estimates for a production ...

Task time estimates for a production line setup project at Robert Klassens Ontario factory are as follows: Activity Time (in hours) Immediate Predecessors A 6.0 B 7.2 C 5.0 A D 6.0

Which is considered part of a companys intellectual property, 1. When a com...

1. When a company plans a new product development project, which department should impact the decisions? (Points : 5) Sales and Marketing Engineering Manufacturing Fina

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