please explain how to solve this

...Thire klem em.pdf Week 3 Solver Homework - Doing the Feed Mix Problem with Excel Solver Using Excel Solver to solve a LP problem You should review the two PowerPoint files for this week: Excel Solver Tutorial and Linear Programming. Excellent tips are in those files. The purpose is to use Microsoft Solver to find how much of two ingredients should be mixed into 100 pounds of grain. The goal is to duplicate the Bar Tender answer shown using Linear Programming in the PowerPoint file by using Solver. The problem statement is as follows: A farmer needs two food supplements for his cattle that need to be added to every 100 pounds of grain Each supplement contains different amounts of vitamins, proteins, and calcium HiPro costs $3.00 an ounce and Vita costs $4.00 per ounce Given the requirements below, we need to determine the number of ounces that will meet the requirements at minimum cost. HiPro Vita Required The problem statement is as follows: A farmer needs two food supplements for his cattle that need to be added to every 100 pounds of grain Each supplement contains different amounts of vitamins, proteins, and calcium HiPro costs $3.00 an ounce and Vita costs $4.00 per ounce Given the requirements below, we need to determine the number of ounces that will meet the requirements at minimum cost. HiPro Vita Required Vitamin 5 50 Protein 10 100 25 10 Calcium Thus, 1 ounce of HiPro contains 5 units of vitamin, 25 units of protein, and 10 units of calcium. One ounce of VITA contains 25 units of vitamin, 10 units of protein, and 10 units of calcium. How much of these supplements should we mix into every 100 pounds of grain at minimum cost? Submit your analytic solution in an Excel file with explanation of what it means when done. decade .com hemmelah