W.Hi.R.R. Logo
W.Hi.R.R. #5471
Winthrop High Rambler Robotics
FRC (FIRST Robotics Competition) Logo

Cost Accounting Worksheet

Event: 

2017 FIRST Robotics Competition
Cost Accounting Worksheet

  Team:   W.Hi.R.R. Team #:   5471 Date:   2017-03-30  
  Event: Pine Tree City:   Winthrop State:   Maine (ME)  
 
Item   Description   Material   Source   Qty.   Measurement   Unit Price   Total
Price
Brush Subsystem  
Hex Shaft   ½” hex shaft   Aluminum   VEX Robotics   1.5   Feet   $4.00   $6.00
Pulley Hub   ½” hex   Aluminum   AndyMark   2   Units   $9.50   $19.00
Mini-CIM   Mini-CIM Motor   Assorted   2017 Kit of Parts   1   Motor   $0.00   $0.00
Drive Pulley   HTD Timing Pulley 15mm 36 tooth, ½” Hex Hub   Plastic   VEX Robotics   1   Unit   $14.99   $14.99
Pulley   HTD timing belt pulley 15mm 42 tooth   Plastic   AndyMark   2   Units   $6.00   $12.00
Surgical Tubing   Natural Rubber Latex Tubing 5’ length   Rubber   2017 Kit of Parts   1   Unit   $0.00   $0.00
Drive Belt   Gates HTD Belt, 15mm wide 120 tooth   Rubber/Kevlar   2017 Kit of Parts   1   Belt   $0.00   $0.00
Conduit   ¾” EMT Conduit   Steel   Audette’s Ace Hardware   1   Feet   $0.35   $0.35
Shaft Adapter   8mm keyed shaft to ½” hex shaft adapter   Steel   VEX Robotics   1   Unit   $14.97   $14.97
Shaft Key   2mm × 2mm × 14mm Machine Key   Steel   AndyMark   1   Unit   $0.50   $0.50
Sheet Steel   28g Sheet Steel   Steel   Audette’s Ace Hardware   1   Sq.Ft.   $3.60   $3.60
Threaded Rod   #6-32 threaded rod   Steel   Audette’s Ace Hardware   4   Feet   $1.30   $5.20
  Subtotals:   $76.61
Bumper Subsystem  
Subcover   Green material to cover pool noodles   Cloth   A.C. Moore   2   Yards   $4.99   $9.98
Bumper Cover   Blue 6” Corner Bumper Cover   Cloth/Velcro   Robo Promo LLC   4   Units   $15.00   $60.00
Bumper Cover   Red 6” Corner Bumper Cover   Cloth/Velcro   Robo Promo LLC   4   Units   $15.00   $60.00
Pool Noodle   Pool Noodle for bumper padding   Foam   Donation   4   Units   $2.00   $8.00
Iron-On Printer Sheets   Transfer Paper for InkJet Printers to Produce Iron-On Transfers   Paper   A. C. Moore   1   Pack   $10.00   $10.00
Plywood Backing   ¾” Plywood backing for bumpers   Plywood   Donated by Mr. E.   4   Sq.Ft.   $0.78   $3.12
Bumper Hardware Kit   Bumper Hardware Kit   Steel   2017 First Choice, Round 2   1   Kit   $0.00   $0.00
L-Bracket   2” times ⅝” Inside Corner Bracket   Steel   Audette’s Ace Hardware   8   Units   $1.15   $9.20
T-Bracket   3” × ¾” Flat Tee Bracket   Steel   Audette’s Ace Hardware   4   Units   $2.00   $8.00
  Subtotals:   $168.30
Chimney Subsystem  
Hinge   Self-closing 2¾” Hinge   Brass   Audette’s Ace Hardware   2   Package of 2   $7.99   $15.98
L-Bracket   5” × 1” Inside Corner Bracket   Steel   Audette’s Ace Hardware   4   Units   $3.99   $15.96
Sheet Steel   24” &times 24” Sheet Steel, 22ga   Steel   Audette’s Ace Hardware   2   Sheets   $26.99   $53.98
Sheet Steel   28g Sheet Steel   Steel   Audette’s Ace Hardware   1   Sq.Ft.   $3.60   $3.60
Steel Rod   3/16” Round Rod   Steel   Audette’s Ace Hardware   1   Foot   $1.50   $1.50
  Subtotals:   $91.02
Climber Subsystem  
Collar clamp   Collar clamp with ⅜” hex bore   Aluminum   AndyMark   2   Items   $5.00   $10.00
CIM Motor   CIM Motor   Assorted   AndyMark   2   Motor   $28.00   $56.00
Cover plate   4” PVC round cover plate, blue   PVC   Audette’s Ace Hardware   4   Items   $2.49   $9.97
PVC Adapter   1½” PVC to 1¼” MPT adapter   PVC   Audette’s Ace Hardware   2   Items   $1.49   $2.98
PVC Pipe   Schedule 40 1¼” ID PVC   PVC   Audette’ Ace Hardware   1   foot   $0.80   $0.80
PVC Pipe   Schedule 40 1½” ID PVC Pipe   PVC   Audette’s Ace Hardware   1   foot   $0.87   $0.87
Bevel Gearbox   LJ Bevel Box with ⅜” hex output shaft   Steel   AndyMark   2   Units   $129.00   $258.00
Floor Flange   1¼” MPT floor flange   Steel   Audette’s Ace Hardware   2   Items   $9.99   $19.98
Gearbox   Banebots BB220 Planetary Gearbox; 64:1 ratio   Steel   AndyMark   2   Units   $150.00   $300.00
Rigid Coupling   ½” keyed round bore   Steel   Grainger   2   Items   $6.92   $13.84
Shaft Adapter   8mm keyed to ½” keyed shaft adapter   Steel   AndyMark   2   Items   $12.00   $24.00
Shaft stock   8mm keyed shaft stock   Steel   Grainger   100   mm   $0.10   $10.00
Wheel hub   Wheel hub with ⅜” hex hub   Steel   AndyMark   2   Units   $10.00   $20.00
Velcro Tape   15’ × ¾” velcro tape   Velcro   Audette’s Ace Hardware   1   Item   $19.99   $19.99
  Subtotals:   $746.43
Drive Subsystem  
Chassis   AndyMark AM14U2   Assorted   2017 Kit of Parts   1   Unit   $0.00   $0.00
CIM Motor   CIM Motor   Assorted   AndyMark   2   Motor   $28.00   $56.00
CIM Motor   CIM Motor   Various   2017 Kit of Parts   2   Units   $0.00   $0.00
  Subtotals:   $56.00
Electrical Subsystem  
Battery Connector   Anderson SB-50   Assorted   2017 Kit of Parts   1   Unit   $0.00   $0.00
Circuit Breaker   120v Main Circuit Breaker   Assorted   2017 Kit of Parts   1   Unit   $0.00   $0.00
PDP   Power Distribution Panel   Assorted   AndyMark   1   Unit   $200.00   $200.00
PWM Cables   Connectors between Motor Controllers and the RoboRio   Assorted   2017 Kit of Parts   6   Items   $0.00   $0.00
Radio   Dual Band 450 Mbps Wireless Access Point   Assorted   2017 Kit of Parts   1   Item   $0.00   $0.00
RoboRio   RoboRio   Assorted   AndyMark   1   Unit   $435.00   $435.00
Robot Signal Light   Panel Signal Device   Assorted   2017 Kit of Parts   1   Unit   $0.00   $0.00
Voltage Regulator Module   Voltage Regulator Module   Assorted   AndyMark   1   Unit   $46.00   $46.00
Velcro   Strap for radio   Cloth/Plastic   2017 Kit of Parts   1   Feet   $0.00   $0.00
Wiring   Assorted Red and Black Wires   Copper/Vinyl   2017 Kit of Parts   10   Feet   $0.00   $0.00
Connector   2-Wire Trailer Wire Connector   Steel/Plastic   Advance Auto Parts   1   Unit   $2.99   $2.99
Motor Controller   Spark Motor Controller   Various   REV Robotics   8   Units   $45.00   $360.00
  Subtotals:   $1,043.99
Gear Holder Subsystem  
Hinge   2” Flat Brass Hinge   Brass   Audette’s Ace Hardware   2   Units   $2.50   $5.00
Webbing   Lawn Chair Webbing   Plastic   Audette’s Ace Hardware   2   Feet   $0.50   $1.00
Cotter Hairpin   Pin to hold Guide Pin in place   Steel   Audette’s Ace Hardware   2   Pins   $0.89   $1.78
Sheet Steel   28g Sheet Steel   Steel   Audette’s Ace Hardware   4   Sq.Ft.   $3.60   $14.40
Spring   ¼” × 2” Compression Spring   Steel   Audette’s Ace Hardware   2   Units   $1.06   $2.12
Servo Motor   HiTec HS-422 Deluxe Standard Servo Motor   Various   Previous Kits of Parts   2   Units   $9.00   $18.00
  Subtotals:   $42.30
Hopper Subsystem  
Acrylic Sheet   0.93” Extruded Acrylic Sheet   Acrylic   Home Depot   16   Sq.Ft.   $3.33   $53.28
¾” Square Tube   Boltmaster ¾” x 3’ Aluminum Square Tube   Aluminum   Audette’s Ace Hardware   5   Unit   $14.99   $74.95
L-Channel   1” ×⅛” Angle Stock   Aluminum   Audette’s Ace Hardware   20   Feet   $11.25   $225.00
Bar Stock   ¾” × ⅛” Flat Bar   Steel   Audette’s Ace Hardware   2   Feet   $2.33   $4.66
Hinge   2” Cabinet Hinge   Steel   Audette’s Ace Hardware   1   Package of 2   $6.93   $6.93
L-Bracket   2½” × ⅝” Flat Corner Brace   Steel   Audette’s Ace Hardware   2   Units   $1.00   $2.00
L-Bracket   2” × ⅝” Inside Corner Bracket   Steel   Audette’s Ace Hardware   22   Unit   $1.15   $25.30
  Subtotals:   $392.12
Hopper Door Subsystem  
Acrylic Sheet   0.93” Extruded Acrylic Sheet   Acrylic   Home Depot   1   Sq.Ft.   $3.33   $3.33
L-Channel   1” ×⅛” Angle Stock   Aluminum   Audette’s Ace Hardware   2   Feet   $11.25   $22.50
Pivot Rod   ½” round bore aluminum rod   Aluminum   Home Depot   2.5   Feet   $2.41   $6.03
Conduit   ½” EMT Conduit   Steel   Audette’s Ace Hardware   2   Feet   $0.35   $0.70
Conduit Strap   ½” EMT Conduit Strap   Steel   Audette’s Ace Hardware   2   Units   $0.27   $0.54
L-Bracket   2” × ⅝” Inside Corner Bracket   Steel   Audette’s Ace Hardware   1   Unit   $1.15   $1.15
Pivot Rod Spring   ½” × 3” compression spring   Steel   Audette’s Ace Hardware   1   Items   $3.60   $3.60
Square Rod   ¼” Square Steel Rod   Steel   Home Depot   0.5   Feet   $1.51   $0.76
Threaded Rod   ¼”-20 Threaded Rod   Steel   Audette’s Ace Hardware   1.5   feet   $1.75   $2.63
Limit Switch   Miniature Basic Switch   Various   2017 Kit of Parts   2   Items   $0.00   $0.00
Motor   Bosch Seat Recliner Motor   Various   2017 Kit of Parts   1   Unit   $0.00   $0.00
  Subtotals:   $41.24
Structure Subsystem  
Square Tube   1” x ⅛”   Aluminum   Audette’s Ace Hardware   1.5   Feet   $4.25   $6.38
Plywood Floor   ½” Plywood   Plywood   Donated by Mr. Dorey   4   Sq.Ft.   $0.55   $2.21
Hanger Strap   Sioux Chief ¾” Galvanized Hanger Strap   Steel   Audette’s Ace Hardware   1   Foot   $0.20   $0.20
L-Bracket   2½” × ⅝” Flat Corner Brace   Steel   Audette’s Ace Hardware   2   Units   $1.00   $2.00
L-Bracket   2” × ⅝” Inside Corner Bracket   Steel   Audette’s Ace Hardware   14   Unit   $1.15   $16.10
Battery Tray Assembly   Battery Tray Assembly   Steel/Plastic   2017 First Choice, Round 1   1   Unit   $0.00   $0.00
Post   2”×4” (nominal) lumber   Wood   Donated by Mr. Dorey   1   Foot   $0.24   $0.24
  Subtotals:   $27.13
   
Totals:
 
$2,685.14
2017 NE District - Pine Tree 2017 Summary
Spending Limit:   $4,000.00
Total Spent:   $2,685.14
Amount Available:   $1,314.86
Amount Overspent:   $0.00
Spending Status:     Good  


Rotæ in Carro Semper Volvunt Volvuntque

22,755 site views     1,116 page views

Copyright © 2014-2017, Winthrop High Rambler Robotics [F.R.C. Team #5471]. All rights reserved.