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 are your recommendation to resolve this lawsuit, Scenario: Com...

Scenario: Commerce Clause ABC Freightways maintained its principal place of business in Arkansas. However, they provided trucking services in all states west of the Mississippi

Process design in operations managment, when asked to critically discuss ma...

when asked to critically discuss main factors that influence process design within a familiar organisation, does this mean a breakdown of the company''s design process or an analys

Explain three process steps performed by three machines, Consider the follo...

Consider the following batch-flow process consisting of three process steps performed by three machines: STEP 1 Processing Time: 0.25 Min/Part Processing Time: 0.20 Min/Part Pro

Operations function - transformation processes and planning, Operations Fun...

Operations Function - Transformation Processes and Planning The operations function is concerned with the design of transformation processes, planning their use, and organisin

Give the definition of a team, QUESTION (a) Give the definition of a te...

QUESTION (a) Give the definition of a team as well as elaborate on the purpose of having teams in the organisation. (b) Explain the different processes that take place in a

Explain what type of noise was experienced, Choose a communication situatio...

Choose a communication situation you recently experienced at your workplace or other organization you are affiliated with. Use the human communication process described on pages 10

Production planning and control (ppc), Production Planning and Control (PPC...

Production Planning and Control (PPC) Production in manufacturing comprise  a series  of steps by  which  material is given  a new  form to  satisfy a predetermined objective,

Explain perspective of project manager to avoid the obstacle, Analyze why i...

Analyze why it is important to address risk through the entire project life cycle. Identify three possible negative results that can occur if an organization fails to address risk

Explain managers viewed emotional intelligence as important, 1.A credit car...

1.A credit card company is interested in the average balance tht is carried by its college aged card holders. They are particularly interested in whether the average balance of the

Explain following is an inequality or equation that expresse, Which of the ...

Which of the following is an inequality or equation that expresses a restriction in a mathematical model? Decision variable Parameter Objective function Constraint N

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