II The case is below the questions. Read the case and answer the questions based on your Linear Programming Model and your Excel Solver solution. 1. Is Tom's objective to maximize impact or to minimize cost? Explain your position. Why are evening TV spots assigned a rating of 100? 2. How will you advise Tom to spend the money? (Use your Solver solution to interpret your decision variables). 3. Tom is willing to run more full-page ads if it is helpful. What would you advise him? Explain your position. Between running one more full-page ad in the daily (Monday through Saturday) paper as opposed to running one more full-page ad in the Sunday paper what would you advise him. Explain your position. 4. If you were the marketing consultant for Tom, would you have asked Tom to consider any other alternatives besides what Tom considered in the case? Explain your position. Case - Saving the Manatees: \"So how am I going to spend this money,\" thought Tom Wieboldt as he sat staring at the pictures and posters of manatees around his office. An avid environmentalist, Tom is the president of \"Friends of the Manatees,\" a non-profit organization trying to help pass legislation to protect manatees. Manatees are large, gray-brown aquatic mammals with bodies that taper to a flat, paddle-shaped tail. These gentle and slow-moving creatures grow to an average adult length of 10 feet and weigh an average of 1,000 pounds. Manatees are found in shallow, slow-moving rivers, estuaries, saltwater bays, canals, and coastal areas. In the United States, manatees are concentrated in Florida in the winter, but can be found in summer months as far west as Alabama and as far north as Virginia and the Carolinas. They have no natural enemies, but loss of habitat is the most serious threat facing manatees today. Most human-related manatee deaths occur from collisions with motor boats. Tom's organization has been supporting a bill before the Florida legislature to restrict the use of motor boats in areas known to be inhabited by manatees. This bill is scheduled to come up for a vote in the legislature. Tom recently received a phone call from a national environmental protection organization indicating that they are going to donate $300,000 to Friends of the Manatees to help increase public awareness about the plight of the manatees and to encourage voters to urge their representatives in the state legislature to vote for this bill. Tom intends to use this money to purchase various types of advertising media to "get the message out" during the four weeks immediately preceding the vote. Tom is considering several different advertising alternatives: newspapers, TV, radio, billboards, and magazines. A marketing consultant provided Tom with the following data on the costs and effectiveness of the various types of media being considered. Advertising Medium Half-page, Daily paper Full-page, Daily paper Half-page Sunday paper Full-page, Sunday paper Daytime TV spot Evening TV spot Highway Billboards 15-second Radio spot 30-second Radio spot Half-page, magazine Full-page, magazine Unit Cost $800 $1,400 $1,200 $1,800 $2,500 $3,500 Unit Impact Rating 55 75 65 80 85 100 $750 $150 $300 $500 $900 35 45 55 50 60 Case - Saving the Manatees: According to the marketing consultant, the most effective type of advertising for this type of problem would be short TV ads during the evening prime-time hours. Thus, this type of advertising was given a "unit impact rating" of 100. The other types of advertising were then given assigned unit impact ratings that reflect their expected effectiveness relative to an evening TV ad. For instance, a half-page magazine ad is expected to be have half the effectiveness of an evening TV ad and is therefore given an impact rating of 50. Tom would like to allocate the $300,000 to these different advertising alternatives in a way that will maximize the impact achieved. However, he realizes it is important to spread his message via several different advertising channels as not everyone listens to the radio and not everyone watches TV in the evenings. The two most widely read newspapers in the state of Florida are the Orlando Sentinel and the Miami Herald. During the four weeks prior to the vote, Tom would like to have half-page ads in the daily (Monday-Saturday) versions of each of these papers at least three times per week. He also wants to have one full-page ad in the daily version of each paper the week before the vote and he is willing to run more full-page ads if this would be helpful. He also wants to run full-page ads in the Sunday editions of each paper the Sunday before the vote. Tom never wants to run a full-page and half-page ad in a paper on the same day. So the maximum number of full and half page ads that can be run in the daily papers should be 48 (i.e., 4 weeks x 6 days per week x 2 papers = 48). Similarly, the maximum number of full and half-page ads that can he run in the Sunday papers is 8. Tom would like to have at least one and no more than three daytime TV ads every day during the four week period. He also wants to have at least one ad on TV every night but no more than two per night. There are ten billboards locations throughout the state that are available for use during the four week before the vote. Tom definitely wants to have at least one billboard in each of the cities of Orlando, Tampa, and Miami. Tom believes that the ability to show pictures of the cute, pudgy, lovable manatees in the print media offers a distinct advantage over radio ads. However, the radio ads are relatively inexpensive and may reach some people that the other ads will not reach. Thus, Tom would like to have at least two 15-second and at least two 30-second ads on the radio each day. However, he would like to limit the number of radio ads to five 15-second ads and five 30-second ads per day. There are three different weekly magazines in which Tom can run ads. Tom wants to run full-page ads in each of the magazines at some point during the four week period. However, he never wants to run full and half-page ads in the same magazine in a given week. Thus, the total number of full and half-page magazine ads selected should not exceed 12 (i.e., 4 weeks x 3 magazines x 1 ad per magazine per week = 12 ads). While Tom has some ideas about the minimum and maximum number of ads to run in the various types of media, he's not sure how much money this will take. And if he can afford to meet all the minimums, he's really confused about the best way to spend the remaining funds. So again "Tom asks himself, "How am I going to spend this money?" Section II The case is below the questions. Read the case and answer the questions based on your Linear Programming Model and your Excel Solver solution. 1. Is Tom's objective to maximize impact or to minimize cost? Explain your position. Why are evening TV spots assigned a rating of 100? 2. How will you advise Tom to spend the money? (Use your Solver solution to interpret your decision variables). 3. Tom is willing to run more full-page ads if it is helpful. What would you advise him? Explain your position. Between running one more full-page ad in the daily (Monday through Saturday) paper as opposed to running one more full-page ad in the Sunday paper what would you advise him. Explain your position. 4. If you were the marketing consultant for Tom, would you have asked Tom to consider any other alternatives besides what Tom considered in the case? Explain your position. Case - Saving the Manatees: \"So how am I going to spend this money,\" thought Tom Wieboldt as he sat staring at the pictures and posters of manatees around his office. An avid environmentalist, Tom is the president of \"Friends of the Manatees,\" a non-profit organization trying to help pass legislation to protect manatees. Manatees are large, gray-brown aquatic mammals with bodies that taper to a flat, paddle-shaped tail. These gentle and slow-moving creatures grow to an average adult length of 10 feet and weigh an average of 1,000 pounds. Manatees are found in shallow, slow-moving rivers, estuaries, saltwater bays, canals, and coastal areas. In the United States, manatees are concentrated in Florida in the winter, but can be found in summer months as far west as Alabama and as far north as Virginia and the Carolinas. They have no natural enemies, but loss of habitat is the most serious threat facing manatees today. Most human-related manatee deaths occur from collisions with motor boats. Tom's organization has been supporting a bill before the Florida legislature to restrict the use of motor boats in areas known to be inhabited by manatees. This bill is scheduled to come up for a vote in the legislature. Tom recently received a phone call from a national environmental protection organization indicating that they are going to donate $300,000 to Friends of the Manatees to help increase public awareness about the plight of the manatees and to encourage voters to urge their representatives in the state legislature to vote for this bill. Tom intends to use this money to purchase various types of advertising media to "get the message out" during the four weeks immediately preceding the vote. Tom is considering several different advertising alternatives: newspapers, TV, radio, billboards, and magazines. A marketing consultant provided Tom with the following data on the costs and effectiveness of the various types of media being considered. Advertising Medium Half-page, Daily paper Full-page, Daily paper Half-page Sunday paper Full-page, Sunday paper Daytime TV spot Evening TV spot Highway Billboards 15-second Radio spot 30-second Radio spot Half-page, magazine Full-page, magazine Unit Cost $800 $1,400 $1,200 $1,800 $2,500 $3,500 Unit Impact Rating 55 75 65 80 85 100 $750 $150 $300 $500 $900 35 45 55 50 60 Case - Saving the Manatees: According to the marketing consultant, the most effective type of advertising for this type of problem would be short TV ads during the evening prime-time hours. Thus, this type of advertising was given a "unit impact rating" of 100. The other types of advertising were then given assigned unit impact ratings that reflect their expected effectiveness relative to an evening TV ad. For instance, a half-page magazine ad is expected to be have half the effectiveness of an evening TV ad and is therefore given an impact rating of 50. Tom would like to allocate the $300,000 to these different advertising alternatives in a way that will maximize the impact achieved. However, he realizes it is important to spread his message via several different advertising channels as not everyone listens to the radio and not everyone watches TV in the evenings. The two most widely read newspapers in the state of Florida are the Orlando Sentinel and the Miami Herald. During the four weeks prior to the vote, Tom would like to have half-page ads in the daily (Monday-Saturday) versions of each of these papers at least three times per week. He also wants to have one full-page ad in the daily version of each paper the week before the vote and he is willing to run more full-page ads if this would be helpful. He also wants to run full-page ads in the Sunday editions of each paper the Sunday before the vote. Tom never wants to run a full-page and half-page ad in a paper on the same day. So the maximum number of full and half page ads that can be run in the daily papers should be 48 (i.e., 4 weeks x 6 days per week x 2 papers = 48). Similarly, the maximum number of full and half-page ads that can he run in the Sunday papers is 8. Tom would like to have at least one and no more than three daytime TV ads every day during the four week period. He also wants to have at least one ad on TV every night but no more than two per night. There are ten billboards locations throughout the state that are available for use during the four week before the vote. Tom definitely wants to have at least one billboard in each of the cities of Orlando, Tampa, and Miami. Tom believes that the ability to show pictures of the cute, pudgy, lovable manatees in the print media offers a distinct advantage over radio ads. However, the radio ads are relatively inexpensive and may reach some people that the other ads will not reach. Thus, Tom would like to have at least two 15-second and at least two 30-second ads on the radio each day. However, he would like to limit the number of radio ads to five 15second ads and five 30-second ads per day. There are three different weekly magazines in which Tom can run ads. Tom wants to run full-page ads in each of the magazines at some point during the four week period. However, he never wants to run full and half-page ads in the same magazine in a given week. Thus, the total number of full and half-page magazine ads selected should not exceed 12 (i.e., 4 weeks x 3 magazines x 1 ad per magazine per week = 12 ads). While Tom has some ideas about the minimum and maximum number of ads to run in the various types of media, he's not sure how much money this will take. And if he can afford to meet all the minimums, he's really confused about the best way to spend the remaining funds. So again "Tom asks himself, "How am I going to spend this money?"