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
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.
I would like help on how to find the blanks columns.
A B D E F G M N o P Q R S T U V H 1 KL Before Solver Parameter 1 2 Units Sold Per Minute During Peak Units Sold Per Minute During Off-Peak Product Wholesale Cost Retail Price Sold % to Total Profit @ Peak Stock On- Hand Sold % to Total Profit Peak . | | Sat. 43 35 0 66 33 36 0 68 0 Sun. 36 42 53 69 35 35 42 68 43 1 Tal Product 3 4 5 Ab Cruncher 6 Amazing Showerhead 7 Auto Hammer 8 Bug Wand 9 Butt-Blaster Exerciser 10 Butter Butler 11 Cable Flex 12 Clever Cam 13 Drain Buster 14 Euroblaster 15 Eurosealer 16 Flat Hose 17 George Foreman Grill 18 Grip Wrench 19 Magic Mop 20 Roll-Away Flat Hose 21 Sewing Genie 22 Trim Spa 23 VCR Co-Pilot 24 Wonder Steamer 25 26 14.95 10.95 5.95 8.95 70.95 2.95 74.95 34.95 3.95 6.95 10.95 16.95 41.95 5.95 8.95 14.95 24.95 12.95 14.95 11.95 Mon Tue. Wed. Thu. Fri. Sat. Sun. 29.95 73 75 79 87 89 94 0 497 29.95 122 114 109 0 124 128 131 728 22.95 102 0 120 102 98 99 102 623 25.95 143 0 136 147 157 151 155 889 89.95 56 59 61 63 0 62 63 364 15.95 0 67 72 78 75 89 88 469 93.95 94 92 0 97 95 101 88 567 49.95 124 90 0 87 96 96 102 595 17.95 84 85 89 96 108 111 85 658 24.95 149 151 171 164 138 | 144 0 917 29.95 94 88 0 97 98 99 560 29.95 59 56 53 0 66 67 301 59.95 96 0 99 111 102 119 89 616 19.95 73 72 0 66 58 84 88 441 24.95 0 145 125 129 126 525 29.95 115 113 132 | 123 106 125 714 39.95 65 73 68 73 82 86 64 511 29.95 122 118 109 113 0 131 114 707 29.95| 148 144 | 169 161 146 | 163 931 29.95 186 171 0 193 195 184 184 1113 12726 Mon. Tue. 41 42 35 36 46 58 74 72 26 34 40 27 35 36 59 0 44 25 25 44 45 43 45 46 38 38 78 56 57 32 0 63 58 72 75 98 0 32 46 77 28 31 41 75 51 27 43 36 1 Wed. Thu. 43 47 0 44 62 57 69 33 0 34 38 39 49 59 46 54 28 34 37 39 37 43 47 43 36 82 76 65 0 36 39 0 63 82 75 94 96 700 600 800 600 900 800 700 900 800 900 700 800 600 900 600 700 800 900 700 600 lolololol 252 224 322 427 189 203 231 378 238 168 259 189 273 245 364 350 224 371 378 581 . loll 46 0 45 44 0 58 43 71 74 95 44 34 47 46 71 66 32 56 0 96Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started