Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

Requesting help with understanding how to input the given data in the attached screenshot into a solver parameter. DATA CAN BE FOUND IN THE SCREENSHOT

Requesting help with understanding how to input the given data in the attached screenshot into a solver parameter.

DATA CAN BE FOUND IN THE SCREENSHOT

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.

***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.

image text in transcribed
A B D E F H K M N P R Product Wholesale Retail Units Sold Per Minute During Peak Units Sold Per Minute During Off-Peak Cost Price Stock On- Sat Thu. Sat. Sun. Ab Cruncher 29.95 73 75 79 87 89 94 0 41 42 43 47 0 Amazing Showerhead 29.95 43 114 36 700 124 128 131 35 36 0 44 5.95 22.95 42 120 600 0 98 99 46 58 62 57 Bug Wand 46 8.95 53 0 800 147 74 72 69 0 Butt-Blaster Exerciser 77 70.95 66 69 89.95 56 59 61 63 0 62 63 26 34 33 0 28 35 Butter Butler 2.95 15.95 33 0 67 72 900 78 75 89 40 34 74.95 36 93.95 35 800 94 92 0 97 95 88 10 35 36 38 39 41 34.95 49.95 42 700 90 96 96 59 11 0 49 59 68 DrainBuster 3.95 68 84 900 89 96 85 12 44 46 54 6.95 51 0 43 800 0 13 25 25 28 34 0 Eurosealer 29.95 29 88 84 0 98 99 44 0 14 45 43 46 29.95 44 59 56 700 0 53 66 0 43 39 36 0 41.95 34 800 59.95 96 0 99 89 16 Grip Wrench 45 46 43 5.95 47 19.95 73 45 72 47 600 66 58 84 88 17 38 38 43 36 Magic Mop 8.95 44 46 24.95 0 0 900 0 78 82 76 57 0 14.95 29.95 71 600 0 19 56 57 65 0 48 58 24.95 39.95 73 66 65 73 700 68 82 86 64 0 20 36 Trim Spa 39 42 43 29.95 32 800 0 131 63 58 63 60 71 29.95 56 900 0 72 75 82 75 0 74 29.95 171 700 0 184 98 0 94 96 102 95 96

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Reporting and Analysis

Authors: Flawrence Revsine, Daniel Collins, Bruce, Mittelstaedt, Leon

6th edition

978-0078025679

Students also viewed these Accounting questions