Reference no: EM131119815

1. TransAm Foods Company has five plants, where it processes and packages fruits and vegetables.
It has suppliers in six cities in California, Texas, Alabama and Florida.
The company has owned and operated its own trucking system in the past for transporting fruits and vegetables.
However, it is now considering transferring all its shipping to outside trucking firsm.
It currently spends $245,000 per month to operate its own trucking system.
It has determined monthly shipping costs (in $1000 per ton) using outside shippers, as shown in the table given below.

Should National Foods continue to operate its own shipping network or should it outsource its shipping to independent trucking firms?

These cells will be populated when you run the solver addd-in
Cells that require input from you

Note: solver requires that you specifiy constraints

2. A sports apparel company has received an order for a college basketball teams' national championship T-shirt.
The company can purchase the T-shirts from textile factories in Mexico, Puerto Rico and Haiti.
The shirts are shipped from the factories to companies in the US that silk-screen the shirts before they are shipped to distribution centers.
Following are the production and transportation costs ($/shirt) from the T-shirt factories to the silk-screen companies to the distribution centers,
plus the supply of T-shirts at the factories and demand for the shirts at the distribution centers.

Determine the optimal shipments that will minimize total production and transportation costs for the apparel company.

Attachment:- template_for_assignment.rar