I have a Linear Programming question and I need help setting up equation in Exce

Question

I have a Linear Programming question and I need help setting up equation in Excel. The employer wants to derivie at least 20% of his total advertising impact from Evening Television advertisements. This question is from Spreadsheet Modeling and Decision Analysis by Ragsdale--Chapter 3 4C. Do I need to set up a new cell or do I use the existing cells and just come up with an excel equation?

I need help with setting up the equation in excel before running analytic problem solver. I know that this spreadsheet in not in excel but if you could help me by telling me which numbers to multiply by 20%, I can then run the analytic problem solver to find the answer. You assistance would be extremely helpful as I am stuck on this problem. Many thanks!

Advertising Medium Units Min Max Impact per unit Impact Total Cost per Unit Cost Total Half Page, Daily 0 24 48 55 0 $800 $0 Full Page, Daily 0 24 48 75 0 $1400 $0 Half Page, Sun 0 0 8 65 0 1200 $0 Full Page, Sun 0 4 8 80 0 $1800 $0 Daytime TV 0 12 84 85 0 $2500 $0 Evening TV 0 28 56 100 0 $3500 $0 Key Totals 0 TOTAL Total Budget $300,000

Explanation / Answer

The employer wants to derivie at least 20% of his total advertising impact from Evening Television advertisements.

Concentrate over Impact total column.

As we don't know no of units , we assumed those column values as A,B,C,D,E,F

Let's assume T = 100 then as per the given information , A+B+C+D+E = 80 & F= 20

Impact/unit for all types of advertising mediums is 460 out of those only 20% share should be for evening TV for not to cross the budget.

Therefore 460 * 20% = 92

But Impact/unit for Evening TV IS 100 but it should 92 to fulfil the budget constraint

ANSWER : Impact/unit total has to be multiplied by 20%

As a result share of impact total for evening TV will be = (A+B+C+D+E+F) *20%

Advertising medium Units Min Max Impact/unit Impact total Cost/unit($) Cost total($) Half page daily 0 24 48 55 A 800 -- Full page daily 0 24 48 75 B 1400 -- Half page Sun 0 0 8 65 C 1200 -- Full page Sun 0 4 8 80 D 1800 -- Daytime TV 0 12 84 85 E 2500 -- Evening TV 0 28 56 100 F 3500 -- Key totals Total = 460 Total = A+B+C+D+E+F Budget 300000

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

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