Close window

Formulas included in the Marketing Spreadsheet

Number of Units Sold per Period
Contribution Margin
Conversion Costs
Direct Labor Variable Costs Per Unit
Direct Materials Variable Costs Per Unit
Fixed Manufacturing Overhead
Fixed Marketing and Administration
Full Absorption Cost
Full Cost
Gross Margin
Manufacturing Fixed Overhead Costs Per Period
Manufacturing Fixed Overhead Costs Per Unit
Manufacturing Variable Overhead Costs Per Unit
Marketing & Administrative Fixed Costs Per Period
Marketing & Administrative Fixed Costs Per Unit
Marketing & Administrative Variable Costs Per Unit
Period Costs for the Period
Period Costs per Unit
Prime Costs
Product Cost per Unit
Profit Margin
Sales Price per Unit
Variable Cost
Variable Direct Labor
Variable Direct Materials
Variable Manufacturing Cost
Variable Manufacturing Overhead
Variable Marketing and Administration

Cost and Margin Interactive Graphs
Break Even Quantity
Break Even Sales
Cash Operating Break Even Quantity
Contribution Margin
Full Capacity Sales
Gross Profit Margin
Manufacturer's Margin
Retailer's Margin
Total Contribution
Total Cost
Wholesaler's Margin

Here is a sample image of what a portion of the Marketing Spreadsheet looks like:

Click to close this window