Reference no: EM131845932
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.
Please view the Camtasia video file "Transportation Problem" as a guide (located in the "Readings & Resources" page of week 5).
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.
|
Are you a morning or an evening person
: Are you a morning or an evening person? When did you first decide that you were one or the other?Has the fact that you are a morning or an evening
|
|
Project technology governance plan
: Describe the governance framework of a organization will use to manage the oversight and use of IT (Information Technology)
|
|
Create any additional data or functions you are suggested
: But if you want to create any additional data or functions, you are suggested to put all the created data or functions inside the SolutionSearch class.
|
|
What is the purpose of accounting
: 1. What is the purpose of accounting? How might a management information system help you as an Accountant?
|
|
Provide the lowest transportation cost
: Determine which location, South Coast Plaza (SCP), Fashion Island (FI), or Laguna Hills (LH), provides the lowest transportation cost.
|
|
Are the three main elements of compensation
: Are the three main elements of compensation systems-internal consistency, market competiveness, and recognizing employee
|
|
Discuss the communication needs
: For the primary stakeholders; sponsor, program manager and project team, discuss the communication needs, type(s) and rationale that you would include
|
|
What are indirect or overhead costs
: What are indirect or overhead costs? Discuss one method in which overhead costs can be allocated?
|
|
Should the ceo make to whole foods strategy going forward
: How does their support of practices such as the development of large scale organic farms fit with their broader social ideology?
|