Using What's Best! (or Solver) determine the least-cost shipping schedule, where each of three (3) hardware vendors provide up to two hundred (200) units and each of six (6) buyers demand one hundred (100) units. The shipping costs (in dollar per unit), which are provided from Buyer 1 to Buyer 6 are as follows:
|
|
Buyer 1
|
Buyer 2
|
Buyer 3
|
Buyer 4
|
Buyer 5
|
Buyer 6
|
|
Nick's Nuts
|
$100
|
$110
|
$90
|
$80
|
$70
|
$120
|
|
Henry's Hardware
|
$150
|
$110
|
$190
|
$50
|
$120
|
$150
|
|
Anthony's Aids
|
$130
|
$125
|
$135
|
$130
|
$100
|
$135
|