# three types of portable air compressors] in page 451 at the end of chapter 13 in your textbook, USA 5th edition. The data is given as part of the question. There is no external data set provided. Use what is given by the problem.?13-7.?Klein Industries manufactures three types of portable?air compressors: small, medium, and large, which have?unit profits of \$20.50, \$34.00, and \$42.00, respectively.?The projected monthly sales are:???????????????????Small?Medium?Large??Minimum?14,000?6,200?2,600??Maximum?21,000?12,500?4,200???The production process consists of three primary activities: bending and forming, welding, and painting. The amount of time in minutes needed to process each product in each department is shown below:?????????????????????????????????Small?Medium?Large?Available Time?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 many of each type of air compressor should the company produce to maximize profit???a.?Formulate and solve a linear optimization model using the auxiliary variable cells method and write a short memo to the production manager explaining the sensitivity information.??b.?Solve the model without the auxiliary variables and explain the relationship between the reduced costs and the shadow prices found in part a.?Solution Tip: You must use Solver tool in Excel. Set your constraints right, and fill in the solver dialogue box properly. Be sure to review links provided in the last lesson, or in one of the announcements in the first week of class. Here is a You Tube link you could view:?http://www.youtube.com/watch?v=Oyc0k9kiD7o?Also additional slides to explain basics and a basic example is attached. The example and slides are for demonstration and illustration purpose only to help practice how to use solver tool.Solution details:STATUS Answered QUALITY Approved ANSWER RATING This question was answered on: Apr 19, 2020 PRICE: \$15 Solution~000.zip (25.37 KB) Buy this answer for only: \$15 This attachment is locked × Please Enter The Email Where You Want To Receive Solution. Get this solution for only: \$

STATUS

QUALITY

Approved

Apr 19, 2020

EXPERT

Tutor

#### YES, THIS IS LEGAL

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

• As a reference for in-depth understanding of the subject.
• As a source of ideas / reasoning for your own research (if properly referenced)
• For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

### Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN A DEADLINE.