Sprint 3 INV04

Lkishko

Hi, Could someone please help me with the module below?

 

I am struggling with the Percentage Full result that I get and I think it is because I am doing something wrong in the Beginning Inventory line.

I am pulling BI from DAT01 which gives a straight line across all months. What am I doing wrong?

I also could use a suggestion for the conditional formatting of the % Full line.

 

Thanks for the help!

einas.ibrahim

Hi @Lkishko 

Ok I see.

Let's think about this from a business perspective. We bought a business and we had some inventory included in the sale.

So at the end of time period 0, we had that specific inventory. We are "Given" that value, we don't calculate it.

Then at the beginning of the month after, the business sold some items from the inventory and purchased some more so at the beginning of time period 1 we have another "beginning" inventory for the month that we can calculate. 
Beginning Inventory at current period = Ending Inventory at previous period + any inventory we added - any inventory we sold.

 

So, you have 2 types of beginning inventory, One is the very first one that you can't calculate and is given as an input for the system.

and another beginning inventory at the beginning of each month. This one you calculate based on what you sold and what you purchased.

In the example, the Inventory in DAT01 is the absolute beginning inventory (input)

The beginning Inventory you calculated in INV01 is your "monthly" beginning inventory.

Which one do you think is more appropriate when you are trying to calculate a monthly percentage?
It is INV01 inventory.

I know I could have just said change the inventory from DAT01 to INV01. That might have solved the issue now but it doesn't explain the thinking process and I believe we should use these model-building activities to learn.

 

If after you adjusted the inventory you still have questions please let me know.