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

Poms-Exercise 01 Decision Tree for Capacity Planning, Ask Poms-Exercise 01 ...

Ask Poms-Exercise 01 Decision Tree for Capacity Planning Expando, Inc. is considering the possibility of building an additional factory that wouldproduce a new addition to its prod

Explain customization in manufacturing or services, Evaluate the statement:...

Evaluate the statement: "Special-purpose technology is a common way of offering increased customization in manufacturing or services without taking on additional labour costs." Cit

Explain best leverage the federal registers website, Analyze the ways in wh...

Analyze the ways in which managers could use the Federal Register to determine the single most significant challenge associated with its use, and how managers could address that ch

Logistics, Ask question #Minimum 100 words acceptedTopic 2: Logistics Logi...

Ask question #Minimum 100 words acceptedTopic 2: Logistics Logistics is the management of the flow of goods, information and other resources, including energy and people, between

Explain production system, If all you knew about a production system was th...

If all you knew about a production system was that total daily output was 400 units and the total labour necessary to produce the 400 units was 350 hours, what kind of productivity

Find the shipping costs for company a to ship one unit, Company A has four ...

Company A has four plants locating in different cities across the region. There are three markets the company is selling its products to. Currently, each plant can only produce 500

Explain implied warranties of merchantability, The UCC includes both implie...

The UCC includes both implied warranties of merchantability, warranties of fitness, and product liability. Some of these warranties protect the customer from defective products and

Trade off between delivery and flexibility, Trade off Between Delivery and ...

Trade off Between Delivery and Flexibility Pagell et al (2000) argue that the trade-off concept is based on Skinner's quandary that a manufacturing plant could not be configur

Define what is divine command theory, What is Divine Command theory? Given ...

What is Divine Command theory? Given the power gap between God and humanity how do we make the moral demands work? How do we make Divine command theory work?

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