For every problem:

1. Formulate an LP model
2. Find the optimal solution by using Excel Solver
3. Provide an interpretation of the Sensitivity Report

Problem 1

Problem 3

PROBLEM 2

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 A farmer in Georgia has a 100-acre farm on which to plant watermelons and cantaloupes. Every acre planted with watermelons requires 50 gallons of water per day and must be prepared for planting with 20 pounds of fertilizer. Every acre planted with cantaloupes requires 75 gallons of water per day and must be prepared for planting with 15 pounds of fertilizer. The farmer estimates that it will take 2 hours of labor to harvest each acre planted with watermelons and 2.5 hours to harvest each acre planted with cantaloupes. He believes that watermelons will sell for about $3 each, and cantaloupes will sell for about $1 each. Every acre planted with watermelons is expected to yield 90 salable units. Every acre planted with cantaloupes is expected to yield 300 salable units. The farmer can pump about 6,000 gallons of water per day for irrigation purposes from a shallow well. He can buy as much fertilizer as he needs at a cost of $10 per 50-pound bag. Finally, the farmer can hire laborers to harvest the fields at a rate of $5 per hour. If the farmer sells all the watermelons and cantaloupes he produces, how many acres of each crop should the farmer plant in order to maximize profits? PC-Express is a computer retail store that sells desktops and laptops. The company earns $600 on each desktop computer it sells and $900 on each laptop. The computers PCExpress sells are actually manufactured by another company. This manufacturer has a special order to fill for another customer and cannot ship more than 80 desktops and 75 laptops to PC-Express next month. The employees at PC-Express must spend about 2 hours installing software and checking each desktop computer the company sells. They spend roughly 3 hours to complete this process for laptop computers. PC-Express expects to have about 300 hours available for this purpose during the next month. The store's management is fairly certain that they can sell all the computers they order but are unsure how many desktops and laptops they should order to maximize profits