Ferdinand Feed Company receives four raw grains from which it blends its dry pet food. The pet food advertises
that each 1-lb packet meets the minimum daily requirements for vitamin C, protein and iron. The cost of each raw grain as well as the vitamin C, protein, and iron units per pound of each grain are summarized in Table 1.
Ferdinand is interested in producing the 1-lb packet at minimum cost while meeting the minimum daily requirements of 6 units of vitamin C, 10 units of protein, and 14 units of iron. The LP formulation to determine the optimal blend for Ferdinand Feed based upon the above requirements is given below.
a) Set-up the spreadsheet model and run Solver to find the optimal solution for LP formulated refinery problem.
b) Cleary label or identify the decision variables, objective function and constraints.
c) Find the optimal solution and generate the Answer and Sensitivity reports, them answer the questions on the first worksheet.
d) What would the required minimum cost for Grain 1 before we would include any in the final product mix?
e) What is the final raw material cost of the 1-lb mix? (give units and report final answer to three digits)
f) What would be the resultant cost of the 1-lb mix if we reduced the the iron requirement by 2 units?
g) How high could the cost of grain 2 be and still have our current optimal solution remain optimal?
It's a practice question for my quiz, but it's excel based type, can you help me how to solve it on excel?
Decision variables Xj = the pounds of grain j (j = 1, 2, 3, 4) Used in the 8-ounce mixture... View the full answer