1. Lets revisit Kelson Sporting Equipment, Inc.. They makes two different models of baseball gloves: a regular glove and a catchers mitt. The LP model to maximize profit is:

.

Let x = number of regular gloves to produce; (1 point)

y = number of catchers gloves to produce. (1point)

Maximize P= 5X+8Y (2 points)

Subject to: ( 1 point each)

X + 1.5Y 900 cutting & sewing time

0.5X + 1/3Y300 finishing time

0.125X + 0.25Y 100 Packaging and shipping time

X - 3Y0 Ratio

X,Y0

1. Use Solver to solve the problem.

1)Attach a screen shot of the spreadsheet model with the solver parameters.

2)Attach a screenshot of your spreadsheet model with the solution

3) Attach a screen shot of the answer report..

When using Solver, set up your spreadsheet model with names for decision variables, objective functions, and constraint.. Remember to show the headers for columns and rows and the gridlines as covered in class.

b)State the optimal mix that Solver recommends to minimize costs

2. Fancy Furniture operates production factories in Burnside and Yarmouth. The two products made at both plants are Sectional and Regular sofas. The products have many similarities in their manufacturing, but the equipment and labor skills at the two plants differ. Two critical resources that are in limited supply are labor for assembly and sewing time. Information about the products, plants and resources is summarized below. (Total question 21 points)

	Burnside		Yarmouth
	Sectional	Regular	Sectional	Regular
Assembly hours/unit	89	82	93	87
Sewing hours/unit	90	85	102	95
Profit	2500	2100	2100	1900

Resource availability	Burnside	Yarmouth
Assembly hours	6000	5500
Sewing hours	25000	20000

Develop a production plan to assist Fancy furniture so that they maximize their profits.

1. Formulate the linear programming model.

2. Use Solver to solve the problem.

1)Attach a screen shot of the spreadsheet model with the solver parameters.

2)Attach a screenshot of your spreadsheet model with the solution

3) Attach a screen shot of the sensitivity report..

When using Solver, set up your spreadsheet model with names for decision variables, objective functions, and constraint.. Remember to show the headers for columns and rows and the gridlines as covered in class.

3. State the production plan that Solver recommends to maximize profit.

4. Which constraints are binding?