Part a. Construct a formula in cell to calculate the sales tax amount for transaction 578. Be sure to appropriately reference the transaction amount and the sales tax rate so your formula can be reused for the remaining transactions.
| Sales Tax Rate | 6.75% | |||||
| Transaction ID | Amount | Sales Tax | Total | |||
| 578 | $42.00 | |||||
| 579 | $167.00 | |||||
| 580 | $209.00 | |||||
| 581 | $142.00 | |||||
| 582 | $234.00 | |||||
| 583 | $88.00 | |||||
| 584 | $197.00 | |||||
| 585 | $209.00 | |||||
| 586 | $163.00 | |||||
| 587 | $151.00 | |||||
| 588 | $103.00 | |||||
| 589 | $148.00 | |||||
| 590 | $51.00 | |||||
| Grand Total | ||||||
|
|
Part b. There are 30 Major League Baseball (MLB) teams. The table on the statistical functions worksheet lists the 2019 and 1990 payroll and win totals for each team (notice that four teams were added after the 1990 season). Some MLB fans complain because the league does little to regulate the amount of money teams can pay for salaries. They argue that the teams that spend the most money will win the most games. This would put teams from small markets (that earn less revenue) at a disadvantage. Complete the tasks by inserting your formulas (or responses) in column I for each task to see if small market teams are at a disadvantage.
| Major League Baseball Salaries by Team | Statistical Functions | |||||||||||
| DIVISION | TEAM | 2019 PAYROLL | 1990 PAYROLL | 2019 WINS | 1990 Wins | Response | Task | |||||
| AL East | Baltimore Orioles | $73,370,109 | $10,037,084 | 54 | 76 | Number of MLB Teams in 1990 | ||||||
| AL East | Boston Red Sox | $229,196,106 | $20,983,333 | 84 | 88 | |||||||
| AL East | New York Yankees | $223,019,037 | $20,991,318 | 103 | 67 | Number of MLB teams | ||||||
| AL East | Tampa Bay Rays | $64,178,722 | NA | 96 | NA | |||||||
| AL East | Toronto Blue Jays | $111,371,067 | $18,486,834 | 67 | 86 | Total salaries paid in 1990. | ||||||
| AL Central | Chicago White Sox | $91,371,201 | $9,496,238 | 72 | 94 | |||||||
| AL Central | Cleveland Indians | $107,693,747 | $15,152,000 | 93 | 77 | Total salaries paid in 2019. | ||||||
| AL Central | Detroit Tigers | $114,631,137 | $18,092,238 | 47 | 79 | |||||||
| AL Central | Los Angeles Angels | $161,270,385 | $21,870,000 | 72 | 80 | Average salary paid by the teams in 1990. | ||||||
| AL Central | Minnesota Twins | $125,256,003 | $15,106,000 | 101 | 74 | |||||||
| AL West | Kansas City Royals | $104,773,003 | $23,873,745 | 59 | 75 | Average salary paid by the teams in 2019. | ||||||
| AL West | Los Angeles Dodgers | $207,000,814 | $21,618,704 | 106 | 86 | |||||||
| AL West | Oakland Athletics | $93,394,531 | $19,987,501 | 97 | 103 | Maximum team salary amount in 1990. | ||||||
| AL West | Seattle Mariners | $144,391,293 | $12,841,667 | 68 | 77 | |||||||
| AL West | Texas Rangers | $148,538,766 | $15,104,372 | 78 | 83 | Minimum team salary amount in 2019. | ||||||
| NL East | Atlanta Braves | $143,947,963 | $13,328,334 | 97 | 65 | |||||||
| NL East | Houston Astros | $168,804,925 | $18,830,000 | 107 | 75 | |||||||
| NL East | New York Mets | $146,335,812 | $22,418,834 | 86 | 91 | |||||||
| NL East | Philadelphia Phillies | $160,192,244 | $13,953,667 | 81 | 77 | |||||||
| NL East | Washington Nationals* | $172,307,808 | $16,656,388 | 93 | 85 | |||||||
| NL Central | Chicago Cubs | $221,590,085 | $14,496,000 | 84 | 77 | |||||||
| NL Central | Cincinnati Reds | $128,391,569 | $14,769,500 | 75 | 91 | |||||||
| NL Central | Milwaukee Brewers | $135,889,019 | $20,019,167 | 89 | 74 | |||||||
| NL Central | Pittsburgh Pirates | $72,731,474 | $15,656,000 | 69 | 95 | |||||||
| NL Central | St. Louis Cardinals | $174,317,164 | $20,923,334 | 91 | 70 | |||||||
| NL West | Arizona Diamondbacks | $118,927,905 | NA | 85 | NA | |||||||
| NL West | Colorado Rockies | $157,162,629 | NA | 71 | NA | |||||||
| NL West | Florida Marlins | $75,596,271 | NA | 57 | NA | |||||||
| NL West | San Diego Padres | $104,254,790 | $18,588,334 | 70 | 75 | |||||||
| NL West | San Francisco Giants | $178,582,126 | $20,942,333 | 77 | 85 | |||||||
| * The Washington Nationals were the Montreal Expos in 1990 | ||||||||||||
| NA = The team did not exist in 1990 | ||||||||||||