irst, we will create a plan for how you are going to handle the shipping of the cases from the port to each Distribution Center. The only additional twist is that we don't want to overship to any DC$.$ We will need to make sure that, as a minimum, we ship at least the number of cases in B$5$:B$12.$

To do that we will need to find out how many cases are actually shipped to each DC so that we can have something for the Solver to compare to B$5$:B$12.$ To do this, on the Distribution Plan sheet, in cells G$5$:G$12,$ for each DC$,$ create a formula that adds up the total number of cases sent to each DC$.$

In cell G$5$ create a formula that adds the total number of cases sent to each DC$.$