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

Factors considered when recruiting salesmen, SUMIT Products Ltd. is a compa...

SUMIT Products Ltd. is a company that produces and markets steel cups, teaspoons, knives and forks for the catering industry. The company was established in 1958 in response to the

Describe swot analysis for long-term strategic planning, Prepare a SWOT ana...

Prepare a SWOT analysis for long-term strategic planning at Sigma Marketing

Describe what is the productivity, A local market research firm has just wo...

A local market research firm has just won a contract for several thousand small projects involving data gathering and statistical analysis. In the past, the firm has assigned each

Compute the composite rating-weighted average, A location analysis for Temp...

A location analysis for Temponi Controls, a small manufacturer of parts for high-technology cable systems, has been narrowed down to four locations. Temponi will need to train asse

Explain why are unions exploring new collaboration solutions, Why are union...

Why are unions exploring new collaboration solutions in the face of economic/work adversity, and how did Saturn's ambitious Quality of Work Life (QWL) program address these factors

Explain how technology can help your suggestions, Come up with 3 businesses...

Come up with 3 businesses that do not need technology to compete, and then demonstrate how technology can help your suggestions be more successful. For example - a hot dog stand. F

Explain purchasing process, Again, another point I would like to add are th...

Again, another point I would like to add are the ratings given to each game. During the purchasing process, CanGo has the ability to ask for I.D information to verify age. Sales mi

Explain demand for product is not a constraint, Which of the following is t...

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 Dema

Determine the standard time by time study, 1. Is work measurement used in y...

1. Is work measurement used in your own organisation? If not, then give thought to how: alternative methods are compared; load is balanced with capacity; productivity is monitored;

Define management practices increasing government regulation, How do you th...

How do you think management practices might change in response to increasing government regulation in the banking and health care industries?

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