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 job design be used to create a motivated workforce, How can job des...

How can job design be used to create a more motivated workforce? Be specific.

Distinguish between legal and employee rights, Q1. What is the biggest chal...

Q1. What is the biggest challenge posed by egoisn Q2. Distinguish between legal and employee rights Q3. How is strategy different from a business model? How is it similar?

Explain random system component is adequately represented, Suppose 40 obser...

Suppose 40 observations of a random system component have been recorded as shown in the table below (these numbers are sorted). 0.0345 0.1079 0.1313 0.1452 0.1788 0.2101 0.2249

Calculate the quarterly index, Over the past year, Meredith and Smunt Manuf...

Over the past year, Meredith and Smunt Manufacturing had annual sales of 10,000 portable water pumps. The average quarterly sales for the past 5 years have averaged: Spring 4,00

Explain traditionally non-user input environment, To what extent should end...

To what extent should end users be involved in the design of a database? How have our ideas of agile development environments affected this traditionally non-user input environment

Explain what amount of safety stock is appropriate, Given this information:...

Given this information: Lead-time demand = 630 pounds Standard deviation of lead time demand = 40 pounds (Assume normality.) Acceptable stockout risk during lead time = 4

Explain does either couple pay a marriage tax, Jabus and Kelsey are a marri...

Jabus and Kelsey are a married couple with no children. Each earns $120,000 per year, and their combined household adjusted gross income is $240,000. Anthony and Caitlin, who are m

What way does a t1 use to achieve high throughput, What method does a T1 us...

What method does a T1 use to achieve high throughput over twisted pair wiring? a. frequency division multiplexing b. wavelength division multiplexing c. statistical multip

Explain what is the flow time for the glove, A manufacture of women's desig...

A manufacture of women's designer gloves has employed a team of students to redesign her manufacturing unit. They gathered the following information. The manufacturing process cons

Process Planning, Process Planning In the design of processes there is...

Process Planning In the design of processes there is a certain similarity to the design of products, in that there is a hierarchy of design stages. At the top level, process

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