The purpose of this assignment is for you to understand the algorithms used to determine what product to ship from whom and where based on the costs of shipment.  You will be using the Transportation Model discussed in week 14 material.  This is an important factor in supply chain management.  The product is transported from a number of sources to a number of destinations at the minimum possible cost and each source is able to supply a fixed number of units. Each destination has a fixed demand. Companies never ship more than demand, so if supply is greater than demand, it remains at the source.

You will be using a linear programming application, Solver, which is an add-on to excel. I illustrate how to add this to excel in the Week 14 videos.


1) Complete the following problem which is explained in the template. See below for the link to this template. (15 pts).

Use this template: Template for transportation model  Download Template for transportation model  Do not alter this template, it makes grading difficult and alterations are not needed. 

Add in the formulations needed in the excel spreadsheet.

Open solver and complete all the necessary fields as shown in the Transportation video.

Run solver

How many children will be assigned from the North District to Addison school?

2) Complete problem #2 (10 pts). Using the same template as before alter the problem based on the new constraint. The school district has determined that it does not want any of the schools to be overly crowded compared with the other schools. It would like to balance enrollments between the four schools. However, the concern is that this might significantly increase travel time. Determine the number of students to be assigned to each school so that enrollments are evenly balanced. Does this new solution appear to significantly increase travel time per student?

Submit a separate excel file with the solution. What was the impact on time given this new constraint?

What Students Are Saying About Us

.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐
"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"

.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."

“Order a custom Paper on Similar Assignment at! No Plagiarism! Enjoy 20% Discount!”