Reference no: EM132819695
A toy manufacturer currently has two warehouses (1 and 2) that are operational and meet the demand of backyard play sets at three retail outlets A, B and C. The supply of the play sets at warehouse 1 and 2 are 500 and 400 units respectively. The demand of play sets at warehouses A, B and C are 400, 600, and 350 units respectively. The unit cost of transportation from warehouse 1 and 2 to retail outlets A, B and C are shown in the table below. The toy manufacturer wants to open a third warehouse which will have a supply of 500 units of backyard play sets per week. Two locations, N1 and N2, are being considered for the new warehouse. Transportation costs from location N1 to stores A, B, and C are $6, $8, and $7 per unit, respectively; from location N2, the costs are $10, $6, and $4, respectively. Which of the two locations is the preferred location for the new warehouse?
Hint: You will have to model and solve two LP transportation problems. Solve the model using Solver in excel.
A B C
Warehouse 1 $ 8.00 $ 3.00 $ 7.00
Warehouse 2 $ 5.00 $ 10.00 $ 9.00
Please show how to solve step by step with Solver under the data tab in excel ribbon.
|
Discuss about the e-commerce infrastructure
: Together the Internet and the World Wide Web make e-commerce possible by allowing computer users to access product and service information to complete purchases
|
|
Discuss an experience with recording a presentation
: Find a helpful tip about recording audio or video and share that here. How is the preparation process, and what obstacles can you face?
|
|
Describe what lean thinking is
: Describe what lean thinking is and what its key elements are. Provide some examples of how different organizations use it
|
|
Compute the cash flows from operating activities
: Power and Surge reported sales of $380,000 and $230,000 and cost of goods sold of $160,000 and $109,250, compute the cash flows from operating activities
|
|
Solve two lp transportation problems
: Hint: You will have to model and solve two LP transportation problems. Solve the model using Solver in excel.
|
|
What should strik-it-rich management do
: What should Strik-it-Rich's management do? The expansion, including the cost of the land, will cost $2,500,000. The current price of gold bullion is $1,400
|
|
What is performance measurement and continuous improvement
: What is performance measurement and continuous improvement? How should organizations incorporate both of these concepts into their lean systems strategy?
|
|
Different kinds of business analytics
: Describe the three different kinds of business analytics. Provide on example of each.
|
|
How much of the payments is tax deductible for pink
: Determine how much of the below payments is tax deductible for Pink? Pink Inc, a publicly-traded, calendar-year, C-Corporation paid
|