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 what is the annual cost for ordering item x, Item X is a standard i...

Item X is a standard item stocked in a company's inventory of component parts. Each year the firm, on a random basis, uses about 2,500 of item X, which costs $25 each. Storage cost

PROJECT MANAGEMENT CPM/PERT CHAT, prepare CPM/PERT chat and determine the s...

prepare CPM/PERT chat and determine the shortest time this project can be completed (using crash time )

Product or service design and process selection, Product or Service Design ...

Product or Service Design and Process Selection  Can the products/services be designed to satisfy the needs of both the market and the producers/providers? For example, it may

Explain identify the basic control issues at unilever, Identify the basic c...

Identify the basic control issues at Unilever from all three levels? How do you think the control function should be organized and managed at Unilever?

Sequencing problem, what mean passing time is not allowed in sequencing pro...

what mean passing time is not allowed in sequencing problem in operation research

Define the resources over and under capacity, Define the resources over and...

Define the resources over and under capacity. The resources over and under capacity: a. Over capacity: it is also called as spare capacity resources for example, staff

Explain finite backward scheduling, A process capacity methodology that is ...

A process capacity methodology that is used to show how well parts being produced fit into a range specified by design limits is which of the following? a. Finite backward sche

Explain perform an analysis of the social, Perform an analysis of the socia...

Perform an analysis of the social / demographic, technological, economic, environmental / geographic, and political/legal / governmental segments to understand the general environm

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

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