The Texas Electronics Company (TEC) is contemplating a research and development program encompassing eight major projects. The company is constrained from embarking on all projects by the number of available scientists, which is 40, and the budget constraint, which is $300,000. Following are resource requirements and the estimated profits for each project: Project Expense($000) Scientists Required Profit ($000)
1 60 7 36
2 110 9 82
3 53 6 29
4 147 4 16
5 192 7 56
6 185 6 61
7 173 8 48
8 165 5 41
Formulate this problem using integer programming.
Solve it using excel. (Hint: in excel, assign integer constraint to decision variables by selecting "int" when selecting integer constraints)
What is the maximal profit? Which projects should be selected?
Suppose the management team decides that project 2 and project 5 are mutually exclusive, what it the revised formula? What is the revised maximal profit? What is the revised projected selected?
Suppose the management team also decides to undertake at least two of the projects involving consumers products (these happens to be projects 5-8). Then what is the revised formula? What is the revised maximal profit? What is the revised projected selected?

937373839828282828828288

Explanation:

2,,nm,ad,fnklwflwrngkreerwjkf,mfw,;

sound is invisible, but sometimes we can feel it. when a kettle-drum is thumped with a stick that time the tight drum skin moving up and down very quickly for some time and then it pumped sound waves into the air. loudspeakers also work in a similar manner.

components of a speaker:

electromagnet

in order to translate an electrical signal into an audible sound, an electromagnet is used in looudspeakers

  suspension

suspension is used to   center the voice coil in the gap of the magnet and it exerts a restoring force to keep it there. suspension is used to limits the maximum mechanical excursion of the diaphragm and voice coil.

voice coil

voice coil is a coil of wire which is attached to the apex of a loudspeaker cone. it provides the motive force to the cone by the reaction of a magnetic field to the current passing through it.

cone

in a   loudspeaker, a   thin, semi-rigid membrane attached to the voice coil, which moves in a magnetic gap due to which it vibrates   and produced sound. it is known as diaphragm and it can also be called a cone, though not all speaker diaphragms are cone-shaped.

surround

surround is also known as front suspension. surround is used to join the cone to the chassis. together with the suspension it controls the cone excursion, and it is also used to   determine how energy which is   travelling through the cone is absorbed, and how the speaker limits when it reaches the ends of its travel.

dustcap

dustcap is used to protect the voice coil from dust and dirt. it is a part of the cone.

how speaker work

the outer part of the cone is fastened to the outer part of the loudspeaker's circular metal rim. the inner part is fixed to   voice coil that sits just in front of a permanent magnet . when loudspeaker is hooked up to a stereo, electrical signals feed through the speaker cables into the coil. it will convert the coil into an electromagnet magnet . when electricity flows back and forth in the cables, the electromagnet either repels or attract the permanent magnet. this moves the coil back and forth, and it pull and push the loudspeaker cone. like a drum skin vibrating back and forth, the moving cone pumps sounds out into the air.in this way loudspeakers works.