KLEIN INDUSTRIESKlein Industries is a manufacturing company that produces air compressors. Theproduction manager has tasked an analyst to figure out how many compressors the company canproduce to maximize profit. Solving this task requires the analyst to take all the constraints intoaccount. The constraints are projected demand, time spent by each department manufacturing acompressor, and how much time each department has available. In order to expedite the task from the production manager, the analyst will use Excelspreadsheets to calculate all the information. According to the information, profits are maximizedwhen Klein Industries produces 16,157 small compressors, 6,200 medium compressors, and2,600 large compressors. The small compressor nets a profit of $20.50. The medium sizecompressor nets a profit of $35.00, while the large compressor nets a profit of $42.00. Amemorandum to the production manager is drafted with information from the excel spread sheet.