View the step-by-step solution to:

You wish to calculate the commission on sales. The commission is 6% on all sales that are at least 20% above cost. You wish to calculate the total...

Using the following scenarios, discuss how you would apply the Excel functions or create a formula to solve the scenario?
Bis155 elder help Discuss how you would apply the Excel functions or create a formula to solve the scenario. You wish to calculate the commission on sales. The commission is 6% on all sales that are at least 20% above cost. You wish to calculate the total pay for an employee who receives regular time for 40 hours, time and a half for 40-50 hours, and double time for hours over 50. You have a list of contracts and due dates for annual maintenance fees. You wish to determine when you have a contract due in the next 45 days and provide a note that warns you that the payment is due.
Background image of page 1

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question