+ Reply to Thread
Results 1 to 10 of 10

demand plan basis on 90 days

  1. #1
    Registered User
    Join Date
    05-19-2011
    Location
    Pakistan
    MS-Off Ver
    Excel 2016
    Posts
    28

    demand plan basis on 90 days

    formrexcel.jpg

    dear(s) let me explain the table
    sum in Col B = 3350 (C+F+G)
    i need 90 in culumn "E"
    culumn D = A+B-C
    now
    Demand plan to be calculated so that "days" must come to 90
    "Days" column have formula =D2/(F2/30)
    please help me to find Demand Plan qty so that days column fill with 90.

    thanks and regards
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    05-19-2011
    Location
    Pakistan
    MS-Off Ver
    Excel 2016
    Posts
    28

    Re: demand plan basis on 90 days

    any solution please.

  3. #3
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: demand plan basis on 90 days

    We advise you not to 'bump' (reply to) your own posts too quickly after posting, unless you are posting some sort of clarification. Since bumped threads have replies, they will no longer appear in the "Zero Reply Posts" listing, which many members use to look for unanswered questions. If you do bump, limit it to no more than once every day. Remember that your best helper may be asleep on the other side of the world.

  4. #4
    Registered User
    Join Date
    05-19-2011
    Location
    Pakistan
    MS-Off Ver
    Excel 2016
    Posts
    28

    Re: demand plan basis on 90 days

    thanks for advice, i will be carefull in future!

  5. #5
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: demand plan basis on 90 days

    Column E is based on D and F.
    Column D is based on B.
    But B is based on three constants (your post says "sum in Col B = 3350 (C+F+G)", but that's not what is in your file).

    You can't modify B to force E to be 90 without changing the constants.

    Your question needs to be clearer.

    Values as displayed
    A
    B
    C
    D
    E
    F
    G
    1
    Opening (1 May)
    Demand Plan
    DN Forecast
    Closing Stock
    Days
    DN Forecast
    DN Forecast
    2
    1412.65
    3340
    1270
    3482.65
    89
    1170
    900
    Underlying formulas
    A
    B
    C
    D
    E
    F
    G
    1
    Opening (1 May)
    Demand Plan
    DN Forecast
    Closing Stock
    Days
    DN Forecast
    DN Forecast
    2
    1412.65
    =SUM(C2,F2,G2)
    1270
    =A2+B2-C2
    =D2/(F2/30)
    1170
    900
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  6. #6
    Registered User
    Join Date
    05-19-2011
    Location
    Pakistan
    MS-Off Ver
    Excel 2016
    Posts
    28

    Re: demand plan basis on 90 days

    thanks for reply but
    applying your formula will result 89 days in column E
    actually question is what should be the Demand Plan (value in B) for 90 days (value in E)
    one warehouse must have 90 days stock to fullfill that demand for 3 months. so in B value is to be calculated and also result 90 in column E

    i hope i explained the query and requirement.

    thanks again

    regards.

  7. #7
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: demand plan basis on 90 days

    Quote Originally Posted by azii View Post
    applying your formula will result 89 days in column E
    It's not my formula, it's YOUR formula from post #1.

    actually question is what should be the Demand Plan (value in B) for 90 days (value in E)
    But you gave a formula for that in post #1

    OK, so the value in column B is a variable that is supposed to be solved such that column E will be 90. That was not clear in post #1.

    The formula for B is

    Formula: copy to clipboard
    Please Login or Register  to view this content.



    Values as displayed
    A
    B
    C
    D
    E
    F
    G
    1
    Opening (1 May)
    Demand Plan
    DN Forecast
    Closing Stock
    Days
    DN Forecast
    DN Forecast
    2
    1412.65
    3367.35
    1270
    3510
    90
    1170
    900
    3
    2056.6
    2508.4
    800
    3765
    90
    1255
    989.5
    4
    2714.85
    155.15
    1070
    1800
    90
    600
    800
    Underlying formulas
    A
    B
    C
    D
    E
    F
    G
    1
    Opening (1 May)
    Demand Plan
    DN Forecast
    Closing Stock
    Days
    DN Forecast
    DN Forecast
    2
    1412.65
    =90*F2/30-A2+C2
    1270
    =A2+B2-C2
    =D2/(F2/30)
    1170
    900
    3
    2056.6
    =90*F3/30-A3+C3
    800
    =A3+B3-C3
    =D3/(F3/30)
    1255
    989.5
    4
    2714.85
    =90*F4/30-A4+C4
    1070
    =A4+B4-C4
    =D4/(F4/30)
    600
    800
    Last edited by 6StringJazzer; 05-01-2022 at 09:08 PM.

  8. #8
    Registered User
    Join Date
    05-19-2011
    Location
    Pakistan
    MS-Off Ver
    Excel 2016
    Posts
    28

    Re: demand plan basis on 90 days

    Dear Dear Dear
    i regret if if could not explain my query clearly!. anyhow thanks alot buddy. you saved my lot of time. it is such a great help and skills you possesed.

    thanks again

    regards.

  9. #9
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    2,956

    Re: demand plan basis on 90 days

    Using Algebra

    E2 = D2/(F2/30) = 90
    => D2/(F2/30) = 90
    => D2 = 90*(F2/30)

    D2 = A2+B2-C2
    => B2 = D2-A2+C2
    => B2 = 90*(F2/30)-A2+C2

  10. #10
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: demand plan basis on 90 days

    Quote Originally Posted by josephteh View Post
    Using Algebra
    Please see post #7 from 12 hours earlier

+ 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. [SOLVED] How do I calculate my clothes dryer demand based on if my electric range has a demand
    By HaloMike in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 12-23-2021, 07:31 PM
  2. Tax Interest calculation where demand is offset against deposits on FIFO Basis
    By dishantrai in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-27-2020, 05:34 PM
  3. Replies: 1
    Last Post: 07-28-2015, 09:46 AM
  4. [SOLVED] How to calculate debtors ageing amount in days on FIFO basis
    By King_BD in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-20-2015, 10:57 PM
  5. Replies: 1
    Last Post: 02-25-2015, 10:48 AM
  6. How to calculate days of supply given variable demand per month
    By hkaushal in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-14-2013, 10:31 AM
  7. Replies: 5
    Last Post: 03-22-2012, 04:51 AM

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