markup

Someone please solve this equation. I have a markup equation that I fill down. I'm trying to net no less that 5.00 but I have products with a wide range of total cost. Price = Total cost + Markup percentage. Net = Price - Total cost. That part works great. The following is what i'm trying...

I apologize in advance if this has been answered. I searched and couldn't find my exact issue. I am creating a quote tool that lists items with a column for cost, sell, and profit. Those columns are totaled. Then I have an area for lease info where the total in the "sell" column is...

Hey all. I have a worksheet which has a bunch of products. These products are keyed by a product type. Beneath this product list, there is a subtotal, profit (markup * subtotal), tax, commission, and a final total. Markup rate, tax rate, commission, etc. can vary based on product type (e.g...

Hey all, I'm looking for a way to dynamically lookup markup rates from another worksheet, multiply them by the correct prices for matching products on the sales worksheet, and display it as a total markup amount beneath the subtotal. Some of the items, however, need to be excluded from the...

First time poster and desperate for help! I work in sales spend a lot of my time working out selling prices for my team and me. As a sanity check, I use a spreadsheet (I call my Margin Calculator) to enter all costs and then, depending on the client, the final selling price rather than pen and...

Hello. I have a quote sheet that marks up my price by a certain percent. The way I have it set up now is for a 10% markup and I adjust it manually. C1 = .10, C2 is where I enter the cost, B2 = C1*C2, A2 = B2+C2. I would like change this to vary the markup percent based on the cost. Ie. as the...

Hi as an employee of an Amazon business, I want to make a listing on amazon. How can I calculate a markup of 10% in excel? - the markup is “on the cost of the item plus the fee amazon takes after the item being sold” which is a percentage of the listing/sale price? Is it possible to have an...

I have a table that has the following Format <tbody> Plate Group Count Market Cost/LB Markup Markup % <= 1.5 and <= 120 319 .46 .39 .07 18% </tbody> I am trying to see if there is a simple way to convert that to <tbody> Plate Group Type Value <= 1.5 and <= 120 Count 319 <= 1.5 and <=...

I've learned that (almost) anything is possible in Excel, so I'm confident someone knows the solution to this :) I'm working on a margin markup formula for our customer reps to use, but the markup percent needs to exponentially decrease as the hard pre-quote value rises, until reaching a set...

Hello, I have the below text that I would like to extract the person's name (highlighted in bold) who is responsible for "Markup Changes" .. essentially this is the second instance of "responsibility of" Cell text looks like this variable text (Responsibility of: surname, firstname, due...

Hi all. This is my first ever post on MrExcel. :) So I have a bunch of OLAP cubes in excel which need to be updated regularly. I have a field "Markup Range" in Report Filter which has a lot of values from 0.00 to 99.99. Now I need this Markup Range filtered. I filter out the value "0.00" in...

Hi all. This is my first ever post on MrExcel. :) So I have a bunch of OLAP cubes in excel which need to be updated regularly. I have a field "Markup Range" in Report Filter which has a lot of values from 0.00 to 99.99. Now I need this Markup Range filtered. I filter out the value "0.00" in...

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...

I have a sheet of 30,000 parts with my vendor costs and I'd like to figure out a formula to apply a certain markup percentage for a certain range of values. $.01-$.49 : Markup Percent 809% ( or mark-up multiplier= 9.091) ex. $.30*9.091=$2.73 $.50-$1.99 : 567% (6.667) $2-$24 : 212.50% (3.12)...

So this is what I am dealing with. When I start, only column N is filled in. I have to calculate 2 different markup prices in the columns to the left. My problem is, the file is many pages long and column N sometimes has blank fields or text, as you can see, so I am unable to just copy a formula...

Hi Mr.Excel, I'm trying to streamline my business and I'm having a heck of a time with a spreadsheet I'm working on. I'd like to create a spread sheet for my estimators that allows them to put in the quantity, description and cost of goods and my spreadsheet will determine the mark-up based...

Good afternoon. In my job, I receive cost invoices that I must convert over to sell invoices. Since markup is typically static across multiple lines of the invoice, is there a way for me to apply markup percentage to the cells that I highlight and replace those results right back into the cells...

<P style="MARGIN: 0in 0in 10pt" class=MsoNormal><FONT size=3 face=Calibri>Background: (1) I have a (Windows Vista) 2007 Excel worksheet with 14 columns and 2,354 rows, for a total of 32,956 cells. The file’s size is 304KB. Alone, the file serves as our parts and price list for our wholesale...