Template: SLDP: Cost Estimate (Robots)

Cost Estimate

Once a robot design is complete, a cost estimate must be generated that specifies the cost of all the materials and labor required for the construction of your design. Tabulate this cost information clearly in an Excel spreadsheet, using the materials cost list provided. You can get help in calculating the cost by reviewing How to plan the schedule and calculate costs for a project. The costs for the parts can be found on the Price list for Lego parts for robot projects.

Note: You should only use the materials contained in the Price list for Lego parts for robot projects. If you want to use other parts, get permission from your faculty member to do so, and also to determine the cost of the parts you want to use that are not in this price list.

Create a cost estimate on a Microsoft Excel spreadsheet. The cost estimate should include the following:

• Labor cost breakdown with hours and rates.
• Consolidate low-cost pieces: axles, beams, bricks, bushings, connectors, gears, plates, etc.
• Itemize high-cost pieces: controllers (NXT/EV3), sensors, etc.
• No decimal places; this is an estimate after all. Round appropriately.
• Total cost must be shown in the bottom right corner.