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 everything else remaining constant what will occurs, Everything els...

Everything else remaining constant, when the sample size increases, which of the following occurs? The sampling error decreases. The sampling error increases. The sampling

Column minima method, Column Minima Method: Step 1: Determine  the  ...

Column Minima Method: Step 1: Determine  the  smallest cost in  the first  column  of the  transportation  table. Let it be  C1j  . allocate  Xi1= min ( ai bi ) in the cell

Advantages of the enterprise-wide systems, Q. What are the advantages of th...

Q. What are the advantages of the enterprise-wide systems? Benefits of Enterprise-wide systems (ERP) systems: a. In this system integration of software applications can easi

Production & Purchasing Managements, Hierarchical planning in operations/Pr...

Hierarchical planning in operations/Production managemnt and the types of time frames in each hierarchy?

Focused improvement programmes - improving productivity, Focused Improvemen...

Focused Improvement Programmes - Improving Productivity Allan Lawlor (1985), Director of Action Learning Associates (ALA) suggests - based on his experiences in industry and

Describe delaying completion of the project, Using the data in Table 13-1, ...

Using the data in Table 13-1, what is the latest possible time that C may be started without delaying completion of the project? Table 13-1 The following represents a project with

Number defective - np chart, Number Defective - Np Chart This type of ...

Number Defective - Np Chart This type of chart can be used when it is possible to establish a constant sample size n. It has the advantage that it is readily understood by use

Process technology, Explain how process technology is chosen for an operati...

Explain how process technology is chosen for an operation.

Explain trial balance, Explain Trial Balance. Trial Balance : After po...

Explain Trial Balance. Trial Balance : After posting all journal entries in the ledger, a statement termed as trial balance is prepared to check the accuracy of postings in th

Explain network design is a key business decision, Network design is a key ...

Network design is a key business decision as well as a technological decision. Why? Provide an example of a company you believe has a good network design, providing supporting rati

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