Excel Busn Math 48: Basics Of Markup (Cost & Selling)

We are trying to make 2 different formulas.

One is for a three tiered pricing formula on one price list:

Cost range of .01 - $2.75 + 80% markup = retail price

Cost range of $2.76 - $7.99 + 60% markup = retail price

Cost range of $8.00 or higher + 40% markup = retail price


The next is a two tiered pricing formula on one price list:

Any item that is $9.99 or less + 60% markup = retail price

Any item that is $9.99 or more + $6.00 = retail price

Many thanks.

*edit typo

I searched everywhere but couldn't find anything like this. I will try to simplify this as good as i can.

I will have one column with different $values, which is the cost of my products. My markup will be as follows.

0-.69 * by 900%
.69-100 * by 800%
1.00-2.00 * by 700%
2.00-3.00 * by 600%
3.00-4.00 * by 500%
4.00-5.00 * by 400%
6.00-10.00 * by 300%
10.00-20.00 * by 200%
20.00+ * by 40%+2

What i would like to accomplish is do a search through the column with my cost $values, and if it finds a value anywhere between the numbers above then put the displayed results on the same row next column over. And I would like to do this all in one routine.

For example in column f row 10, 14, 22,48 all have cost amounts of 0-.69. then my markup would be 0-.69 * 900% and display results next column over on rows 10,14,22, and 48. And do the same for all the other cost amounts within the same routine.

I am a novice with formulas and macros on excel, but have been searching around and would my best option be a vlookup table and if statements as a macro and if so, please some guidance? Or any other suggestions?

thanks

To calculate ebay fees it is:

Up to $50 is 8%, $50 to $1000 its 8% on the first $50, 5% on the rest, over $1,000 is 8% on first $50, 5% on next $950, and 2% for the rest.

Then I get 5% off of that, and i calculate the paypal fees which is 1.9% and $0.30

That is my net cost. So I got that calculation down and created it in a userform to calculate for me I put in my price and it gives me what I net. I want to do the oposite now. I want to put in what I want to NET, I want it to reverse that calculation to tell me what price I need to put it up at.

This calculation exists, this website has the reverse feature http://www.rolbe.com/ebay.htm and there are many other sites and programs that can reverse calculate it. But I am writing my own custom userform that does it for me and I can't figure out the logic to do it backwards. Can anyone help me figure this out???

Hi everyone,

I have small gift article business and all selling price are marked manually for that I have created sheet1 cost price range between in column A And B and selling Price in column C.
Every time when I receive invoice I look the cost of article and check the price range in column A And B to mark the corresponding selling price. Which is in the column C.

Sheet1
*



A



B



C



1



Cost Price in Between



Sale Price



2



0,00



0,30



0,60



3



0,31



0,60



1,10



4



0,61



0,90



1,70



5



0,91



1,20



2,20



6



1,21



1,50



2,70



7



1,51



1,80



3,30



8



1,81



2,10



3,80



9



2,11



2,40



4,40



10



2,41



2,70



4,90



11



2,71



3,00



5,40



12



3,01



3,30



6,00





To avoid looking each article cost price range in column A and C and finding selling price manually.
Can it is possible to work out selling price creating Sheet2 as shown below just inserting cost price in column A and finding corresponding selling price (from sheet1) in the column B.

Sheet2
*



A



B



1



Cost Price



Sale Price



2



0,99



2,20



3



1,29



2,70



4



1,82



3,80



5



0,95



?



6



2,90



?



7



3,20



?



8



0,69



?



9



2,35



?



10



2,99



?



11



0,89



?



12



1,49



?






Please help

Thanks And Regards,
Moti

Properties increase by 10% of the original price with each new purchase.

Current Price:

Code:

F37*(1+E37/10)

Properties are built on a required property. If the required property has not been purchased, the Current Price is:

Code:

IF(metropolis<2,VLOOKUP(metropolis,shipping_metropolis,2,FALSE)+F37*(1+E37/10),F37*(1+E37/10))

If I sell this property, the Cash Received:

Code:

E37*(G37+F37*0.9)/4

However, it's incorrect if the required property is "not owned" in the spreadsheet. I need help figuring out the formula to exclude the price of the required property (the VLOOKUP) for the Cash Received.

Hi all,

I am new to the forum. I have a certain concern which I would like to discuss, but I don't know if this is the appropriate place to post. Also, I don't know if these type of questions are allowed.

I have developed a Budgeting program in excel that I would like to sell online. I would like some words of caution from people who have sold programs or who know about how this is done.

Hi,

I posted the same question on another board but since it's more of a project and I'm not really in a situation (read: living in ramen noodles world..) where I can pay for a solution the topic got closed ( http://www.ozgrid.com/forum/showthread.php?t=145753 ).

So, I thought that maybe I could try to find someone here.

In Short:
My parents bought a water-bottle-refill store a few days ago and I was just there and saw that they are tracking everything on a piece of paper that they then have to add up and tie to the cash register - and getting any 'statistics' from the sales is near impossible and/or very hard to do.

So...I thought I was going to be a good daughter and see if I couldn't bring them into the modern days and get them a used laptop and set them up with something that would be easier for them to track - and USE the data they are collecting

The challenge:
I'm not very good with spreadsheets/access databases myself..so as I said I thought I'd see if there would be a helpful soul here that might be willing to help out.

What they are doing now:
They sell two kinds of water:
- 25cents per gallon, and
- 45cents per gallon.

People can pay either by cash - or a 'prepaid membership card'.

They have a piece of paper with basically four columns:
C25, C45, M25, M45
(Cash 25c, Cash45c, Membership25, Membership45)

If someone comes in and buys, say, 5 gallons of the 25cent wanter and pay in cash - they put a '5' in the column named 'C25'. End of the day the add up all the columns and see if it ties to the cash register.

The reason they 'break out' the 25, 45, cash and membership is to see what sells and how (do they need the membership, is the more expensive water in demand, etc).

The Challenge:
Input:
I would love something easy to use but that looks 'professional'
I'm not sure if one can make a 'front-end' or 'form' maybe where they would just pick the cash/member/25/45 with checkboxes (or something) and then type in the gallons.
Something that's easy to use and for people that can't read text tooo small

Output:
I think this is maybe the real challenge.
I would love to be able to help them by giving them tools that could show them for instance;
- the total for the day,
-the total for the week,
- totals BY say member/cash,
- totals BY cash or membership,
- any total for a certain day/time period you type in,
- Etc

Maybe in text..maybe in like pie charts..I am not sure

Is this something anyone out there have an idea about how to do (including the 'form-frontend')?

I can't really offer any money as compensation (unemployed and soon, if things doesn't look better working in my parents waterstore ) - but maybe there is something to say for good karma.

Anyone.....?

/Tiff

I work as an engineer for a pump distributor and have written an Excel
based spreadsheet program which will print out part numbers and prices of
the parts
for any selected pump/options combination of one particular pump
manufacturer whom we represent.

I am nearly finished with the program and am currently working out
small bugs in it. I would like to market and sell this program to other
pump distributors across the USA that also sell this brand of pump.

I'm an engineer and not too familiar with legalities. Is this legal?
Would I need a special license or permission to do this? Any advice is
appreciated.


Greg

I am trying to insert a formula to calculate a percentage of margin/markup.
Example cost = $7.00 divided by 30 % = $10.00. My cost is 7.00, my sale price
is 10.00. Can anyone help with this formula?

HTML markup to add comments to excel cell

Hi,

I want to create an html string such that if I just paste that html string
into an excel sheet it will add a comment to one cell. Something like:

<table>
<tr>
<td ss:Comment="This is my comment text">my cell text</td>
<td>another cell</td>
</tr>
</table>

In the above example the text "This is my comment text" should become
a comment in the excel cell with text "my cell text".

Is this possible? If so, what is the markup to use?

I know that I could use something like the code below to add comments, but would rather not.

<div style='mso-element:comment'>
<div>
<!--[if gte mso 9]><xml>
<v:shapetype id="_x0000_t202" coordsize="21600,21600" o:spt="202" path="m,l,21600r21600,l21600,xe">
<v:stroke joinstyle="miter"/>
<v:path gradientshapeok="t" o:connecttype="rect"/>
</v:shapetype><v:shape id="_x0000_s1025" type="#_x0000_t202" style='position:absolute;
margin-left:107.25pt;margin-top:1.5pt;width:96pt;height:55.5pt;z-index:1;
visibility:hidden' fillcolor="#ffffe1" o:insetmode="auto">
<v:fill color2="#ffffe1"/>
<v:shadow on="t" color="black" obscured="t"/>
<v:path o:connecttype="none"/>
<v:textbox style='mso-direction-alt:auto'/>
<x:ClientData ObjectType="Note">
<x:MoveWithCells/>
<x:SizeWithCells/>
<x:AutoFill>False</x:AutoFill>
<x:Row>0</x:Row>
<x:Column>1</x:Column>
<x:Author>23059278</x:Author>
</x:ClientData>
</v:shape></xml><![endif]-->

<div v:shape="_x0000_s1025" style='padding:.75pt 0pt 0pt .75pt;text-align:left'
class=shape><font class="font6">23059278:</font><font class="font5"><br>
This is my comment</font></div>
</div>
</div>

Any help is greatly appreciated!

Regards
/Christoffer