I need help with the following problem, specification is under the problem.

1. Formulate a suitable linear programming model, specify the meaning of the decision variables and the units of measurement.

2. Comment on how realistic the (proportionality, additivity, etc.) assumptions of an LP model are in this situation.

3. Find an optimal solution to the mathematical model by using Excel. Interpret the optimal solution in context of the decision situation. Include the solution and sensitivity reports from Excel.

Thank you for your help in advanced

26. HEALTH FOODS. Health Valley Foods produces three types of health food bars in two-ounce sizes: the Go Bar, the Power Bar, and the Energy Bar. The Energy Bar also comes in an 8-ounce size. The three main ingredients in each bar are a protein concentrate, a sugar substitute, and carob. The recipes for each bar in terms of percentage of ingredients (by weight) and the daily availabilities of each of the ingredients are as follows. Bar GO Power Energy Daily availability % Protein Concentrate 20 50 30 600 lbs. % Sugar Substitute % Carob 60 20 30 20 10 30 1000 lbs. . 800 lbs. The following costs are incurred in the production of the health food bars: Labor and packaging (2-oz, bars) Labor and packaging (8-oz. bars) Protein concentrate Sugar substitute Carob Costs S0.03/bar $0.05/bar $3.20/1b. $1.40/1b. S2.60/1b. Health Valley's wholesale selling prices to health food stores are $0,68, S0.84, and $0.76, respectively, for 2-ounce sizes of the Go Bar, the Power Bar, and the Energy Bar, and $3.00 for the 8-ounce Energy Bar, The company has facilities for producing up to 25,000 2-ounce bars and 2000 8-ounce bars daily. It manufactures at least 2500 of each of the 2-ounce bars daily. No 2-ounce bar is to account for more than 50% of the total production of 2-ounce bars, and the total production (by weight) of Energy Bars is not to exceed more than 50% of the total production (by weight). Determine an optimal daily production schedule of health food bars for Health Valley Foods