Develop a mathematical model for the following questions and solve them with Mic

Question

Develop a mathematical model for the following questions and solve them with Microsoft Excel and AMPL. You need to submit following files through TRACS for each question: 1. Report includes a. Mathematical model b. Screenshot of AMPL mod file c. Screenshot of AMPL run file d. Screenshot of AMPL model run and result 2. 3. 4. AMPL mod file AMPL run file Microsoft Excel File QUESTION1: A company wants to promote its products through various media environment. The advertisement budget is limited to $20,000 a month. Unit price of radio, TV, and social media advertisement costs 20, $250, $200. The company prefers to advertise on radio at least three times as much as on TV The company does not want to give more than 350 units of advertisement on radio. TV advertisement is 30 times more affective than radio advertisement and 2 times more affective than social media. The company wants to spend at least %20, %25, and %30 of its whole budget on radio, TV and social media. Develop a model to optimize the best budget allocation to different media to

Explanation / Answer

Let value on Radio advertisement be a, Value on TV advertsement = 30a; Value on social media= 15a

Let radio be X, TV be y and social media be Z

Mximize x+30y+15 z

such that

20x+250y+200z<=20000

x<=350

x>=20%*20000/20 or x>=200

y>=5000/250 or y>=20

z>=6000/200 or y>=30

x>=3y

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.