please help using spreadsheet

Unowing nutrients 04 nutrients per pound of feed: FEED NUTRIENT (OUNCES PER POUND OF VERD) A B C 3 2 1 6 2 3 0 4 1 2 Feed mix X Feed mix Y Feed mix Z nd $2.25 per Feed mixes X, Y, and Z cost $3, $4, and $2.25 pound, respectively. The minimum requirement cattle per day is 4 pounds of nutrient A, 5 pour of nutrient B, 1 pound of nutrient C, and 8 pound of nutrient D. The ranch faces one additional restrie tion: it can only obtain 500 pounds of feed mix 7 per day from the feed supplier regardless of its need Because there are usually 100 cattle at the feed lot at any given time, this means that no more than 5 pounds of stock Z can be counted on for use in the feed of each cattle per day. Formulate this problem as a linear program and solve it by using Excel. The production department for an aluminum valve plant is scheduling its work for next month. Each valve must go through three separate machines dur- ing the fabrication process. After fabrication, each valve is inspected by a human being, who spends 15 minutes per valve. There are 525 inspection hours available for the month. The time required (in hours) by each machine to work on each valve is shown in the following table. Also shown are the minimum number of valves that must be produced for the month and the unit profit for each valve. 6-38 CAPACITY (HOURS) PRODUCT Y231 Y242y784 7906 Unowing nutrients 04 nutrients per pound of feed: FEED NUTRIENT (OUNCES PER POUND OF VERD) A B C 3 2 1 6 2 3 0 4 1 2 Feed mix X Feed mix Y Feed mix Z nd $2.25 per Feed mixes X, Y, and Z cost $3, $4, and $2.25 pound, respectively. The minimum requirement cattle per day is 4 pounds of nutrient A, 5 pour of nutrient B, 1 pound of nutrient C, and 8 pound of nutrient D. The ranch faces one additional restrie tion: it can only obtain 500 pounds of feed mix 7 per day from the feed supplier regardless of its need Because there are usually 100 cattle at the feed lot at any given time, this means that no more than 5 pounds of stock Z can be counted on for use in the feed of each cattle per day. Formulate this problem as a linear program and solve it by using Excel. The production department for an aluminum valve plant is scheduling its work for next month. Each valve must go through three separate machines dur- ing the fabrication process. After fabrication, each valve is inspected by a human being, who spends 15 minutes per valve. There are 525 inspection hours available for the month. The time required (in hours) by each machine to work on each valve is shown in the following table. Also shown are the minimum number of valves that must be produced for the month and the unit profit for each valve. 6-38 CAPACITY (HOURS) PRODUCT Y231 Y242y784 7906