Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Algebra and Trigonometry

Authors: Ron Larson

10th edition

9781337514255, 1337271179, 133751425X, 978-1337271172

More Books

Students also viewed these Mathematics questions

Question

25.0 m C B A 52.0 m 65.0 m

Answered: 1 week ago

Question

What are the principal alloying elements in SAE 4340 steel?

Answered: 1 week ago

Question

What are you curious about regarding Robert?

Answered: 1 week ago