Question

I cannot figure out how to set this problem up in solver or if it is possible to do in a chart. . im so frustrated because i have tried so many ways but cannot find a solution.. i have included my work n the attempts at a solution

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 plant capacities and distributor demands for the next month are as follows:
Plant Capacity (units) Augusta 300 Tupper Lake 100
Distributor Demand (units) Boston 150 New York 100 Philadelphia 150

The units transportation costs (in $) for shipments from the two plants to the two warehouses and from the two warehouses to the three distributors are

Plant-to-warehouse Information
Plant/Warehouse Albany Portsmouth
Augusta 7 5
Tupper Lake 3 4

: Warehouse-to-distributor Information
Warehouse/Distributor Boston New York Philadelphia
Albany 8 5 7 300
Portsmouth 5 6 10 100
150 100 150
My answer:
50 units from AUG to BOS
100 Units from AUG to New York
150 units from AUG to Philly
100 units from Portsmouth to BOS

so i can get the table set up without the pricings, but how do i know what warehouse & price each goes through ?

Answer 1

idk either t