Creative Sports Design (CSD) manufactures a standard-size racket and an oversize racket. The firm’s rackets are extremely light due to the use of a magnesium-graphite alloy that was invented by the firm’s founder. Each standard-size racket uses 0.125 kilograms of the alloy and each oversize racket uses 0.4 kilograms; over the next two-week production period only 80 kilograms of the alloy are 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 a total of 80 hours of manufacturing time is available over the two weeks. Marketing demands that at least 100 of the oversized rackets be produced this period even though CSD can sell as many rackets as they can produce in either size.
What would be the objective (goal) in this situation?
What would be the natural decision variables? (You must be explicit about the units of measure!)
Write out the formula that would be entered in cell G8.