+ Reply to Thread
Results 1 to 1 of 1

formulas for a price list that has different discounts & yearly price increases

  1. #1
    Registered User
    Join Date
    07-14-2020
    Location
    London
    MS-Off Ver
    16.38
    Posts
    7

    formulas for a price list that has different discounts & yearly price increases

    Hi

    I was asked by my parents to create a suppliers price list for their company that would show how much we are paying out on materials. We have the suppliers list but are then given discounts by the supplier (i.e 94%, 85%) depending on products so these need to be applied to show what is paid out at a quick glance. We then get yearly percentage price increases for certain products. So I need the prices increases to go off the last price increase. I have created something but its too hard for other members of staff to use or update. I feel like there must be an easier formula/formulas to use for this. I will attach the price list. If anyone has any suggestions that would be greatly appreciated.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 12-05-2020, 05:29 AM
  2. Replies: 6
    Last Post: 04-25-2020, 09:24 AM
  3. Replies: 3
    Last Post: 09-12-2015, 10:42 AM
  4. How can I calculate price discounts and also identify top customer?
    By cwarfox in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-24-2014, 03:37 PM
  5. Replies: 3
    Last Post: 01-03-2013, 12:32 AM
  6. Replies: 4
    Last Post: 08-15-2012, 09:49 AM
  7. Question abuot creating a price quote from a long price list
    By glennchung in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 02-02-2009, 03:49 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1