8-1 guided

profileinwoodchck
CopyofWearEverShoes-08.xlsx
Home>Computer Science homework help>8-1 guided

Marketing Analysis

Wear-Ever Shoes Marketing Budget Analysis
TV Magazine Total Exposures
Exposures per Ad 2000 850 2,850
Cost per Ad Total Budget Spent Total Available Budget
Ad budget $500 $250 $750 <= $3,750
Audience Reached per Ad (in millions) Total Audience Reached Desired Reach
Audience reached 1.85 0.5 2.35 >= 12
TV Magazine
Number of Ads 1 1
<=
Maximum TV 6
New TV AD Costs Budget
$500 Goal Seek
$525
How many magazine ads to reach 15 million?
How many TV ads to reach 15 million?

Inventory

Wear-Ever Inventory, First Quarter
Product ID Product Color Size Quantity Men's or Women's Cost Retail
WE001 Rugged Hiking Boots Brown 8 5 M $46.50 $90.00 Increase % 10% 15% 20%
WE002 Rugged Hiking Boots Brown 10 3 M $46.50 $90.00 $7.50
WE003 Rugged Hiking Boots Black 9.5 6 M $46.50 $90.00 $42.50
WE004 Rugged Hiking Boots Black 10.5 4 M $46.50 $90.00 Current Costs $46.50
WE005 Rugged Hiking Boots Black 7.5 4 W $53.50 $98.00 $47.50
WE006 Rugged Hiking Boots Black 8 2 W $53.50 $98.00 $48.00
WE007 Rugged Hiking Boots Brown 9 3 W $53.50 $98.00 $53.50
WE008 Rugged Hiking Boots Brown 8.5 2 W $53.50 $98.00
WE009 Comfy Walking Shoes Brown 8.5 4 M $47.50 $65.00
WE010 Comfy Walking Shoes Black 9 1 M $47.50 $65.00
WE011 Comfy Walking Shoes Navy 7.5 4 W $47.50 $65.00
WE012 Comfy Walking Shoes Black 8 1 W $47.50 $65.00
WE013 Comfy Walking Shoes Taupe 7.5 2 W $47.50 $65.00
WE014 Comfy Walking Shoes Brown 8 3 W $47.50 $65.00
WE015 Lazy Flip-Flops Pink 6 4 W $7.50 $14.00
WE016 Lazy Flip-Flops Pink 7 0 W $7.50 $14.00
WE017 Lazy Flip-Flops Pink 8 2 W $7.50 $14.00
WE018 Lazy Flip-Flops White 6 3 W $7.50 $14.00
WE019 Lazy Flip-Flops White 7 1 W $7.50 $14.00
WE020 Lazy Flip-Flops White 8 2 W $7.50 $14.00
WE021 Lazy Flip-Flops Brown 8 2 M $7.50 $14.00
WE022 Lazy Flip-Flops Brown 9 4 M $7.50 $14.00
WE023 Lazy Flip-Flops Brown 10 2 M $7.50 $14.00
WE024 Lazy Flip-Flops Brown 11 2 M $7.50 $14.00
WE025 Seriously Tall Boots Black 6 0 W $42.50 $80.00
WE026 Seriously Tall Boots Black 6.5 0 W $42.50 $80.00
WE027 Seriously Tall Boots Black 7 1 W $42.50 $80.00
WE028 Seriously Tall Boots Black 7.5 0 W $42.50 $80.00
WE029 Seriously Tall Boots Black 8 2 W $42.50 $80.00
WE030 Seriously Tall Boots Black 8.5 1 W $42.50 $80.00
WE031 Glide Running Shoes White 8 6 M $48.00 $75.00
WE032 Glide Running Shoes White 9 6 M $48.00 $75.00
WE033 Glide Running Shoes White 10 6 M $48.00 $75.00
WE034 Glide Running Shoes Black 8 2 M $48.00 $75.00
WE035 Glide Running Shoes Black 9 3 M $48.00 $75.00
WE036 Glide Running Shoes Black 10 1 M $48.00 $75.00

These are new costs at each percentage increase.

Glide History

WearEver Shoes
Glide Running Shoes
Quarter Pairs Sold
3/31/15 125
6/30/15 145
9/30/15 250
12/31/15 115
3/31/16 105
6/30/16 175
9/30/16 235
12/31/16 200
3/31/17 185
6/30/17 200
9/30/17 225
12/31/17 275