Use any software to solve this problem by finding the( sensitity analysis) kacae

Question

Use any software to solve this problem by finding the( sensitity analysis)

kacae/bbcswebdav/pid-29697-dt-Content-rid-11 S225-1/courses ENG-341-1-FALL2017/Linear%20Programm n Case study4 Advertising modia selection Problem data Advertising media 1Friday- day Units of Cost of one view ine 400 2Saturday -day 3. Sunday- day rate of one view 5000 5500 5700 Friday-night 5. Saturday-night Sunday-nigh 480 500 550 8200 8400 Other relative elements Gost Determinaton of vwews frecords in order to maximize the total audience rate . Total avalable amount 45000 Maximum amount for Friday: 11000 Maximum amount for Saturday 14400 . Total daily iew number at least 20

Explanation / Answer

The above table states was done using MS Excel. First use the maximum day condition to get the cost of the day and calculate the day expenditurefor each day. Then calculate the remaining allocated amounts for Friday and Saturday. using this calculate the view for the night based on the maximum view condition. Using this view count which is multiplied by the expected view rate of 1 view we get the audience rate on each day and night. Thus the total maximized total audience rate is Euro 583,200. and the budget is Euro 39600.

cost of 1 view ex. Audience rate of 1 view views cost allocation expected audience Rate Fri day 400 5000 12 4800 60000 36 Sat day 450 5500 12 5400 66000 Sun day 450 5700 12 5400 68400 Fri night 500 7500 12 6000 90000 48 Sat night 500 8200 18 9000 147600 Sun night 500 8400 18 9000 151200 84 39600 583200

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.