A Company Is Considering Various Advertising Media to Promote Its

question 14

Essay

A company is considering various advertising media to promote its new toy.Pertinent information regarding potential customers reached and costs per advertisement is given below:
$\begin{array}{lccc} & \text { No. of Customers } \\\text { Media } & \begin{array}{c}\text { Maximum Times } \\\text { Reached }\end{array} & \begin{array}{c}\text { Cost per } \\\text { Available per Month }\end{array} & \text { Advertisement } \\ \text { Daytime TV } & 1000 & 10 & \$ 2000 \\\text { Evening TV } & 3000 & 8 & \$ 3500 \\\text { Daytime Radio } & 500 & 15 & \$ 1000 \\\text { Evening radio } & 750 & 15 & \$ 1500 \\\text { Newspaper } & 900 & 4 & \$ 500\end{array}$

Currently,the company has a monthly advertising budget of $150,000.The marketing department has imposed the following restrictions:
•No more than $20,000 may be spent on radio advertising each month.
•At least 5 TV ads must be used each month.
Use Excel to formulate and solve this problem to maximize monthly audience exposure.

---

Definitions:

Appointments

Scheduled events or meetings, often entered into a calendar or schedule book, indicating a commitment at a particular time.

Calendar Items

Events, appointments, or tasks scheduled on a calendar that help users organize their time and activities.

iCalendar File

A digital file format used to store and share calendar event details across different applications and platforms.

Recurring Event

An event that happens regularly according to a predetermined schedule, often seen in calendar applications.