Question: Problem #1 (problem #19 in chapter 6) Adirondack Paper Mills, Inc., operates paper plants in Augusta, Maine, and Tupper Lake, New York. Warehouse facilities are

Problem \#1 (problem \#19 in chapter 6) Adirondack Paper Mills, Inc., operates paper plants in Augusta, Maine, and Tupper Lake, New York. Warehouse facilities are located in Albany, New York, and Portsmouth, New Hampshire. Distributors are located in Boston, New York, and Philadelphia. The plants' capacities and distributor demands for the next month are as follows: The unit transportation costs (in dollars) for shipments from the two plants to the two warehouses and from the two warehouses to the three distributors are as follows: (a) Draw the network representation of the Adirondack Paper Mills problem. (b) Formulate the Adirondack Paper Mills problem as a linear programming problem. (c) Optional for Extra Credit (2pt): Use Excel Solver to determine the minimum cost shipping schedule for this problem. Include your Excel file with your submission
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
