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

  Book review - the goal

Operations Management is about a book review. Title of the book is "Goal". This book has been written by Dr. Eliyahu Goldartt. The book has been appreciated by many as one of those books which offers an insight into the operations and strategic capac..

  Operational plan in hospitality enterprise

Operational plan pertaining to a hospitality enterprise is given in detail in the solution. The operational plan is an important plan or preparation which gives guidelines regarding the role and responsibilities of each and every operation at all lev..

  Managing operations and information

Recognise the importance of a strategic approach to the development and deployment of organisational information systems. Demonstrate an understanding of the importance of databases and their integration to the organisation's overall information mana..

  A make-or-buy analysis

An analysis of the holding costs, including the appropriate annual holding cost rate.

  Evolution and contributor of operations management

Briefly explain Evolution and contributor of Operations management.

  Functions and responsibilities of an operations manager

A number of drivers of change have transformed the roles, functions and responsibilities of an operations manager over recent years. These drivers have not only been based on technological innovations but also on the need for organisations to develop..

  Compute the optimal order quantity

Compute the Optimal Order quantity of DVD players. Determine the appropriate reorder point.

  Relationship to operations practice in the organisation

Evaluate problems in operations and identify approaches to overcoming them. Critically evaluate operating plans and identify areas for improvement. Justify, implement and evaluate changes to operations in line with modern approaches.

  A make or buy analysis

Develop a report for Figi Fabricating that will address the question of whether the company should continue to purchase the part from the supplier or begin to produce the part itself.

  Prepare a staffing plan

Prepare a staffing plan showing the change of your unit from medical/surgical staffing to oncology staffing.

  Leadership styles in different organizations

Ccompare the effectiveness of different leadership styles in different organizations

  Risk management tools and models

Be able to understand the concept of risk, roles and responsibilities for risk management and risk management tools and models.

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