The Pandora Company, a U.S.-based manufacturer of furniture and appliances that offshores: Operations Management & Analytics Assignment, UON, Malaysia
University | University of Nottingham (UON) |
Subject | Operations Management & Analytics Assignment |
The Pandora Company, a U.S.-based manufacturer of furniture and appliances that offshores all of its manufacturing operations to Asia, has distribution centers at various locations on the East Coast near ports where their items are imported on container ships. In many cases, their appliances and furniture arrive partially assembled, and they complete the assembly at their distribution centers before sending the finished products to retailers.
For example, appliance motors, electric controls, housings, and furniture pieces might arrive from different Asian manufacturers in separate containers. Recently, the company began exporting its products to various locations in Europe, and demand steadily increased. As a result, the company determined that shipping items to the United States, assembling the products, and then turning around and shipping them to Europe was inefficient and not cost- effective.
Are You Searching Answer of this Question? Request Malaysian Writers to Write a plagiarism Free Copy for You.
The company now plans to open three new distribution centers near ports in Europe, so that it will ship the items from Asian ports to its distribution centers at the European ports, offload some of the items for final product assembly, and then ship the partially filled containers on to its U.S. distribution centers. The table 1.1 shows the seven possible distribution center locations near container ports in Europe and their container capacities; the container shipments from each of its Asian ports; and the container shipping cost from each of its Asian ports to each possibie distribution center location. The table 1.2 shows the demand from each of the U.S. ports and the cost for container shipments from each of the possible distribution center locations to each of the U.S. ports.
Determine the three distribution center locations in Europe that Pandora should select, and the shipments from each of the Asian ports to these selected distribution centers, and from the European distribution centers to the U.S. ports that will result in the lowest overall cost for the 1 year of operations. You are expected to show a) the minimizing equation, b) all the supply, demand and any other required constraint equations and c) the minimum overall costs. You are also expected to show the tables that you have developed in Excel in order to use the Solver Add-In to compute the solution to the problem.
Get Solution of this Assessment. Hire Experts to solve this assignment for you Before Deadline.
Get Help By Expert
Navigate the intricacies of Operations Management & Analytics assignments with the leading Assignment Helper. Malaysian students can pay for dedicated support, extending to our distinguished Professional Online Exam Helper services, ensuring a pathway to academic success characterized by expertise and excellence.
Recent Solved Questions
- EBQ2054: Business Research Method Essay, UM, Malaysia Describe the theoretical contribution in your research with the consideration of the relevant social theories that are supported by the specified arguments
- Finance for Strategic Managers Assignment, IBAS, Malaysia Pietro Yon, a local businessman, owns and manages a number of retail stores that sell a range of homewares
- ENT3074: Entrepreneurship Assignment, SU, Malaysia Students are required to focus on proposing a business in any sector in Malaysia
- LAW1014 Business Law Course Work, SU, Malaysia Discuss the application of the doctrine of caveat emptor with particular reference to the implied conditions
- FBWFF1013: Fundamentals of Finance Case Study, UUM, Malaysia Taking into consideration the fact that the $98,000 home price will grow at 4% per year, what will be the future median home selling price
- BNNS6433: Urinary calculi may remain within the renal parenchyma or renal collecting system: Genitourinary & Endocrine Nursing Assignment, LUC, Malaysia
- LEI2043: CURRENT ISSUES IN LAW ENFORCEMENT Assignment, SUC, Malaysia Based on the above article, kindly explain and elaborate what is the extent of discretionary powers of a police officer
- Management and Leadership in Education Assignment, UPM, Malaysia Ms. Sara is a principal at a secondary school in Malaysia who has noticed that her teachers seem stressed and overwhelmed
- BED15203: Write a C program that prompts user to enter 2 sides of a rectangle and the radius of a circle: Fundamentals Of Programming Assignment, UniKL, Malaysia
- Anti-Money Laundering & Counter Financing of Terrorism Practices Assignment, ICTA, Malaysia Describe the breaches of US sanctions committed by ABC in respect of the three (3) sanctioned countries