You have just been hired as an advertising manager for a generic advertising program for dairy farmers, Dairy Management, Inc. (DMI). DMI wants to conduct generic advertising to increase the demand for milk. DMI decided to consider TV, radio, print, and outdoor advertising and wants you to determine how much money should be allo- cated for each type of media for the next month. You expect that one TV commercial will increase sales by 25,000 gallons; one radio commercial will increase sales by 7,000 gallons; one print advertisement will increase sales by 3,500 gallons; and one billboard will increase sales by 5,000 gallons. It costs $10,000 per TV commercial, $5,000 per radio commercial, $1,000 per print advertisement, and $3,500 per bill- board. Your boss tells you that you can't spend more than $500,000 on this project. Furthermore, the radio and TV stations tell you they have a combined maximum of 45 minutes for your commercials for the month
Each TV commercial takes 1 minute, and each radio commercial takes 0.5 minutes to air. The boss tells you that he doesn't want more than 25 TV commercials because he gets sick of watching the same thing over and over again. The objective is to find the combination of TV, radio, print, and billboard advertisements that maximizes milk sales. Solve this problem with Solver. Report and analyze the solution.