1 of 1 people found this helpful
GROSS PROFIT: Sales - Cost of Goods Sold = Gross Profit
So a sample calculation for Gross Profit would be SUM([Sales]) - SUM([Cost of Goods Sold])
What makes up Cost of Goods Sold? You'll need to decide which if (or all) any of the following make up that amount:
Variable costs include:
Plant supervisor salaries
Utilities for a plant or a warehouse
Depreciation expense on production equipment
Fixed costs generally are more static in nature. They include:
Office expenses such as supplies, utilities, a telephone for the office, etc.
Salaries and wages of office staff, salespeople, officers and owners
Payroll taxes and employee benefits
Advertising, promotional and other sales expenses
Auto expenses for salespeople
GROSS PROFIT MARGIN (RATIO): Gross Profit / Sales = Gross Profit Margin
So a sample calculation for Gross Profit Margin would be (use previous Gross Profit calculation): [Gross Profit] / SUM([Sales]) and format as a % Percentage if desired or leave as decimal.
Hope that helps! Thx, Don
I have no idea!
I can only point you in the right direction. You'll need to decide whether your data matches what I've provided. I don't have access to your data so cannot definitively tell you one way or the other. Thx! Don