Level 2- Sprint 3- INV01 Inventory Ordering Module

Options
Jemsheed
Jemsheed Member, ALL USERS, Community Member, Certified Model Builder Posts: 5 New Contributor
in Planning & Modeling

Could someone please tell me what I am doing wrong with these formulas. @Misbah 
1. Beginning Inventory = 
IF 'SYS01 Time Settings By Week'.'1st Week of Timescale?' THEN 'DAT01 Beginning Inventory'.Beginning Inventory ELSE PREVIOUS(Ending Inventory)

2. Submit Purchase Order Request= OFFSET(PO Submitted, Shipping Time Weeks, 1) = 1

3. PO Submitted = IF Submit Purchase Order Request THEN 1 ELSE 0

4. Confirmed PO Delivery= IF PO Submitted > 0 THEN OFFSET(PO Submitted, Final Shipping Time Weeks, -1) ELSE 0

5. Confirmed Purchase Order Receipt= IF Confirmed PO Delivery > 0 THEN OFFSET(Final Shipment Amount, -Final Shipping Time Weeks, 0) ELSE 0

6.Shipping Time Weeks= 'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)'[LOOKUP: 'SYS08 SKU Details'.Product]

Tagged:

Comments

  • Wesley
    Wesley Member, ALL USERS, Partner, Certified Model Builder Posts: 1 New Contributor

    I have tried everyting for this POST, OFFSET no matter what I try I do not get the desired result

  • TParikh
    TParikh Member, ALL USERS, Certified Model Builder Posts: 1 New Contributor

    @Misbah firstly thanks for all the comments you have put on various subjects - it is very helpful especially for level 2 when one is trying to learn independently 

     

    With respect to this discussion: Confirm Purchase Order Receipt I thought the guidance notes provides the answer: 

    • IF Confirmed PO Delivery > 0 THEN OFFSET(Suggested Order Amount for the Month, -Shipping Time Weeks, 0) ELSE 0 

    or have I misunderstood this? Or is this as an update? 

     

     

    Additionally for "Confirmed PO Delivery" you have recommeded POST - which I have tried and it works but the guidance is specifically asking to use OFFSET 

    "Set the Confirmed PO Delivery line item to use the PO Submitted 1 value and OFFSET it based on the number of weeks between the order and delivery.

    • For example, if a PO Submitted has a value in Week 1 and the Shipping Time Weeks has a value of 2, there would be a value of 1 in the Confirmed PO Delivery line item in Week 3.
    • Use the OFFSET function and reference the Shipping Time Weeks line items (should pull the value from the periods prior)."

    If I use POST would that work for the exam?

  • KARASAGE
    KARASAGE Member, ALL USERS, Partner Posts: 5 New Contributor

    Hi, 

     

    I have an issue on this step some of my lines are not charging the data so perhaps something is wrong ? 

    Such as the override amount and I dont understand why ? 

     

     

  • venkateshs4
    venkateshs4 Member, ALL USERS, Partner Posts: 1 New Contributor

    I am unable to clear the Level 2 - Sprint 3 - Exam - I am getting maximum 60% only that New York question says incorrect answer and Other formulas also not able to figure out. Please help.

Categories