The marketing department of Company TM is deciding on the number of months its advertising material be aired on television and radio, aside from its aggressive campaign on social media

Subject:MathPrice:4.87 Bought7

Share With

The marketing department of Company TM is deciding on the number of months its advertising material be aired on television and radio, aside from its aggressive campaign on social media. Production and airing cost for 1 month on TV is 12,000,000 whereas on radio, production and airing cost would amount to 1,000,000. To maximize returns which equates to increase in brand awareness, as mentioned, the company wants to compute for the number of months that would be allocated for both media given the following costs, and audience reach: 

The company has an advertising budget of PhP70,000,000.00. Provide for the optimal solution. 

Instructions:

Medium                              Cost                                     Audience Reach

TVC                                           12,000,000                  6,000,000

Radio                                        1,000,000                      600,000

a. Formulate the linear problem by identifying the decision variables. Make a table indicating the decision variables and constraints. Compute for the optimal solutions and total cost using MS Excel Solver .

b. Make an algebraic equation/formula indicating the objective function, constraints, and non-negativity restriction .

c. Find the feasible region and optimal solutions through graphical solution.