The Prototype development costs were considered within the span of three months, and the total output will produce one prototype. This prototype will use different parts and materials than the mass production item, as this is a proof of concept. The funding for the prototype development will likely be granted by a medical or research grant.
| Prototype Development | Number Needed | Individual Cost ($) | Total Cost ($) | |
| Case | 1 | 5.09 | 5.09 | Geekworm UNO R3 |
| Pins | 40 | N/A | 7 | Elegoo Dupont Wire Pins |
| Logic Board | 1 | 23 | 23 | Arduino Uno Rev 3 |
| Ultrasonic Sensor | 5 | 2.71 | 13.59 | Smraza Ultrasonic Module |
| Haptic Motor | 2 | 4.5 | 9 | Tatoko 3V Haptic Motor |
| Arduino Speaker | 2 | 5.5 | 11 | |
| Maps License (Monthly) | 1 | 20 | 60 | Google Maps Pricing |
| Labor – Hardware Engineer | 1 | 37 | 14800 | Labor Statistics (BLS) |
| Labor – Logic Engineer | 1 | 60 | 24000 | Arc Dev: Logic Engineer |
| Total Prototype Cost ($) | 38928.68 |
The Beta Testing development costs were also considered within the span of three months, and the goal is here to create 10 iterations of the prototype. Each new iteration will build on the qualities and rectify the downfalls of the previous iteration. The funding for the beta testing stage will likely come from a medical or charity organization.
| Beta Testing | Quantity | Individual Cost ($) | Total Cost ($) | Product Links |
| Case | 10 | 5.09 | 50.9 | Geekworm UNO R3 |
| Pins | 400 | N/A | 70 | |
| Logic Board | 10 | 23 | 230 | Arduino Uno Rev 3 |
| Ultrasonic Sensors | 50 | 2.71 | 135.9 | |
| Haptic Motors | 20 | 4.5 | 90 | Tatoko 3V Motor |
| Speaker | 20 | 5.5 | 110 | MakerHawk Arduino Speaker |
| Maps License (Monthly) | 1 | 20 | 600 | |
| Labor – Hardware Engineer | 1 | 37 | 14800 | Labor Statistics (BLS) |
| Labor – Logic Engineer | 1 | 60 | 24000 | Arc Dev |
| Total Beta Test Cost ($) | 40086.8 |
The Mass Production development costs were not considered with any timeframe in mind, as it is meant to be a continuous operation. As such, the inclusion of a wage for labor just indicates how many people we would likely need to assemble components given mass production. The parts used in this stage will be different from the other stages, as this will be cheaper in mass production. Funding for the mass production of the completed product will most likely be handled by collaborating with health technology companies such as Johnson & Johnson or Integra LifeSciences.
| Mass Production | Quantity | Individual Cost ($) | Total Cost ($) | Product Links |
| Case | 1000 | 2.38 | 2380 | |
| Pins | 40000 | 0.0165 | 660 | |
| Logic Board | 1000 | 12.74 | 12740 | |
| Ultrasonic Sensors | 5000 | 2.82 | 14100 | |
| Haptic Motors | 2000 | 0.78 | 1560 | Micro Vibration Motor |
| Speaker | 2000 | 3 | 6000 | |
| Assembly Labor | 5 | 19.31 | 1931 | Indeed Technician Salary |
| Shipping (UPS Extra Large) | 1 | 24.3 | 24.3 | USPS Shipping |
| Total Mass Production Cost ($) | 39395.3 |
Nice! Instead of pasting in long URLs, hyperlink the row heading text and click the link button to paste the URL. Also, stretch the first column wider, so it is easier to read.
Much better. 🙂 I do recommend using right-alignment for number cells with no decimal places, and add a $ to the total row, along with a “Total” label. These changes follow typical spreadsheet conventions.
To improve the readability of the tables, I recommend combining the last column of links with the first column of generic terms, so they read like this: “Geekworm UNO R3 Case”.
I tried combining everything, but once I finished, I didn’t have a way to delete columns.
Introduce the first table with a paragraph. Or rearrange the text so text describes the table below it.
Where did you get your 3 month timeframe for the Beta Testing development?
The 3-month timeframe was used a fixed time period solely for the sake of deciding how much to pay engineers. It’s hard to say exactly how much time it would take to develop the prototype or commence beta testing without actually having done it. So the 3 months just represent the minimum timeframe which we thought would be needed.