Question: 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.
?

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
Get step-by-step solutions from verified subject matter experts
