Computation

Week4ExcelData.xlsx

Sheet1

Walk and Rock Music
First Quarter Rock-It MP3 Sales
	Northeast	Southeast	Midwest	South	West
Videos	66145.15	79677.1	34657.66	52517.2	99455.49
Mini	31,375.24	82,937.72	66,137.50	30,681.82	43,595.24
Micro	27,596.37	92,716.32	88,294.78	87,984.79	83,380.72
Flash	27,885.59	98,800.57	24,111.33	69,737.51	51,003.09
Accessories	9,715.12	31,284.20	66,527.37	40,374.83	46,321.88
	162717.47	385415.91	279728.64	281296.15	323756.42
	Global Sales Tax		7%
	Total Tax Paid
	Total Plus Tax