Graphing and Computation

1. 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:

Medium	Cost	Audience Reach
TVC	12,000,000	6,000,000
Radio	1,000,000	600,000

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

Instructions:

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

b. Create an algebraic equation/formula indicating the objective function, constraints, and non-negativity restriction (10 pts).

c. Find the feasible region and optimal solutions through graphical solution (10pts.).

2. Compute for the following What-if problem with constraints using MS Excel Solver:

Product type	Cost of goods	Fixed cost	Variable cost	Total Cost
Type A	3,132	3,500	867
Type B	5,343	3,500	567
Type C	4,577	3,500	545
Type D	2,234	3,500	532
Type E	4,563	3,500	345
Type F	1,234	3,500	643
Type G	978	3,500	345
Type H	6,546	3,500	699
Type I	8,001	3,500	765
Type J	7,342	3,500	754
			Total Cost

Total budget should not exceed total cost:

Variable cost should not exceed 1,000:

Fixed cost should be 3,500:

Total product type cost for each product type should not exceed 9,000: