You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
If I wanted to calculate the (wholesale price) x (mark up percent) to find (retail sale price) on Apple numbers what would that formula look like
if I wanted to calculate the (wholesale price) x (gross margin percent) to find the (margin dollars) on apple numbers what would that formula look like
First, some clarification of terms:
Margin, also referred to s gross margin, is the difference between cost and selling price. When expressed as a percentage, it is the percentage of the sale price that is (gross) profit.
Markup is the amount that must be added to the cost of an item to determine its sale price. when expressed as a percentage, it is the percentage of the cost price needed to attain the desired gross margin.
Because the markup amount and the margin amount are the same, percent markup is always greater than percent margin.
For a more detailed article regarding margin and markup, see What is the difference between margin and markup at AccountingTools.com
Suppose you had a product that cost you $75, and you wanted to sell for $100, for a gross margin of 25% (of $100)
To achieve that margin, you will need a $25 markup of the cost ($75), or 33,3%
Here are the calculations:
In each row, B is the cost price, C is the margin or markup percentage and D is the retail (sale) price. The two cells with numbers ar the known values. The unknown value shows the formula needed to get the unknown result. The same formula is entered into column D, and calculates the result shown. Column E contains labels naming what has been calculated on that row.
The four formulas are repeated in copyable text below the table.
D2: retail price from cost price and markup %: B2×(1+C2)
C3: margin % from Retail and Cost prices: (D3−B3)÷D3
C4: Markup % from cost and retail prices: (D4−B4)÷B4
D5: Cost price from retail price and margin %:: D5−(C5×D5)
Regards,
Barry
AustinBudelo wrote:
If I wanted to calculate the (wholesale price) x (mark up percent) to find (retail sale price) on Apple numbers what would that formula look like
=B3*(1+B6)
Where cost (or wholesale price) is in B3 and markup % in B6.
f I wanted to calculate the (wholesale price) x (gross margin percent) to find the (margin dollars) on apple numbers what would that formula look like
=B3/(1−B5)−B3
where cost (or wholesale price) is in B3 and gross margin % is in B5
Note that the gross margin % can be further than markup % from "breakeven" 0% – when you're selling at a loss!
SG
assuming that:
Wholesale Price is in cell B2 and
Markup percent is in cell C2
the formula is:
=B2*C2
if you want a fixe mark up and that value is in cell C1, then you can use the formula:
=B2*$C$2
Numbers Formulas
