• John Appleton owns a sod company based in Pocatello, Idaho. He sells his sod by truckload to 11 different nurseries across Southern Idaho from Payette to Idaho Falls. His company started with a sod farm in Pocatello. He soon began selling enough sod in the western part of the state that he decided to buy a larger sod farm near Boise. Currently, the Pocatello farm produces 800 truckloads of sod a year. The Boise farm produces 1000 truckloads a year. This is not enough to keep up with the demand for sod from the nurseries, which could sell nearly 3000 truckloads of sod. Because the nurseries prefer John's sod to their alternative suppliers, John has agreed to supply at least 10 truckloads of sod to each nursery each year. It is difficult for John to manage shipments to the nurseries from his farms. He constantly worries that his shipping costs are higher than they should be. Use Solver and the shipping model on the Sod worksheet to determine how many truckloads of sod he should ship to each nursery from each farm in order to minimize his overall shipping costs. As part of your analysis, make sure that you
• 1) ship all of the sod available at each farm without exceeding what is available,
• 2) do not ship a partial truckload of sod,
• 3) do not ship more than the demand for the sod to any nursery, and
• 4) ship at least 10 total truckloads of sod to each nursery. How do you solve using excel "solver". I just paid $10 to get the answers without showing the steps to obtaining the answer. Can you help? I would need to know how to write the inputs for the constraints on excel "solver", (under the data tab).
• 

Model Inputs Nursery Blackfoot Boise Burley Caldwell Idaho Falls Mountain Home Nampa Payette Pocatello Sun Valley Twin Falls Shipping Costs per Truckload Boise Pocatello $560 $100 $60 $526 $370 $210 $104 $566 $614 $154 $144 $434 $94 $556 $634 $172 $526 $362 $308 $54 $384 $276