please show me steps if possible. Second image is the questions and example how it should be answered. thank you
Your company, Ziegler Promotions has been asked by the Department of Health and Human Services to develop promotional plans for their upcoming public service programs and seminars. Advertising alternatives include television, radio, and newspaper. The audience estimates, costs, and maximum media usage limitations are provided in the table below: Constraint Audience per advertisement Cost per advertisement Maximum media usage Television 250,000 $5000 30 Radio 36,000 $800 50 Newspaper 85,000 $1600 25 To ensure a balanced use of advertising media, radio advertisements must not exceed 50% of the total number of advertisements authorized. In addition, television should account for at least 10 % of the total number of advertisements authorized. The total amount allocated by the Department of Health and Human Services is $ 360,000 Part I Formulate a linear program to determine how many commercial messages should be run on each medium to maximize total audience contact. Note that you do not have to choose integer values for your decision variables that your decision variables Part II Develop an Excel spreadsheet to find the optimal allocation of advertisements. Part III Following the directions in the Task Outline, prepare a managerial report for the Health and Human Services detailing your recommendations. In your report, be sure to answer the following questions in the Summary of Major Results: What is the optimal allocation of advertisements? What is the expected maximum total audience contact? represents. Which of your constraints are binding? Do you have any non-binding constraints? Do you have any slack or surplus? List and identify them, the amounts, and what each (You may make a table for this if you have more than two non-binding constraints.) Which of your objective function coefficients has the smallest range of optimality? it mean? What does If you could change the right-hand-side value of one of the constraints, which one would you change and why? How much would you change it? What would be the new optimal solution and the new total audience contact? This original worksheet is submitted in your Summary 1. Define your decision variables. How many decision variables do you have? 2 Let A = the # of gallons of Product A B = the # of gallons of Product B 2. What is your objective in words)? To minimize the total product cost of Products A and B while meeting all of the managerial constraints What is your objective function (mathematical expression)? MIN 2 4_+3B where the cost per gallon of Product A is $2/gal and Product B is $3/gal 3. Define your constraints. How many constraints do you have? 4 Constraint # In Words and Units Mathematical Expression Demand for Product A, in gallons > 125 1 1A 2 Total product requirement for A and B, in gallons 14 +1B 2 350 3 Processing time allotted, in hours 24_+IB S 600 Non-negativity constraint 4.B 20
