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 characteristics of a definable sample group, Which of the following...

Which of the following requires the opinion of an expert to determine the location and characteristics of a definable sample group? Judgment sample Simple random sample S

Analyze the relationship between analysis and planning, Analyze the relatio...

Analyze the relationship between analysis, planning, implementation, and control. Provide an example of a product or service that flows through the relationship. Break down this pr

Explain functional structure with simple structure, Explain how the followi...

Explain how the following somewhat match each other: • functional structure with simple structure • divisional structure with departmentalization by product • machine bureaucracy w

Performance dimensions common in service than manufacturing, 1. Name some p...

1. Name some performance dimensions more common in service than manufacturing operations.  Answer: These are the dimensions listed. Services tend to be more intangible and tailo

Explain bank is insisting on an improved profit picture, Company A finds pr...

Company A finds profit at $15,000 inadequate for expanding business. The bank is insisting on an improved profit picture prior to approval of a loan for some new equipment. Company

Explain efficiently report of schedule of a project, Illustrate how to effe...

Illustrate how to effectively and efficiently report on the schedule of a project to the different stakeholder groups. Show calculations and provide rationale for each strategy.

Schmenner''s service-process matrix - operation strategy, Schmenner's Servi...

Schmenner's Service-Process Matrix The service-process matrix was introduced earlier. It is Schmenner's service industry equivalent of the product-process matrix. The service

Explain administrative issues, Unit IV: At the Bargaining Table Unit V: Gri...

Unit IV: At the Bargaining Table Unit V: Grievances and Arbitration Unit VI: Wage Issues and Economic Supplements Unit VII: Institutional Issues Unit VIII: Administrative Issues

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

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