Part 3: Decision Making with Excel 2007

Part three of the book Excel 2007 with Excel Master is concerned with decision making. The book takes you through a wide range of methods and techniques of decision making. Some of the content of part three are essentially scene setting: things that you need to understand before you can apply Excel 2007. Other topics are more advanced and are concerned with the decision making itself.

Contents of Part Three of the Book

At the time I am writing this, I have not finished writing the book and so what you are about to read is still subject to change. However, it gives you a good idea of what I am preparring. Here is the content of part three of the book:

 

Decision Making

 

  • Chapter 8
  • Chapter 9
  • Chapter 10
  • Chapter 11
  • Chapter 12
  • Chapter 13
  • Chapter 14

Behaviour of Costs

  • Splitting costs into their fixed and variable elements
  • MINVERSE
  • MMULT
  • Non linear costs
  • The linear treatment of costs: true and fair?

Break Even Analysis

  • Building on the work of chapter 1 of this part of the book, we will now explore the practical application of the behaviour of costs under the heading of break even analysis
      • the break even point in values
      • the break even point in volumes or units
      • the contribution per unit
      • the contribution to sales (C/S) ratio
      • the margin of safety
      • multi product break even analysis
      • the break even points under uncertainty
      • BEA applied to real data

Marginal Costing and Decision Making

  • Continuing with the theme of the behaviour of costs and the application of it to management accounting situations, in this chapter we explore how a knowledge of marginal costs can be used in decision making.

Stock Valuation and Traditional and Activity Based Costing

  • Stock Valuation Methods
    • Weighted Average
    • First in First Out
    • Last In First Out
  • Traditional overhead analysis: absorption costing
  • Allocation
  • Apportionment
  • Re apportionment
  • Overhead absorption rates
  • Absorption costing
  • Activity Based Costing

Budgeting

  • This chapter concentrates on the preparation of budgets and budgeting reports that include:
  • Functional budgets
  • Cash budgets
  • Master budget
  • Budget reports
    • Conditional formatting
  • Balanced scorecard reporting

Capital Budgeting

  • Payback
  • Accounting Rate of Return
  • Net Present Value
  • Profitability Index
  • Internal Rate of Return
  • Divisibility of Projects

Excel Techniques for Analysis and Decision Making

  • Goal Seek
  • Scenario Manager
  • SOLVER
  • Excel Tables

 

 

 

Once the table of contents has been finalised, there will be a PDF Format copy of it available here