Budgets and Organizational Architecture

Budgets and Organizational Architecture

Variances:

Variances:

Variances:

Examples

Example: Country Club

Example: Private University

Responsibility centers in 4 colleges: 2 cost centers, 2 profit centers.

Example: Private University

Example: Private University

Example: Large Corporation

Example: Large Corporation

Example: Large Corporation

Trade-offs

Trade-off: Communication vs. Evaluation

Trade-off: Communication vs. Evaluation

Budget Ratcheting

Budget Ratcheting

Budget Ratcheting

Trade-off: Bottom-up vs. Top-down

Trade-off: Bottom-up vs. Top-down

Trade-off: Resolving Disagreements

Modern budgeting

Modern Approaches to Budgeting

Modern Approaches to Budgeting

Modern Approaches to Budgeting

What do you think of the Following Assertions?

Horizon

Short-run vs. Long-run

Budget Types/Terms/Policies

Modern firms use a mix of all of these types.

Line-Item Budgets

Line-Item Budgets

Rolling Budgets

Rolling Budgets

Rolling Budgets

Note: Similar to ABC, this is hard for companies with poor information systems and very natural for firms with modern information systems.

Budget Lapsing

Budget lapsing is a requirement that funds allocated for a particular year cannot be carried over to the following year.

Budget Lapsing

Budget Lapsing

Incremental vs. Zero-Based Budgets

Static Budgets

Flexible Budgets

Note:

The static and flexible budgets will be used in the next lecture to decompose variances!

Example: Sandy Cove Bank

Sandy Cove Bank

Sandy Cove Bank

Sandy Cove Bank

Sandy Cove Bank

Loan Rate Loan Demand Savings Rate Savings Supply
6% $12,100,000 2% $ 4,700,000
7% 10,000,000 3% 5,420,000
8% 8,070,000 4% 8,630,000
9% 6,030,000 5% 9,830,000
10% 4,420,000 6% 11,800,000

Sandy Cove Bank

Sandy Cove Bank

Sandy Cove Bank

Sandy Cove Bank

SCB Question 1

  1. Calculate the processing, loan default, and overhead expenses for each possible interest rate.
Loan Rate Loan Demand Savings Rate Savings Supply New Loans
6% $12.1 M 2% $ 4.7 M $ 4.7 M
7% 10 3% 5.42 5.42
8% 8.07 4% 8.63 8.07
9% 6.03 5% 9.83 6.03
10% 4.42 6% 11.8 4.42

SCB Solution 1

Loan Rate Loan Demand Savings Rate Savings Supply New Loans Processing Expenses
6% $12.1 M 2% $ 4.7 M $ 4.7 M $70,500
7% 10 3% 5.42 5.42 81,300
8% 8.07 4% 8.63 8.07 121,050
9% 6.03 5% 9.83 6.03 90,450
10% 4.42 6% 11.8 4.42 66,300

SCB Solution 1

Loan Rate Loan Demand Savings Rate Savings Supply New Loans Processing Expenses Default Exp
6% $12.1 M 2% $ 4.7 M $ 4.7 M $70,500 $47,000
7% 10 3% 5.42 5.42 81,300 54,200
8% 8.07 4% 8.63 8.07 121,050 80,700
9% 6.03 5% 9.83 6.03 90,450 60,300
10% 4.42 6% 11.8 4.42 66,300 44,200

SCB Solution 1

Loan Rate Loan Demand Savings Rate Savings Supply New Loans Processing Expenses Default Exp Overhead Expenses
6% $12.1M 2% $ 4.7M $ 4.7M $70,500 $47,000 $30,000
7% 10 3% 5.42 5.42 81,300 54,200 30,000
8% 8.07 4% 8.63 8.07 121,050 80,700 30,000
9% 6.03 5% 9.83 6.03 90,450 60,300 30,000
10% 4.42 6% 11.8 4.42 66,300 44,200 30,000

Logical flow

Logical flow{ height=75% }

SCB Question 2

  1. Create an annual budgeted income statement for five-year loans and deposits for the Boat and Car Loan Department given a savings interest rate of 4 percent. Remember to match supply and demand.
     
Interest income $8,070,000 × 8%= $645,600
Interest expense $8,070,000 × 4%= 322,800
Net interest income   $322,800
Fixed overhead   30,000
Processing expense   121,050
Default expense   80,700
Net income   $ 91,050

SCB Question 3

  1. Table 2 shows the actual income statement for the Boat and Car Loan Department. Included are the actual loans and savings for the same period. Calculate the variances and provide a possible explanation.
  Budget Actual
Interest income $645,600 $ 645,766
Interest expense 322,800 314,360
Net interest income $322,800 $ 331,406
Fixed overhead 30,000 30,200
Processing expense 121,050 130,522
Default expense 80,700 77,800
Net income $ 91,050 $ 92,884
Loans 8,070,000 $8,062,000
Deposits 8,070,000 $8,123,000

SCB Solution 3

  Budget Actual Fav. (Unfav.) Variance
Interest income $645,600 $ 645,766 $ 166
Interest expense 322,800 314,360 8,440
Net interest income $322,800 $ 331,406 $ 8,606
Fixed overhead 30,000 30,200 (200)
Processing expense 121,050 130,522 (9,472)
Default expense 80,700 77,800 2,900
Net income $ 91,050 $ 92,884 1,834
Loans 8,070,000 $8,062,000 $ (8,000)
Deposits 8,070,000 $8,123,000 $(53,000)

SCB Solution 3

SCB Solution 3

SCB Solution 3

SCB Solution 3

SCB Solution 3

Master Budget

NaturApples data

NaturApples data

NaturApples data

NaturApples data

NaturApples data

NaturApples data

NaturApples budgeting process

NaturApples budgeting process

NaturApples budgeting process

NaturApples budgeting process

NaturApples budgeting process

Logical flow

Logical flow

Logical flow{ height=75% }

Logical flow

Logical flow

Three key processes:

  1. procurement
  2. sales
  3. production

NaturApples budgeting process

NaturApples budgeting process

NaturApples budgeting process

NaturApples budgeting process

NaturApples budgeting process

NaturApples budgeting process

Basic data:

Basic Data for Budgeting Example for Fiscal Year Beginning 10/1/19:

  Cases Cost/Case  
Beginning Inventory 13,500 $57.96 $782,460
Sauce 2,300 $48.81 $112,263
Pie filling McCoun Granny  
Pounds of Apples/Case      
Sauce 60 40  
Pie filling 50 30  

Departmental budgets:

Departmental budgets:

Departmental budgets (sales):

  Budgeted Cases Budgeted Price/Case Budgeted Revenue
Sauce 140,000 $68.95 $ 9,653,000
Pie filling 60,000 53.95 3,237,000
Total     $12,890,000