Essay
Mr. Ortiz is paid a salary of $575 each week and 5% commission on sales over $10,000 less any returned merchandise. His sales information is located in a spreadsheet where salary is in Cell B2, commission rate expressed as a decimal is in Cell C2, returns are in Cell D2, and total weekly sales are in Cell E2. What formula should be in Cell F2 to calculate Mr. Ortiz's net weekly pay?
Correct Answer:
Verified
Correct Answer:
Verified
Q3: Jackson is married with four allowances. His
Q5: Kazuki Sato makes $46,835 annually as a
Q10: Loretta is single with two allowances. Her
Q11: Maya Costello is married with two allowances.
Q19: Monica earns $1,250 each week. She lives
Q21: Bhairav Nagesh is a computer programmer. Bhairav
Q23: LeMonte earns $239.60 each week. He lives
Q24: Latina had gross earnings of $562.90 last
Q44: Josiah lives in a state with a
Q46: The FICA or Federal Insurance Contributions Act