File attached for info.
Thanks for getting back to me. I'm in the UAE hence the delay in getting to you. My response to your queries are given below.
1. That's right and also to be added to J3.2. Correct.3. At this moment, yes. We will input from stock take what goes into F3.
Wondered how you were getting on with the queries.
1.In F3 (Quantity in Stock), you want to add the value you enter in H3 (Quantity on Board). But is this G3 a blank cell originally? Or does it contain a value that is a result of a formula or calculation?
A: My mistake. We want to add the Quantity on Board (H3) to Available Stock (J3). Quantity on Order (G3) is manually input at the point of raising a purchase order.
2.Also, in like manner, in G3, you want to subtract the value in H3, but is this G3 cell originally blank? Or holds a value that is a result of some calculation?
A: We need to add Quantity on Order (G3) to Quantity on Board (H3).
We would like anything that is deducted from Available Stock (J3) to be added to deducted fromQuantity in Stock (F3).
This is what we've worked out from this side.
a) Quantity on board (H3) + Quantity in stock (F3) = Available stock (J3) (includes stock at sea)
b) Once the goods have landed, they will be deducted from Available Stock (J3) and need to be added to Quantity in Stock (F3).
c) We think we are missing a step. Anything that is in Pending Orders (I3) should be deducted from Available Stock (J3).
Hopefully that should clear things up.
When goods have landed, yes, this is quantity on board which has been added into the available stock minus pending orders. Once landed it becomes quantity in stock. Point 2 is correct. Yes, it will be as described.
In the example, no. This is because quantity on board (25), quantity in stock (50), however, this may be on two containers. Therefore, may possibly only (15) pieces are landed. So, quantity in stock becomes (65) quantity on board becomes (10) but available stock remains (75).
Hope this clarifies things.
I've just received a 'rate the service' email but haven't received the rebuilt inventory sheet as mentioned above. Can you confirm if I'm missing an answer.
Thanks and regards
Many thanks for this. I need to look over it but it's the weekend here at the moment. Please give me a bit of time before I rate it. I'm sure it's absolutely fine. Thanks again and I'll get back to you as soon as (hopefully tomorrow) with the rating.
Completely aware that I haven't rated your service as yet. It's the weekend here and I haven't had a chance to look through what you sent in details. I hope to get back to you tomorrow, or at the very latest Monday.
Thanks for your patience.