transportation analysis

Project Description:

please find the lowest total cost of transportation, so as to meet all customer requirements => how many units must be shipped from each factory to result in the lowest tota transportation cost?


transportation rates transportation numbers requirement
shipping cost (per unit) factory 1 factory 2 factory 3 factory 4 units shipped factory 1 factory 2 factory 3 factory 4 total units per customer
customer 1 20188.00 20305.00 20242.00 20233.00 0.00 10.00 customer 1
customer 2 20242.00 20255.00 20315.00 20265.00 0.00 11.00 customer 2
customer 3 20265.00 20165.00 20214.00 20242.00 0.00 11.00 customer 3
customer 4 20276.00 20264.00 20186.00 20305.00 0.00 16.00 customer 4
customer 5 20288.00 20253.00 20172.00 20255.00 0.00 23.00 customer 5
customer 6 20272.00 20309.00 20158.00 20165.00 0.00 12.00 customer 6
customer 7 20287.00 20298.00 20221.00 20500.00 0.00 19.00 customer 7
customer 8 20288.00 20253.00 20214.00 20242.00 0.00 10.00 customer 8
customer 9 20287.00 20298.00 20221.00 20398.00 14.00 customer 9
output cells
total capacity 30.00 33.00 31.00 32.00 data cells

due to operational & regulatory reasons:
total cost= factory 1 cannot deliver to customer 2 & 7
factory 2 cannot deliver to customer 3 & 6
factory 3 cannot deliver to customer 4 & 8
factory 4 cannot deliver to customer 1&5
Skills Required:
Project Stats:

Price Type: Fixed

Project Budget: $20 to $50
Completed
Total Proposals: 5
1 Current viewersl
46 Total views
Project posted by:

Proposals

Proposals Reputation Price offered
  • 4.6
    103 Jobs 52 Reviews
    $50 in 2 Days
  • 4.9
    1178 Jobs 609 Reviews
    $50 in 3 Days
  • 4.9
    246 Jobs 94 Reviews
    $50 in 2 Days
  • 4.0
    72 Jobs 31 Reviews
    $45 in 3 Days
  • 5.0
    1 Jobs 1 Reviews
    $35 in 1 Day