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 supply base innovation and risk management, Why are supply base inn...

Why are supply base innovation and risk management two future areas that will consume more of the supply manager's day?

Define desired lot size, A firm that operates 300 days in a year and uses a...

A firm that operates 300 days in a year and uses a level material usage approach has collected the following data: Annual Demand = 30,000; Daily Demand = 100; Daily production= 300

Explain enable them to limit the probability of a stockout, A wine company'...

A wine company's daily demand is normally distributed with a mean of 18 bottles, and a standard deviation of 4 bottles. This company checks their winery's stock every 30 days. In t

What is average costumer waits time in line, A newly opened car wash statio...

A newly opened car wash station has a car wash machine. The machine washes each car in a constant rate of 5 minutes per car. It has been estimated that costumers will arrive accord

Monthly forecast for landing gear assemblies, 1) Rocco wants to prepare the...

1) Rocco wants to prepare the sales forecast for the next 24 months today. His company produces heavy-duty on/off timers used by large Christmas light displays and above ground swi

Explain the risk evaluation process, Discuss and describe the risk evaluati...

Discuss and describe the risk evaluation process in a simplified approach.

Process Design, Discuss how the five Operational Performance Objectives may...

Discuss how the five Operational Performance Objectives may influence decision-making associated with process design and layouts.

Explain inventory management technology, Costco is able to keep its invento...

Costco is able to keep its inventory expenditure relatively low through its management technology and cutting-edge point-of-sale inventory management technology. As a result, Costc

Explain authorities under the industrial disputes act, Explain the authorit...

Explain the authorities under the Industrial Disputes Act, 1947. Ans: One of the authorities under the Industrial Disputes Act, 1947 for investigation and settlement of indu

Explain what if anything should their supervisor do, Two employees speak Sp...

Two employees speak Spanish to each other at work. Because they often giggle or laugh, some of their co-workers and a few patients think that they are being made fun of, and they d

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