Crombie supermarket sells its private label brand of canned peas as well as other national brands. The store makes a profit of $0.28 per can for its private label peas and a profit of $0.19 for any of the other 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. Analytics show that each week the store sells less than half as many cans of its private label brand as it does the other national brands. The store wants to know how many cans of its own brand of peas and how many cans of the other brands to stock each week on the allocated shelf space in order to maximize profits. a. Formulate the problem algebraically a linear programming model for this problem. b. Solve this problem using Excel.
Unitary Method
The word “unitary” comes from the word “unit”, which means a single and complete entity. In this method, we find the value of a unit product from the given number of products, and then we solve for the other number of products.
Speed, Time, and Distance
Imagine you and 3 of your friends are planning to go to the playground at 6 in the evening. Your house is one mile away from the playground and one of your friends named Jim must start at 5 pm to reach the playground by walk. The other two friends are 3 miles away.
Profit and Loss
The amount earned or lost on the sale of one or more items is referred to as the profit or loss on that item.
Units and Measurements
Measurements and comparisons are the foundation of science and engineering. We, therefore, need rules that tell us how things are measured and compared. For these measurements and comparisons, we perform certain experiments, and we will need the experiments to set up the devices.
Crombie supermarket sells its private label brand of canned peas as well as other national brands. The
store makes a profit of $0.28 per can for its private label peas and a profit of $0.19 for any of the other
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. Analytics show that each week the store sells less than half as many
cans of its private label brand as it does the other national brands. The store wants to know how many
cans of its own brand of peas and how many cans of the other brands to stock each week on the
allocated shelf space in order to maximize profits.
a. Formulate the problem algebraically a linear programming model for this problem.
b. Solve this problem using Excel.
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 5 images
