Download Start Excel File: http://ift.tt/2FqXHDO
Download pdf Notes: http://ift.tt/2tvXcmg
Entire Class Web Site: http://ift.tt/2BjafuY
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