Search results
Results from the WOW.Com 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 ...
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.
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.
ASO. $44.43 . 12/15/2021 . Sold. AAPL. $160 . Where if I type in a stock ticker, for instance AAPL, it will tell me if I sold it at a loss in the past 30 days. In this case AAPL would be a wash sale. If I type in MSFT it would not be a wash sale since I sold it for a profit.
The VP of sales in my company has dreamt up the most convoluted sales plan in the history of the world. Rather than just paying the reps a straight commission, this plan involves paying a base rate and a 2% bonus based on the product sold, and a monthly profit sharing bonus. For the spreadsheet below, I need to create a formula that can be copied to all rows and all months.
Bill method 1: Re-shape the team hierarchy data. Make both ranges into Ctrl + T tables. Create a pivot table, adding the data to the data model. Pull Team from second table. Mike Method2: Build a SUMIFS where the Criteria2 field is an array! Bill Method 3: Rearrange the hierarchy table so sales rep is on the left.
May 2, 2018. #1. I have stock buy/sell transactions and want to calculate my position. Here is some sample data: I can calculate most things I need but I'm struggling with Average Cost. So XXX bought 100 at $1 then sold 50 at $2, so my average cost is $1. Then bought 100 at $2 and sold 100 at $3 so I have a Holding of 50.
Hi all, I'm looking for a way to do a calculation based on price bands where a value needs to be calculated based on several bands: Transaction Bands Price 10000 0.2 20000 0.15 50000 0.1 1000000000 0.05 Based on the bands above, if the number of transactions is 80000 then the way...