1. Find the optimal solution using Excel.

A manufacturer of travel pillows must determine the production plan for the next production cycle. He wishes to make at least 300 of each of the three models that his firm offers and no more than 1,200 of any one model. The specifics for each model are shown in the following table. How many pillows of each type should be manufactured in order to maximize total profit?

PILLOW MODEL SELLING PRICE CUTTING SEWING FINISHING PACKING $5.75 0.10 0.05 0.18 0.20 $6.95 0.15 0.12 0.24 0.20 Junior travel pillow Travel pillow Deluxe travel pillow Available hours Cost per hour $7.50 0.20 0.18 0.20 0.20 450 550 600 450 $7.00 $9.00 $8.50 $7.25 PILLOW MODEL SELLING PRICE CUTTING SEWING FINISHING PACKING $5.75 0.10 0.05 0.18 0.20 $6.95 0.15 0.12 0.24 0.20 Junior travel pillow Travel pillow Deluxe travel pillow Available hours Cost per hour $7.50 0.20 0.18 0.20 0.20 450 550 600 450 $7.00 $9.00 $8.50 $7.25