Explore BrainMass

Explore BrainMass

    Least cost shipping schedule

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Using WHAT'S BEST! or Solver answer the following:

    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 dollars 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 $150 $110 $190 $50 $120 $150

    Anthony's $130 $125 $135 $130 $100 $135

    © BrainMass Inc. brainmass.com March 5, 2021, 12:32 am ad1c9bdddf
    https://brainmass.com/statistics/descriptive-statistics/least-cost-shipping-schedule-514930

    Solution Preview

    Please find attached an excel file with full step by step explanations of the ...

    Solution Summary

    A step by step explanation on how to solve transshipment problems using excel solver. A separate sheet is dedicated to formulation, and solver procedure is explained using pictures.

    $2.49

    ADVERTISEMENT