Formulate the linear programming model , Assembly Language

Assignment Help:

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.


Related Discussions:- Formulate the linear programming model

Nonrecursive Factorial, Write a nonrecursive version of the Factorial proce...

Write a nonrecursive version of the Factorial procedure (Section 8.3.2) that uses a loop. (A VideoNote for this exercise is posted on the Web site.) Write a short program that inte

Write an assembly language program, Your assignment for this project is to ...

Your assignment for this project is to write an assembly language program that checks if the user's input is a valid ISBN number. A sample run of your program might look like:

Flowchart for the sequence of 8251-microprocessor, Flowchart for the sequen...

Flowchart for the sequence of 8251 Whether the control, mode or sync character register is selected depends on the accessing sequence.  A flowchart of the sequencing is given i

#title:Shifitng of memory, Ask 2. Exchange higher byte of AX and higher byt...

Ask 2. Exchange higher byte of AX and higher byte of BX registers by using memory location 0160 in between the transfer. Then stores AX and BX registers onto memory location 0174 o

Group-assemblers directive-microprocessor, GROUP : Group the Related Segme...

GROUP : Group the Related Segments:- The directive which is used to form logical groups of segments with same purpose or type. This isused to inform the assembler to form a log

Sbb-arithmetic instruction-microprocessor, SBB: Subtract  with Borrow  :- ...

SBB: Subtract  with Borrow  :- The subtract with borrow instruction subtracts the source operand and the borrow flag (CF) which might reflect the result of the past calculations,

Program translation sequence, Program Translation Sequence Developing ...

Program Translation Sequence Developing a software program to accomplish a particular task, the implementer chooses an appropriate language, develops the algorithm (a sequence

.., Sum of series of 10 numbers and store result in memory location total

Sum of series of 10 numbers and store result in memory location total

AAD, AAD stand for what??

AAD stand for what??

Instruction set of 8086-microprocessor, Instruction set of 8086 : The 8...

Instruction set of 8086 : The 8086/8088 instructions are categorized into the following major types. This section describes the function of each of the instructions with approp

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd