Accounting

[mhayon]

Hey,

I was put in charge of my team's cost accounting. We are a rookie team (1676), so we are not sure of how to document costs. How do I do it? Is it just name of part, quantity, total price?

Sorry if this question has been answered- I could not find it using the Search function.
Any help would be greatly appreciated.

Thanks,
Matt

[Joe Ross]

Good question.

In the past, I've had 2 spreadsheets. One that shows everything that we've bought or had donated (and donated supplies also show the cost had we'd bought it). The second is just the stuff that is on the robot. It makes it easier to get everything that is on the robot if you know everything you could have put on the robot, as you will buy some things and end up not using them, and you don't have to count those.

As for specific things I track, I do part number, description of the part, supplier, cost, quantity, and a description of where it is on the robot.

[ChrisH]

Originally Posted by Joe Ross

Good question.

In the past, I've had 2 spreadsheets. One that shows everything that we've bought or had donated (and donated supplies also show the cost had we'd bought it). The second is just the stuff that is on the robot. It makes it easier to get everything that is on the robot if you know everything you could have put on the robot, as you will buy some things and end up not using them, and you don't have to count those.

As for specific things I track, I do part number, description of the part, supplier, cost, quantity, and a description of where it is on the robot.

I'd add another column for weight, and weigh every part before it goes on the robot then you can see how close to the limit you are. You can also sort items by weight to find the "heavy hitters" should you need to put your robot on a crash diet. Why keep two spreadsheets when with a minor amount of extra work, one will do?