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

What is eoq and optimum time between orders, An industrial machine tools ma...

An industrial machine tools manufacturer supplies replacement parts from its inventory. For a particular part, the annual demand is expected to be 750 units. Machine setup costs ar

Explain the network is overloaded, Information asymmetry exists when - T...

Information asymmetry exists when - The network is overloaded - Sellers and buyers have the same information - One party in a transaction had more important information th

Impact of internet on new product development, Question 1: Illustrate t...

Question 1: Illustrate the different types of stores layout Free-Flow Layout Grid Layout Loop Layout Spine Layout Question 2: Describe the ingredient

Explain how these factors would affect the management, There are a number o...

There are a number of factors that affect the expansion of a multinational firm, including macroeconomic, political, regulatory, cultural, and social. Choose one multinational orga

Depict a project network that includes all the activities, Operations and S...

Operations and Supply Chain Management : CELL PHONE DESIGN PROJECT 1. Draw a project network that includes all the activities 2. Calculate the start and finish times for each

Describe at least four basic factors, In operations management, as in life,...

In operations management, as in life, a balanced approach is often the best policy. One of the best examples of the benefits of this in operations management is the "lean approach"

Find the optimum economic production quantity, A manufacturing company sell...

A manufacturing company sells its products directly to customers and operates 5 days a week, 52 weeks a year. The production department of this company can produce at the rate of 6

Explain how can she be sure of her judgment, How can she be sure of her jud...

How can she be sure of her judgment? • How can she convince the marketers? • How should she act in this situation?

Explain developing or enhancing their organization, There are several diffe...

There are several different models of business development that entrepreneurs can utilize when developing or enhancing their organization. Research on stages of business developmen

Explain environment that best serves the organization, Briargrove is taking...

Briargrove is taking proposals for a Centralized Learning Network to be rolled out first in the corporate office in Dallas, TX and then across the organizational footprint. A priva

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