Logistics at freight company Unit shipping costs To Customer 1 Customer 2 Customer 3 Unit purchase cost From Warehouse 1 $15 $35 $25 $100 Warehouse 2 $10 $30 $40 $100 Units purchased for: Originally available Warehouse 1 0 40 Warehouse 2 20 30 Shipments To Customer 1 Customer 2 Customer 3 Total Available From Warehouse 1 10 0 30 40 = 40 Warehouse 2 20 30 0 50 = 50 Total 30 30 30 = = = Required 30 30 30 Total purchase cost $2,000 Total shipping cost $2,000 Total cost $4,000 Range names used: Available =Model!$H$16:$H$17 Purchased =Model!$C$10:$C$11 Required =Model!$C$20:$E$20 Shipped =Model!$C$16:$E$17 SumIn =Model!$C$18:$E$18 SumOut =Model!$F$16:$F$17 TotCost =Model!$B$24