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

Number of rules for string diagram, There are a number of rules developed a...

There are a number of rules developed and given under three broad headings: 1. Related to the use the Human Body : a. The two hands should beings as well as complete their

supply chain, What is the primary objective of supply chain managemen

What is the primary objective of supply chain management

Explain mechanistic or organic organization, Does Mr. Goodnight want to cre...

Does Mr. Goodnight want to create more of a mechanistic or organic organization? Explain

Compare all partial factor and total factor productivity, Consider - a smal...

Consider - a small manufacturing company which produces high quality furniture has provided the following data: Compare all partial factor and total factor productivity for

Hungarian method, How is the Hungarian method applied for obtaining a solut...

How is the Hungarian method applied for obtaining a solution if the matrix is rectangular

Explain what makes the ipad a disruptive technology, 1. Evaluate the impact...

1. Evaluate the impact of the iPad using Porter's competitive forces model. 2. What makes the iPad a disruptive technology? Who are likely to be the winners and losers if the iP

Define the supply management''s heightened concern, Discuss the supply mana...

Discuss the supply management's heightened concern for future acquisition needs - for example, capital equipment acquisition, supplies contract, standard commodity, etc.

Design and management of an efficient operating system, Question 1: (a)...

Question 1: (a) Using appropriate examples, explain in details the different approaches that operations managers can use to reconcile capacity and demand. (b) Critically S

A computerised payroll package, A computerised payroll package is an exampl...

A computerised payroll package is an example of a   Data processing system

Explain how much would he receive under the incentive plan, Fulton Enterpri...

Fulton Enterprises is trying to determine standard production per day for an incentive program. Suppose that the incentive program will pay $1 per unit produced above standard rate

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