The Johnson brothers want to develop a model that can determine the optimal amount of

feedstock needed while minimizing the total cost. For this problem, we want Excel to

determine the amount of each specific food they should purchase daily. The objective will be

minimizing the total cost. Next, we need to determine the constraints. Here, the constraints

are maintaining minimum daily requirement$/$demand of each sheep.