Level 2 Model Building Course Sprint 3 Exam
I've been enjoying the model building training thus far, but I've run into a problem on the Level 2 Model Building Sprint 3 Exam.
The question is asking for the formula for the Beginning Inventory line item. I've followed the instructions for creating the formula exactly and my Beginning Inventory values match the values in the examples. I have also triple checked the names of the modules/line items referenced in the formula.
Without posting the formula here or giving away anything further than what the instructions describe here is how I created my formula.
If the SYS01 Time Setting By Week "Not 1st Week of Timescale?" box is checked the formula will give the previous periods Ending Inventory, otherwise, the value will be the beginning inventory from the DAT01 "Beginning Inventory" line item. The only thing I can think of that would cause me to fail this question is that I used a LOOKUP that references the distribution center in SYS08 SKU Details. The formula gives me the correct answer but I'm not sure if the exam question is looking for another method?
I have noticed some discrepancies between some of the instructions. For example, the "Not 1st Week of Timescale?" line item is referenced as having a capital W in the final module name check but is lowercase in one of the earlier instructions. I'm not sure if this would cause the formula to be incorrect, but I matched the names of my modules/line items to the "Check Your Module & Line Items" section at the end of Sprint 3.
Thanks for your help!