For the problem:

1. Formulate an LP model
2. Find the optimal solution by using Excel Solver and submit Excel Template with your solution results.
3. Provide an interpretation of the Sensitivity Report.

Problem 1. Bibbins Manufacturing produces softballs and baseballs for youth recreation leagues. Each softball costs $11 to produce and sells for $17 while each baseball costs $10.50 and sells for $15. The material and labor required to produce each item is listed here along with the availability of each resource. Amount Required Per Amount Resource Softball Baseball Available Leather 5 OZ 4 oz 6,000 oz Nylon 6 yds 3 yds 5,400 yds Core 4 oz 2 oz 4,000 oz Labor 2.5 min 2 min 3,500 min Stitching 1 min 1 min 1,500 min