A B D E F G H 1 For every problem: 2 1. 3 2. 4 Formulate an LP model Find the optimal solution by using Excel Solver and submit Excel Template with your solution results. 3. Provide an interpretation of the Sensitivity Report. 5 6 7 8 9 10 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. 11 12 13 Amount Required Per Amount 14 15 Resource Softball Baseball Available 16 17 18 Leather 5 oz 4 oz 6,000 oz 19 20 Nylon 6 yds 3 yds 5,400 yds 21 22 23 Core 4 oz 2 oz 4,000 oz 24 25 Labor 2.5 min 2 min 3,500 min 26 27 Stitching 1 min 1 min 1,500 min 28 29 30 31 32 33 34 25 K L M N