Taking advantage of consumer weaknesses is what the Impulse Shopping Network does best. On-air hosts peddle each product during a predetermined period of time. During each segment (10minutes maximum), viewers are enticed to whip out their credit card and order the product shownbefore the time runs out. These marketers are so convincing that even the savviest consumer can’tavoid temptation. Moore Zales, Director of Marketing at Impulse Shopping Network needs to dosome product planning for tomorrow evening’s line-up. She needs to decide how to split the groupof products being offered between an hour of peak and two hours of off-peak airtime in order tomaximize the profits generated for the three-hour line-up. The following is a list of available items,their wholesale cost, retail price, stock-on-hand, and data on the quantity sold per minute in theprevious week during both peak and off-peak times. Use excel solver please!

Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Chapter6: Statistical Inference
Section: Chapter Questions
Problem 41P
Question

Taking advantage of consumer weaknesses is what the Impulse Shopping Network does best. On-
air hosts peddle each product during a predetermined period of time. During each segment (10
minutes maximum), viewers are enticed to whip out their credit card and order the product shown
before the time runs out. These marketers are so convincing that even the savviest consumer can’t
avoid temptation. Moore Zales, Director of Marketing at Impulse Shopping Network needs to do
some product planning for tomorrow evening’s line-up. She needs to decide how to split the group
of products being offered between an hour of peak and two hours of off-peak airtime in order to
maximize the profits generated for the three-hour line-up. The following is a list of available items,
their wholesale cost, retail price, stock-on-hand, and data on the quantity sold per minute in the
previous week during both peak and off-peak times. Use excel solver please!

Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials of Business Analytics (MindTap Course …
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
Essentials Of Business Analytics
Essentials Of Business Analytics
Statistics
ISBN:
9781285187273
Author:
Camm, Jeff.
Publisher:
Cengage Learning,