Excel Homework
Revenue by Department
| Blue Lake Sports | ||||||
| First Quarter Sales by City | ||||||
| Department | Atlanta | Boston | Chicago | San Diego | St. Louis | Total |
| Apparel | $ 2,600 | $ 3,200 | $ 3,800 | $ 3,700 | $ 3,200 | $ 16,500 |
| Baseball | $ 3,500 | $ 1,200 | $ 1,350 | $ 2,100 | $ 2,475 | $ 10,625 |
| Basketball | $ 1,800 | $ 1,800 | $ 2,250 | $ 1,400 | $ 1,750 | $ 9,000 |
| Bike & Skate | $ 1,500 | $ 1,325 | $ 1,225 | $ 2,450 | $ 1,650 | $ 8,150 |
| Exercise | $ 2,650 | $ 2,875 | $ 3,250 | $ 3,775 | $ 2,950 | $ 15,500 |
| Fishing | $ 2,350 | $ 1,035 | $ 1,250 | $ 2,750 | $ 1,450 | $ 8,835 |
| Footwear | $ 1,875 | $ 2,675 | $ 3,575 | $ 3,250 | $ 2,950 | $ 14,325 |
| Game Room | $ 1,300 | $ 1,500 | $ 1,900 | $ 1,050 | $ 1,275 | $ 7,025 |
| Golf | $ 4,750 | $ 875 | $ 925 | $ 5,400 | $ 1,250 | $ 13,200 |
| Hockey | $ 850 | $ 1,875 | $ 1,950 | $ 750 | $ 1,650 | $ 7,075 |
| Hunting | $ 2,000 | $ 1,000 | $ 650 | $ 725 | $ 950 | $ 5,325 |
| Lacrosse | $ 1,750 | $ 1,800 | $ 1,750 | $ 1,375 | $ 1,150 | $ 7,825 |
| Running | $ 1,925 | $ 2,400 | $ 2,800 | $ 2,650 | $ 2,000 | $ 11,775 |
| Winter Sports | $ 1,250 | $ 34,350 | $ 2,750 | $ 550 | $ 1,550 | $ 40,450 |
| Total | $ 30,100 | $ 57,910 | $ 29,425 | $ 31,925 | $ 26,250 | $ 175,610 |
Atlanta Revenue
| Blue Lake Sports | |||||
| January Sales in Atlanta | |||||
| Department | Week 1 | Week 2 | Week 3 | Week 4 | Total |
| Apparel | $ 235 | $ 325 | $ 215 | $ 450 | $ 1,225 |
| Baseball | $ 430 | $ 250 | $ 180 | $ 315 | $ 1,175 |
| Basketball | $ 85 | $ 150 | $ 90 | $ 200 | $ 525 |
| Bike & Skate | $ 200 | $ 325 | $ 75 | $ 175 | $ 775 |
| Exercise | $ 150 | $ 160 | $ 180 | $ 170 | $ 660 |
| Fishing | $ 75 | $ 150 | $ 85 | $ 200 | $ 510 |
| Footwear | $ 500 | $ 350 | $ 275 | $ 330 | $ 1,455 |
| Game Room | $ 45 | $ 75 | $ 35 | $ 15 | $ 170 |
| Golf | $ 175 | $ 350 | $ 580 | $ 200 | $ 1,305 |
| Hockey | $ 85 | $ 125 | $ 50 | $ 35 | $ 295 |
| Hunting | $ 125 | $ 350 | $ 475 | $ 450 | $ 1,400 |
| Lacrosse | $ 200 | $ 50 | $ 65 | $ 75 | $ 390 |
| Running | $ 165 | $ 235 | $ 325 | $ 180 | $ 905 |
| Winter Sports | $ 75 | $ 15 | $ - 0 | $ 15 | $ 105 |
| Total | $ 2,545 | $ 2,910 | $ 2,630 | $ 2,810 | $ 10,895 |