answer this using ASP solver

On the tab labeled “Original
Problem”, I have provided the modeling of Case 3.4 on Pages136-138. Carefully read the case in the textbook and
then review the model and solver set up to familiarize yourself with the
integration of the LP into Excel. On the
tab labeled “Case Update”, you will see there are 5 changes that must
be made in the model. Using the model I
have provided on the “Case Update” tab, make the required changes and
re-load the solver (on the “Case Update” tab) to determine the new
advertising strategy. The model should
be solved only one time: after you have
incorporated all 5 changes noted on the “Case Update” tab. In addition to updating the model and solver,
you should provide a sentence or two to state how you addressed each change
within the model. Each question is worth
16 points: 8 points for a clear, concise, grammatically correct description of
the mechanical changes made to the model and 8 points for the correct solution
resulting from the changes made.
Questions should be answered on the “Case Update” tab and
typed in unboldedblack
fontright after the statement of the
question. Please remember that case
studies are individual effort, however, if you have questions you are urged to
post a note on the course site within the discussion forum. Good luck and as always…HAVE FUN!*********************************************************************

.png”>

.png”>

Impact
Cost

Advertising Medium
Units
Min
Max
Per Unit
Total
Per Unit
Total

Half-page, Daily paper
46.0
24
48
55
2,530
$800
$36,800

Full-page, Daily paper
2.0
2
48
75
150
$1,400
$2,800

Half-page, Sunday paper
6.0
0
8
65
390
$1,200
$7,200

Full-page, Sunday paper
2.0
2
8
80
160
$1,800
$3,600

Daytime TV spot
29.6
28
84
85
2,513
$2,500
$73,900

Evening TV spot
28.0
28
56
100
2,800
$3,500
$98,000

Highway Billboards
10.0
3
10
35
350
$750
$7,500

15 second Radio spot
140.0
56
140
45
6,300
$150
$21,000

30 second Radio spot
140.0
56
140
55
7,700
$300
$42,000

Half-page, magazine
9.0
0
12
50
450
$500
$4,500

Full-page, magazine
3.0
3
12
60
180
$900
$2,700

Key Totals:
Units
Min
Max
Total:
23,523
Total:
$300,000

Daily paper
ads
48.0
24
48

Budget:
$300,000

Sunday paper ads
8.0
2
8

Magazine ads
12.0
3
12

****************************************************************************

.png”>

.png”>

.png”>

Impact
Cost

Advertising Medium
Units
Min
Max
Per Unit
Total
Per Unit
Total

Half-page, Daily paper
0
24
48
55
0
$800
$0

Full-page, Daily paper
0
2
48
75
0
$1,400
$0

Half-page, Sunday paper
0
0
8
65
0
$1,200
$0

Full-page, Sunday paper
0
2
8
80
0
$1,800
$0

Daytime TV spot
0
28
84
85
0
$2,500
$0

Evening TV spot
0
28
56
100
0
$3,500
$0

Highway Billboards
0
3
10
35
0
$750
$0

15 second Radio spot
0
56
140
45
0
$150
$0

30 second Radio spot
0
56
140
55
0
$300
$0

Half-page, magazine
0
0
12
50
0
$500
$0

Full-page, magazine
0
3
12
60
0
$900
$0

Key Totals:
0
Min
Max
Total:
0
Total:
$0

Daily paper
ads
0
24
48

Budget:
$300,000

Sunday paper ads
0
2
8

Magazine ads
0
3
12

1.
(16 Points) Tom now wants to run full-page ads in both major newspapers
for at least two weeks leading up to the vote.
NOTE: this changes the minimum
value in two cells in Column C.2.
(16 Points) Tom is scaling back his daytime television advertising
strategy which will now consist of running at least one but no more than three
spots per week for the four weeks leading up to the vote.3.
(16 Points) Tom wants to derive at least 20% of his total advertising
impact from evening television advertisements.
4.
(16 Points) Tom has decided he is willing to run a maximum of 7,
15-second radio spots per day for the 28 days leading up to the vote and a
maximum of 6, 30-second spots per day over the same period of time. However, he wants to ensure the total impact
derived from radio does not exceed 65% of the total impact.
5.
(16 Points) With his increase in radio spots, Tom plans to use the
majority of these new spots in the Orlando, Tampa, and Miami markets thus he
feels the billboards in these cities are no longer required for advertisement. However, because Tom feels there is value in
billboard advertising, he wants to derive at least 1% of his total impact from
billboards.

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more