--%>

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 : Test Please read the assignment

    Please read the assignment carefully and confirm only if you are 100% sure. Please go through below mentioned guidelines and penalties: • Your solution must be accurate and complete. • Please do not change Subject Title of the Email. • Penalty clause will be applied in case of delayed or plag

  • Q : Examples of groups Examples of groups:

    Examples of groups: We now start to survey a wide range of examples of groups (labelled by (A), (B), (C), . . . ). Most of these come from number theory. In all cases, the group axioms should be checked. This is easy for almost all of the examples, an

  • Q : Problem on mass balance law Using the

    Using the mass balance law approach, write down a set of word equations to model the transport of lead concentration. A) Draw a compartmental model to represent  the diffusion of lead through the lungs and the bloodstream.

  • Q : Who derived the Black–Scholes Equation

    Who derived the Black–Scholes Equation?

  • 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 : Global And Regional Economic Development

    The Pharmatec Group, a supplier of pharmaceutical equipment, systems and services, has its head office in London and primary production facilities in the US. The company also has a successful subsidiary in South Africa, which was established in 1990. Pharmatec South A

  • Q : Who firstly use the finite-difference

    Who firstly use the finite-difference method?

  • Q : Define terms Terms : Terms are defined

    Terms: Terms are defined inductively by the following clauses.               (i) Every individual variable and every individual constant is a term. (Such a term is called atom

  • 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 : Explain a rigorous theory for Brownian

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