Markup/Cost formula help...

A

Angela

Ok, I think this is the most ridiculous scenario. I am working on a project that deals with low dollar product that will be selling at a fixed price. The application requires that the markup be the same for all items in a given category, so I am going to have to manipulate the cost to get it to do what I need. I have no problem figuring out the markup to use for the first product, but can't get my head around how I then calculate what the cost needs to be if I need to sell another item in the same category (therfore using the same markup levels) for a different price.

Here's an example (different price levels are for higher quantity purchases of the same item).

Product Cost: $1.75

Price Level 1: $8 (Markup 357%)
Price Level 2: $6 (Markup 243%)
Price Level 3: $4 (Markup 129%)
Price Level 4: $3.25 (Markup 86%)

EggHeadCafe - Software Developer Portal of Choice
Automated Registry Backups with VSS Shadow Copy Service
http://www.eggheadcafe.com/tutorial...e-fd64d00c9924/automated-registry-backup.aspx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Matching Values 1
Markup Costs 2
Help with workbook updates 2
Customize Products & Services Fields 0
Help with multiple workbooks 4
Formula Help 0
help with a formula 2
Help - is this possible? 2

Top