Calling the Excel wizards!...

[matt21]

...I am trying to work out how many months stock we are holding.

I have starting inventory.
Planned outbound sales
Planned inbound sales.

So I have starting + inbound - outbound.

However, we have a forecast going forward for the inbound sales (is a car dealership).

I want to know based on our planned customer sales and what we will recieve to the factory the average amount of stock we will hold.

Month 1 2 3 4 5 6
Customer sales 15 12 18 15 25 20
From factory 22 8 12 22 30 22
Inventory Qty 10 17 13 7 14 19 17

Months Inv? End of mth one has 17 units in stock which is one and a bit months stock - based on 12 in mth 2 and 18mth 3.

Month 2 has ending stock of 13 with 18 in mths 3 so less than 1mth inv.

I want to work this out going forward as one sum per box. Is this possible?

Sorry if I have explained myself poorly!

How do I work out the months inventory

[The Moose]

PM me your e-mail address and I will e-mail you the spreadsheet.

The only issue I can see you having is that all your cars won't arrive from your supplier on day 1, I imagine they will arrive during the course of the month so you may need to forecast a bit better than what you are talking about?

Cheers

The Moose