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 observable cultural forms, Think of an organization with which you ...

Think of an organization with which you are personally familiar (best), or of which you are aware through word of mouth or reading. Identify one underlying value, belief, or assump

Explain development of a strategic plan, What are the primary external orga...

What are the primary external organizational considerations for the development of a strategic plan? Which consideration is the most important? Why?

Transportation and assignment problem, Transportation and Assignment Proble...

Transportation and Assignment Problem: Transportation  problem is the  problem of determining the minimum  cost for  allocating a product from  several supply sources to sever

Compute the standard time for each work, The Arkade Company has decided to ...

The Arkade Company has decided to use a 15 percent allowance factor based on job time. Calculate the standard time for each work element and for the total job. The frequency equals

What is a quality management system, Question: (a) What is a Quality Ma...

Question: (a) What is a Quality Management System (QMS) and why should an organization implement a Quality Management System? (b) Explain the eight fundamental Quality Manag

South African activists promise massive protest at World Cup, identify the ...

identify the material requirement lacking and its cause

Statistical aspects of variability, Statistical Aspects of Variability  ...

Statistical Aspects of Variability  Consider a pharmaceutical process producing paracetamol tablets, for which the weight of the active ingredient (nominally 500 mg per tablet

Product focused production system, Product Focused Production System ...

Product Focused Production System In this type of production processing, the production departments are organized according to the type of product / service being produced, a

Why is the eoq model important, 1. The annual demand for university student...

1. The annual demand for university students style note pads is 10,000 units. The supplier operates the business 300 days per year and delivers over five working days. Calculate th

Explain framework of the general model of planned change, Describe the fram...

Describe the framework of the general model of planned change. Include a discussion of each activity and a typical sequence of events.

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