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 conflict with the protections provided in the nlrb, The National La...

The National Labour Relations Act has been criticized as an outdated piece of legislation that is hindering, rather then helping, American cope with the realities of the new global

What are disadvantages of using single sourcing strategies, What are the di...

What are the disadvantages of using single sourcing strategies? Disadvantages of using single sourcing strategies: a. Could merely one single supplier into the industry

Explain company follow a plan of concentrated manufacturing, You are the CE...

You are the CEO of a chemical company that produces sulphuric acid, an acid that is used as an input in a wide variety of industrial products. The company has a good reputation in

Explain consumer products into brazil, What steps could a company take to a...

What steps could a company take to avoid making product design and marketing mistakes when introducing new consumer products into Brazil?

Determine whether ability and motivation is more important, Determine wheth...

Determine whether ability or motivation is more important in selecting the right person for the right job. Explain your rationale.

Explain does either couple pay a marriage tax, Jabus and Kelsey are a marri...

Jabus and Kelsey are a married couple with no children. Each earns $120,000 per year, and their combined household adjusted gross income is $240,000. Anthony and Caitlin, who are m

How to compute capacity utilization rate last of a month, 1. A manufacturin...

1. A manufacturing shop is designed to operate most efficiently at an output of 550 units per day. In the past month the plant produced 490 units. What was its capacity utilization

Describe the value chain, Question 1: Describe the main growth strategi...

Question 1: Describe the main growth strategies that a firm can pursue and discuss conditions that favour each strategic option. Support your answer with suitable examples.

Explain marketing to customers and consumers, Discuss the value of marketin...

Discuss the value of marketing to the consumer, the stakeholder and stockholder. Address the following: a. the value you place on marketing b. the value of marketing to customers a

Is true or not that demand for product is not a constraint, Which of the fo...

Which of the following is true? Once you complete the five steps, the process is complete. Another constraint will always appear when the original constraint is broken. De

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