show all formulas used and explain thanks.

11-14. Salespeople receive $10,000 base salary plus a commission of 2% of sales. Anyone who sells over $3 million receives a free vacation in Tahiti. Anyone who sells over $5 million receives an additional $15,000 bonus. At the end of the year salespeople are rated as follows: under $2 million "Dud", $2 million through $5 million "Star", over $5 million "Superstar". Create a worksheet that allows you to enter a salesperson's name and annual sales amount and then calculates the following: pione oper 210 | CHAPTER 11 Salesperson Summary Name: Annual sales: (input) (input) Base salary: Commission: Bonus: $10,000 (formula) (formula) (formula) Total pay: Free vacation? (formula) Status: (formula)