Spreadsheet: 869697d1716294599-excel-formula-ph-hyb-power-ch
Sheet: Bill of Material Costing

 | Redwood TTM Ltd |  |  |  |  |  |  |  |  |  |  |  |  |  | Date | 2024-05-21 00:00:00
 | [NAME] of Material Costing |  |  |  |  |  |  |  |  |  |  |  |  |  | Time | 11:36:57
 | Reference |  | Description |  |  |  |  | Version |  | Qty Costed For |  | Date/Time of Costing |  | Costed By
 | PH-HYB-POWER-CH |  | HYBRID-POWER_CELL [NAME] |  |  |  |  | 0.02 |  | 50 |  | 2024-05-21 11:32:49.020000 |  | bspencer
 | Reference |  |  | Costing Quantity |  | Quantity Required | Unit of Measure |  | Cost Price | Stock Unit | Cost | Overhead % | Overhead |  | Total Inc. Overheads
 | MaterialsMaterials |  |  |  |  |  |  |  |  |  | 473.24865475 |  |  |  | 473.24865475
 | [NAME] |  |  |  |  |  |  |  |  |  | 142.23179475 |  |  |  | 142.23179475
 | TE067/GREY/300 |  |  |  |  | 16.425 | [NAME] |  | 8.65947 | [NAME] | 142.23179475 |  |  |  | 142.23179475
 | TFL-B NATURAL 300 MICRON |  |  |  |  | 32 | [NAME] |  | 7.53061 | [NAME] | 240.97952 |  |  |  | 240.97952
 | WEB001 |  |  |  |  | 291.04 | [NAME] |  | 0.22485 | [NAME] | 65.44034 |  |  |  | 65.44034
 | BUCKLE006 |  |  |  |  | 100 | Units |  | 0.22597 | Units | 22.597 |  |  |  | 22.597
 | RWLABEL0002-RED-REV1 |  |  |  |  | 50 | Each |  | 0.02 | Each | 1 |  |  |  | 1
 | RWLABEL0001-RED-REV1 |  |  |  |  | 50 | Each |  | 0.02 | Each | 1 |  |  |  | 1
 | LabourLabour |  |  | 21 hrs, 28 mins, 30 secs |  |  |  |  |  |  | 355.10167 | 28.50000114051844 | 101.20398 |  | 456.30565
 | Flag Stitching Flag Stitching |  |  | 1 hour, 40 minutes | 100 |  |  |  |  |  | 25.05 | 28.5 | 7.13925 |  | 32.18925
 | Runtime  Runtime |  |  | 1 hour, 40 minutes | 100 |  |  |  |  |  | 25.05 | 28.5 | 7.13925 |  | 32.18925
 | Sewing Operators |  |  | 1 hour, 40 minutes | 100 |  |  |  |  |  | 25.05 | 28.5 | 7.13925 |  | 32.18925
 | Gerber single Gerber single |  |  | 2 hours, 30 minutes | 150 |  |  |  |  |  | 41.05 | 28.5 | 11.69925 |  | 52.74925
 | Runtime  Runtime |  |  | 2 hours, 30 minutes | 150 |  |  |  |  |  | 41.05 | 28.5 | 11.69925 |  | 52.74925
 | Gerber Operators |  |  | 2 hours, 30 minutes | 150 |  |  |  |  |  | 41.05 | 28.5 | 11.69925 |  | 52.74925
 | Packing Sewing Packing Sewing |  |  | 2 hours, 5 minutes | 125 |  |  |  |  |  | 60.04167 | 28.50000674531538 | 17.11188 |  | 77.15355
 | Redwood TTM Ltd |  |  |  | 0 |  |  |  |  |  |  |  |  | Product |  | Sage 200
 | [NAME] of Material Costing |  |  |  | 0 |  |  |  |  |  |  |  |  | Page |  | 1
 | Runtime  Runtime |  |  | 2 hours, 5 minutes | 125 |  |  |  |  |  | 60.04167 | 28.50000674531538 | 17.11188 |  | 77.15355
 | Packing Operators |  |  | 2 hours, 5 minutes | 125 |  |  |  |  |  | 60.04167 | 28.50000674531538 | 17.11188 |  | 77.15355
 | Sewing Sewing |  |  | 15 hours | 900 |  |  |  |  |  | 225.45 | 28.5 | 64.25325 |  | 289.70325
 | Runtime  Runtime |  |  | 15 hours | 900 |  |  |  |  |  | 225.45 | 28.5 | 64.25325 |  | 289.70325
 | Sewing Operators |  |  | 15 hours | 900 |  |  |  |  |  | 225.45 | 28.5 | 64.25325 |  | 289.70325
 | Webbing Cutting Webbing Cutting |  |  | 13 minutes, 30 seconds | 13.5 |  |  |  |  |  | 3.51 | 28.5 | 1.00035 |  | 4.51035
 | Setup  Setup |  |  | 1 minute | 1 |  |  |  |  |  | 0.26 | 28.5 | 0.0741 |  | 0.3341
 | Border Operators |  |  | 1 minute | 1 |  |  |  |  |  | 0.26 | 28.5 | 0.0741 |  | 0.3341
 | Runtime  Runtime |  |  | 12 minutes, 30 seconds | 12.5 |  |  |  |  |  | 3.25 | 28.5 | 0.92625 |  | 4.17625
 | Border Operators |  |  | 12 minutes, 30 seconds | 12.5 |  |  |  |  |  | 3.25 | 28.5 | 0.92625 |  | 4.17625
 | MachineMachine |  |  | 19 hours, 10 minutes | 1150
 | Flag Stitching Flag Stitching |  |  | 1 hour, 40 minutes | 100
 | Runtime  Runtime |  |  | 1 hour, 40 minutes | 100
 | Sewer Flag Stitcher 1 |  |  | 1 hour, 40 minutes | 100
 | Gerber single Gerber single |  |  | 2 hours, 30 minutes | 150
 | Runtime  Runtime |  |  | 2 hours, 30 minutes | 150
 | Gerber Single Ply |  |  | 2 hours, 30 minutes | 150
 | Sewing Sewing |  |  | 15 hours | 900
 | Runtime  Runtime |  |  | 15 hours | 900
 | Sewing Group |  |  | 15 hours | 900
 | SubcontractSubcontract |  |  |  |  |  |  |  |  |  | 18.0675 |  |  |  | 18.0675
 | [NAME] |  |  |  |  |  |  |  |  |  | 18.0675 |  |  |  | 18.0675
 | Subcontract Process  Subcontract Process |  |  |  |  |  |  |  |  |  | 18.0675 |  |  |  | 18.0675
 | Redwood TTM Ltd |  |  |  |  |  |  |  |  |  |  |  |  | Product |  | Sage 200
 | [NAME] of Material Costing |  |  |  |  |  |  |  |  |  |  |  |  | Page |  | 2
 | Runtime   Runtime |  |  |  |  |  |  |  |  |  | 18.0675 |  |  |  | 18.0675
 | ROLLCUT |  |  |  |  |  |  |  |  |  | 18.0675 |  |  |  | 18.0675
 | Total Cost: | 846.41782 | Calculated Unit Cost: |  | 16.92836 |  |  |  | Total Sales Value: |  | 947.6218
 | Total Overheads: | 101.20398 | Average [NAME] %: |  | 0 |  |  |  | Suggested Selling Price: |  | 18.95244
 | Total Inc. Overheads: | 947.6218 | Margin %: |  | 0 |  |  |  | Profit: |  | 0
 | Redwood TTM Ltd |  |  |  |  |  |  |  |  |  |  |  |  | Product |  | Sage 200
 | [NAME] of Material Costing |  |  |  |  |  |  |  |  |  |  |  |  | Page |  | 3