Reference no: EM133072540
1. The National Paper company contracts with their suppliers on a quarterly basis to buy pulp for their paper mills in Maine, Georgia, and Louisiana. The pulp comes from four suppliers in four regions: Western Canada, Brazil, Scandinavia, and the Pacific Northwest. The cost of purchasing the pulp (in US dollars per ton), the amount of pulp available, and the forecasted quarterly demand (in tons) for the next quarter are given in the tables below.
|
Supplier
|
Cost/ton
|
Availability (tons/quarter)
|
|
Canada
|
$1100
|
850000
|
|
Brazil
|
$950
|
950000
|
|
Scandinavia
|
$1000
|
1250000
|
|
USA
|
$1200
|
500000
|
|
Mill
|
Demand (tons/quarter)
|
|
Maine
|
900000
|
|
Georgia
|
1080000
|
|
Louisiana
|
960000
|
The cost of shipping pulp (per ton) using standard shipping containers is given in the table below.
|
Shipping costs (US Dollars per ton)
|
|
From To
|
Maine
|
Georgia
|
Louisiana
|
|
Canada
|
$120
|
$150
|
$180
|
|
Brazil
|
$150
|
$130
|
$120
|
|
Scandinavia
|
$150
|
$180
|
$200
|
|
Pacific Northwest
|
$120
|
$150
|
$160
|
1a. Formulate a linear programming (LP) model to help National Paper acquire their pulp for the upcoming quarter.
1b. Solve your model in Excel and determine the optimal value and the optimal solution. Report your results.
Suppose the Scandinavian supplier alerts National Paper that they can no longer ship their pulp using standard storage containers due to a container shortage. As a result, the Scandinavian supplier has contracted cargo ships that can carry 30000 tons of pulp per cargo ship. They will only sell National Paper pulp in increments of a full cargo ship (i.e., in increments of 30000 tons), applying the same shipping costs (per ton) as given in the previous table.
1c. Revise your LP formulation to account for this new shipping requirement. Write out your formulation in its entirety.
1d. Solve your model in Excel to determine a new optimal acquisition schedule and a new optimal value. Report your results.
|
Operational analysis and quality improve
: Describe the challenges these patients may face in relation to the five domains of quality improvement
|
|
Limit order book of a specialist
: Consider the following limit order book of a specialist. The last trade in the stock occurred at a price of $40
|
|
What is the firm share price today
: A Corporation plans to issue equity to raise $84,016,159 to finance a new investment. After making the investment, the firm expects to earn free cash flows of $
|
|
Goal and purpose of program
: Describe the key components or activities of your proposed program; for example, health education materials or screening.
|
|
Formulate a linear programming model
: 1. The National Paper company contracts with their suppliers on a quarterly basis to buy pulp for their paper mills in Maine, Georgia, and Louisiana. The pulp c
|
|
What is estee lauder portfolio weight
: Utilizing Solver in excel, what is Estee Lauder's portfolio weight with a maximum Sharpe ratio of 1.56?
|
|
Compute mcgee degree of operating leverage
: McGee Corporation has fixed operating costs of $10 million and a variable cost ratio of 0.65. The firm has a $20 million, 10 percent bank loan and a $6 million,
|
|
Develop a capital budgeting decision model
: Develop a capital budgeting decision model that displays cash flows, cost of capital, and decision metrics (i.e., NPV, IRR, MIRR, regular payback, and discounte
|
|
Different conclusions from the same data
: What are pros and cons of peer review? What is a concern about coming to different conclusions from the same data?
|