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 why employees steal property, Discuss what you think are FOUR (4) r...

Discuss what you think are FOUR (4) reasons why employees steal property (office supplies, petty cash, cheat on travel expense reports, parts/ equipment, embezzle money) from their

Explain matching supply with demand, From "Matching Supply with Demand" Cac...

From "Matching Supply with Demand" Cachon/Terwiesch (Inventory Cost) A manufacturing company producing medical devices reported $60,000,000 in sales over the last year. At the e

Explain an increased velocity in sensing and responding, Discuss an example...

Discuss an example of an unknown-unknown risk that proved damaging to a supply chain. Explain how the following strategies might have mitigated this risk: • Investment in redund

Explain how the market value of the shares, St James Ltd. Has just paid a d...

St James Ltd. Has just paid a dividend of £0.22 per share. The market expects this dividend to grow constantly in each future year at the rate of 7% p.a. The cost of capital for St

Define a simple cpm network has five activities, A simple CPM network has f...

A simple CPM network has five activities, A, B, C, D, and E. A is an immediate predecessor of C and of D. B is also an immediate predecessor of C and of D. C and D are both immedia

Define internal vs external recruiting, Compare internal vs external recrui...

Compare internal vs external recruiting. When would you want to use each option? what are some advantages and disadvantages of each?

Describe the liability of each party, Upon graduation from college, Bob, Ca...

Upon graduation from college, Bob, Carol, Ted, and Alice formed Kotaku, LP, and a limited partnership, to distribute video gaming software over the Internet. Bob and Carol each con

., define the following key terms in product layout;product interval,produ...

define the following key terms in product layout;product interval,product duration and assembly line balancing

Factors determining production control, Factors Determining Production Cont...

Factors Determining Production Control 1. Nature of Production: In job oriented manufacturing products and operations designed for some particular order which may or may not b

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