Plaid Design's has been featured in several home decorating websites and magazines. They recently have decided to outsource the production of several of their most common products so they have excess production time available to experiment with a new line of home budget-friendly products. They have requested your assistance to help them determine the optimal mix of products to produce given the excess production capacity that they have available.

The products that they have decided to include in this budget-friendly line include Pillows, Curtains, Runners, and Bedding. The number of minutes needed per product in each area is as follows:

	PRODUCT
PRODUCTION PROCESS	Pillows	Curtains	Runners	Bedding
Pressing machine	1	3	3	2
Cutting Machine	6	2	4	6
Sewing Machine	4	8	2	4
Inspection	1	2	1	1

The number of minutes available each week for each of the production processes are 3,000 minutes for the pressing machines, 4,700 minutes for the cutting machines, 5,200 minutes for the sewing machines, and 2,400 minutes for inspection. Based on early promotions, Plaid Design's has already secured the weekly orders for each product group. At a minimum, they will need to produce at least 300 pillows, 150 curtains, 375 runners, and 150 bedding sets.

The expected profit on each unit is as follows: Pillows $90, Curtains $120, Runners $150, and Bedding $110.

a.	Formulate a linear programming model for this problem.
b.	Solve your model using Excel Solver.
c.	How many of each product should be produced and what will the profit be?
d.	Any of the resource constraints have slack? If so, which one(s)? And how much?
e.	Which resource should the company work to increase: pressing machine time, cutting machine time, sewing machine time, and/or inspection time? Why?

Solve using Solver on excel Answer all questions in Excel