--%>

Formulating linear program of a Software company

A software company has a new product specifically designed for the lumber industry. The VP of marketing has been given a budget of $1,35,00to market the product over the quarter. She has decided that $35,000 of the budget will be spent promoting the product at the national trade show in New Orleans which will be held during this planning quarter.

Because eh product targets a specialized audience the VP has ruled out television radio and mainstream magazine advertisements. Instead she has decided to promote the product using black and white (B &W) and color ads in some or all of the followings specialized publications: Building today lumber weekly and timber world building today is a week day trade newspaper that accepts both full page and half page black and white advertising. Lumber weekly and timber world are glossy magazines that run both black and white and color ads. The VP and her staff have decided to run only full page ads in these last two publications. The circulation and advertising cost data for each outlet is summarized in the following table:

1758_softyarwe.jpg

After a discussion of the potential advertising the marketing team made the following judgment:

• A maximum of one ad should b placed in any one issue of any of the trade publications during the quarter:
• At least 50 full page ads should appear during the quarter:
• At least eight color ads should appear during the quarter:
• One ad should appear in each issue of timber world:
• At least four weeks of advertising should be placed in each of the building today and lumber weekly publications:
• No more than $40,000 should be spent on advertising in any one of the trade publications.

Formulate a linear programming model that will provide the VP and her marketing staff a marketing plan for the next quarter to maximize audience exposure for their new software product.

Implement your formulation in excel and find the optimal solution using solver. Sum marize your solution (decision variable values and objective function value ) below your formulation.

   Related Questions in Mathematics

  • Q : Probability and Stochastic assignment

    Introduction to Probability and Stochastic Assignment 1: 1. Consider an experiment in which one of three boxes containing microchips is chosen at random and a microchip is randomly selected from the box.

  • Q : Set Theory & Model of a Boolean Algebra

    II. Prove that Set Theory is a Model of a Boolean Algebra The three Boolean operations of Set Theory are the three set operations of union (U), intersection (upside down U), and complement ~.  Addition is set

  • Q : Pig Game Using the PairOfDice class

    Using the PairOfDice class design and implement a class to play a game called Pig. In this game the user competes against the computer. On each turn the player rolls a pair of dice and adds up his or her points. Whoever reaches 100 points first, wins. If a player rolls a 1, he or she loses all point

  • Q : Elasticity of Demand For the demand

    For the demand function D(p)=410-0.2p(^2), find the maximum revenue.

  • Q : Abstract Algebra let a, b, c, d be

    let a, b, c, d be integers. Prove the following statements: (a) if a|b and b|c. (b) if a|b and ac|bd. (c) if d|a and d|b then d|(xa+yb) for any x, y EZ

  • Q : Problem on inverse demand curves In

    In differentiated-goods duopoly business, with inverse demand curves: P1 = 10 – 5Q1 – 2Q2P2 = 10 – 5Q2 – 2Q1 and per unit costs for each and every firm equal to 1.<

  • Q : How do it? integral e^(-t)*e^(tz) t

    integral e^(-t)*e^(tz) t between 0 and infinity for Re(z)<1

  • Q : Solve each equation by factoring A

    A college student invested part of a $25,000 inheritance at 7% interest and the rest at 6%.  If his annual interest is $1,670 how much did he invest at 6%?  If I told you the answer is $8,000, in your own words, using complete sentences, explain how you

  • Q : Law of iterated expectations for

     Prove the law of iterated expectations for continuous random variables. 2. Prove that the bounds in Chebyshev's theorem cannot be improved upon. I.e., provide a distribution that satisfies the bounds exactly for k ≥1, show that it satisfies the bounds exactly, and draw its PDF. T

  • Q : What is Non-Logical Vocabulary

    Non-Logical Vocabulary: 1. Predicates, called also relation symbols, each with its associated arity. For our needs, we may assume that the number of predicates is finite. But this is not essential. We can have an infinite list of predicates, P