Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Extel Industries produces integrated circuit components for use in the next generation of automobiles. In particular, it can make the AT50 unit that can control

Extel Industries produces integrated circuit components for use in the next generation of automobiles. In particular, it can make the AT50 unit that can control the air temperature in the car, the V35 unit that monitors vibration and makes adjustments accordingly, and the GM30 that regulates the engine so that the car provides maximum efficiency. The unit profits on these units are $84, $112, and $126, respectively. Each of these units uses different quantities of three computer chips (as shown below), which Extel purchases from a Taiwanese distributor.

chips: (the materials)

C101 H122 P043

circuit: (the product) AT50 1 1 1

V35 1 1 2

GM30 1 2 1

Each week Extel receives 350 C101's, 300 H122's, and 400 P043's. Formulate a linear programming model and use excel solver to help Extel decide how many units of each product to produce weekly to maximize profit. (Decision variables, Objective function and constraints.)

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_2

Step: 3

blur-text-image_3

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

The Power Of Laws

Authors: Terence K Moloisane

1st Edition

B08Z7HTFTJ, B0CP2YDQDK

More Books

Students also viewed these General Management questions

Question

What is cost plus pricing ?

Answered: 1 week ago

Question

1. What are the types of wastes that reach water bodies ?

Answered: 1 week ago

Question

Which type of soil has more ability to absorb water?

Answered: 1 week ago