View the step-by-step solution to:

Question

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.JPG


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?

Thanks

a.JPG

Top Answer

Decision variables Xj = the pounds of grain j (j = 1, 2, 3, 4) Used in the 8-ounce mixture... View the full answer

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question