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

Qualitative and quantitative justification, 1.  Maggie Company produces a l...

1.  Maggie Company produces a light fixture with the following unit costs:   Direct Materials: $2 Direct Labour: $2 Variable Cost: $3 Fixed Cost: $2 UNIT TOTAL COST: $9   The

Compute the appropriate loan table, You just took a $20,000, eight-year loa...

You just took a $20,000, eight-year loan. Payments at the end of each year are flat (equal in every year) at an interest rate of 8 percent. Calculate the appropriate loan table, sh

Kanban scheduling system for lean and just in time, Kanban Scheduling Syste...

Kanban Scheduling System for Lean and Just in Time The ideal lot size is one - how many can we work on at one time? - usually one. Even in batch production, only one item in t

What are disadvantages of using single sourcing strategies, What are the di...

What are the disadvantages of using single sourcing strategies? Disadvantages of using single sourcing strategies: a. Could merely one single supplier into the industry

Platts and gregory approach - operation management, Platts and Gregory Appr...

Platts and Gregory Approach - Operation Management The Platts and Gregory approach has three steps and is based on the approach of comparing what the market wants with how the

Explain assess the importance of slack, Assess the importance of "slack" to...

Assess the importance of "slack" to the project manager

Define what is the sample value of the test statistic, 1. The average laten...

1. The average lateness for one of the top airline companies is 10 minutes. The Standard Deviation of the lateness measure is calculated as 3. An airplane arrived 8.5 minutes after

Advantages of work measurement, Advantages of Work Measurement: 1.    ...

Advantages of Work Measurement: 1.        It serves as a basis  for  methods  analysis by comparing  the efficiency  of alternative  work  method. Other  conditions  beings  t

Define what is a principle within a health care organization, What is a pri...

What is a principle within a health care organization?

How library to research and analyze markets and competitors, E-commerce is ...

E-commerce is the trend that most companies are going toward now a days. You are to select one business that does not already employ e-commerce and develop an Internet strategy for

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