Stat 279 Operations Research

Stat 279 Operations Research
Problem 1.
Nanaq Europe-                     
Regions                       Electric motors
Gaydon (UK)                          140,000
Rouen (France)                       130,000
Dresden (Germany)                160,000
Nanaq International
Regions                                   Refrigerators.
Jung (Sweden)                                                130,000
Reynosa (Mexico)                               120,000
Pohang (South Korea)                                    145,000
East Tamaki (New Zealand)               25,000
Supplied by Nanuq Europe                     To Nanaq InternationalSupply(SS)
Jung ReynosaPohangEast Tamaki 
Gaydon80240180280780
Rouen40210200320770
Dresden20250140200610
Demand(DD)1407005208002160
Total demand for motors.
∑DD=140 + 700+520+800= 2,160 motors
  1. Total supply for motors.
∑SS= 780+770 +610 = 2,160 motors.
  1. Use LCM (Least cost method) to construct a transportation tableau.
Identify the least cost in the whole table.
NoSupplierDestinationCost (Euros)Allocation
1.DresdenJung20140
2.DresdenPohang140470
3.GaydonPohang18050
4.RouenReynosa210700
5.GaydonEast Tamaki280730
6.RouenEast Tamaki32070
 Transportation Tableau.
Supplied by Nanuq Europe                     To Nanaq InternationalSupply(SS)
Jung ReynosaPohangEast Tamaki 
Gaydon00180280780
Rouen02100320770
Dresden2001400610
Demand(DD)1407005208002160
Transportation cost tableau.
Unit cost (Q)Allocation (C)Total Cost $ (C*Q) Euros
201402,800
14047065,800
180509,000
210700147,000
280730204,400
3207022,400
∑C = 1,150∑Q = 2,160∑TC = 451,400
Interpret the starting solution from the least cost method.
Total minimum cost:
(140*20) + (470*140) + (50*180) + (700 * 210) + (730* 280)+ (70*320)
= 451,400Euros.
Stat 279 Operations ResearchUsing the Least cost method to solve the transportation problem, it can be concluded that to obtain the minimum cost of transporting to Nanuq International, it will cost $ 451,400 and the supplies should originate from the suppliers in Europe as indicated by the tableau above. It will have to transport a total of 2,160 electric motors. 
  1. Obtain the optimal solution using excel. Cut and paste the excel output into word document and interpret the solution.
Conclusion:
  • 140 Electric motors should be transported from Rouen to Jung.
  • 70 Electric motors should be transported from Gaydon to Reynosa
  • 630 Electric motors should be transported from Rouen to Reynosa
  • 190 Electric motors should be transported from Gaydon to East Tamaki
  • 610 Electric motors should be transported from Dresden to East Tamaki.
Excel:
  1. According to excel, the total cost is 423, 500
Problem 2.
Calculate the total cost according to the excel solution. Also comment on any excess supply or demand.
According to excel solution, the Total minimum cost is $ 167,000
According to excel, the following persons should be assigned the following projects;
Person Assigned                   Work Project.
Mary                        2
Elizabeth                        4
 Steven                              1
Joshua                               3
 REFERENCE LIST.
  1. Mokhtar S. B., John, J. J., &Hanif, D. S. (2011). Linear Programming and Network Flows (3rd). Hoboken, New Jersey: John Wiley & Sons Inc.

Comments

Post a Comment

Popular posts from this blog

Unit 4 Managing Quality in HSC

Image
Unit 4 Managing Quality in HSC 4.1 Evaluate me thods for evaluating anchor service quality with regard to external and internal perspectives. There are numerous methods for evaluating anchor service quality such as focus groups structured and semi structured interviews panels and complaints procedures. First is Marketing as marketing depends upon the needs of the customers then second comes service marketing which helps in understanding the nature of services and the quality of services provided ; and third is the service quality models which are used commonly within the service marketing discipline. Also there can be other means like questionnaire survey with the customers to evaluate and know their feedback toward the services provided by Anchor care home. Road shows can be held for knowing the response of public. For evaluating anchor care service quality healthcare providers take interests in the different perceptions while anchor itself seeks for cost minimizing issues a...
Read more

Unit 35 Web Application Development

Image
Unit 35 Web Application Development Module Booklet Unit 35 Web Application Development Unit   Unit35: – Web Application Development Unit level 5 Unit code K/601/1510 Credit Value 15 Qualification BTEC HND in Computing and Systems Development Term Start Date 20 November 2017 Hand out date 20 November 2017 Submission Deadline 18 February 2018 Lecture 9 weeks Revision Clinic 1 Week Module Leader Rafiqul Islam Lecturer Ekereuke Udoh   Copyright Statement: This document is the product and property of the UK College of Business and Computing and therefore may not be: shared with any external third party; reproduced in full or in part; or used in any other related manner whatsoever, without prior expressed written permission. This statement is for the attention of students, staff and external parties. In the case of copyright infringement, legal action will be exercised Introduction   The internet has emerged as a do minating area of IT developmen...
Read more

Unit 5 Marketing in Travel and Tourism

Image
Unit 5 Marketing in Travel and Tourism Module Booklet   Qualification Pearson BTEC (HND) Travel and Tourism Management Unit 5 Marketing in Travel and Tourism QCF level 4 Unit code R/601/1744 Module type Core Credit value: 15 Block start date 05 June 2017 Issue date 05 June 2017 Assignment submission date 13 August 2017 Lectures and formative assessment 10 Weeks Guided learning hours 60 Module leader Mr  K.A Mayah Introduction   Aim This unit enables learners to understand the concepts, principles and role of marketing and the marketing mix, and gain skills to use the promotional mix in travel and tourism. Unit abstract The aim of this unit is to develop learners’ understanding of the key concepts and principles of marketing as they apply to the travel and tourism sector. The unit aims to equip learners with the knowledge and understanding of the key factors affecting marketing environments and the role of marketing in different industries withi...
Read more