Sprint 3 INV04

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!

10 REPLIES 10
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
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
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
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Highlighted
Occasional Contributor

Re: Sprint 3 INV04

Hi @einas.ibrahim ,

 

Can you please guide me with Formula used to get Beginning Inventory in INV04 as i am getting very weird numbers in the result.

 

I have used INV01 module as source based on sum from SYS08 Supplied by.

 

Is this correct or i am missing somethings and need to rework the formula.

 

gauravj6_0-1596998257107.png

Thanks and Regards

Gaurav

Highlighted
Valued Contributor

Re: Sprint 3 INV04

Hello @gauravj6 

I know what you mean by weird numbers, I faced the same issue too and I believe it's because of the initial data provided.

The way you have formed the formula is correct.

So keep on 🙂

 

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Highlighted
Occasional Contributor

Re: Sprint 3 INV04

Thank you for the feedback.

Regards
Gaurav
Highlighted
Contributor

Re: Sprint 3 INV04

Hi @einas.ibrahim 

 

I have seen the Screenshots provided by @Lkishko  & @gauravj6  both used correct formula and which is same as mine as well but both have a different value for total inventory line item and mine values for total inventory is also different from them, so how can we validate our values, since the review file do not hold correct values.

 

kunal_311_1-1597352822458.png

 

 

Highlighted
Valued Contributor

Re: Sprint 3 INV04

Hi @kunal_311 

I'm not sure about the screenshots for others you mentioned so I can't speak to that. I do recall though getting crazy numbers for percentage full as well.
It depends on what values we change - such as forecast override or placing a purchase order with different quantities and shipping methods.

I am not even sure that reloading the files given throughout the training will fix the issue. The good news is, and for that particular reason - you get clean files in the exam to ensure we all have the same data.

Go ahead, you are so close 😊 

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Highlighted
New Contributor

Re: Sprint 3 INV04

@einas.ibrahim 

 

Hi,

 

I am stuck in making this formula as well. I have been using the INV01 as the beginning inventory, but when i do a SUM of the SYS08 Distribution Center module within the % Full line item, i get percentages that are over 100,000%. Any ideas or advice on how to change the formula so I get the right outputs?