LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 30
Default Avg. price increase

How do I figure out what price increases to take on my various
products when I want the average come out to 6%? One of the items is
going to take a 12% increase. Example:

Item A Units Sold YTD 1256 Current Price is $15.40 New
Selling Price will be $17.25
Item B Units Sold YTD 987 Current Price is $9.89 New
Selling Price will be ??
Item C Units Sold YTD 1500 Current Price is $12.76 New
Selling Price will be ??
etc.

My average price increase can not exceed 6%, but I need to take 12% on
Item A. How do I figure out what increase I can take on Items B, C,
etc.?

Thanks.

Chip

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help: Need Excel formula to return correct price from price history table Ian_W-at-GMail Excel Discussion (Misc queries) 5 March 21st 07 06:45 PM
How to apply a 25% price increase to a column of rates. woolfie Excel Worksheet Functions 3 January 25th 07 01:05 PM
Price List overall price increase Sean Lambertz Excel Discussion (Misc queries) 4 May 22nd 06 01:39 PM
calculate/convert volume price to monthly average price Bultgren Excel Worksheet Functions 2 February 14th 06 09:36 AM
price increase to always end in 9, i.e. 1.99 Frank Excel Discussion (Misc queries) 1 September 22nd 05 09:15 PM


All times are GMT +1. The time now is 08:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"