Search results
Results from the Tech24 Deals Content Network
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 ...
Hi Guys So, I need a formula or a VBA method to Increase a Sale Prices by 25% based on cost + 25% but when the sale price goes up a fee price also goes up so I end up with a circular reference! Lets say: Cost In E2, Fee in G2 and Postage Cost in i2. In J2 I want to add the costs up and add...
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 ...
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.
Using the formula, a cost price of £1 results in a sale price of £4.66. Taking out the costs results in a profit of £0.18 which is 4.5%. If I would like the margin to be 20% of the sale price e.g sell for £4 I would be left with 80p profit after VAT, commission and other costs. Using your formula: Calculated Sale Price £4.66
I’m after some expert help to find a formula that will do the following: I want to know the sale price of my goods, when I enter the gross profit percentage that I want to make (not markup%). I know the cost price of my goods. For example, I want to make 50% gross profit on something that costs me £1.00.
we have margin calculators that have cost / sell / margin options. i simply cannot work out the maths to write a formula in excell. example. £1.00 ADD 30 percent margin = £1.43. £1.43 minus 30 percent marging = £0.99. £1.43 sale price £1.00 cost price = 30 percent margin. hope i make sense and thanks for looking.
now how do you calculated the sales price needed in order to achieve a net price required , since the fees increase when the sales price changes. so if i want to make £25 , what price must i sell the item at. you cant just add - sales price + fees together , as now the new fees are larger. Net Price = sales price - ( ( (Sales price)*0.1322)+0.3)
Hey guys, I'm sure this is an easy formula, but for some reason today I cannot seem to figure it out. I'm trying to come up with either a table or formula that I can have on an Excel spreadsheet which will help me calculate a sales price. Here is my example: I have some materials which costs me $1600 for 1600 sq ft.
Hi everyone, I'm having a mental block. I need to work out a formula to calculate the Cost Price of items, if i know the selling price and the GP%. Also VAT needs to be calculated at 20%. I've done it before, but having a complete block. So bacially: A1 = £3.00 (Selling price including 20%...