Search results
Results from the WOW.Com Content Network
The first thing you have to do is get the selling price of your item that generates a 15% Gross Margin. In you example your total cost, is the item cost plus the shipping: 1.72 + .87 = 2.59. To get a Gross Margin of 15% for item that costs 2.59, you must divide the cost by the reciprocal of the GM. So that is 2.59/ (1-15%) = 3.05.
Margin % = (Cost-Retail)/Retail so if we wanted to calculate the Retail price of an item based off a margin given we would follow a formula =24.9/(1-.85) this would give you the sale price of $166. Now if you were in a retail company that insisted on everything ending in .*9 then you could build additionally onto this like such =(MROUND(24.9/(1 ...
Minimum amazon selling price (Incl. VAT): currently set manually at £301.99 (This is the price I need the formula to work out for me when I change the minimum profit, amazon fees, VAT rate or cost price values) cost price (excl. VAT): £199.91 VAT rate: 20% Amazon fees: 0.15 (Minimum selling price *0.15) minimum profit: £6.45 Thank you Matthew
I know the cost price of my goods. For example, I want to make 50% gross profit on something that costs me £1.00. The answer I know is not £1.50 as that is only a gross profit of 33%. But I know that if I sell at £2.00 I am getting my GP at 50%, but what is the formula to work that out! Please help! Neil
Also I need 15% added to the value excluding the cost price. For eg. A1 - £2.99. A2 - 20%. A3 - £3.58. I need to input into A2 to give me a value in A3 and also to add 15% onto the difference between A1 and A3 (£0.59 which will then be £0.69) into A3 to give the correct value of £3.68. I have tried doing this multiple cells but it doesn't ...
Feb 11, 2017. #1. NOG stands for Nett On Gross and is calculated by dividing cash margin ex VAT by retail sales including VAT. Whereas the standard method of working out retail margin is cash margin divided by retail sales excluding VAT. NOG example. Retail Sales Price of Product X = £2.00. Less 20% VAT = £1.67.
236. Feb 5, 2014. #1. If I want to workout the profit on return (POR) of a particular item I would divide the margin (difference in selling price to cost price) by the selling price. EX:- Product A costs $1.50 and sells for $4.50 the margin is $3.00 if you then divide that margin by the retail price you get the POR like so 3.00/4.50 =66.67%.
Hi, I use a repricing software for amazon which automatically reprices my items. I have a spreadsheet with all of my data in, but at the moment I manually set my minimum price to get the desired minimum profit. Can anyone help me with a formula that can work out the minimum selling price using...
Hi There, I wanted to create a formula on my speadsheet that will automatically populate the selling price for an item on eBay. Cell A = Cost Price (price I paid for the item) Cell B = Ebay Selling fee (12.8% Plus 30p fixed fee) Cell C = Profit margin on the cost price (15%) Cell D - List Price. So basically I know what Cell A is going to be ...
New Member. I am not sure if it is possible to do in Excel, but is there a formula or way to use Solver to allocate based on the selling price, and is contingent upon (1) the allocated amount must be less than or equal to the capacity, and (2) the sum of the allocated amount by part number must be equal to the sales forecast by part number.