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

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

Explain capacity is the maximum rate of output of a process, 1. Capacity is...

1. Capacity is the maximum rate of output of a process. 2. Capacity decisions should be made separate from strategic decisions. 3. Capacity can be expressed by output or inpu

Explain selling verses marketing concept, Explain Selling Vs Marketing Conc...

Explain Selling Vs Marketing Concept. Selling Vs Marketing Concept : The concept of selling is a management orientation which assumes that consumers will normally not buy suff

Process technology life cycle , Process Technology Life Cycle Process ...

Process Technology Life Cycle Process technologies have life cycles related to product life cycles as shown in figure below. Over time unit manufacturing costs diminish for ma

What is network perspectives in innovative research, What are the different...

What are the different network perspectives in innovative research? Why do authors differ in how they define innovation networks? How can networks influence actions of its members?

Find the total cost of ordering and carrying semiprecious, 1. A jewelry fir...

1. A jewelry firm buys semiprecious stones to make bracelets and rings. The supplier charges $20 per stone, annual carrying costs are 50%, and the cost of processing orders is $40.

Define part-time employees fall within artistic and creative, 1. Grapple In...

1. Grapple Industries has 1,000 full-time and part-time employees who manufacture parts for hand tools. Company policy states that part-time employees are not eligible for overtime

Upper and lower control limits, Clerks at Lotsa Data Systems key in thousan...

Clerks at Lotsa Data Systems key in thousands of insurance records each day for a variety of client firms.  The process is in control but CEO Donna Lotsa wants to be sure that at

Describe the response of the organization, The issue of fraud must be consi...

The issue of fraud must be considered when managing risk as it could present a major liability to the organization. Fraud is an act that requires an aggressive response and correct

Nash equilibrium levels, 2 enterprises (1 and 2), are in competition with e...

2 enterprises (1 and 2), are in competition with each other by choosing advertising expenditures. The payoff functions of the two enterprises, if enterprise 1 chooses to spend x an

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