Excel & Business Math 37: Trade Discounts, Series Discounts, Net Cost Equivalents & Wholesale Cost

In this video learn how to calculate Trade Discounts (Single and Series) in order to calculate a Wholesale Cost. Learn about Business Terms. Learn about using VLOOKUP and IF Functions to automat calculations.
Excel & Business Math Class (Busn 135) taught by Michael Girvin at Highline College / Mike Girvin at excelisfun Channel at YouTube Channel.
Topics in Video:
1. (00:01) Introduction
2. (01:27) Business Terms: Retail & Wholesale Businesses. List Price and Wholesale Cost. Trade Discount $ Amount.
3. (05:42) Examples of Wholesale Cost Catalogs and the four different formulas needed to calculate Whole Sale Costs under four different assumptions.
4. (11:28) Single Trade Discount % Video Example. See three different Methods to calculate Wholesale Cost.
5. (15:02) Calculate Series Discounts. See three different Methods to calculate Wholesale Cost.
6. (20:28) Series Trade Discount % with Two Successive Discounts
7. (21:42) Series Trade Discount % where 2nd Discount Depends on Quantity Purchased. Learn how to use VLOOKUP Function.
8. (26:23) Series Trade Discount % where 2nd & 3rd Discount Depends on Quantity Purchased.
9. (30:43) Learn how to use IF & VLOOKUP Functions to make calculations automatic for a Series Discount.
10. (34:57) Summary

Next Video: 38 Excel & Business Math

[chrisgray]

Thank you, Sir. I've been practicing the payroll table from the last lesson for quite some time. I think I am ready to move on. This lesson is a much simpler procedure.

[zouma]

I've found this chanel today, and I started an udemy course in the same time, so far your videos are way better.. thanks for your work

[alexxgalindo]

I'm really grateful for what you do sir. You are amazing

[sachinrv]

Very useful. I always feel that there is no limit to creativity in excel when it comes to integration of formulas/ functions. Thanks for uploading.

[karimmansour]

Sr. Ultimate Respect And many thanks, Surly you deserve that. With full admiration .

[johnmartin]

Hi Mike, I loved the video top lad.
You are simply the best excel teacher in the English speaking world my friend.

[masteryourexcel]

nice video, Trying to make a Excel video youtube like yours… mostly for fun and get better to Excel for my self

[ismailismaili]

easy, awesome, and very useful thank you so much Mr. Mike really appreciate your videos

[hassanalaidroos]

Hello Sir, You are amazing . Thank you so much. May God bless you.

[Rahul-]

Thanks and could you upload some video on dashboard

[johnmartin]

Hi Mike, on the series discount tab, you have the 1st Trade Discount at 40%, and the Trade Discount 10%, yet in row 3 you have the series discount at 40/20. Is this correct, and I am missing something, or should the 2nd discount 10% match the the number in the equation 40/20?

[petewilkins]

Hi Mike.. fantastic work. Is it possible to contact you to help with a problem without discussing it here?