Give the solution of operation management problems in excel

Assignment Help Operation Management
Reference no: EM131276169

Problem:1

A location analysis for Cook Controls, a small manu
facturer of parts for high-technology cable systems, has been nar. rowed down to four locations. Cook will need to train assemblers testers, and robotics maintainers in local training centers. Lori Cook, the president, has asked each potential site to offer training programs, tax breaks, and other industrial incentives. The critical factors, their weights, and the ratings for each location are shown in the following table. High scores represent favorable values.

FACTOR

WEIGHT

AKRON,
OH

LOCATION

BILOXI,        CARTHAGE,

MS           TX

DENVER,
CO

Labor availability

.15

90

80

90

80

Technical school quality

.10

95

75

65

85

Operating cost

.30

80

85

95

85

Land and construction cost

.15

60

80

90

70

Industrial incentives

.20

90

75

85

60

Labor cost

.10

75

80

85

75

a) Compute the composite (weighted average) rating for each location.
b) Which site would you choose?
c) Would you reach the same conclusion if the weights for oper¬ating cost and labor cost were reversed? Recompute as neces¬sary and explain.

 

Problem:2

18 Hyundai Motors is considering three sites-A, B, and C at which to locate a factory to build its new-model automobile, the Hyundai Sport C150. The goal is to locate at a minimum-cost site, where cost is measured by the annual fixed plus variable costs of production. Hyundai Motors has gathered the following data:

SITE

ANNUALIZED
FIXED COST

VARIABLE COST PER
AUTO PRODUCED

A

$10,000,000

$2,500

B

120,000,000

52,000

C

$25,000,000

S1,000

The firm knows it will produce between 0 and 60,000 Sport Cl 50s at the new plant each year, but, thus far, that is the extent of its knowledge about production plans.
a) For what values of volume, V, of production, if any, is site C a recommended site?
b) What volume indicates site A is optimal?
c) Over what range of volume is site B optimal? Why?

 

Problem:3

The following table gives the map coordinates and the
shipping loads for a set of cities that we wish to connect through a central hub.

CITY MAP COORDINATE (x, 4 SHIPPING LOAD
A (5, 10) 5
B (6, 8) 10
C (4, 9) 15
D (9, 5) 5
E (7, 9) 15
F (3, 2) 10
G (2, 6) 5

a) Near which map coordinates should the hub be located?

b) If the shipments from city A triple, how does this change the coordinates?

Reference no: EM131276169

Questions Cloud

Corporations just develop internally the business : Why don’t corporations just develop internally the business/capabilities that it could obtain through acquisitions? Why do you think target firms might agree to be acquired?
Discuss the process of setting up closely held corporation : Discuss the process of setting up a closely held corporation. Also discuss advantages and disadvantages of the closely held corporation. Discuss antitrust laws and their relationship to Major League Baseball. Why is this anomaly present and will it c..
When is the ebita interest coverage ratio more appropriate : When is the EBITDA interest coverage ratio more appropriate than the EBITA ratio? When is the EBITA interest coverage ratio more appropriate than the EBITDA ratio?
Discuss sweatshops as they relate to labor laws : Discuss sweatshops as they relate to labor laws. Are there sweatshops present in the US? Why or why not? is there an argument that can be made in support of sweatshops in poverty-stricken nations?
Give the solution of operation management problems in excel : Give the Solution of Operation Management Problems In Excel.For what values of volume, V, of production, if any, is site C a recommended site?What volume indicates site A is optimal?Over what range of volume is site B optimal? Why?
Discuss what rainbows can tell us about nature of sunlight : Discuss what rainbows can tell us about the nature of sunlight. Choose a technology device that makes use of the EM Spectrum. Next, explain how this device works using terminology learned in this chapter.
What alternatives exist to handle new cash : If the company generates more cash than it needs, how could the balance sheet be adjusted to handle this? What alternatives exist to handle new cash?
What factors contribute to improved territory management : Describe methods and tools are used to rate performance and compliance. When can health information be disclosed for legal purposes? (in your word). What in your opinion are the complementary assets that have given rise to paces like Silicon valley o..
Emotional intelligence can improve leader effectiveness : Next, detail the significant ways that an awareness of emotional intelligence can improve a leader’s effectiveness. Select a situation in which you demonstrated emotional intelligence that improved your effectiveness as a leader, either in your profe..

Reviews

Write a Review

Operation Management Questions & Answers

  Elucidate how many hrs do you expect the assembly

Elucidate how many hrs do you expect the assembly of the 100th unit to take. Is the contract‘s assumption about the average labour hrs per unit valid or should the price be revised.

  Determine the coordinates of the location that will minimize

Weekly quantities to be shipped to each location are also shown in the table. Determine the coordinates of the location that will minimize distributioncosts.

  Mazda beefed up the model with heavier shocks and a faster

mazdas miata convertible originally drew the most interest from women between the ages of 35-55. in order to interest

  Supply and higher inventory turnover

If fewer weeks of supply and higher inventory turnover are better, is it possible for a supply chain to achieve zero weeks of supply and infinite inventory turns? Why or why not?

  Define were the actions of the employee appropriate

The employee notified the facility union representative, who promptly called OSHA to report the concerns. Subsequently, OSHA arrived and conducted an inspection; multiple violations were issued to the company concerning forklift operators who had ..

  Advertising-public relations and sales promotion

As the promotional manager for a new line of cosmetics targeted to preteen girls, you have been assigned the task of deciding which promotional mix elements—advertising, public relations, sales promotion, and personal selling—should be used in promot..

  Reflected in any procurement contracts

When changes are made to the project schedule, scope, or resource allocation, how should they be reflected in any procurement contracts or RFPs that are in place?

  What are safety stock and reorder point for service level

The daily demand of a product is very stable at 250 units per day. However, its delivery lead time varies and can be specified by a normal distribution with a mean lead time of twelve days and standard deviation of three days. What are the safety sto..

  Strategies to account for this changing spending behavior

If you worked on the marketing team for a retailer that targets Gen Y customers, how might you revise your marketing strategies to account for this changing spending behavior?

  Prepare an advertisement for that position

Prepare an advertisement for that position that complies with federal law. This advertisement must be detailed. The minimum length of your job description must be 300 words (approximately three-fourths of a page).

  Would it be the same if the award was published

Would it be the same if the award was published on the Internet, but the revocation in the newspaper? Explain

  What was described as the sandpaper test

Colgate- Palmolive CO. ran television commercial to show that its shaving cream, Rapid Shave, could soften even the toughness of sandpaper. The commercial showed what was described as the sandpaper test. Actually, what was used was a sheet of Plexigl..

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