Highlighted
Occasional Contributor

Sprint 3 INV04

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.

 

Lkishko_1-1590167357438.png

Lkishko_2-1590167458383.png

Thanks for the help!

3 REPLIES 3
Highlighted
Valued Contributor

Re: Sprint 3 INV04

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.

Einas
Highlighted
Occasional Contributor

Re: Sprint 3 INV04

@einas.ibrahim Thank you, that is helpful to think through and I was able to figure that part out actually, but I am still struggling with getting the correct output. It seems like I use the INV01 Module for Beginning Inventory and sum based on distribution center. 

There might be another variable I am missing because later when I check the Distribution Center Summary Dashboard, my "Percentage Full" outcomes are wrong. 

 

Lkishko_0-1590177933381.png

Lkishko_1-1590178036194.png

For Percentage full I am using Total Beginning Inventory / Distribution Center Capacity.

 

Please let me know if you can see my mistakes here.

 

 

 

 

Highlighted
Valued Contributor

Re: Sprint 3 INV04

@Lkishko 

You and me both buddy 😀
I don't think these dashboard grids have the right numbers. I just posted a question about that here.

So let's see what the community or academy will say. I'll keep you posted.

Einas