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

Calculate first''s rop with legal firms in san francisco, First printing ha...

First printing has contracts with legal firms in San Francisco to copy their court documents. Daily demand is almost constant at 12,500 pages of documents. The lead time for paper

Define the local convenience store makes personal pan pizzas, The local con...

The local convenience store makes personal pan pizzas. Currently, their process makes complete pizzas, fully cooked, for the customer. This process has a fixed cost of $20,000, and

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 approach the technology issues facing the company, As the advisor t...

As the advisor to Keyes what offensive or defensive strategic options would you recommend for blockbuster as the company moves forward? In particular, how would you approach the te

Explain employees effectively execute the strategy, Select a company that y...

Select a company that you believe uses its employees to achieve a competitive advantage. Discuss how the employees effectively execute the strategy and how the company can sustain

What is matrix organisation, What is Matrix organisation? Ans: A Mat...

What is Matrix organisation? Ans: A Matrix organisation is a combination of Project and functional organisation.

Explain enable them to limit the probability of a stockout, A wine company'...

A wine company's daily demand is normally distributed with a mean of 18 bottles, and a standard deviation of 4 bottles. This company checks their winery's stock every 30 days. In t

What are the benefits of an erp system, 1. Does the JIT philosophy incorpor...

1. Does the JIT philosophy incorporate the calculation of EOQ?  2. What is the difference between MRP and ERP?  3. Why would a company implement an MRP system?  4. What ar

Logical process modelling, What is logical process modelling? What is physi...

What is logical process modelling? What is physical modelling?

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