Determine which provides the lowest transportation cost

Assignment Help Operation Management

Reference no: EM131846082

A large retailer is planning to open a new store to add to its two existing retail stores (A & B). Three locations in California are currently under consideration for the new store: South Coast Plaza (SCP), Fashion Island (FI), and Laguna Hills (LH).

Each of these new stores under consideration will have a demand of 500 units. The product (construction building toy sets) is currently supplied from three warehouses (1, 2, and 3).

Warehouses 1, 2 and 3 can each supply a total of 600, 340, and 200 units, respectively. The following two tables provide additional Information regarding supply/demand and shipping costs per unit reflected in $.

Shipping costs/unit

	SCP	FI	LH
Warehouse 1	$4.00	$7.00	$5.00
Warehouse 2	$11.00	$6.00	$5.00
Warehouse 3	$5.00	$5.00	$6.00

	A	B	Supply
Warehouse 1	$15.00	$9.00	600
Warehouse 2	$10.00	$7.00	340
Warehouse 3	$14.00	$18.00	200
Demand	400	500

Determine which location, South Coast Plaza (SCP), Fashion Island (FI), or Laguna Hills (LH), provides the lowest transportation cost.

Set up this problem as a linear programming (LP) problem and find the optimal solution using Excel's Solver.

Your spreadsheet file should have three worksheets in it named "SCP", "FI", and "LH".

Moreover, please make sure that all Solver parameters inputs (e.g., "Set objective cell", "By Changing Variable cells", and constraints) are all reflected in each corresponding Excel worksheet.

Formulate this problem as a linear programming (LP) problem by identifying the decision variables (e.g., let X1 = no. of units shipped from A to B, etc.), objective function (e.g., Min $15X1 + $9X2 +....), and all relevant constraints for the South Coast Plaza (SCP) location only (e.g., the relevant supply and demand constraints).

You may embed/insert your LP formulation anywhere in the SCP worksheet.

Reference no: EM131846082

Questions Cloud

Compare the performance of python list based stack and queue : Design and implement an experiment that will compare the performance of the Python list based stack and queue with the linked list implementation.

How does the small firm take on the challenge of the triple : Some large multinational organizations eclipse the size of countries. They receive pressure to be good global citizens.

Review problem related to electronic sensors : You are a co-founder of a start-up firm making electronic sensors. After a year of sales, your business is not growing rapidly.

Create an implementation of a queue : Create an implementation of a queue that would have an average performance of (1) for enqueue and dequeue operations.

Determine which provides the lowest transportation cost : Set up this problem as a linear programming (LP) problem and find the optimal solution using Excel's Solver.

Can you tell me what each of the numbers mean : STT100 Research Assignment. We recently implemented a new phone system that captures data on all incoming calls. Can you tell me what each of the numbers mean

Discuss about the economic empowerment : In addition, even though there has been some progress for women in India, others attribute the use of gender selection to women's lack of social, political.

Draw a sierpinski triangle using paper and pencil : Draw a call stack for the Tower of Hanoi problem. Using the recursive rules as described, draw a sierpinski triangle using paper and pencil.

Write a program that prints out pascals triangle : Write a program that prints out Pascal's triangle. Your program should accept a parameter that tells how many rows of the triangle to print.

User Account

All Pages