Level 2 Sprint 3 - 3.3.5.2 Inventory Ordering Module Formulas

Hi All,

After working on the formulae in this section , the expected result is not as shown is section 3.3.5.3.

Please find attached the screenshots of the "my output", "expected output" and the "Sys01 time setting". Request you to guide me where am I committing the mistake so that I can proceed.

Thank you,

Har**bleep**ha.

My_output_109937.PNG

expected_output_109937.PNG

time_setting_109937.PNG

Accepted answers

rajuvendra01

harshitha.narayan@sony.com

Please check the 'Ending Inventory' Formula because of this Reorder Flag is set. This might be the reason for numbers not matching.

All comments

rajuvendra01

harshitha.narayan@sony.com

Please check the 'Ending Inventory' Formula because of this Reorder Flag is set. This might be the reason for numbers not matching.

harshitha.narayan

@rajuvendra01 Thank you for your reply.

I will again check on this and get back to you.

Regards,

Har**bleep**ha

harshitha.narayan

Hi @rajuvendra01

I had committed two errors:

First is that the ROUNDing to be applied for the line item Initial Demand forecast (DEM03 Demand Forecast module) was wrong. I corrected this first. Because of this, the line items like Forecast demand, Suggested Order Amount for the Month were all getting calculated incorrectly.
Secondly, as suggested I revisited the formula for "ending inventory" and noticed that the sequence I was trying to subtract the Sum of Beginning Inventory and Confirm Purchase Order Receipt with Forecast demand was wrong.

Thank you for providing the hint.

Regards,

Har**bleep**ha

Quick Links

Can you help?

Unanswered questions

Hide the cards under "Models" section once connected
Hi Is there a way to hide the cards under the "Models" section once connected, as I would like the users to see only the links to the apps? Thank you
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…