question archive 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
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 retums 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 I000,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 equationfformula 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: