Practical Accounting The Better Way to Learn. Breakeven Point, Target Profit, Change of Variables, Practice in Excel.
What you will learn
Using a Pizza Shop Example, learn ONE straightforward method in Excel to analyze Cost Behavior and Use the Method to separate Mixed costs into Variable & Fixed
Learn the One Formula needed for this module. Make the CVP Graph Dance to Understand how Price/Unit, Variable Cost/Unit, Fixed Cost and Volume Impact Profit
Solve for Breakeven Point and Target Profit using the same One Method – No Formulas to Forget
Understand One Method Operating Leverage and Margin of Safety. Enhance your Excel Skills with the Included worksheets.
Description
Developed over 15 years by a Professor and Master Tutor Team. View and use Excel to on the Path to a Deep Understanding of CVP relationships. Do it All with One Method, One Formula and One Interactive Graph. Eliminate the Need to Memorize Formulas.
Lesson 1: Introducing the Bridge: One formula that you already know applied to the course and a straightforward explanation using the One Method to explain the difference between Absorption and Variable Costing.
Lesson 2: Learn the how to classify Costs using a Pizza Shop example with Graphics.
Lesson 3: The Bridge Problem Solving Method is applied to a Self Checking Puzzle format to Separate Mixed Costs. Additional Practice Problems and Solutions are in the Workbook.
Lesson 4: Integrate the Bridge Method of Computation with the Graphical Chart to develop the foundation of Breakeven Point Analysis.
Lesson 5: Apply the Bridge Method to calculate Breakeven Point without using the Formulas and apply your knowledge with Practice Puzzles and solutions.
Lesson 6: Module Highlight: Change Price/Unit, Variable Cost/Unit, Total Fixed Cost and Units. Make the Graphs Dance then Apply your Knowledge with Practice.
Lesson 7: Learn Operating Leverage and Margin of Safety using the Bridge Method for straightforward computation and application.
Includes Excel Workbook with Dancing Graphs and Practice Sheets
Content