Solve Problem and Applications: ch 13- prob 7 [Klein Industries manufactures three patterns of movable air compressors] in page 451 at the end of section 13 in your textbook, USA 5th edition. The facts is absorbed as portio of the inquiry. There is no apparent facts set supposing. Use what is absorbed by the substance.

13-7.  Klein Industries manufactures three patterns of movable air compressors: narrow, average, and great, which have unit avail of \$20.50, \$34.00, and \$42.00, respectively. The designed monthly sales are:

Small  Medium  Large

Minimum  14,000   6,200  2,600

Maximum  21,000  12,500  4,200

The origination manner consists of three important activities: elastic and forming, welding, and painting. The total of season in minutes needed to manner each result in each division is shown below:

Small  Medium  Large  Available Season   Bending/forming            0.4       0.7       0.8       23,400

Welding                       0.6       1.0       1.2       23,400

Painting                       1.4       2.6       3.1       46,800

How manifold of each pattern of air compressor should the union consequence to maximize benefit-service?

a.  Formulate and reresolve a straight optimization pattern using the accessory fickle cells mode and transcribe a soon memo to the origination supervisor interpreting the sensitivity knowledge.

b.  Solve the pattern outside the accessory fickles and interpret the kindred betwixt the subsided costs and the reflection prices endow in portio a.

Solution Tip: You must use Solver utensil in Excel. Set your constraints fair, and swell in the resolver tete-a-tete box correctly. Be safe to resurvey couples supposing in the ultimate instruction, or in one of the announcements in the principal week of assort. Here is a You Tube couple you could view: http://www.youtube.com/watch?v=Oyc0k9kiD7o

I HAVE ATTACHED A SAMPLE SOLUTION OF SOLVER TITLED. SOLVER.XLSX, CROSS CHECK YOUR SOLUTION WITH THIS SOLUTION TO GIVE YOU AN IDEA OF WHAT IS REQUIRED. DON'T FORGET THE FIRST QUSTION ASKS YOU TO WRITE A SHORT MEMO AFTER SOLVING QUESTION A THEN AFTER SOLVING QUESTION B.

ABSOLUTELY NO PLAGIARISM.