+ Reply to Thread
Results 1 to 3 of 3

Require a formular for FIFO method with different rates

  1. 10-13-2016, 06:01 AM #1
    shashi30790
    shashi30790 is offline
    Registered User
    Join Date
    10-13-2016
    Location
    Colombo
    MS-Off Ver
    2010
    Posts
    2

    Require a formular for FIFO method with different rates

    Hi. I have a list of stock bought at different per unit costs. And I need to develop a formulae to track separately at the end of each month the balance of purchases, its per unit price and the month to date sales value and the per unit composition of the sale.
    Attached Files Attached Files
    Last edited by shashi30790; 10-13-2016 at 06:03 AM.
    Reply With QuoteRegister To Reply
  2. 10-13-2016, 07:24 AM #2
    zbor
    zbor is offline
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,602

    Re: Require a formular for FIFO method with different rates

    What with other months?
    Reply With QuoteRegister To Reply
  3. 10-14-2016, 01:13 AM #3
    shashi30790
    shashi30790 is offline
    Registered User
    Join Date
    10-13-2016
    Location
    Colombo
    MS-Off Ver
    2010
    Posts
    2

    Re: Require a formular for FIFO method with different rates

    I need to get a formular to get the other months calculated when i update/ change the purchase quantitites.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Balancing through Kncokoff fifo method
    By srinivasan1965 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-03-2016, 03:19 AM
  2. FIFO Method
    By jenna_max in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-18-2015, 04:41 AM
  3. How to apply Fifo method?
    By mahaveersomani in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-16-2013, 08:29 AM
  4. fifo method
    By soniasingh in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-03-2012, 01:18 PM
  5. Automatic assignment in FIFO Method
    By marc5354 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-11-2012, 03:25 AM
  6. FIFO Method - Tracking
    By KnotNExcelGuru in forum Excel General
    Replies: 8
    Last Post: 10-28-2011, 02:14 AM
  7. FIFO Method-Production
    By ab1593577891 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-03-2009, 07:34 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1