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

Sequencing.., program to find optimal sequence, total elapsed time and tota...

program to find optimal sequence, total elapsed time and total idle time in 6 jobs and 3 machines

Use of confidence interval calculator and the area gas, To complete this sc...

To complete this scenario, use the Confidence Interval Calculator and the Area Gas Prices %u2013 Random Sample documents, provided in the Resources. The Minneapolis Star Tribune

Explain companies choose not to tie resources to their job, Some companies ...

Some companies choose not to tie resources to their projects. In what ways does this benefit a project? In what ways does this hinder a project?

Explain advantages of budgets, Explain advantages of budgets. Advantag...

Explain advantages of budgets. Advantages of Budgets: (i) Actions plans and policy taken are all reflected into the budgetary control system. Now here is a formal recognit

Explain particulates and ph balance, Please give a detailed explanation for...

Please give a detailed explanation for the answer for the following scenario: You are a division manager of a manufacturing facility that produces waste? Water that must be treated

Advocacy of a focused factory - operations strategy, 1. Explain the quandar...

1. Explain the quandary experienced by Skinner (1969,1974) and his advocacy of a 'focused factory'. Answer: Skinner argued that the trade-off concept is based on the quandary th

Explain what is a serial entrepreneur, 1. What is a serial entrepreneur? Is...

1. What is a serial entrepreneur? Is this a new phenomenon? 2. What does it take to be a successful serial entrepreneur? 3. Steve Chen, former PayPal engineer who co-founded

Explain trench coat and improve profitability, 1. How did the overall consu...

1. How did the overall consumer behaviour of Burberry customers change from 2006 to 2010. 2. What measures did Burberry take to improve sales of Burberry merchandise, especially th

Explain collective bargaining, Explain collective bargaining Collectiv...

Explain collective bargaining Collective Bargaining : Collective Bargaining constitutes the negotiations among the management and the union with the final objective of agreein

Process flow and layouts, process flow and layout flows are at the core of ...

process flow and layout flows are at the core of lean manufacturing, do you agree or disagree?

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