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

Computer simulation used to evaluate capacity, Computer simulation Used to ...

Computer simulation Used to Evaluate Capacity In many systems, proper scheduling of the conveners ion can lead to better use of existing capacity. Sometimes a careful analysis r

Total operation system, critically discuss the total operation system, poli...

critically discuss the total operation system, policies and practices of an organization

Explain product or a service, At what point does acceptable exaggeration be...

At what point does acceptable exaggeration become lying about a product or a service?

The owners it person has alerted him to several problems, The graphic desig...

The graphic design shop where you work as the Account Manager is doing well. Just last year, the owner hired three new designers and a receptionist, bringing the total number of em

Operations function - transformation processes and planning, Operations Fun...

Operations Function - Transformation Processes and Planning The operations function is concerned with the design of transformation processes, planning their use, and organisin

Process layout - process design, Process Layout - Process Design This ...

Process Layout - Process Design This form of layout is used when there is no dominant flow pattern, and is particularly appropriate for job shop and small-batch operations. Th

Describe the terms entity and relationship, Explain the terms entity, relat...

Explain the terms entity, relationship, and attributes. Describe how they are used in a database.

Formulation of a service operations strategy, 1. What issues are raised by ...

1. What issues are raised by this case in relation to the formulation of a service operations strategy? Answer: This example raises interesting questions relating to service str

Explain fundamental purpose of supply chain design, 1. The purpose of suppl...

1. The purpose of supply chain management is to synchronize a firms processes with those of its suppliers and customers. 2. Supply chain management tries to match the flow of ma

After working for 30 years, After working for 30 years, Ramjee Somjee Dutt ...

After working for 30 years, Ramjee Somjee Dutt opted for VRS and started a courier company and did

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