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 what is the maximized profit, Riverside Oil Company in eastern Kent...

Riverside Oil Company in eastern Kentucky produces 3 different grades of gasoline. They are regular, premium, and supreme grades. Each barrel of regular grade sells for $82 while p

Explain protected group category, To be considered lawful, a voluntary affi...

To be considered lawful, a voluntary affirmative action plan must meet all of the following criteria except: a. it must be permanent b. It must exist to eliminate past imbalances b

Define critical path, Define Critical Path. Critical Path: Computatio...

Define Critical Path. Critical Path: Computation of Earliest and Latest Values of the events of the specified network is as follows:-  Event              EOT

Explain which of the following is not a production activity, Which of the f...

Which of the following is not a production activity report generated by MRP? a. Planning report b. Exception report c. Planned-order schedules d. Performance contro

Explain what is the most that should be paid for forecast, Nick has plans t...

Nick has plans to open some pizza restaurants, but he is not sure how many to open. He has prepared a payoff table to help analyze the situation. States of Nature Alternatives Good

Give specific example of all type of strategy marketing plan, Imagine that ...

Imagine that you are creating a marketing plan for a company that will sell motor scooters . As you consider the marketing program, what types of strategy should you consider inc

Explain lower control limits for mean and range charts, Determine upper and...

Determine upper and lower control limits for mean and range charts.

Quality, Ques: What do you think happened to the quality, variety, availabi...

Ques: What do you think happened to the quality, variety, availability or cost of agricultural or manufactured products - or the level of competition? Ans: Quality increased; va

Explain modern sweatshops are a problem, 1) List the four schools of though...

1) List the four schools of thought along with the basic cause of the labour problem and solution to the labour problem for each. 2) Explore the online exhibit about the 1911 Tr

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