2. Wilson manufactures a special standard-size racket and a special oversize racket to be sold specifically during the U.S Open tournament in New York. The firms rackets are extremely light due to the use of magnesium-graphite alloy that was invented by the founder of Wilson. Each standard-size racket uses 0.125 kilograms of the alloy and each oversize racket uses 0.4 kilograms. Wilson only dedicates two-weeks of production time to manufacture both rackets scheduled just prior to the U.S. open tournament. Over that two-week production period, only 80 kilograms of the alloy will be available. Each standard-size racket uses 10 minutes of manufacturing time and each oversize racket uses 12 minutes. The profit contributions are $10 for each standard-size racket and $15 for each oversize racket, and 40 hours of manufacturing time are available each week. Management specified that at least 20% of the total production time must be dedicated to the standard-size racket.

Using your complete LP model, solve the problem using Microsoft Excel.

Max (Profit) $10S + $15V

s.t.

0.125S + 0.4V 80 (Kilograms of Alloy Available)

10S + 12V 4800 (Total Production Time)

10S 960 (Production Time Requirement for Standard Racket)

S, V 0

1. How many standard and oversized rackets should Wilson manufacture?

(b) What is the total maximum profit?