A Company Can Make Three Size Luxury Blankets At Their Facility. Each Blanket …

     1. A company can make three size luxury blankets at   their facility. Each blanket requires   stuffing material, quilted material, cutting time and sewing time to   manufacture. The table below is the   production information for each size blanket:           Size Stuffing Quilted Cutting Sewing Profit   (LBS) Fabric Time Time Per     (sq. ft) (Minutes) (minutes) unit   Small 3 55 3 5 19   Medium 4 75 5 6 26   Large 6 95 6 8 32           Due   to production limits and market demands the constraints on production are:           1. A minimum of 120 units of each type of blanket must be   produced. You need at least 120 small,   120 medium and 120 large blankets.   2. Suppliers are limited to: 2,700 LBS of stuffing and 48,000 sq.   ft. of quilted fabric.   3. Labor is limited to: 50 hours of cutting time and 200 hours of   sewing time. That is 3,000 minutes of   cutting time and 12,000 minutes of sewing time.           Profits   for each blanket size are listed in the table.            a)   Based on the above information, what are the optimal production levels for   the blankets? Make sure to copy and   paste your Excel solver sheets into the solution. There is no need to use the   graphical method to do this problem.          b) What   is the maximum profit from the optimal production?