Answer Happy

3. Kroeger supermarket sells its own brand of canned peas as well as several national brands. The store makes a profit of $0.28 per can for its own peas and a profit of $0.19 for any of the national brands. The store has 6 square feet of shelf space available for canned peas, and each can of peas takes up 9 square inches of that space. Point-of-sale records show that each week the store never sells more than half as many cans of its own brand as it does of the national brands. The store wants to know how many cans of its own brand of peas and how many cans of the national brands to stock each week on the allocated shelf space to maximize profit, (a) Formulate a linear programming model for this problem. (b) Solve this model by using graphical analysis. (c) Solve this model using Excel Solver (include a printout of the spreadsheet).