Question: Illustrate in excel (for graphic) and step by step for upvote Thank you Ingalls Markets sell its own brand of canned corn as well as
Illustrate in excel (for graphic) and step by step for upvote
Thank you
- Ingalls Markets sell its own brand of canned corn as well as several national brands. The store makes a profit of $0.32 per can for its own corn and a profit of $0.22 for each can of corn for the national brands. The store can use up to 10 square feet of shelf space for canned corn and each can of corn takes up 10 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 80 cans on national brands of the shelf and she wants at least 25 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)
- What is the profit (value of the objective function) for the optimal solution?
- How many Ingalls cans should be placed on the shelf (based on the optimal solution)?
- How many national brand cans should be placed on the shelf (based on the optimal solution)?
- Is stocking the shelf with 20 Ingalls cans and 80 national brand cans feasible (not asking if it is optimal). Does it fall in the feasible region?
- Is stocking the shelf with 30 Ingalls cans and 70 national brand cans feasible (not asking if it is optimal). Does it fall in the feasible region?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
