Question: 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:

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. (10 Points)

b) What is the maximum profit from the optimal production? (10 Points)

Price: $2.99

Solution: The downloadable solution consists of 3 pages
Deliverable: Word Document