Problem $4-$ Transshipment $-$ Grandma's Cheese Shed $(15\%)$

Your team has recently accepted a consulting role at Grandma's Cheese Shed and has been tasked with helping their

logistics department. Recently, Grandma's Cheese Shed has added two new cheeses as part of their "Grandmas Pack'n

HEAT" line of spicy foods, these two cheeses are 'Carolina Reaper' Cheddar and 'Heat is Real' Muenster. These new

cheese varieties have been so popular, Grandma's Cheese Shed has been struggling to keep them in stock. Your team

is tasked with producing a transportation model to find the lowest possible daily cost of shipping these new spicy cheeses

to the many cheese sheds scattered across Ohio.

The head of the logistics department has provided you with some information to help your team build the transportation

model. First, you are informed that while there are no capacity constraints associated with the company's two

warehouses in Columbus and Canton, the connections between the various cheese factories, warehouses, and cheese

sheds do have a limited capacity. The refrigerated trucks that will be used to ship the spicy cheeses must share space

with other products and therefore, each truck can only carry $1000$ blocks of spicy cheese at a time. You are also told that

each facility connection has one truck assigned to it that runs twice a day, with two deliveries being made. Second, you

are informed about an agreement that exists between Grandma's Cheese Shed and Trader Terry's, a large grocery store

chain in the Midwest. This agreement allows Grandma to sell her products in Trader Terry's if Grandma delivers the

products to Trader Terry's Distribution center. For each block of cheese delivered to Trader Terry's Distribution Center,

Grandma's Cheese Shed will earn $50$ cents. Furthermore, you are informed that $15\%$ of total spicy cheese sales are for

the 'Heat is Real' Muenster. Lastly, its not possible for Grandma to sell a partial block of cheese! Be sure to make this an

integer program.

In the template, the following variables represent the respective cheeses:

$A=$ 'Carolina Reaper' Cheddar

$B=$ 'Heat is Real' Muenster

The decision variable will work like so: X 'product type' $-$ 'start node' $-$ 'end node'

USE SOLVER AND EXCEL FORMULAS TO COMPLETE THE TABLE.