You have to set up an advertising campaign and selected four types of advertising: TV, Radio, Billboards
Question:
You have to set up an advertising campaign and selected four types of advertising: TV, Radio, Billboards and Newspapers. A summary of information for the formulation of a LP formulation is as follows: the cost for each advertising type, the smallest number of audience to be reached for each advertising type, and the minimum number of advertisements for each advertising type:
Additional information:
- (A) There should be not more than six ADS on TV or Radio or some combination of the two.
- (B) Amount spend on billboards and newspapers must be at least the amount spend of TV AD's.
- (C) Amount spend on TV and Radio must not exceed 50% of the expenditure on Billboards.
- (D) Monthly budget for advertising is R15 000.00. You are requested to use the entire budget.
a) Formulate the above scenario into a LP solution to show how many AD's should you place to maximize the total number of people reached. (19)
Question 2 (17 marks)
You are a dietician for the local soccer team. You want to determine a balanced nutritional lunch for all players participating in soccer practice. The following is the national nutritional accepted requirements for a proper lunch for athletes:
- Calories - between 900 and 1500
- Iron - at least 5 MG
- Fat - no more than 50 GM's
- Protein - at least 26 GM's
- Carbohydrates - between 30 and 60 GM's
You select a menu from 7 basic food items with corresponding national nutritional value for each food item. It is summarized as follows:
Spreadsheet Modeling & Decision Analysis A Practical Introduction to Management Science
ISBN: 978-0324656633
5th edition
Authors: Cliff T. Ragsdale