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 does the sarbanes-oxley act effectively, Does the Sarbanes-Oxley Ac...

Does the Sarbanes-Oxley Act effectively protect stakeholders? Why, or why not?

Define management information system and its scope, Normal 0 fa...

Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4

Characteristics of job order production, Characteristics of job order Produ...

Characteristics of job order Production Small Production Runs: Job order production is characterized by the manufacturing of one or few numbers of single product designe

What is usefulness of materials requirement planning, Q. What is usefulness...

Q. What is usefulness of materials requirement planning first to manufacturing operations? Materials requirement planning (MRP I) is an inventory control system that gives an a

Auto Parts store manager, Needs to know how to run office affairs and to ha...

Needs to know how to run office affairs and to handle the paperwork of all customers as they come in each day, and take care of the work load of the employees as to setting up the

Factors influencing plant layout, Factors Influencing Plant Layout While...

Factors Influencing Plant Layout While choosing the layout for a factory the following factors should be taken into consideration: Management Policy: Management has to de

Explain agreed based on prisoner''s privacy concerns, 1. In Everson v. Mich...

1. In Everson v. Michigan Department of Corrections, the defendant claimed that hiring only female Corrections and Residential Housing Unit Officers was justified as a BFOQ. The co

Explain an engine system consists of three main components, An engine syste...

An engine system consists of three main components in a series, all having the same reliability. Determine the level of reliability required for each of the components if the engin

Initiate an organizing campaign for the technical employees, 1) Company A w...

1) Company A wants to discourage unionization through the United Technical Workers of America. True or False: In order to do so, it can initiate an organizing campaign for the Tech

Explain where was the world''s first air raid in 1849, Where was the world'...

Where was the world's first air raid in 1849 from hot air balloons?

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