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 labour practices requirements, From the legal perspective, what cha...

From the legal perspective, what challenges May supervisors face in filling the positions? How might they unintentionally run short of regulatory hiring and labour practices requir

Explain project management in the form of a cpm, Discuss an example of a wo...

Discuss an example of a work-related project that is able to be broken down into structure, tasks, subtasks, and work packages, and why project management in the form of a CPM/PERT

Products produced by project, 1. Identify products which you would expect t...

1. Identify products which you would expect to be produced by each of the following configurations: project, job shop, and batch and continuous. Answer: Many possible answers:

Explain how much repayment of principal, Jan sold her house on December 31 ...

Jan sold her house on December 31 and took a $50,000 mortgage as part of the payment. The 10-year mortgage has a 11% nominal interest rate, but it calls for semiannual payments beg

Provide source of enlightenment to the problem, Assume you are the CFO of A...

Assume you are the CFO of ABC Corporation, a multi-state supplier of janitorial supplies. The CEO as just met with you and "suggested" your job might depend on your ability to hide

Explain how many hats should be in inventory, The Bryant Museum is open 360...

The Bryant Museum is open 360 days per year. On average, they sell 3 hounds tooth hats per day. Each hat sells for $16. The museum%u2019s holding cost is $1 / hat / month. Each ord

Ansrwe, What do you understand by “line balancing

What do you understand by “line balancing

Examples of productivity measures, Examples of Productivity Measures  ...

Examples of Productivity Measures  Sales ($)/labour costs ($)  Sales ($)/pay ($)  Total value of sales (billed) ($)/labour costs($) + investment ($)  Sales/salespeopl

What are the advantages as well disadvantages for a u.s, What are the advan...

What are the advantages and disadvantages for a U.S.-based company entering a mature market economy?

Makw or to Buy ?, • ABC Ltd. is in the business of manufacturing one type o...

• ABC Ltd. is in the business of manufacturing one type of valves for last 3 years. • Their sales have grown from 10,000 to about 50,000 valves per month. • Now they are planning t

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