Question
A company produces two types of soap (A & B). Based on an analysis of current inventory levels and potential demand for the coming month,
A company produces two types of soap (A & B). Based on an analysis of current inventory levels and potential demand for the coming month, M&D's management specified certain constraints that must be placed on total production, processing time, and demand. M&D's objective is to satisfy these requirements at a minimum total production cost. Production costs are$2 per bar of soap for product A and $3 per bar of soap for product B. To find the minimum-cost production schedule, we arrive at the following linear program:
LetA= number of bars of soap for product A.
LetB= number of bars of soap for product B.
Minimize | 2A + 3B | |||
Subject to | ||||
1A | 125 | Demand for product A (number) | ||
1A + 1B | 350 | Total production (number) | ||
2.5A+ 1B | 600 | Processing time (minute) | ||
A,B | 0 & integer |
Using integer linear programming in Excel, find the optimal number of products A and B that should be produced to minimize the production costs. What is the optimal value of the objective function?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started