Excel Guided Project 6-3

Jennifer.Anderson-WearEverShoes-06.xlsx

Home >Computer Science homework help >Excel Guided Project 6-3

Inventory

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

Satisfaction Survey

Wear-Ever Shoes
Customer Satisfaction Survey
Product ID	Product	Color	Size	Comfort	Fit	Style	Value
WE001	Rugged Hiking Boots	Brown	8	7	9	7	7
WE002	Rugged Hiking Boots	Brown	10	8	8	10	8
WE003	Rugged Hiking Boots	Black	9.5	8	9	8	9
WE004	Rugged Hiking Boots	Black	10.5	6	9	9	10
WE005	Rugged Hiking Boots	Black	7.5	8	8	10	9
WE006	Rugged Hiking Boots	Black	8	7	9	9	10
WE007	Rugged Hiking Boots	Brown	9	9	9	8	8
WE008	Rugged Hiking Boots	Brown	8.5	9	8	9	7
WE009	Comfy Walking Shoes	Brown	8.5	8	3	8	6
WE010	Comfy Walking Shoes	Black	9	10	10	8	9
WE011	Comfy Walking Shoes	Navy	7.5	9	3	8	4
WE012	Comfy Walking Shoes	Black	8	7	5	10	6
WE013	Comfy Walking Shoes	Taupe	7.5	8	8	3	7
WE014	Comfy Walking Shoes	Brown	8	3	3	8	6
WE015	Lazy Flip-Flops	Pink	6	10	1	4	2
WE016	Lazy Flip-Flops	Pink	7	3	1	9	8
WE017	Lazy Flip-Flops	Pink	8	3	4	1	3
WE018	Lazy Flip-Flops	White	6	3	7	1	4
WE019	Lazy Flip-Flops	White	7	6	9	5	6
WE020	Lazy Flip-Flops	White	8	1	4	9	7
WE021	Lazy Flip-Flops	Brown	8	3	1	10	10
WE022	Lazy Flip-Flops	Brown	9	2	3	9	4
WE023	Lazy Flip-Flops	Brown	10	10	1	1	2
WE024	Lazy Flip-Flops	Brown	11	8	2	6	10
WE025	Seriously Tall Boots	Black	6	4	2	8	9
WE026	Seriously Tall Boots	Black	6.5	10	7	7	3
WE027	Seriously Tall Boots	Black	7	2	5	10	10
WE028	Seriously Tall Boots	Black	7.5	4	4	10	10
WE029	Seriously Tall Boots	Black	8	10	3	2	9
WE030	Seriously Tall Boots	Black	8.5	10	9	2	10
WE031	Glide Running Shoes	White	8	9	9	9	9
WE032	Glide Running Shoes	White	9	10	9	9	8
WE033	Glide Running Shoes	White	10	9	10	8	9
WE034	Glide Running Shoes	Black	8	9	9	8	9
WE035	Glide Running Shoes	Black	9	8	10	10	10
WE036	Glide Running Shoes	Black	10	10	10	9	9

Average Ratings

Wear-Ever Shoes
Average Ratings by Shoe Style
Product ID	Product	Comfort	Fit	Style	Value	Overall	Rating	Ratings
WE001	Rugged Hiking Boots							Excellent	9 or higher
WE009	Comfy Walking Shoes							Above Average	Between 8 and 9
WE015	Lazy Flip-Flops							Average	Between 5 and 7
WE025	Seriously Tall Boots							Poor	Below 5
WE031	Glide Running Shoes

Criteria

Product ID	Product	Color	Size	Quantity	Men's or Women's	Cost	Retail	Reorder
Product ID	Product	Color	Size	Quantity	Men's or Women's	Cost	Retail	Reorder
Product ID	Product	Color	Size	Quantity	Men's or Women's	Cost	Retail	Reorder
Product ID	Product	Color	Size	Quantity	Men's or Women's	Cost	Retail	Reorder
Product ID	Product	Color	Size	Quantity	Men's or Women's	Cost	Retail	Reorder

Depreciation

	Wear-Ever Shoes
	Asset Depreciation for Packaging Equipment
	Cost of Equipment	$175,000
	Salvage Value	$22,000
	Life in Years	8
	Year	Amount
	1
	2
	3
	4
	5
	6
	7
	8

E-Mail

Wear-Ever Shoes
Employee E-Mail List
First Name	Last Name	Email Addresses
Vincent	Bowman
Louis	White
Patricia	Lynwood
Drew	Cronin