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 : Mathematical Method for Engineers The

     The function is clearly undefined at , but despite all of this the function does have a limit as approaches 0. a) Use MATLAB and ezplot to sketch for , and use the zoom on facility to guess the . You need to include you M-file, outp

  • Q : Budgeted cash disbursements The ABC

    The ABC Company, a merchandising firm, has budgeted its action for December according to the following information:

    • Sales at $560,000, all for cash.

    • The invoice cost for goods purc

  • Q : Relationships Between Data Introduction

    Relationships Between Data - Introduction to Linear Regression Simple Regression Notes

    If you need guidance in terms of using Excel to run regressions, check pages 1 - 10 of the Excel - Linear Regression Tutorial posted to th

  • Q : Properties for polynomial Specify the

    Specify the important properties for the polynomial.

  • Q : State Fermat algorithm The basic Fermat

    The basic Fermat algorithm is as follows:

    Assume that n is an odd positive integer. Set c = [√n] (`ceiling of √n '). Then we consider in turn the numbers

    c2 - n; (c+1)2 - n; (c+2)2 - n.....

    until a perfect square is found. If th

  • Q : What is Big-O hierarchy The big-O

    The big-O hierarchy: A few basic facts about the big-O behaviour of some familiar functions are very important. Let p(n) be a polynomial in n (of any degree). Then

    logbn is O(p(n)) and p(n) is O(an<

  • 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 : Statistics math Detailed explanation of

    Detailed explanation of requirements for Part C-1 The assignment states the following requirement for Part 1, which is due at the end of Week 4: “Choose a topic from your field of study. Keep in mind you will need to collect at least [sic] 3- points of data for this project. Construct the sheet y

  • 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 : Nonlinear integer programming problem

    Explain Nonlinear integer programming problem with an example ?

2015 ©TutorsGlobe All rights reserved. TutorsGlobe Rated 4.8/5 based on 34139 reviews.