Question

M4.1 Ingalls Markets sell its own brand of canned corn as well as several national brands. The store makes a profit of $0.58 per can for its own corn and a profit of $0.46 for each can of corn for the national brands. The store can use up to 12 square feet of shelf space for canned corn and each can of corn takes up 9 square inches of shelf space. Ingalls brands always sell less than half as many cans compared to the national brand. The store manager wants to put no more than 50 cans on national brands of the shelf , and she wants at least 10 cans of Ingalls brands on the shelf. How many cans of Ingalls brand and national brands should they stock each week to maximize profit? Solve this problem using the LP Graphing utility. (Hint: 1 square foot = 144 square inches)

SOLUTION: The optimal solution, the value of the profit should be $37.50. Formulation:

Formulate this problem by defining decision variables, objective function, and constraints in standard format as specified/demonstrated in videos.

Questions:

1. a)  How many Ingalls cans should be placed on the shelf (based on the optimal solution)?

2. b)  How many national brand cans should be placed on the shelf (based on the optimal solution)?

3. c)  Is stocking the shelf with 20 Ingalls cans and 35 national brand cans feasible (not asking if it is

   optimal). Does it fall in the feasible region? Explain.

4. d)  Is stocking the shelf with 15 Ingalls cans and 40 national brand cans feasible (not asking if it is

   optimal). Does it fall in the feasible region? Explain.

Use the LP Template.xlsx provided to you in the Module Documents & Files. Place the formulation and answers to the questions in the appropriate text boxes. NOTE: Do not solve the problem in Excel – leave the Excel table blank. Submit the Excel file with your formulation and answers to the questions.

Answer 1

$IMG_20210618_080106.jpg$

$IMG_20210618_080127.jpg$

$IMG_20210618_080150.jpg$

$IMG_20210618_080218.jpg$