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 advertisingbudget of PhP70,000,000.00. Provide forthe optimal solution.

Instructions:

a. Formulate the linear problem by identifying the decision variables.write down 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: