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 a wealthy farmer owns fifty acres of land, A wealthy farmer owns fi...

A wealthy farmer owns fifty acres of land. He is going to plant each acre with sugarcane or corn. Each acre planted with sugarcane yields Rs 16,000 profit; each with corn yields Rs

Explain when quality discounts are introduced, When quality discounts are i...

When quality discounts are introduced, will optimum order quantity be made smaller, unchanged, or larger? Illustrate by using a numerical example.

Explain retailer franchise system, What is a franchise organization? Is Vic...

What is a franchise organization? Is Victorias Secret A franchise, if so what kind? If not should it be?? 3 types of franchises: 1. manufacturer-sponsored retailer franchise system

Explain what prompted the change effort at the irs, What prompted the chang...

What prompted the change effort at the IRS, and what was targeted to change? Why was the proposed change controversial?

Explain making and marketing the new product, Mary Williams, owner of Willi...

Mary Williams, owner of Williams Products, is evaluating whether to introduce a new product line. After thinking through the production process and the costs of raw materials and n

Explain personality traits affect management and leadership, Your managemen...

Your management team has been retained by a senior manager who is concerned about the effectiveness of his managers and their leadership abilities. He would like you to develop a t

Forecasting, what are the different steps in quantitative forecasting in ma...

what are the different steps in quantitative forecasting in manufacturing

How a company is most efficient in its use of credit, Step 1: Pick an indus...

Step 1: Pick an industry that you find interesting. This may be driven by a company by which you would like to be employed or by some other factor. Within the industry, identify th

Explain changing the manufacturing process, Your company makes baby seats f...

Your company makes baby seats for cars and RVs. Your main product was designed some time ago, and new and better engineering data are available, but your product has a good record

Resources planning and execution., Explain why it is important to carry out...

Explain why it is important to carry out a rough-cut capacity planning check on critical resources before proceeding with the development of the final master production schedule

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