M3_IND3. A snack company packages and sells three different canned party mixes that contain a total of 1 lb. of nuts. These three different products (Plain Nuts, Mixed Nuts, and Premium Mix) include a mix of four possible types of nuts (peanuts, cashews, almonds, and walnuts). The table below show the number of Ibs. of each ingredient in each product type, the amount of ingredient available, and the revenue generated by selling each type of product. What should their production plan be to maximize their revenue? There is on additional piece of information that impacts their production plan and should be included in your formulation. Past demand indicates customers purchase at least three times as many cans of Plain Nuts as Mixed Nuts. Your formulation should include a constraint that states that the number of cans of Plain Nuts produced should be at least three times the number of cans of Mixed Nuts produced. Formulate and solve the problem in Excel to determine the number of each product to produce that meets the requirements and maximizes revenues. (Note: Consider this an average amount of cans produced - the number of cans does not need to be an integer). PRODUCT INGREDIENTS PLAIN MIXED PREMIUM INGREDIENT NUTS NUTS MIX AVAILABILITY (Ibs.) PEANUTS (lbs./can) 0.8 0.25 500 CASHEWS (lbs./can) 0.2 0.25 0.2 300 ALMONDS (Ibs./can) 0.25 0.4 120 WALNUTS (lbs./can) 0.25 0.4 100 REVENUE ($/UNIT) $2.25 $5.65 $7.85 a) What is the maximum revenue based on your optimal solution (the value of the objective function)? b) How many cans of Plain Nuts should be produced based on your optimal solution (enter two decimal places)? c) How many cans of Mixed Nuts should be produced based on your optimal solution (enter two decimal places)?? d) How many cans of Premium Mix should be produced based on your optimal solution (enter two decimal places)?? e) After producing the number of cans of each product as suggested in your optimal solution, which of the ingredients has not been totally used by your production plan