Increase/Markup Cost By X Percent
Formula for figuring retail price from cost. ie Cheeseburger 1.00 cost and I want a 60% markup. (2.55 Retail)
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Cost Based Mark Up
set up a cost based markup spreadsheet? I need to be able to mark up values from 0.019.99 by 20% of their value, and 10.00 and above by 10% of their value. I only know how to mark up values by a single percentage.
View Replies!
View Related
Percent Over Last Year
I want to find the percent of increase over last year. If last year was 100 and this year is 500 then the percent would be 500%. However things get tricky if last year was 100 and this year is 500 or if last year was 100 and this year is 500 then it get's screwy and I'm not sure what formula to use to handle any situation.
View Replies!
View Related
Top 90 Percent
how to mimic SELECT TOP 90 PERCENT from Access in Excel? I can't use the percentile function because it interpolates the value if you don't have the right multiple of values in your array.
View Replies!
View Related
#DIV/0! With A Percent
I have a spreadsheet that determines what percent increase over a previous quarter. The values can be negative or positive; however, I have one entry that I'm trying to divide zero by a number which results in the #DIV/0! error message. I rather have it say 1000% since that is the value I'm looking for. I now how to deal with a simple division by using an IF statement such as IF(B1,A1/B1,0), but this one is throwing me a curve. The attached spread sheet is a quarterly percent increase over the last one. In the example, N00377 represents a machine in cell D14 and D17, where cell D17 is the last quarter, and I'm comparing it to cell D14 which should show an increase or decrease in cell F.
View Replies!
View Related
Percent Formula
I need a formula to show percent value in a certain way in cell D1 formula is C1 = B1A1 but I am stuck to get the percent syntax in formula bar right. D1 = PERCENT OF B1A1 Example1 A1 B1 C1 D1 52.52.5050 % ( RED/NEGATIVE PERCENT) Example2 A1 B1 C1 D1 2.552.5050% ( BLACK/POSITIVE PERCENT) Example3 1037.0070% ( RED/NEGATIVE PERCENT) 3107.00 70% ( BLACK/POSITIVE PERCENT) Somehow I seem to think I need to use the Value of C1 ( which is required btw) to get a percent in D1, but not sure how it would go in one complete formula in D1
View Replies!
View Related
Figuring Percent %
This is what I have Rate Hours =basePay plus 6% plus 7.1% total $50.00 10 $500.00 $530.00 $567.63 $567.63 What i want to have is one cell that I can Total everything. I want my spread sheet to display just rate, hours total I am having troule making the formula to display everything in the total cell
View Replies!
View Related
Calculate Probabilities In Percent
I have had a fascination with the lottery, purely hobby, and have had lots of fun over the years working different things out. The last 6 months though I have become fascinated with roulette & thought it would be a fun project to work out all sorts based around that, plus I don't have to wait for lotto results I can get instant numbers & results, however my latest attempts are hitting a brick wall! I am trying to work out (in percentages) the increasing & decreasing % of 3, 11, 12, 22, possible outcomes I have worked out the 2 possible outcomes initially for odd/even as follows At the start they both have a 48.65% chance of hitting, then whatever is hit first the percentages are 76.33% and 23.67%. If you have 2 in a row of odd/even then the percentages are 88.49% & 11.51%, 3 in a row would give you 94.40% & 5.60% etc. I have used the following formula for this (BM5 is where the totalhits for even are calc'd) ...
View Replies!
View Related
Percent Change Calculations
I want to calculate percentage changes, but sometimes my values are negative. Using the traditional (latestfirst)/first I'm getting incorrect percentages because of the negative values. How can I write one formula that corrects for this?
View Replies!
View Related
Find Duplicates Within A Percent Tolerance
Below is a short segment of my excel spreadsheet: A B 1020.0024289.84 1020 88.11 1021 85.3 1021.49480.41 1021.49 86.98 1030.04 89.4 1030.042 88.26 1030.94 79.98 1030.93381.5 1030.96185.87 1040.041888.77 1040.39187.3 1040.29182.94 1040.01684.12 1049.82 84.7 What I need to do is write a macro that will find duplicates in Column A, within a changeable tolerance, say 0.1 (10%). After finding all duplicates within a tolerance in A, I need to make another "Master" worksheet with the Duplicates from A, and their counterpart in B. So if A1 and A4 where within 10% of each other, the "Master" worksheet would contain: A1 B1 A4 B4 using the values, giving: 1020.0024289.84 1021.49480.41 I tried using SUMPRODUCT and some other functions but just can't seem to put my finger on this one. I'm sure it's not hard and am overlooking something.
View Replies!
View Related
Convert Number To Percent Format
I have built a spreadsheet that pulls data into B60:AA240 (Sheet name is "Actual Numbers Report") from a different sheet in the same workbook. Some of the data is in Number format and the other is in Percent Format. What I would like to do is if AL10 in the Actual Numbers Report sheet says "Actual Numbers" then I would like the cells in B60:AA240 convert to a number format "000,000,000" If AL10 says "Trends" then I want it to convert the cells in B60:AA240 to a percent format "0.0%". I tried creating some code, but it doesn't seem to work. Private Sub Convert_Percent() If Not Intersect(Target, Range("B60:AA240")) Is Nothing Then If .Range("AL9") = "Actual Numbers" Then Range("B60:AA240").Select Selection.NumberFormat = "000,000,000" ElseIf .Range("AL9") = "Trends" Then Range("B60:AA240").Select Selection.NumberFormat = "0.0%" End If End If End Sub If this can work then the 2nd question I would have is can this same line of thinking work to format the chart that this data is pulled from? So if it is Actual Numbers the chart would be in a number format and if it is Trends then it will change to a percent format?
View Replies!
View Related
Make Numbers A Percent Of 100
I have a spreadsheet with a large list of plants. Each plant has a breakdown of colors by container size. Each cell contains a number that corresponds to a percent, e.g. a cell may contain the number 20, which would also mean this number is equal to 20%. I want to change all numbers to a percent of 100, or turn 20, for instance, into .20. There are many hundreds of numbers that I need to make a percent, so I was hoping I could do this in one fell swoop somehow. This percent number will be used in another spreadsheet for calculating on order. How do I do this?
View Replies!
View Related
No Calculation Flag, And Percent Formula
1. In neighborhoods that have zero units in a given price range I have it to display "" , because this unit is not actually zero, the data is not available. Therefore a #VALUE! is displayed for the percent because it cannot calculate the "". How do I get excel to glance over "" and flag it for no calculation? 2. For the percentages I am having to manually do them row by row. I would like to set it up in a manner that allows me to copy the formula down by column and across by row correctly. For instance in the percent for Mira Lagos I have =B4/N3 where b4 is the units for mira lagos and n3 is the total. I can drag that formula across by rowto get all the correct percentages for mira lagos price ranges only, but I cannot copy this formula down by column to any of the other neighborhoods. In otherwords I have to do a new formula for each subdivision. e.g. Grand Peninsula=B5/N3 Meadow Glen(Mansfield)=B6/N3 ...etc Again I would like to make it so I can copy the formula across by row and down by column so excel will automatically compute it.
View Replies!
View Related
Parentheses For Negative Percent Results 
I have been able to format single cells to display negative percents (Budget to Actual hours), but I cannot copy the formatting to cells with positive percents without eliminating the format style I want. [I need to display, with the parenthesis, (13.6%)for negative results, but say, 18.6% for positive results.] When I copy the correctly formatted cell (13.6%) to another cell with a positive result, it sets the display to general formating. As I have over 25 rows of data to compare against 62 projects and 12 programs, with each value potentially changing from one analysis to the other, I am looking for a method to automatically change the "look" of the results. I have looked at conditional formatting, but have had no indication this will do what I am looking for.
View Replies!
View Related
Calculate Percent Of In Pivot Table
looking for a way to run some pivot tables on a large data table. Would like the result to show some different data extraction from the same field / column. The table is customer survey results for my employees, and the fields in question can have values from 15. I would like to finish the pivot table with all of these fields: Row: Name (ok, that part is easy) Data fields: % of entries (column 2) that are 5 % of entries (column 2) that are 4 or 5 % of entries (column 2) that are 1 or 2 # of entries (column 2) % of entries (column 3) that are 5 % of entries (column 3) that are 4 or 5 % of entries (column 3) that are 1 or 2 # of entries (column 3) I'm hoping this is something I can do with calculated fields, but haven't been able to figure it out. So far all I have is a 'Count' function in the pivot wizard for the # of entries, but I'm not getting the % of entries at all. Column A = Name, Column B = 1st metric, Column C = 2nd metric. Fairly simple layout, but I have a small sample file I can attach if that's not explanatory enough.
View Replies!
View Related
Calculate The Percent Of People Within Age Range
In the demographics sheet, I have ages listed from row F2 to F31 with different ages. I would like to get assistance with a formula that calculates the percentage of people within these age ranges: 2125 2630 3135 3640 4150 5159 60+ It should be separate formulas. I'm sure if I'm given the first and last ones that I could do the others myself. Also, if I needed to know the percent of males and females, would i use the same formula?
View Replies!
View Related
Formula For True/false Tolerance Percent
I need to be able to get a true/false from a tolerance percent. Here is an example of what I am trying to do cell a2 is Nitrogen cell b2 is (Known gas%) 2.4800% cell c2 is (unknown gas%) 2.4963% cell d2 is =b2c2 and I get the answer no trouble there. what I need is to take the answer in cell d2 and set a plus/minus 2% tolerance in cell f2 and get a true/false comparison.
View Replies!
View Related
VBA Userform – Convert Number To Percent
In the attached sample (with macros enabled), you will find the problem when pressing the button “INDTAST DATA” (I apologize for the linguistic challenge, but the XLsheets are in Danish… To relief – check the crash course in Danish below) and then entering some number in the two last textboxes (called “Forventet ændring i antal timer I næste kvartal (%)” and “Forventet ændring i omsætning i næste kvartal (%)”)… If you enter something there, the result will be multiplied by 100 in the worksheet. I would like to be able to simply enter a full number – like 12 or 9,5– which will then be entered into the worksheet as 12% or 9,5% (and not 1200% or 950%)… I think the answer lies in inserting some code in the VBA code, when the macro writes the data to the worksheet, but you guys know more about it than I do... I can, of course, enter a full number in the textboxes – followed by a %sign, but that will slow down the process significantly as well as increase the risk of errors… Virksomhed = Company Kvartal = Quarter År = Year Branche = Industry Fakturerede timer = Billed hours Faktureret omsætning = Billed revenue Timeforventning = Expected hours (next quarter) Omsætningsforventning = Expected revenue (next quarter) Indtast data = Enter data
View Replies!
View Related
Formula To Calculate Percent Difference Between Last 2 Columns
See attachment. In this example, in Column D I want to calculate the percent difference between the numbers in the last 2 columns (Column B and Column C). BUT I want a formula that will automatically update if I were to insert a new column between Column C and Column D. So as a result, new numbers would go in Column D and the percent difference would now be in Column E.
View Replies!
View Related
Formula To Calculate Percent Change, Varied By Amount Of Months
I need to figure out a formula for cell F17 that will calculate a percentage change only for the months that have data in 2009. The way it is set up right now I have to go in every month and change the cell reference of the formula to include the latest data. Since the 2008 data is totally populated the formula gets messed up if I include the months of 2009 that have not yet occurred.
View Replies!
View Related
Calculating Cost Per Second
I'm trying to make a worksheet where I can calculate the cost of a mobile postpaid subscription. It is charged per minute and the cost differs depending on which of the 2 available networks the customer is calling to. The first 20 minutes are free, not depending on network. Edit: Charges to network A is 1,79, per minute after the first 20 minutes are spent. Charges to network B is 2,29, per minute after the first 20 minutes are spent. To sum up: 1. The customer makes a call. 2. If there there are available free minutes, these should be spent first. 3. The customer is charged per minute, depending on network called.
View Replies!
View Related
Least Cost Routing
im working on a VoIP company, and having a hard time to figure out a result on a little time. the problem is finding a "least cost routing" wherein you will find the cheaper to higher price, and putting the results on a designated columns: I am including an image, sorry if the image seems to be heavy and large: as you can see: Column C contains the sale rate for the client, while Columns D to I, are the buy rates from our source carriers. While the columns K to P, are the columns where should one source carrier should be fitted base on the buy rates, that is best fitted to the sale rate. Red marks=are not suitable or nonprofitable buy rate for the sale rate. Sorry for the bad english, but i hope you get what i mean. this is only a sample from our Internal data.
View Replies!
View Related
Calculating Cost
Problem  billing spreadsheet for prisoner fee. 1  8 hrs = $55 9  24 hrs = $55 + $65 or $120 Anything over 24 hrs  $65 for each additional (24 hrs) ($185) So if you were locked up for 6 hrs it is $55. If you were locked up for 18 hrs it is $120. If you were locked up for 28 hrs it is $185. And if you were locked up for 49 hrs it is $250. Cell F5 contains number of hours locked up  I would like cell I5 to calculate the cost of the stay. I am proud of myself for figuring out the date and time subtraction  but this part has me stumped.
View Replies!
View Related
Calculate Amount Of Days Paid In Advance And Apply Percent Discount
Part of the assesment task is to write a formula, to work out how many days in advance the customer paid, and then apply the needed discount. I have tried several basica variations to the formula, and keep getting the same Err message. give point me in the right direction to how i can calculate amount of days paid in advance and apply a % discount? attached is the start of the assesment question. You should create and enter formulas to calculate the No. of Days paid in Advance, the Discount and the Course Fee Paid. Use a VLOOKUP function in your template to determine the discount rate to be used for the calculation of the Discount. Your template should include a separate discount table containing the following information about the discount received: • If students pay the course fee less than 7 days prior to the course commencing then they receive no discount. • If students pay the course fee 7 to 13 days prior to the course commencing then they receive a discount of 5%. • If students pay the course fee 14 to 20 days prior to the course commencing then they receive a discount of 8%. • If students pay the course fee 21 days or more prior to the course commencing then they receive a discount of 10%.
View Replies!
View Related
Cost Vs Units Graph
I'm wondering how to display the following cost model on a graph (this is a piecewiselinear cost model for some production company): Cost per unit for 010 units: $1 Cost per unit for 1120 units: $3 Cost per unit for 2130 units: $5 Cost per unit for 3140 units: $8 Fixed cost: $100 (this is regardless of the number of units produced) Basically I'm looking to construct a cost vs units graph.
View Replies!
View Related
Transferring Cost From One Sheet To Another
I am trying to figure out how to update cost from a manufacturers price sheet in excel. I have one worksheet that has the manufacturer's part number and my current cost. A=item number B= current cost. on the second sheet is the same setup but my price list has roughly 3500 rows and the vendor price sheet is 23000 rows. Is there a way to automate the cost replacement by comparing item number and if they are the same replacing cost on sheet one with cost on sheet two?
View Replies!
View Related
Calculate X Percentage Of Cost
I am trying to create a simple formula to extract cost from a total that includes both cost and and a percentage for maintanance. Assume $100, 10% of which is maintenance the remainder is cost. If I just subtract 10% from $100 I get $90, however 10% of $90 is $9 which equals $99.
View Replies!
View Related
Cost Average Effect
Example number 1: You invested 10.000 Dollar in the year 1985 into a tempelton fund and waited 20 years. Result can be seen at many forums and stock plattforms Example number 2: In 1985 you had no 10.000 Dollar, but only 100 Dollar a month. You invested this 100 Dollar each month for 20 years. How big will the difference be between example 1 and 2 ? *** Background. If a "share" will cost 100 Dollar, you will get 1 share for 100 Dollar. Next month share is down to 50 Dollar, you will get 2 shares for your monthly 100 Dollar. Next month share is up at 200 Dollar, you will get only a half share for your 100 Dollar. Its called cost average effect. Tool should allow "play arround", to simulate various scenarios, talking into account growth rate, time period, monthly investment, fluctuation of a theoretical share. Idealy we would love to " import" e.g. famous fund history (eg. Tempelton, Pioneer) etc. to see how investment would have developed when a steady monthly payment would have been made.
View Replies!
View Related
Time And Cost Calculations ..
I am compiling a simple worksheet that will keep an ongoing track of labour costs in a production environment. The objective is to end up with a labor cost "per unit" for packing punnets of soft fruit. The source data I have is; 1  Start time and end time of the job 2  Any breaks taken during the job 3  The number of staff it took to do it 4  The status of the staff (Supervisor, temp, etc) and their hourly pay rates 5  The number of punnets packed. With all of the above it should be a relatively simple exercise to calculate the cost per unit (and with a calculator is!). My problem appears to be that I am not formatting something correctly, because when I try to calculate the costs for the employees' my costs are obviously wrong. I have attached my early draft for reference, in the example shown I am showing that a supervisor earning £7.50 an hour worked for 1 hour 15 mins at a cost of £0.39
View Replies!
View Related
Calculating Cost Based On Several Factors
i. I currently have a spreadsheet which is used to forecast resource cost for a project. The forecasted cost is calculated on a few factors  rate, allocation, contract start and end date, and expected days worked per month. One of the mods actually helped me out with this a few weeks ago. I now have been told that there is a possibility that certain resource costs may change in the new year and that will need to be reflected in the sheet whilst keeping the historic information. For example  XXX has a rate of £200 p/d, allocation is 1, working 18.83 days p/m and is working from 01/01/09 to 01/06/09. The current formula will work out his cost per month until contract end. Now say his rate will be changed to £150 p/d from the 01/03 and all other info remains the same, I need the sheet to calculate his revised cost from 01/03 onwards and not change the calculation previous to that month. Now Ive actually managed to figure that part out myself by adding in two columns (override rate and override date) using a nested IF statement. The only problem is that if the new rate starts mid month then it will still calcuate the original amount for the full month and the revised amount from the next month. Edit  Also, could someone advise as to how do I remove my old attachments as I have almost used up my allocation.
View Replies!
View Related
Cost Price Vs Quantity Discount
I'm trying to work out how to get a spreadsheet to calculate when it works out cheaper to buy more of something, due to quantity price breaks, than less... e.g. 110 are £12.50 each, but 1020 are £10 each and 2030 are £8.75 each.. so it's as cheap to buy 10 (10x10=100) as it is 8 (8x12.50=100) and cheaper to but 10 (100) than it is to buy 9 (112.50) than 10... but there are similar price breaks at 20, 50 +
View Replies!
View Related
Way To Check Whether Any Cost Centre Has Been Missed Out ...
I attached a workbook and it shows data in row 2  960. and in cells BA1574 BM1604 are the summary by using 'sum if' function. As you can see, row 160 countercheck the results and it shows differences. So my questions are 1) any formula that i can use to ensure all cost centres are taken up in Col AZ1574  AZ1604? I am sure that i have missed something out. 2) My goal is to summarise the total of each cost centre. Is there other options to reach this goal apart from using 'sum if' function? I would like to learn something new.
View Replies!
View Related
Manufacturing To Retail Cost Calculator
I am trying to make an EASY Manufacturing Cost to Retail pricing calculator. This calculator would have ability to include cost of goods, labor, markup etc of components manufactured and sold as retail products, example: small bookshelves versus large bookshelves or cabinets all have different materials (wood types, stain etc) in determining the final retail product costs that would reflect time of labor hours involved in producing to determine final retail costs. Should be simple in Excel 2000 (my version). I have the basic template created and have used Data Validation Drop Down Lists and utilized LOOKUP function. While my knowledge is limited in Excel, I am frustrated as how the LOOKUP function works, I can only get it to work where in the formula, the costs per unit are input manually, whereas I would prefer to have the data input automatically from columns of calculated wholesale cost plus markup per square foot data, ie: =lookup(A1, X1:X30, Y1:Y30) but get errors when doing this. Instead this works: =lookup(A1,{"pine", "oak", "birch"},{"3.99","7.87","5.15"}) and using this cell (A1) in my calculations for including the square foot costs in the final retail calculations. While this seems to work, it is not easily modifiable as costs change rapidly and would like to easily input the cost per square foot of the different woods in their own cells rather than in the formula calculation of the lookup. Hope that makes sense..... any suggestions? perhaps lookup is not the best function for what I am attempting?  sample file is attached, light green are notes of where my data is located.
View Replies!
View Related
ISDN Call Cost Formula
I have an Excel workbook with 2 worksheets, labelled as "codes" and "data" The "codes" worksheet contains three columns of data. Column A shows Country names Column B shows Country dialling codes Column C shows Cost per minute to the country ...
View Replies!
View Related
>>> Finding Lowest Cost/Vendor
I need to find the lowest price, mark it up and designate which vendor it’s from so the CSR knows which one to quote back to the customer. Besides going through it line by line, is there a way to do this? It seems like there could be a formula where it pulls the lowest of the 3 prices and vendor name into a new “price” and “vendor” columns and then I can go through and mark it up. Here’s a small sample of what the sheet looks like: Item #Desc V1 V1 CostV2V2 CostV3V3 Cost 123456brush Advance 2.56Weiler5.65Osborn3.25
View Replies!
View Related
Simple Job Cost Sheet
The job cost controller is not exactly what I need, so I have been trying to create my own. So far my progress has got me to be able to separate each laborer for each job. Here is my query: I have a drop down menu that lists ten different tasks(i.e. carpentry, painting, demo, etc.) and I want each of the ten tasks to separate themselves. Is this a vlookup function? How do I make excel listen?
View Replies!
View Related
Inventory: FIFO, LIFO And Average Cost
I need to compare and calculate the Unit Cost Price of my Inventory based on the 3 methods of inventory valuation: FIFO (First In, First Out), LIFO (Last In, First Out) and Average Cost. Next, I enclose 3 snapshots of each method with the results required (columns color yellow).
View Replies!
View Related
Sum The Total And Find The Average Cost
I need a formula that will scan column A (Code)total the like items (also) add column B (Qty) if there is a number greater than 1. Then add the price ($) together and divide by the sum of A&B. In other words find the average price for the total of each item.. A B C Code Qty $ PH06003000 1 1504.8 PH06003000 1 1582.24 PH06003000 1 1606 PH06003000 1 1504.8 PH06003000 2 3009.6 PH06003000 1 1504.8 PH06003000 1 1504.8 PH06003000 1 1504.8 PH06024000 1 2499.2 PH06024000 1 2499.2 PH06024000 1 1896.07 PH06024000 2 3909.66 PH06024000 1 2240.7 PH06024000 1 2259.4 PH06024000 15 30030 PH06024070 1 2039.4 PH06024070 1 1958.66 PH06025670 1 2521.2
View Replies!
View Related
Calculating Manhours/labor Cost In 2003
I am having trouble trying to calculate cost for a specific task. I know this is something simple and I am going to kick myself when it gets solved, but I have total brain lock right now! Here is the example of what I am trying to do. A B C D E F # of people start finish time man hours labor cost 3 1:35 2:05 :30 1.5 $15.00 I am entering the values in A, B and C, with B & C formatted as TIME. D is calculated by =(C3B3), but I am lost trying to calculate E and F.
View Replies!
View Related
Calculating Total From Number Of Minutes And Cost P/m
I need to calculate the total cost of outbound calls based on the total duration of outbound calls multiplied by cost per minute. For example, in a given month, the total duration of outbound calls is 261:16:34 being 216 hours, 16 minutes and 34 seconds. I have this figure in cell A1 with the format [h]:mm:ss. I then convert this to minutes in cell B1 by saying B1=A1, but having the format [m], which gives me 15676. In cell C1, I have the cost per minte value of £0.026. But when I apply the formula D1=B1*C1, I get £0.283, when 15676*£0.026 should in fact be £407.58.
View Replies!
View Related
If Then Or Else: Calculate The Cost Of A Cushion That Is Governed By It’s Thickness
use the “INDEX & MATCH” formula and I thank him very much for that. Now, I have another problem which I think the “IF & ELSE” statement may come into play. I am trying to calculate the cost of a cushion that is governed by it’s thickness. Example: ABCDEFGHI 1CushionB/FrontS/SideBorderQuantitySeat 2Feather121251£8.25 3Feather121241£7.32 4 B2 represents 12 inches C2 represents 12 inches D2 represents 5 inches 144 represents square foot The calculation is, F2=B2*C2/144*D2*£1.65*E2..............
View Replies!
View Related
Calculating Cost Dependant On Month And Category
I have a sheet with 3 columns. First one is a date in the format dd/mm/yy, second is category type (numerical 140) and then the final column is cost in the format 0.00. These columns will need to run from A2:A65536, B2:B65536 & C2:C65536 to cover all later additions. I need to work out a cost total for each of the categories in each month.
View Replies!
View Related
Determine Cost For Stepped Pricing In Seconds
The phone call is charged at 0.57 for the first 60 seconds, thereafter 0.0095 per second. Determine cost if duration (in seconds) is available? AND The phone caal is charged at 1.654 for the first 60 seconds, thereafter 0.827 for every 30 seconds.Determine cost if duration (in seconds) is available?
View Replies!
View Related
