Basic Excel Business Analytics - Good Spreadsheet Model Design, Fixed Variable Cost Example

Overview

Dive into the principles of good spreadsheet model design through a practical fixed variable cost analysis example. Learn how to structure your Excel workbook effectively, starting with the creation of a well-organized formula inputs area. Develop mathematical formulas to describe your calculations, and construct a model area incorporating decision variables. Explore the use of influence diagrams to visualize data flow, and implement Excel formulas with proper labeling and formatting. Conclude by conducting what-if analysis to test your model's flexibility. Download accompanying files to follow along and reinforce your understanding of business analytics in Excel.

Syllabus

) Rules for Good Spreadsheet Model Design & Excel’s Golden Rule.
) Description of the Fixed Variable Cost Analysis for the manufacturing of a Quad Boomerangs From Gel Boomerangs.
) Create Formula Inputs Area (Formula Inputs, Parameters, Assumptions, Variables) with proper labeling and formatting.
) Create Math Formulas that describe our calculations for our model.
) Create Model Area that contains Decision Variable and later it will contain our Excel Formulas..
) Influence Diagram to show the flow Formula Inputs and Formulas in the Model..
) Create Excel Formulas in the Model Area with Proper Labels and Formatting..
) What-If Analysis with our Model.