Dive into a comprehensive 37-minute video tutorial on trade discounts, series discounts, net cost equivalents, and wholesale cost calculations in Excel. Learn essential business terms, explore various methods for calculating wholesale costs, and master the use of VLOOKUP and IF functions to automate calculations. Gain practical skills in handling single and series trade discounts, including scenarios where discounts depend on purchase quantities. Download accompanying Excel files and PDF notes to enhance your learning experience in this Excel and Business Math class taught by Michael Girvin at Highline College.
Excel & Business Math - Trade Discounts, Series Discounts, Net Cost Equivalents & Wholesale Cost
ExcelIsFun via YouTube
Overview
Syllabus
) Introduction.
) Business Terms: Retail & Wholesale Businesses. List Price and Wholesale Cost. Trade Discount $ Amount..
) Examples of Wholesale Cost Catalogs and the four different formulas needed to calculate Whole Sale Costs under four different assumptions..
) Single Trade Discount % Video Example. See three different Methods to calculate Wholesale Cost..
) Calculate Series Discounts. See three different Methods to calculate Wholesale Cost..
) Series Trade Discount % with Two Successive Discounts.
) Series Trade Discount % where 2nd Discount Depends on Quantity Purchased. Learn how to use VLOOKUP Function..
) Series Trade Discount % where 2nd & 3rd Discount Depends on Quantity Purchased..
) Learn how to use IF & VLOOKUP Functions to make calculations automatic for a Series Discount..
) Summary.
Taught by
ExcelIsFun
Related Courses
-
Create Excel Invoices, Data Validation Drop-Down, VLOOKUP & IF Functions
-
Excel and Business Math - VLOOKUP and MAX Functions for Percentage Method Federal Income Tax Deduction
-
Excel & Business Math - Date Math, Invoices, Cash Discounts on Invoices, Nested IF Functions
-
Excel Basics - Excel Table Feature & Dynamic Ranges for VLOOKUP, PivotTables, & More
