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

Analytical estimating, Analytical Estimating This technique  of work m...

Analytical Estimating This technique  of work measurement  is used  to determine the  time  values for jobs  having  long and  non repetitive  operations. The time  values  ar

Process Model - Serivces, Apply a proces smodel to a services industry proc...

Apply a proces smodel to a services industry process that experiences problems with either internal or external customers. Discuss all elements

Production efficiencies and reducing unit costs, A manufacturer concerned m...

A manufacturer concerned mainly with production efficiencies and reducing unit costs is known as Production oriented.

Accounting, describe the element that makeup TQM as amoderv philosophy and...

describe the element that makeup TQM as amoderv philosophy and quality mangementsamodern

Explain motivation, Explain Motivation. The factors leading mainly towa...

Explain Motivation. The factors leading mainly towards motivation are :- (i) Achievement - Personal satisfaction in job completion and problem solving. (ii) Advancement -

Explain turnover and low retention among expatriate employee, Utilizing Tex...

Utilizing Textbook Concepts Answer ALL of the Questions Below: 1. based on what you've learned this semester, why do you think there is high turnover and low retention among expatr

Describe quantities would your supplier selection change, Your company asse...

Your company assembles five different models of a motor scooter that is sold in specialty store in the United States. The company uses the same engine for all five models. You have

Explain what is the production, A local market research firm has just won a...

A local market research firm has just won a contract for several thousand small projects involving data gathering and statistical analysis. In the past, the firm has assigned each

Brandon production is a tiny firm focused on the assembly, Brandon Producti...

Brandon Production is a small firm focused on the assembly and sale of custom computers. The firm is facing stiff competition from low-priced alternatives, and is looking at variou

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