Spreed Sheet Assigment
Figure1.1
| Material Price Quotes: | ||||
| Component | Description | Quantity | Unit | Cost/Unit |
| Leather | Exterior leather | 1 | sf | 19.86 |
| Internal Arch Support | Molesole arch support | 1,000 | lot | 2,235 |
| Sole | Polymer resin - preformed | 12 | lot | 124.45 |
| Laces | Smooth leather | 1 | inch | 0.047 |
| Trim | Suede appliques - set of 3 | 1 | set | 4.25 |
| Trim | Wedge logo insert | 1 | each | 1.57 |
| Cost Calculations per Shoe: | ||||
| Component | Quantity | Unit | Total Cost | |
| Leather | 1.23 | sf | 24 | |
| Internal Arch Support | 1 | each | 2 | |
| Trim (applique set & logo) | 2 | set/each | 7 | |
| Laces | 31.5 | inch | 1 | |
| Materials Total | 36 |
Figure1.2
Figure1.3
| TZEdge Material Analysis | ||||
| Material Price Quotes: | ||||
| Component | Description | Quantity | Unit | Cost/Unit |
| Leather | Exterior leather | 1 | sf | $ 19.860 |
| Internal Arch Support | Molesole arch support | 1,000 | lot | 2,235.000 |
| Sole | Polymer resin - preformed | 12 | lot | 124.450 |
| Laces | Smooth leather | 1 | inch | 0.047 |
| Trim | Suede appliques - set of 3 | 1 | set | 4.250 |
| Trim | Wedge logo insert | 1 | each | 1.570 |
| Cost Calculations per Shoe: | ||||
| Component | Quantity | Unit | Total Cost | |
| Leather | 1.23 | sf | 24 | |
| Internal Arch Support | 1 | each | 2 | |
| Trim (applique set & logo) | 2 | set/each | 7 | |
| Laces | 31.5 | inch | 1 | |
| Materials Total | 36 |
Figure1.4
Figure 1.5
| TZEdge Material Analysis | ||||
| Material Price Quotes: | ||||
| Component | Description | Quantity | Unit | Cost/Unit |
| Leather | Exterior leather | 1 | sf | $ 19.860 |
| Internal Arch Support | Molesole arch support | 1,000 | lot | 2,235.000 |
| Sole | Polymer resin - preformed | 12 | lot | 124.450 |
| Laces | Smooth leather | 1 | inch | 0.047 |
| Trim | Suede appliques - set of 3 | 1 | set | 4.250 |
| Trim | Wedge logo insert | 1 | each | 1.570 |
| Cost Calculations per Shoe: | ||||
| Component | Quantity | Unit | Total Cost | |
| Leather | 1.23 | sf | 24 | |
| Internal Arch Support | 1 | each | 2 | |
| Trim (applique set & logo) | 2 | set/each | 7 | |
| Laces | 31.5 | inch | 1 | |
| Materials Total | 36 |
Prepared by: Paul Gomez TheZone: TZEdge Product Design Team November 15, 2016
Figure1.6
| TZEdge Material Analysis | ||||
| Material Price Quotes: | ||||
| Component | Description | Quantity | Unit | Cost/Unit |
| Leather | Exterior leather | 1 | sf | $ 19.860 |
| Internal Arch Support | Molesole arch support | 1,000 | lot | 2,235.000 |
| Sole | Polymer resin - preformed | 12 | lot | 124.450 |
| Laces | Smooth leather | 1 | inch | 0.047 |
| Trim | Suede appliques - set of 3 | 1 | set | 4.250 |
| Trim | Wedge logo insert | 1 | each | 1.570 |
| Cost Calculations per Shoe: | ||||
| Component | Quantity | Unit | Total Cost | |
| Leather | 1.23 | sf | 24 | |
| Internal Arch Support | 1 | each | 2 | |
| Trim (applique set & logo) | 2 | set/each | 7 | |
| Laces | 31.5 | inch | 1 | |
| Materials Total | 36 |
Figure 1.7
| TZEdge Material Analysis | ||||
| Material Price Quotes: | ||||
| Component | Description | Quantity | Unit | Cost/Unit |
| Leather | Exterior leather | 1 | sf | $ 19.860 |
| Internal Arch Support | Molesole arch support | 1,000 | lot | 2,235.000 |
| Sole | Polymer resin - preformed | 12 | lot | 124.450 |
| Laces | Smooth leather | 1 | inch | 0.047 |
| Trim | Suede appliques - set of 3 | 1 | set | 4.250 |
| Trim | Wedge logo insert | 1 | each | 1.570 |
| Cost Calculations per Shoe: | ||||
| Component | Quantity | Unit | Total Cost | |
| Leather | 1.23 | sf | 24 | |
| Internal Arch Support | 1 | each | 2 | |
| Trim (applique set & logo) | 2 | set/each | 12 | |
| Laces | 31.5 | inch | 1 | |
| Materials Total | 40 |
Figure1.8
| TZEdge Material Analysis | ||||
| Material Price Quotes: | ||||
| Component | Description | Quantity | Unit | Cost/Unit |
| Leather | Exterior leather | 1 | sf | $ 19.860 |
| Internal Arch Support | Molesole arch support | 1,000 | lot | 2,235.000 |
| Sole | Polymer resin - preformed | 12 | lot | 124.450 |
| Laces | Smooth leather | 1 | inch | 0.047 |
| Trim | Suede appliques - set of 3 | 1 | set | 4.250 |
| Trim | Wedge logo insert | 1 | each | 1.570 |
| Cost Calculations per Shoe: | ||||
| Component | Quantity | Unit | Total Cost | |
| Leather | 1.23 | sf | 24.42780 | |
| Internal Arch Support | 1 | each | 2.23500 | |
| Trim (applique set & logo) | 2 | set/each | 11.64000 | |
| Laces | 31.5 | inch | 1.48050 | |
| Materials Total | 39.78330 |
Figure1.9
| TZEdge Material Analysis | ||||
| Material Price Quotes: | ||||
| Component | Description | Quantity | Unit | Cost/Unit |
| Leather | Exterior leather | 1 | sf | $ 19.860 |
| Internal Arch Support | Molesole arch support | 1,000 | lot | 2,235.000 |
| Sole | Polymer resin - preformed | 12 | lot | 124.450 |
| Laces | Smooth leather | 1 | inch | 0.047 |
| Trim | Suede appliques - set of 3 | 1 | set | 4.250 |
| Trim | Wedge logo insert | 1 | each | 1.570 |
| Cost Calculations per Shoe: | ||||
| Component | Quantity | Unit | Total Cost | |
| Leather | 1.23 | sf | $ 24.43 | |
| Internal Arch Support | 1 | each | 2.24 | |
| Trim (applique set & logo) | 2 | set/each | 11.64 | |
| Laces | 31.5 | inch | 1.48 | |
| Sole | 1 | each | 10.37 | |
| Materials Total | $ 39.78 |
Figure1.10
| TZEdge Material Analysis | ||||
| Material Price Quotes: | ||||
| Component | Description | Quantity | Unit | Cost/Unit |
| Leather | Exterior leather | 1 | sf | $ 19.860 |
| Internal Arch Support | Molesole arch support | 1,000 | lot | 2,235.000 |
| Sole | Polymer resin - preformed | 12 | lot | 124.450 |
| Laces | Smooth leather | 1 | inch | 0.047 |
| Trim | Suede appliques - set of 3 | 1 | set | 4.250 |
| Trim | Wedge logo insert | 1 | each | 1.570 |
| Cost Calculations per Shoe: | ||||
| Component | Quantity | Unit | Total Cost | |
| Leather | 1.23 | sf | $ 24.43 | |
| Internal Arch Support | 1 | each | 2.24 | |
| Trim (applique set & logo) | 2 | set/each | 11.64 | |
| Laces | 31.5 | inch | 1.48 | |
| Sole | 1 | each | 10.37 | |
| Materials Total | $ 50.15 |
Prepared by: Paul Gomez TheZone: TZEdge Product Design Team November 15, 2016