Question: Please create an LP model that i can apply to my excel problem and describe how i create it Find the optimal solution by using
Please create an LP model that i can apply to my excel problem and describe how i create it Find the optimal solution by using Excel Solver and submit Excel Template with your solution results. 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 Please solve problem so and explain how i can apply it to excel and properly format
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
