Mechanical
5940 uses a simple spreadsheet for leadership to remain aware of how much stock we have, and when to purchase more. This Section will serve as an explanation for how the spreadsheet is implemented and how we use it.
This is a pretty basic spreadsheet... the columns have a few headers.. the highest header describes the data type, the next shows the minimum amount of the material to order at a time, the next indicates when to order mrore, and the final header labels the material.
Each row is one "data point". Someone will walk around the shop and physically take inventory and create a new row with that data.
Conditional formatting is used to improve readability.
This serves as a tutorial for our own team members.
- Enter the date
- Take stock of aluminum and poly sheets. 5940 stocks sheets in ~18x36" rectangles.
For each material and thickness, first count the number of totally complete sheets. Add to this the rough amount of usable space in partially consumed sheets in 1/4 sheet increments. Make this assessment visually, and don't consider any space smaller than 4"x4". Enter this number into the corresponding cell in the new entries row.
- Take stock of shafts.
For each type of shaft, measure complete pieces longer than 6" in length and divide their length by 6", rounding down. Add the number of 6" lengths of each piece of shaft of a single type together. Enter this number into the corresponding cell in the new entries row.
- Take stock of tube.
For each type of tube, measure complete, usable pieces longer than 3 feet in length and divide their length by 3 feet, rounding down. Add the number of 3 foot lengths of each piece of tube together. Enter this number into the corresponding cell in the new entries row.
