This assignment focuses on Lecture # 4 and 5 and particularly using Linear programming Method. Please answer the 3 questions and show all your work in detail:

1. Defining and describe your variables clearly with explanations of why you think they are the variables 2. Develop your objective function and how it is related to its variables. (show it mathematically) 3. Determine what are you trying to achieve: Maximize or Minimize? 4. What are your constraints? Explain them in words and write them mathematically 5. Attached Excel file showing how you used the Solve function to achieve your result. Question 1. [5 Marks] Rodolfo Barreto, the Marketing Director at LOV Brazil, is deciding how to best utilize the advertising budget for one of his newest accounts. The client has provided him with $1,972,000 to spend and asked for the ads created by LOV to be placed on a variety of marketing channels. After some research, Rodolfo picked eleven candidate channels and put together the following table with their estimated exposure (in thousands of people reached, according to Nielsen data), and cost per ad placement (in $1000) Refer to the previous problem and consider these additional requirements, one at a time: We want to advertise on at most four channels. If we advertise on channel 2, then we also have to advertise on channel 3. If we advertise on channel 6, then we cannot advertise on channel 8. If we advertise on channels 3 and 4, then we must also advertise on channel 10. The client wants exactly one magazine ad and one radio ad.

Question 1. [5 Marks] Rodolfo Barreto, the Marketing Director at LOV Brazil, is deciding how to best utilize the advertising budget for one of his newest accounts. The client has provided him with $1,972,000 to spend and asked for the ads created by LOV to be placed on a variety of marketing channels. After some research, Rodolfo picked eleven candidate channels and put together the following table with their estimated exposure (in thousands of people reached, according to Nielsen data), and cost per ad placement (in \$1000) Refer to the previous problem and consider these additional requirements, one at a time: - We want to advertise on at most four channels. - If we advertise on channel 2 , then we also have to advertise on channel 3. - If we advertise on channel 6 , then we cannot advertise on channel 8. - If we advertise on channels 3 and 4 , then we must also advertise on channel 10. - The client wants exactly one magazine ad and one radio ad