help

excel5.xlsx

Sheet1

Blue Lake Sports
Number of Transactions by Department
Week of September 1
Department	City	Transactions
Apparel	Atlanta	71
Baseball	Atlanta	96
Basketball	Atlanta	82
Bike & Skate	Atlanta	70
Exercise	Atlanta	69
Fishing	Atlanta	71
Footwear	Atlanta	93
Game Room	Atlanta	55
Golf	Atlanta	52
Hockey	Atlanta	79
Hunting	Atlanta	72
Lacrosse	Atlanta	65
Running	Atlanta	95
Winter Sports	Atlanta	60
		51
		58
		81
		63
		71
		56
		67
		95
		67
		82
		96
		69
		97
		56
Apparel	Chicago	59
Baseball	Chicago	66
Basketball	Chicago	95
Bike & Skate	Chicago	66
Exercise	Chicago	50
Fishing	Chicago	78
Footwear	Chicago	88
Game Room	Chicago	82
Golf	Chicago	57
Hockey	Chicago	69
Hunting	Chicago	80
Lacrosse	Chicago	94
Running	Chicago	90
Winter Sports	Chicago	89
Apparel	St. Louis	67
Baseball	St. Louis	72
Basketball	St. Louis	55
Bike & Skate	St. Louis	73
Exercise	St. Louis	60
Fishing	St. Louis	75
Footwear	St. Louis	95
Game Room	St. Louis	89
Golf	St. Louis	85
Hockey	St. Louis	93
Hunting	St. Louis	59
Lacrosse	St. Louis	83
Running	St. Louis	100
Winter Sports	St. Louis	83

Blue Lake Sports
Random Transaction Analysis
Location	Sales Ticket Before Tax	Sales Ticket with Tax
Atlanta	$195.32
Atlanta	$200.76
Atlanta	$225.45
Atlanta	$225.89
Atlanta	$187.20
Chicago	$184.32
Chicago	$275.00
Chicago	$325.89
Chicago	$199.99
Chicago	$242.89
Chicago	$179.89
Boston	$139.99
Boston	$299.99
Boston	$119.99
Boston	$475.00
Boston	$375.00
St. Louis	$135.99
St. Louis	$175.89
St. Louis	$195.99
St. Louis	$225.00
St. Louis	$85.99

Blue Lake Sports Fixed Credit Card Fees
		Number of Transactions
	Fee per Transaction	Atlanta	Boston	Chicago	St. Louis
White Card	$0.25	8000	6000	5000	11000
Blue Card	$0.35	6000	7500	10000	15000
Platinum Card	$0.40	7500	8000	15000	11500
Gold Card	$0.45	12000	8500	20000	16000
		Fees by Location
	Atlanta	Boston	Chicago	St. Louis
		Fees by Card Type
		White Card
		Blue Card
		Platinum Card
		Gold Card