View the step-by-step solution to:

Question

Create formulas for excel. You wish to calculate the commission on sales. The commission is 6% on all sales that

are at least 20% above cost.

Sign up to view the entire interaction

Top Answer

Dear Student Please find... View the full answer

Business-7602364.xls

Ans
Let the cost be = y Therefore, selling price
(y+20% of y) = 1.20y Commission
(6% of 1.20y) = 0.072y Alternative,
Let the cost be = 100 Therefore, selling price
(100+20% of 100) = 120...

Sign up to view the full answer

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
Ask a homework question - tutors are online