Reference no: EM133127105
1. The Freezing Cold Refrigerator Company has five production plants in Vancouver, Salem, Fresno, Bakersfield and Imperial. The harpsicords are all shipped to one of six distribution centers in Charlotte, Montreal, Philadelphia, Orlando, Hartford, and Augusta. The transportation costs between plants and distribution centers are as follows:
Charlotte Montreal Philadelphia Orlando Hartford Augusta
Vancouver 588 510 525 610 599 634
Salem 449 540 600 611 549 657
Fresno 482 590 625 595 608 721
Bakersfield 472 629 687 563 625 759
Imperial 454 612 721 586 656 801
The maximum capacity of the Vancouver plant is 120; the capacity of the Salem plant is 80; the capacity of the Fresno plant is 100; the capacity of the Bakersfield plant is 90; and the capacity of Imperial plant is 70. The minimum required shipments to Charlotte, Montreal, Philadelphia, Orlando, Hartford, and Augusta are 81, 60, 73, 92, 86, and 58, respectively.
a. The company's objective is to minimize the cost of transporting its product from its plants to its distribution center while satisfying the above constraints. Write out the objective function and the constraints.
b. Find the cost-minimizing solution using EXCEL's Solver. Hand in copies of the answer report and the sensitivity report.
c. How do you interpret the shadow prices for the capacity constraints? Would it be profitable to add another unit of capacity to the Vancouver plant if the cost of an additional unit of capacity is $50? Explain your answer with reference to the sensitivity report.
d. Explain the value of Salem's shadow price with reference to the changing pattern of shipments if Salem had one more unit of capacity available.
e. By how much could the cost of shipping from Salem to Augusta change by without changing your initial answer? Explain your answer with reference to the sensitivity report.
|
Technology of skill formation
: Reading: Cunha, F., & Heckman, J. (2007). The Technology of Skill Formation. The American Economic Review, 97(2), 31-47.
|
|
Calculate ngdp for 2000
: Imagine that an economy produces two goods, hot dogs and baseballs. In the year 2000 the economy produces 20 hot dogs and 15 baseballs, and the prices of hot do
|
|
What is the economic growth from 2000 to 2001
: Imagine that an economy produces two goods, hot dogs and baseballs. In the year 2000 the economy produces 20 hot dogs and 15 baseballs, and the prices of hot do
|
|
Write a short report discussing alternative approaches
: Discussing alternative approaches to (certificate-based) PKI and how they might overcome some of the inherent PKI limitations
|
|
Production plants in vancouver
: 1. The Freezing Cold Refrigerator Company has five production plants in Vancouver, Salem, Fresno, Bakersfield and Imperial. The harpsicords are all shipped to o
|
|
Provide the ending inventory at cost valuation
: Provide the ending inventory at cost valuation by using the "conventional" retail inventory method
|
|
Japanese manufacturer buys a us bondj
: Suppose a U.S. Toyota dealer imports 100 cars worth $10,000 each and the Japanese manufacturer buys a U.S. bond with the $1 million proceeds. Then the U.S.
|
|
Is the project suitable at net present value
: The initial investment would be $720,000 and the estimated annual cash flows over 4 years would be $260,000. Is the project suitable at net present value
|
|
Prepare all entries that concord corporation must make
: Prepare all entries that Concord Corporation must make during its 2020 fiscal year related to the parental benefits plan in regard to Zeinab Jolan
|