selling

Hi All, Hoping there's an easy formula for this as I am having a blank moment. So the below is a simple example of what I am trying to pull through in to column E. I would like to look up multiple "Item Number" which are the same, sometimes theres 2/3/4 of the same items. I would then like...

I have cost of $100.00, I need a 10% profit = $110.00. total selling price. I have a 35% lease agreement that reduces $110.00 to $71.50. I have tried to merge these two formulas to accomplish, a formula that will tell me what profit I need to make for my total selling price, to be the same...

I have cost of $100.00, I need a 10% profit = $110.00. total selling price. I have a 35% lease agreement that reduces $110.00 to $71.50. I have tried to merge these two formulas to accomplish, a formula that will tell me what profit I need to make for my total selling price, to be the same...

Hi Guys I'm hoping someone can help. I have a spread sheet with all my products which include the purchase price, shipping costs and fees etc. I have a column for the minimum sale price, and this needs to be the break even price after VAT @ 20%, amazon fees, packaging costs etc Here is an...

Hi All, I need a Excel formula to calculate my selling price based on a predetermined profit. What is know is: 1) The final profit after all the cost ($20) 2) The item cost 3) The merchant fee which is 10% (0.10) 4) The payment processor fee which is 2.9% + $0.30 5) The shipping material cost...

Hi folks, I'm not sure if this has been posted before or if there is a guide on how to do this on this forum, so apologies if there is. I want a formula which I can use to work out my selling price on eBay, assuming I want to make a 15% profit of the selling price, and the following are my...

Hello All, I am trying to build a template to calculate the selling price of an item given the various costs. Assuming I buy a product for $10.00, I expect to make a 10% profit Margin so technically I would need to sell it for $11.00 So far I can handle it, the issue is that the platform where...

I'm looking for help regarding calculating profit margins when selling on marketplaces Amazon I'd like to know if it would be possible to set the profit margin to eg. 20% and work backwards from there; have excel calculate what my selling price should be to make the 20%? Fixed Expenses...

142.88 143.97 144.50 145.00 142.00 -1.06 -1.06 -0.97 -0.80 -0.70 how can i show the correlation between selling price and Raw material update line chart

I have a workbook that has two tabs. Tab 1 = Selling price and selling month (i.e. in A1 I have the month #, in A2 I have the selling price of a house) Tab 2 = Columns for month 1,2,3, etc all the way out to month 24. (i.e in A1, etc I have month #, and in A2, etc I want the selling price...

Hi, I know it's Monday and I keep hitting a wall to calculate my selling price. I am trying to come up with a selling price where I can factor in all my costs and still make a 10% profit. The problem is I pay a 15% hosting fee based on the selling price I list, I want to make sure I am...

Hi, I made this sample file. I would like to do the following under Nov Sales Sheet. https://docs.google.com/spreadsheets/d/1OawXSruy50khcw_zQDQtd7vhPlslpmsQUR-gUoCgrU4/edit?usp=sharing If SALE(C5) = "Y"(a drop down Y and N list), I would like to delete the contents of "SELLING FOR.(E5)" and...

Hi I have a P&L that calculates the selling prices as a positive and the product costs as a negative but want to determine the % markup. I have a positive selling value $280,000.00 in Q50 and a cost that is a negative value in Q50 -$200,000.00 so the markup should return as 40% markup but cannot...

Hi, I would like to ask if there is any way to retrieve information such as "sold by" which seller, and how much is the selling price...

Formula math logic issue: I know these things: 1. vendor cost 2. desired net margin dollars 3. commission percentage what I don't know and need to determine by formula is: 1. a selling price 2. a value of the commission % (I know the desired percentage, but since I don't know the selling...

Can I have a value inserted into a sentence? "If you are selling under the name of<insert data="" from="" a2="">,(data from a2) please select one" Thank you in advance.</insert>

Is possible count by formulas eBay Buy It Now price ? My cost price is £10 I want 40% = £14 (£4 profit) I need add ebay Fees + Postage + PayPal fees so I need selling price £17.90 Where is PayPal 3.4% + 20p Ebay 40p listing Ebay 10% Fee Postage £0.9 I need formula where I set my cost...