Do not do problem 3 only 2,

ues excel solver if possible

Problem 2: Kilgore's Deli is a small delicatessen located near a major university. Kilgore's does a large walk-in carry-out lunch business. The deli offers two luncheon chili specials, Wimpy and Dial 911. At the beginning of the day, Kilgore needs to decide how much of each special to make (he always sells out of whatever he makes). The profit on one serving of Wimpy is $45, on one serving of Dial 911, $58. Each serving of Wimpy requires.25 pound of beef, 25 cup of onions, and 5 ounces of Kilgore's special sauce. Each serving of Dial 911 requires.25 pound of beef, .4 cup of onions, 2 ounces of Kilgore's special sauce, and 5 ounces of hot sauce. Today, Kilgore has 20 pounds of beef, 15 cups of onions, 88 ounces of Kilgore' 5 special sauce, and 60 ounces of hot sauce on hand. Develop an LP model that will tell Kilgore how many servings of Wimpy and Dial 911 to make in order to maximize his profit today and find the optimal solution. Problem 3: Edwards Manufacturing Company purchases two component parts from three different suppliers. The suppliers have limited capacity, and no one supplier can meet all the company's needs. In addition, the suppliers charge different prices for the components. Component price data (in price per unit) are as follows: Supplier Componenti 23 S12 S13 S14 SIOSII SIO Each supplier has a limited capacity in terms of the total number of components it can supply. However, as long as Edwards provides sufficient advance orders, each supplier can devote its capacity to component 1, component 2, or any combination of the two components, if the total number of units ordered is within its capacity. Supplier capacities are as follows: Supplier 1 2 3 Capacity 600 1000 800