General Supervisory Services has $12,000 available for advertising. The following table gives the costs per ad and the number of people exposed to its ads for three different media (with costs in thousands).

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

A. If they wish to maximize the number of exposures to working mothers, how many ads of each type should be purchased? What is the objective function, and system of constraints?

J
2. a. General Supervisory Services has $12,000 available for advertising. The following table
(with costs in thousands).
gives the costs per ad and the number of people exposed to its ads for three different media
Ad Packages
Cost
Total audience
Working mothers
Social Media
2
30
6
↓
If the total available audience is 420,000, and if they wish to maximize the number of
exposures to working mothers, how many ads of each type should be purchased? Write the
objective function and the system of constraints necessary for this situation.
b. Set up a workspace in an Excel program and solve the problem. Include the space you used to
work the problem with the solution into a word document with a discussion about what the
solution means.
c. It is determined that a more realistic expectation for media exposure to working mothers
is: 6,000 to the social media, 4,000 to the radio, and 8,000 to the TV. Make the change in
the optimization function and solve the problem with these new parameters. Include the
space you used to work the problem with the solution into a word document with a
discussion about what the solution means.
I
II
d. Write a short paragraph discussing how the parameters may be changed, and how they
can affect the value of the variables which optimize the problem. Feel free to try
some other parameters to see what the results are as part of your discussion.
Cost/week
Radio
2
21
12
3. a. A Deli and Catering company has two menus: I and II. They prepare these at three
different facilities: A, B, and C. The production capacities and costs per week to operate
the three facilities are summarized in the following table:
A
200
100
$1000
TV
4
54
8
B
200
200
$3000
C
400
100
$4000
How many weeks should each facility operate to fill their orders at a minimum cost, and wha
this situation.
is the minimum cost? Write the objective function and the system of constraints necessary fo
b. Set up a workspace in an Excel program and solve the problem.
c. Include the space you used to work the problem with the solution into a word document
with a discussion about what the solution means.
Transcribed Image Text:J 2. a. General Supervisory Services has $12,000 available for advertising. The following table (with costs in thousands). gives the costs per ad and the number of people exposed to its ads for three different media Ad Packages Cost Total audience Working mothers Social Media 2 30 6 ↓ If the total available audience is 420,000, and if they wish to maximize the number of exposures to working mothers, how many ads of each type should be purchased? Write the objective function and the system of constraints necessary for this situation. b. Set up a workspace in an Excel program and solve the problem. Include the space you used to work the problem with the solution into a word document with a discussion about what the solution means. c. It is determined that a more realistic expectation for media exposure to working mothers is: 6,000 to the social media, 4,000 to the radio, and 8,000 to the TV. Make the change in the optimization function and solve the problem with these new parameters. Include the space you used to work the problem with the solution into a word document with a discussion about what the solution means. I II d. Write a short paragraph discussing how the parameters may be changed, and how they can affect the value of the variables which optimize the problem. Feel free to try some other parameters to see what the results are as part of your discussion. Cost/week Radio 2 21 12 3. a. A Deli and Catering company has two menus: I and II. They prepare these at three different facilities: A, B, and C. The production capacities and costs per week to operate the three facilities are summarized in the following table: A 200 100 $1000 TV 4 54 8 B 200 200 $3000 C 400 100 $4000 How many weeks should each facility operate to fill their orders at a minimum cost, and wha this situation. is the minimum cost? Write the objective function and the system of constraints necessary fo b. Set up a workspace in an Excel program and solve the problem. c. Include the space you used to work the problem with the solution into a word document with a discussion about what the solution means.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 8 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.