--%>

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 assignments 1. Smith keeps

    1. Smith keeps track of poor work. Often on afternoon it is 5%. If he checks 300 of 7500 instruments what is probability he will find less than 20substandard? 2. Realtors estimate that 23% of homes purchased in 2004 were considered investment properties. If a sample of 800 homes sold in 2

  • Q : Explain a rigorous theory for Brownian

    Explain a rigorous theory for Brownian motion developed by Wiener Norbert.

  • Q : Problem on Fermats method A public key

    A public key for RSA is published as n = 17947 and a = 3. (i) Use Fermat’s method to factor n. (ii) Check that this defines a valid system and find the private key X.

    Q : Formal Logic It's a problem set, they

    It's a problem set, they are attached. it's related to Sider's book which is "Logic to philosophy" I attached the book too. I need it on feb22 but feb23 still work

  • Q : Row-echelon matrix Determine into which

    Determine into which of the following 3 kinds (A), (B) and (C) the matrices (a) to (e) beneath can be categorized:       Type (A): The matrix is in both reduced row-echelon form and row-echelon form. Type (B): The matrix

  • Q : Use MS Excel to do the computations

    Select a dataset of your interest (preferably related to your company/job), containing one variable and atleast 100 data points. [Example: Annual profit figures of 100 companies for the last financial year]. Once you select the data, you should compute 4-5 summary sta

  • Q : Research Areas in Medical Mathematical

    Some Research Areas in Medical Mathematical Modelling:1. Modeling and numerical simulations of the nanometric aerosols in the lower portion of the bronchial tree. 2. Multiscale mathematical modeling of

  • Q : Abstract Boolean Algebra I. Boolean

    I. Boolean Algebra Define an abstract Boolean Algebra, B,  as follows:  The three operations are:  +   ( x + y addition) ( x y multiplic

  • Q : Define Well-formed formulas or Wffs

    Wffs (Well-formed formulas): These are defined inductively by the following clauses:    (i) If  P  is an n-ary predicate and  t1, …, tn are terms, then P(t1, …, t

  • Q : Formulating linear program of an oil

    An oil company blends two input streams of crude oil products alkylate and catalytic cracked to meet demand for weekly contracts for regular (12,000 barrels) mind grade ( 7,500) and premium ( 4,500 barrels) gasoline’s . each week they can purchase up to 15, 000