bobgrand
Active Member
- Joined
- Apr 14, 2008
- Messages
- 252
- Office Version
- 365
- Platform
- Windows
Hello all,
I am searching through the templates for a project tracker. One that will track customer releases by date along with sales orders and corresponding purchase orders to suppliers.
Calculate released quantities against the estimated beginning quantity to know how much remains.
Calculate the cost of goods. How much value has been used to how much is remaining.
Changes can be made to a specific release mid stream. Example. 1 x 500' of Wire for Release 14 was issued on 2/17 to be delivered on 6/18. Release 14 changed to 14-A on 5/15 to 2 x 325' of wire to be delivered on 6/18.
We are using a sheet that someone created but it does not have the structure to track these types of changes. I am working on manipulating the sheet we have now but I was hoping someone could guild me in a direction to a template or if someone has something they wouldn't mind sharing.
Any guidance would be greatly appreciated.
Thank you
Bob
I am searching through the templates for a project tracker. One that will track customer releases by date along with sales orders and corresponding purchase orders to suppliers.
Calculate released quantities against the estimated beginning quantity to know how much remains.
Calculate the cost of goods. How much value has been used to how much is remaining.
Changes can be made to a specific release mid stream. Example. 1 x 500' of Wire for Release 14 was issued on 2/17 to be delivered on 6/18. Release 14 changed to 14-A on 5/15 to 2 x 325' of wire to be delivered on 6/18.
We are using a sheet that someone created but it does not have the structure to track these types of changes. I am working on manipulating the sheet we have now but I was hoping someone could guild me in a direction to a template or if someone has something they wouldn't mind sharing.
Any guidance would be greatly appreciated.
Thank you
Bob
