Workbook Archive
Cost workbook for the xTend prosthetic arm, including per-arm cost, equipment assumptions, and cost build-up by phase.
A cost workbook that turns equipment, delivery, and source notes into a clear per-arm price.
This workbook was made to answer a basic finance question first: what does one xTend arm cost before the project scales?
The sheets keep equipment costs, per-arm assumptions, scaling cases, and NHS comparison notes separate so each number can be checked.
Source sheet: 00_Read_Me
Scroll sideways to inspect the full sheet.
| xTend Prosthetics | ||||
| Cost & Unit Economics | ||||
| All figures lifted directly from P2 - FUNDING ESTIMATION_.xlsx and HY - CV. Nothing fabricated. | ||||
| Tabs | ||||
| Tab | Description | |||
| 01_Phase1_Equipment | Phase 1 reusable equipment & tools — £1,046 total (from BASIC MATERIALS + PHASE 1 COSTS sheet) | |||
| 02_Phase1_Per_Arm | Materials per assembled arm — £46 + £45 delivery = £91 per arm | |||
| 03_Phase1_Scaling | Cost to deliver 1 / 5 / 10 arms (source values £91 / £455 / £910) | |||
| 04_Capacity_Building | Phase 2 capacity build — £2,463 equipment + £915 prototyping = £3,378 | |||
| 05_Phase2_Bionic | Bionic prosthetic — £133 ops tooling + £158 per arm (incl. £40 delivery) | |||
| 06_NHS_Comparison | £91 vs £2,600 NHS comparator (from CV) | |||
| 07_Source_Index | Cross-reference: every cell back to a row in a source file | |||
Source sheet: 01_Phase1_Equipment
Scroll sideways to inspect the full sheet.
| Phase 1 — Reusable Equipment & Tools (Source: P2 file, BASIC MATERIALS + PHASE 1 COSTS sheet) | ||||
|---|---|---|---|---|
| Item | Qty | PPU (£) | Total (£) | Notes |
| Cr-10 smart pro | 1 | £200 | £200 | |
| Cr-10 smart pro (used, just purchased) | 1 | £165 | £165 | |
| Bamboo P1s 3D printer | 1 | £600 | £600 | |
| Tools (pliers, screwdrivers, etc.) | 1 | £15 | £15 | |
| Ink or oil-based paint for silicone | 1 | £10 | £10 | |
| 8× Phillips self-tapping screws | 100 | £8 | £8 | Quantity 100 |
| 80-100lb PE braided line | 1 | £30 | £30 | |
| M3 hex cap-head stainless steel screws | 50 | £8 | £8 | Quantity 50 |
| Cable cutters | 1 | £10 | £10 | |
| Total non-current (reusable) assets | £1,046 | |||
| Source-file total: £1,046 ✓ matches above | ||||
Source sheet: 02_Phase1_Per_Arm
Scroll sideways to inspect the full sheet.
| Phase 1 — Cost per Arm Assembled (Source: P2 file, BASIC MATERIALS + PHASE 1 COSTS sheet) | ||||
|---|---|---|---|---|
| Item | Qty / Size | PPU (£) | Total (£) | Notes |
| 3D printer filament 500g | 1 spool | £15 | £15 | |
| P35–P40 addition-cured silicone | 40g | £15 | £15 | |
| 2mm thick neoprene (wetsuit) | 1 | £5 | £5 | |
| Velcro straps | 5 | £7 | £7 | Source uses 7 as line total |
| Super glue gel | 1 | £4 | £4 | |
| Materials sub-total per arm | £46 | |||
| Transportation and delivery (per arm) | £45 | |||
| TOTAL DELIVERED COST PER ARM | £91 | |||
| Source confirms: 1 arm = £91, 5 arms = £455, 10 arms = £910 | ||||
Source sheet: 03_Phase1_Scaling
Scroll sideways to inspect the full sheet.
| Phase 1 — Cost to Deliver N Arms | |||||
|---|---|---|---|---|---|
| Line | 1 arm | 5 arms | 10 arms | 25 arms (PROJECTED) | 50 arms (PROJECTED) |
| Materials per arm (£46) | £46 | £230 | £460 | £1,150 | £2,300 |
| Delivery per arm (£45) | £45 | £225 | £450 | £1,125 | £2,250 |
| Per-arm cost | £91 | £455 | £910 | £2,275 | £4,550 |
| Plus Phase 1 reusable equipment | £1,046 | £1,046 | £1,046 | £1,046 | £1,046 |
| TOTAL CASH OUTLAY (source labels for 1 & 10 arms only) | £1,137 | £1,501 | £1,956 | £3,321 | £5,596 |
| Source values (P2 file, 'Cost per amount of Arms made and delivered'): 1=£91, 5=£455, 10=£910 | |||||
| Source: 'TOTAL BASIC OPERATIONAL COSTS + 1 ARM' = £1,137; '+ 10 ARMS' = £1,956 | |||||
| 25 and 50 arm columns are linear projections (per-arm cost × N + £1,046 equipment, one-time). | |||||
Source sheet: 04_Capacity_Building
Scroll sideways to inspect the full sheet.
| Capacity Building — Source: P2 file, CAPACITY BUILDING sheet | ||||
|---|---|---|---|---|
| Item | Qty | PPU (£) | Total (£) | Notes |
| Cr-10 smart pro | 2 | £200 | £400 | |
| Bamboo P1s 3D printer | 3 | £600 | £1,800 | |
| Tools (pliers, screwdrivers, etc.) | 3 | £15 | £45 | |
| Ink/oil-based paint for silicone | 4 | £10 | £40 | |
| 8× Phillips self-tapping screws (4 sets) | 400 | £8 | £32 | 400 = 4 sets of 100 |
| 80-100lb PE braided line | 4 | £30 | £120 | |
| M3 hex cap-head stainless steel screws (2 sets) | 200 | £8 | £16 | 200 = 2 sets of 100 |
| Cable cutters | 1 | £10 | £10 | |
| Equipment sub-total | £2,463 | |||
| Prototyping (one rotation, source: same sheet) | ||||
| Initial Material Costs | 1 | £130 | £130 | |
| Cost per Bionic Arm (×5) | 5 | £133 | £665 | From source |
| Transportation Costs (per arm, ×5) | 5 | £40 | £120 | |
| Prototyping sub-total | £915 | |||
| TOTAL — Capacity Building | £3,378 | |||
| Source-file total: £3,378 ✓ matches above | ||||
Source sheet: 05_Phase2_Bionic
Scroll sideways to inspect the full sheet.
| Phase 2 — Electric/Bionic Prosthetic (verbatim from P2 file, PROTOTYPING AND PHASE 2 COSTS sheet) | ||||
|---|---|---|---|---|
| Note: the source 'Qty' column is descriptive — the £ figure shown is the line total as recorded in the source, not qty × PPU. Sub-totals match source row R14 (£133) and R20 (£130). | ||||
| Item | Qty (source) | PPU (source) | Line £ (source) | Notes |
| Phase 2 operational tooling (source rows R4–R13) | ||||
| Kevlar fibre string | 1 | — | £15 | |
| Small-diameter metal tubing | 4 | 9 | £9 | Source: qty 4, PPU 9 columns; line total recorded as £9 (column 3 in source) |
| Nylon carbon filament | 1 | — | £30 | |
| Servo tester | 1 | — | £8 | |
| 5V BEC board | 1 | — | £6 | |
| PTFE tubing | 1 | — | £12 | |
| Electric drill | 1 | — | £25 | |
| Hacksaw | 1 | — | £8 | |
| Files | 3 | — | £15 | Source row R12 (qty shown as date-format artefact '2024-02-03') |
| Battery tray | 2 | 5 | £5 | Source: qty 2, PPU 5; line total recorded as £5 |
| Sub-total tooling | £133 | |||
| Source-stated total: £133 ✓ match: True | ||||
| Per-arm bionic components (source rows R17–R20) | ||||
| Sony NPF batteries + charger | 2 | — | £45 | Source: qty 2, line total £45 (column 3 in source) |
| Arduino Nano (w/ Bluetooth) | 1 | — | £23 | |
| Servo driver board | 2 | — | £15 | Source: qty 2, line total £15 (column 3 in source) |
| Itemised sub-total | £83 | |||
| Source-stated total at R20: £130 | £130 | |||
| Reconciliation: source-stated £130 vs itemised sub-total £83. The source rows shown above sum to £83. The difference suggests either a rounding/typo in the source row R20, or a line item not explicitly itemised. Treat source-stated £130 as authoritative for forward planning. | ||||
| Transportation & delivery (per arm) | £40 | Source row R24 | ||
| TOTAL DELIVERED COST PER BIONIC ARM | £158 | |||
| Source confirms: 1 arm = £158, 2 = £316, 3 = £474, 4 = £632, 5 = £790. 'One rotation (+ operational tools + one unusable prototype)' total = £1,036 per source row R34. | ||||
Source sheet: 06_NHS_Comparison
Scroll sideways to inspect the full sheet.
| Cost vs NHS Comparator (Source: HY CV) | |||
|---|---|---|---|
| xTend basic arm | xTend bionic arm | NHS comparator | |
| Delivered cost per arm | £91 | £158 | £2,600 |
| Difference vs NHS (£) | £2,509 | £2,442 | £0 |
| Cost ratio (xTend cost ÷ NHS) | 4% | 6% | 100% |
| Multiple cheaper than NHS | 28.57142857142857 | 16.45569620253164 | 1 |
| Source language (CV): 'Achieved over 700% price reduction for prosthetic delivery compared to NHS services (approx £2,600 NHS)'. Per the cost data, the basic arm is 28.6× cheaper than the NHS comparator; the bionic arm is 16.5× cheaper. | |||
Source sheet: 07_Source_Index
Scroll sideways to inspect the full sheet.
| Source Index — Where Every Number Comes From | |||
|---|---|---|---|
| Tab in this workbook | Source file & sheet | Source row(s) | Value(s) |
| 01_Phase1_Equipment | P2 - FUNDING ESTIMATION_.xlsx → BASIC MATERIALS + PHASE 1 COSTS | R2–R11 | Line items, total £1,046 |
| 02_Phase1_Per_Arm | P2 - FUNDING ESTIMATION_.xlsx → BASIC MATERIALS + PHASE 1 COSTS | R13–R19, R23 | £46 materials + £45 delivery = £91 |
| 03_Phase1_Scaling | P2 - FUNDING ESTIMATION_.xlsx → BASIC MATERIALS + PHASE 1 COSTS | R25–R33 | 1 arm £91; 5 arms £455; 10 arms £910; Ops+1 £1,137; Ops+10 £1,956 |
| 04_Capacity_Building | P2 - FUNDING ESTIMATION_.xlsx → CAPACITY BUILDING | R2–R20 | Equipment £2,463 + prototyping £915 = total £3,378 |
| 05_Phase2_Bionic | P2 - FUNDING ESTIMATION_.xlsx → PROTOTYPING AND PHASE 2 COSTS | R3–R30 | Per-arm £158; one-rotation £1,036; tooling £133; per-arm components £130 |
| 06_NHS_Comparison | HY - CV - GS Client Solutions _ Sales.docx | Para 2 of Abstract | NHS approx £2,600; xTend 700% cheaper claim |