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

How conduct an analysis of american apparel, Conduct an analysis of America...

Conduct an analysis of American Apparel. Assess American Apparel's vertical integration, global strategy, and diversification. Compare American Apparel's approach to Google's

What are some merits of a pay-for-knowledge pay system, What are some advan...

What are some advantages of a pay-for-knowledge pay system?

Explain what happens to the leased property, Ann leases an office in Ted's ...

Ann leases an office in Ted's building for a one-year term. At the end of the period specified in the lease, the lease ends without notice, and possession of the office returns to

How supply chain change works, An online retailer of a single product has f...

An online retailer of a single product has four major markets in the four "corners" (North-East, South-East, North-West and South-West) of a country. Assume that daily demand in ea

Number of defects - control chart, Number of Defects - Control Chart S...

Number of Defects - Control Chart Sometimes the attribute of concern is the number of defects (c) in an item rather than the number of defective items in a sample: for example

Explain the probable destiny competing products, Consider this: Lee Peterso...

Consider this: Lee Peterson has invented a new product that detects water leaks due to broken pipes and sends out an alarm similar to a smoke alarm. However, Lee has very little pe

Explain use debt financing, If you decide to use debt financing, which kind...

If you decide to use debt financing, which kind of loan, fixed-rate or variable-rate, would you prefer? Why? If you decide to use equity financing, where would you find equity f

Explain approaches that project managers, Project managers frequently face ...

Project managers frequently face competing constraints. Identify these common constraints and describe approaches that project managers can use to make the trade-offs required to s

Who was the founder of scientific management, Who was the founder of Scient...

Who was the founder of Scientific Management? Ans: The founder of Scientific Management is F.W. Taylor.

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