1. "Wimble Don Racquets Inc." is a manufacturer and seller of tennis racquets. They make four different models: Murray, Federer, Djokovic, and Nadal. Information about the production of these Racquets is in the following table: Murray Federer Djokovic Nadal Tennis Raquet Labour Labour ($17/hr) 1.5 $ 25.50 Composite Composite String String (hrs) (2) ($2/g) (cm) ($0.45/cm) 2 $ 4.00 4 $ 1.80 2 $ 34.00 3 $ 6.00 5 $ 2.25 2.5 $ 42.50 3 $ 6.00 6 $ 2.70 4 $ 68.00 3.5 $ 7.00 7 $ 3.15 Tennis Raquet Price Total Sales (Units) Murray $ 75.00 3000 Federer $ 85.00 4000 Djokovic $ 95.00 5000 Nadal $105.00 6000 Production is constrained by having only 14,500 hours of labour, 18,000 grams of composite (i.e. plastic), and 26,000 cm of string (i.e. nylon). Do the following using excel and solver and other functions. Please consider each independently and put each in a separate worksheet: vestigate a. Assuming there are no constraints, what is the profit? b. Assuming you must keep within the constraints, what is the optimal production amount of each model to maximize profits and what are the profits? c. Assuming you can reduce the labour hours required for the Djokovic and Nadal models to 2 hours, what is the optimal product per model and what is the profit? d. At what price level per racquet for the Nadal racquet would it just marginally result in the optimal solution being to produce only Nadal racquets and what would the profit be? Explain how you did this calculation. e. Assuming there is a labour shortage and only 8,000 hours of labour are available, what is the ontimal solution