• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help in Calculating the Months of Supply of Inventory

D

Diwakar GANESH

New Member
Dear all

Request all to please help me to in calculating the months of supply for each month

I have opening inventory
Sales projections of 12 months and each month inventory

attached a sample sheet for your reference
 

Attachments

Hi Khalid,
thanks for your reply.
We are working on budgets for my company and I have prepared FOB / Shipment forecast based on the Opening Inventory, my shipment and Sales projections.
I have derived closing inventory for a month say for Mar 2017, as Feb Opening + Feb Goods in transit - Feb Sales = Mar Opening Inventory. As I have already calculated the projected sales (POS ) for each month, I need to see Mar 2017 opening inventory will be catering to how many months of Sales ..

Attached sample for your reference


thanks
Diwakar GANESH
 

Attachments

You must log in or register to reply here.
Back
Top