Formulate the linear programming model , Assembly Language

Print Media Advertising (PMA) has been providing a contract to market Buzz Cola via newspaper ads in a main southern newspaper. Full-page ads in the weekday editions (Monday through Saturday) cost $2000, while on Sunday a full-page ad costs $8000. Daily circulation of newspaper is 30,000 on weekdays and 80,000 on Sundays.

PMA has been provides a $40,000 advertising budget for the month of August. The experienced advertising executives at PMA feel which both weekday and Sunday newspaper ads are significant; hence they wish to run the equivalent of at least eight weekday and at least two Sunday ads during August. (Assume that a fractional ad would simply mean that a smaller ad is placed on one of the days; which is, 3.5 ads would mean three full-page ads and one half-page ad. Also, suppose that smaller ads reduce exposure and costs proportionately.) This August has 26 weekdays and 5 Sundays.

The goal is to determine the optimal placement of ads by PMA in the newspaper during August so as to maximize the cumulative total exposure (as measured by circulation) for the month of August.

a)  Formulate the linear programming model for the problem.

b)  Use the Graphical method to find the optimal solution. Show all steps.

c)  Use Excel Solver to find the optimal solution. Copy and paste your spreadsheet and the Answer report in its entirety from Excel. Remember to not delete/modify any part of the Answer Report.

Here is how the spreadsheet was set up for Excel Solver. The spreadsheet shows 10 weekdays and 10 for Sundays.  These numbers were selected arbitrarily. Any quantities can be entered weekdays and Sundays since Excel Solver would find the optimal solution anyway.

Posted Date: 4/1/2013 5:34:25 AM | Location : United States

Related Discussions:- Formulate the linear programming model , Assignment Help, Ask Question on Formulate the linear programming model , Get Answer, Expert's Help, Formulate the linear programming model Discussions

Write discussion on Formulate the linear programming model
Your posts are moderated
Related Questions
Program Translation Sequence Developing a software program to accomplish a particular task, the implementer chooses an appropriate language, develops the algorithm (a sequence


need some project ideas

Intel's 8237 DMA controller : 1) The 8237 contain 4 independent I/O channels 2) It contains 27 registers, 7 of which are system-wide registers and 5 for each channel. 3)

1. Write a program that will generate an array of ten random 32-bit integers, and that will  display on the monitor the numbers followed by either the words " has the fourth bit se

Write a program to evaluate the following expression. You are to evaluate the following equation: num1 - (input + num2) - (num3 + num4) Input will be a hex number input by

SUB: Subtract :- The subtract instruction subtracts the source operand from destination operand and result is left in the destination operand. Source operand might be memory locati

Project Description: Write an 80x86 assembly program that performs the following functions: Reads a set of integers from a file into an array. The data file name is to be

TEST : Logical Compare Instruction: The TEST instruction performs bit by bit logical AND operation on the 2 operands. Each bit of the result is then set to value I, if the equival

program to find negative and positive integers from given signed numbers with output and explanation of every instructions.