Given the increase in remote work and the popularity of business casual, a popular clothing manufacturer decided to discontinue their women's professional career separates clothing line.

With this change in focus, they need to determine the optimal allocation of the excess production capacity. Management will devote this excess capacity to the following products: pants, tops, dresses, and skirts. The time (in minutes) required for production per unit is as follows:

	PRODUCT
MACHINE TYPE	Pants	Tops	Dresses	Skirts
Pressing machine	0.5	1.5	1.5	1.0
Cutting Machine	3	1	2	3
Sewing Machine	2	4	1	2
Inspection	0.5	1.0	0.5	0.5

The available time in each area in minutes per week is 1,500 minutes for the pressing machine, 2,350 minutes for the cutting machine, 2,600 minutes for the sewing machine, and 1,200 minutes for inspection. According to the sales team, there are already existing weekly orders for each product group so the minimum production level will be 150 pants, 100 tops, 200 dresses, and 400 skirts.

Based on past sales data, the profit on each unit is as follows: Pants $9, Tops $12, Dresses $15, and Skirts $11.

a.	Formulate a linear programming model for this problem.
b.	Solve your model using Excel Solver.
c.	How many of each kind of clothing should be produced and what will the profit be?
d.	Does 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. Answer all questions in Excel and then upload your completed Excel file here.