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

Functions of product development team, How is anticipating a material requi...

How is anticipating a material requirement or need through purchasing's involvement on a new-product development team different from reacting to a purchase need?

Explain what suggestions for improvement, You are the contracting officer's...

You are the contracting officer's representative (COR) of a program management support contract awarded to Easy Corp. It is the first year of a five-year contract. You have noti

Forecasting adn Time Series Anlaysis, To answer Question 1: Use the forecas...

To answer Question 1: Use the forecasting module that you opened in the POM-QM for Windows software to solve the Southwestern University case study at the end of Chapter 4 of the H

Explain reflecting back on our readings about entrepreneursh, Reflecting ba...

Reflecting back on our readings about entrepreneurship in, would you consider someone who buys a franchise to be an entrepreneur?

Explain work in an information technology department, You are talking with ...

You are talking with another MIS 200student who is complaining about having to learn about the information systems development life -cycle (SDLC- Chapter 6), because he is not goin

Explain travel from the workstations to the main aisle, A portable lunch wa...

A portable lunch wagon is to be located along the main aisle of an industrial plant. The vendor wishes to locate the wagon so that the total walking distance for his customers is m

Explain minimize make span in a two machine flow shop, Please explain your ...

Please explain your answer- Johnson's rule gives the optimal answer for which of the following type of problems? A) Minimize make span in a two machine flow shop B) Minimi

Explain the linear program, The linear program MAX 3A+4B St. -1A + 2b ? ...

The linear program MAX 3A+4B St. -1A + 2b ? 8 1A+2B ? 12 2A+1B ? 16 A,B ? 0 1-write this problem in the standard form ? 2-Solve the problem using the graphical solution proced

Explain gear box sub-assembly, Production and management Brunswick, read an...

Production and management Brunswick, read an article on time-phased requirements planning. He was curious about how this technique might work in scheduling Brunswick's engine assem

Define the strategies that you might use in addressing goals, Develop a str...

Develop a strong talent management program globally to develop and retain talent that you have been losing to competitors and downsizing. Discuss the strategies that you might use

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