Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed

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 96

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Introductory Econometrics For Finance

Authors: Chris Brooks

4th Edition

110843682X, 9781108436823

More Books

Students also viewed these Finance questions

Question

How do you reindex a series? Why might you want to do this?

Answered: 1 week ago

Question

mple 10. Determine d dx S 0 t dt.

Answered: 1 week ago

Question

Explain the place of planning in human resource management

Answered: 1 week ago