Close window

Formulas included in the Managerial Accounting Spreadsheet

Costs and Margins
Fixed Marketing and Administration
Fixed Manufacturing Overhead
Variable Marketing and Administration
Variable Manufacturing Overhead
Variable Direct Labor
Variable Direct Materials
Variable MFR Cost
Variable Cost
Full Absorption Cost
Full Cost
Prime Cost
Conversion Cost
Product Cost per Unit
Period Costs per Unit
Profit Margin
Gross Margin
Contribution Margin
Period Costs for the Period
Process Costing - FIFO
Beginning Work In Process (BWIP)
# of Units Started this Period
# of Units Completed this Period
Ending Work In Process (EWIP)
Equivalent Units
Beginning Work In Process (BWIP)
# of Units Started & Completed this Period
Ending Work In Process (EWIP)
Unit Costs and Total Cost
Cost Assignment
BWIP Cost for Last Period
BWIP Cost for Current Period
Cost for Started & Completed Current Period
Total Current Period Costs
EWIP Cost for Current Period
Total Cost

Economic Value Added
Total Capital Employed
Predetermined Overhead Rates
Calculated Variable Overhead Rate per Labor Hour
Calculated Variable Overhead Rate per Labor Dollar
Calculated Variable Overhead Rate per Production Unit
Calculated Fixed Overhead Rate per Labor Hour
Calculated Fixed Overhead Rate per Labor Dollar
Calculated Fixed Overhead Rate per Production Unit
Production Cycle Time
Production Cycle Efficiency
Waste Ratio
Profit Variance Analysis
Sales Price Variances
Sales Volume Variances
Sales Revenue Variance
Variable Cost Variance
Contribution Margin Variance
Fixed Cost Variance
Total Flexible Budget Variance
Flexible Budget
Master Budget
Operating Income
Level 0 Variance Analysis
Level 1 Variance Analysis
Level 2 Variance Analysis
Actual Operating Income
Budgeted Operating Income
Budget Variance of Operating Income
Direct Cost Variances
Efficiency Variance
Variable Overhead Variance
Allocated Variable Overhead
Spending Variance
Fixed Overhead Variance
Production Volume Variance
Total Fixed Overhead Variance
Allocated Fixed Overhead
Underallocation of Overhead
Overallocation of Overhead

Here is a sample image of what the Managerial Accounting Spreadsheet looks like:

Click to close this window