Using Excel Solver function in excel 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. Note: Zero units sold in the below table indicate the product was not shown on-air on a particular day. Managerial Report Prepare a managerial report that helps Moore Zales 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. Units Sold Units Sold Units Sold Units Sold Units Sold Units Sold Units Sold Units Sold Units Sold Units Sold Units Sold Units Sold Units Sold Units Sold Per Minute Per Minute Per Minute Per Minute Per Minute Per Minute Per Minute Per Minute Per Minute Per Minute Per Minute Per Minute Per Minute Per Minute Product Wholesale Cost Retail Price During Peak During Peak During Peak During Peak During Peak During Peak During Peak During Off- Peak During Off- Peak During Off- Peak During Off- Peak During Off- Peak During Off- Peak During Off- Peak Stock On-Hand Mon. Tue. Wed. Thu. Fri. Sat. Sun. Mon. Tue. Wed. Thu. Fri. Sat. Sun. Ab Cruncher $14.95 $29.95 73 75 79 87 89 94 0 41 42 43 47 0 43 36 700 Amazing Showerhead $10.95 $29.95 122 114 109 0 124 128 131 35 36 0 44 32 35 42 600 Auto Hammer $5.95 $22.95 102 0 120 102 98 99 102 46 58 62 57 46 0 53 800 Bug Wand $8.95 $25.95 143 0 136 147 157 151 155 74 72 69 0 77 66 69 600 Butt-Blaster Exerciser $70.95 $89.95 56 59 61 63 0 62 63 26 34 33 0 28 33 35 900 Butter Butler $2.95 $15.95 0 67 72 78 75 89 88 40 27 0 34 31 36 35 800 Cable Flex $74.95 $93.95 94 92 0 97 95 101 88 35 36 38 39 41 0 42 700 Clever Cam $34.95 $49.95 124 90 0 87 96 96 102 59 0 49 59 75 68 68 900 DrainBuster $3.95 $17.95 84 85 89 96 108 111 85 0 44 46 54 51 0 43 800 Euroblaster $6.95 $24.95 149 151 171 164 138 144 0 25 25 28 34 27 0 29 900 Eurosealer $10.95 $29.95 94 88 84 0 97 98 99 44 45 0 37 43 46 44 700 Flat Hose $16.95 $29.95 59 56 0 53 0 66 67 0 43 39 37 36 0 34 800 George Foreman Grill $41.95 $59.95 96 0 99 111 102 119 89 45 46 43 47 0 45 47 600 Grip Wrench $5.95 $19.95 73 72 0 66 58 84 88 38 38 43 36 0 44 46 900 Magic Mop $8.95 $24.95 0 145 0 125 129 126 0 0 78 82 76 57 0 71 600 Roll-Away Flat Hose $14.95 $29.95 115 113 132 123 106 0 125 56 57 65 0 48 58 66 700 Sewing Genie $24.95 $39.95 65 73 68 73 82 86 64 32 0 36 39 42 43 32 800 Trim Spa $12.95 $29.95 122 118 109 113 0 131 114 63 58 0 63 60 71 56 900 VCR Co-Pilot $14.95 $29.95 148 144 169 161 0 146 163 72 75 82 75 0 74 0 700 Wonder Steamer $11.95 $29.95 186 171 0 193 195 184 184 98 0 94 96

Using Excel Solver function in excel 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. Note: Zero units sold in the below table indicate the product was not shown on-air on a particular day. Managerial Report Prepare a managerial report that helps Moore Zales 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. Units Sold Units Sold Units Sold Units Sold Units Sold Units Sold Units Sold Units Sold Units Sold Units Sold Units Sold Units Sold Units Sold Units Sold Per Minute Per Minute Per Minute Per Minute Per Minute Per Minute Per Minute Per Minute Per Minute Per Minute Per Minute Per Minute Per Minute Per Minute Product Wholesale Cost Retail Price During Peak During Peak During Peak During Peak During Peak During Peak During Peak During Off- Peak During Off- Peak During Off- Peak During Off- Peak During Off- Peak During Off- Peak During Off- Peak Stock On-Hand Mon. Tue. Wed. Thu. Fri. Sat. Sun. Mon. Tue. Wed. Thu. Fri. Sat. Sun. Ab Cruncher $14.95 $29.95 73 75 79 87 89 94 0 41 42 43 47 0 43 36 700 Amazing Showerhead $10.95 $29.95 122 114 109 0 124 128 131 35 36 0 44 32 35 42 600 Auto Hammer $5.95 $22.95 102 0 120 102 98 99 102 46 58 62 57 46 0 53 800 Bug Wand $8.95 $25.95 143 0 136 147 157 151 155 74 72 69 0 77 66 69 600 Butt-Blaster Exerciser $70.95 $89.95 56 59 61 63 0 62 63 26 34 33 0 28 33 35 900 Butter Butler $2.95 $15.95 0 67 72 78 75 89 88 40 27 0 34 31 36 35 800 Cable Flex $74.95 $93.95 94 92 0 97 95 101 88 35 36 38 39 41 0 42 700 Clever Cam $34.95 $49.95 124 90 0 87 96 96 102 59 0 49 59 75 68 68 900 DrainBuster $3.95 $17.95 84 85 89 96 108 111 85 0 44 46 54 51 0 43 800 Euroblaster $6.95 $24.95 149 151 171 164 138 144 0 25 25 28 34 27 0 29 900 Eurosealer $10.95 $29.95 94 88 84 0 97 98 99 44 45 0 37 43 46 44 700 Flat Hose $16.95 $29.95 59 56 0 53 0 66 67 0 43 39 37 36 0 34 800 George Foreman Grill $41.95 $59.95 96 0 99 111 102 119 89 45 46 43 47 0 45 47 600 Grip Wrench $5.95 $19.95 73 72 0 66 58 84 88 38 38 43 36 0 44 46 900 Magic Mop $8.95 $24.95 0 145 0 125 129 126 0 0 78 82 76 57 0 71 600 Roll-Away Flat Hose $14.95 $29.95 115 113 132 123 106 0 125 56 57 65 0 48 58 66 700 Sewing Genie $24.95 $39.95 65 73 68 73 82 86 64 32 0 36 39 42 43 32 800 Trim Spa $12.95 $29.95 122 118 109 113 0 131 114 63 58 0 63 60 71 56 900 VCR Co-Pilot $14.95 $29.95 148 144 169 161 0 146 163 72 75 82 75 0 74 0 700 Wonder Steamer $11.95 $29.95 186 171 0 193 195 184 184 98 0 94 96

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

Using Excel Solver function in excel

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.

Note: Zero units sold in the below table indicate the product was not shown on-air on a particular day.

Managerial Report

Prepare a managerial report that helps Moore Zales 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.

			Units Sold	Units Sold	Units Sold	Units Sold	Units Sold	Units Sold	Units Sold	Units Sold	Units Sold	Units Sold	Units Sold	Units Sold	Units Sold	Units Sold
			Per Minute	Per Minute	Per Minute	Per Minute	Per Minute	Per Minute	Per Minute	Per Minute	Per Minute	Per Minute	Per Minute	Per Minute	Per Minute	Per Minute
Product	Wholesale Cost	Retail Price	During Peak	During Peak	During Peak	During Peak	During Peak	During Peak	During Peak	During Off- Peak	During Off- Peak	During Off- Peak	During Off- Peak	During Off- Peak	During Off- Peak	During Off- Peak	Stock On-Hand
			Mon.	Tue.	Wed.	Thu.	Fri.	Sat.	Sun.	Mon.	Tue.	Wed.	Thu.	Fri.	Sat.	Sun.
Ab Cruncher	$14.95	$29.95	73	75	79	87	89	94	0	41	42	43	47	0	43	36	700
Amazing Showerhead	$10.95	$29.95	122	114	109	0	124	128	131	35	36	0	44	32	35	42	600
Auto Hammer	$5.95	$22.95	102	0	120	102	98	99	102	46	58	62	57	46	0	53	800
Bug Wand	$8.95	$25.95	143	0	136	147	157	151	155	74	72	69	0	77	66	69	600
Butt-Blaster Exerciser	$70.95	$89.95	56	59	61	63	0	62	63	26	34	33	0	28	33	35	900
Butter Butler	$2.95	$15.95	0	67	72	78	75	89	88	40	27	0	34	31	36	35	800
Cable Flex	$74.95	$93.95	94	92	0	97	95	101	88	35	36	38	39	41	0	42	700
Clever Cam	$34.95	$49.95	124	90	0	87	96	96	102	59	0	49	59	75	68	68	900
DrainBuster	$3.95	$17.95	84	85	89	96	108	111	85	0	44	46	54	51	0	43	800
Euroblaster	$6.95	$24.95	149	151	171	164	138	144	0	25	25	28	34	27	0	29	900
Eurosealer	$10.95	$29.95	94	88	84	0	97	98	99	44	45	0	37	43	46	44	700
Flat Hose	$16.95	$29.95	59	56	0	53	0	66	67	0	43	39	37	36	0	34	800
George Foreman Grill	$41.95	$59.95	96	0	99	111	102	119	89	45	46	43	47	0	45	47	600
Grip Wrench	$5.95	$19.95	73	72	0	66	58	84	88	38	38	43	36	0	44	46	900
Magic Mop	$8.95	$24.95	0	145	0	125	129	126	0	0	78	82	76	57	0	71	600
Roll-Away Flat Hose	$14.95	$29.95	115	113	132	123	106	0	125	56	57	65	0	48	58	66	700
Sewing Genie	$24.95	$39.95	65	73	68	73	82	86	64	32	0	36	39	42	43	32	800
Trim Spa	$12.95	$29.95	122	118	109	113	0	131	114	63	58	0	63	60	71	56	900
VCR Co-Pilot	$14.95	$29.95	148	144	169	161	0	146	163	72	75	82	75	0	74	0	700
Wonder Steamer	$11.95	$29.95	186	171	0	193	195	184	184	98	0	94	96	102	95	96	600

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.