+ Reply to Thread
Results 1 to 1 of 1

How to do a tracker on production

  1. #1
    Registered User
    Join Date
    02-27-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    1

    How to do a tracker on production

    I have 12 months of production and 12 payments. If current month production is in excess of the target, the excess can be used to validate next month target. If current month target is not enough, next 6 months production can be used to validate.

    My problem is that I do not know what formulae to use if:

    1) Last month production that was used to validate previous target can not be used to validation current month target

    2) Current month target is using the excess from previous month and next month production. Eg: In Mth2, I'm using the excess production of 1 from Mth1 and shortfall of 2 from Mth3 to meet Mth2 target and will pay out $2

    3) Max catch-up is 6 months. Eg: Mth1 target can use Production from Mth1 to Mth6, Mth2 target can use Production from Mth2 to Mth7 so on and so forth
    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)

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