Spreadsheet: 881233d1729185455-count-by-customer-in-date-range-olander-tooling-qtr3-job-sample
Sheet: Realtrac Report

Olander Tooling Weekly Job Review
Job Number | Customer Name | Part | Part Description | Closed Date | [NAME] | Qty Mfg | Act Hrs | [NAME] | % of Est | Price Each | Cost Each | Profit Each | Order Value | Material Cost | Subcontract Cost | Other Buyout Cost | Labor Cost | Workstation Cost | Total Cost | Total Profit | Total Profit %
24J21438 | Boston Scienitic Scimed | 51948939 | CAM LOCK ASSEMBLY | 2024-10-16 00:00:00 | 4 | 4 | 5.53 | 13.52 | 46.05 | 50 | 25 | 25 | 25 | 25.52 | 12 | 10 | 45 | 100 |  | 10 | 65.93
24J21419 | Volumetric Technologies | 106783 | Updated Cup Nest | 2024-10-15 00:00:00 | 1 | 1 | 2.2 | 2.02 | 216.39 | 50 | 25 | 25 | 25 | 25.52 | 12 | 10 | 45 | 100 |  | 10 | 15
24J21416 | Boston Scienitic Scimed | 50633952 | AGl Breaker Plate | 2024-10-10 00:00:00 | 3 | 3 | 3.28 | 6.25 | 69.12 | 50 | 25 | 25 | 25 | 25.52 | 12 | 10 | 45 | 100 |  | 10 | 40.72
24J21404 | Trident Seafood | 1108639 (M-4080092) | 1108639 2-UP FIBER BOARD  (M-4080092) | 2024-10-15 00:00:00 | 12 | 12 | 0.92 | 2.73 | 52.88 | 50 | 25 | 25 | 25 | 25.52 | 12 | 10 | 45 | 100 |  | 10 | 88.13
24J21401 | Dans Prize Inc. | Rapid Pack Guide Bracket | Rapid Pack Guide Bracket | 2024-10-16 00:00:00 | 6 | 6 | 4.25 | 3.58 | 150 | 50 | 25 | 25 | 25 | 25.52 | 12 | 10 | 45 | 100 |  | 10 | 25.02
24J21393 | Trident Seafood | 1108698 (M-4493001) | 1108698 Guide Pins M-4493001 | 2024-10-15 00:00:00 | 18 | 18 | 5.68 | 3.45 | 192.66 | 50 | 25 | 25 | 25 | 25.52 | 12 | 10 | 45 | 100 |  | 10 | 5.69
24J21392 | Aagard Group, LLC | 1111622 | 1.5 Hex Hub | 2024-10-09 00:00:00 | 2 | 3 | 14 | 5.75 | 294.74 | 50 | 25 | 25 | 25 | 25.52 | 12 | 10 | 45 | 100 |  | 10 | -3.83
24J21385 | Volumetric Technologies | 103075 | Rotary Actuator Mount 3.25 CL | 2024-10-10 00:00:00 | 1 | 1 | 2.08 | 2.13 | 183.82 | 50 | 25 | 25 | 25 | 25.52 | 12 | 10 | 45 | 100 |  | 10 | 27.96
23J20697 | BW Integrated Systems | 199045 | SHAFT 1.5 SQ x 85.25 LG | 2024-01-05 00:00:00 | 1 | 1 | 1.45 | 5.42 | 60 | 50 | 25 | 25 | 25 | 25.52 | 12 | 10 | 45 | 100 |  | 10 | 67.34
23J20696 | BW Integrated Systems | 175618 | SUPPORT BAR | 2024-01-05 00:00:00 | 1 | 1 | 0.3 | 0.88 | 78.26 | 50 | 25 | 25 | 25 | 25.52 | 12 | 10 | 45 | 100 |  | 10 | 29.77
23J20695 | BW Integrated Systems | 175617 | SUPPORT BAR | 2024-01-05 00:00:00 | 1 | 1 | 0.22 | 0.88 | 56.52 | 50 | 25 | 25 | 25 | 25.52 | 12 | 10 | 45 | 100 |  | 10 | 20.11
23J20692 | Boston Scientific Scimed | 90053215 | CLAMP TOP | 2024-01-17 00:00:00 | 6 | 6 | 7.32 | 9.67 | 89.59 | 50 | 25 | 25 | 25 | 25.52 | 12 | 10 | 45 | 100 |  | 10 | 23.64
23J20690 | LGC Douglas Scientific | M12-1-023 | 4mL COLUMN CHUCK | 2024-01-05 00:00:00 | 85 | 85 | 11.73 | 39.03 | 31.43 | 50 | 25 | 25 | 25 | 25.52 | 12 | 10 | 45 | 100 |  | 10 | 70.28
23J20689 | Boston Scientific Scimed | 90053214 | CLAMP BOTTOM | 2024-01-17 00:00:00 | 6 | 6 | 12.17 | 9.67 | 148.98 | 50 | 25 | 25 | 25 | 25.52 | 12 | 10 | 45 | 100 |  | 10 | 5.71
23J20688 | Boston Scientific Scimed | 90051135 | CARTRIDGE,HEAD | 2024-02-02 00:00:00 | 8 | 8 | 28.13 | 28.25 | 108.21 | 50 | 25 | 25 | 25 | 25.52 | 12 | 10 | 45 | 100 |  | 10 | 13.15
23J20548 | Boston Scientific Scimed | 90045901 | CONCENTRICITY RING | 2024-01-25 00:00:00 | 16 | 16 | 14.75 | 38.42 | 41.07 | 50 | 25 | 25 | 25 | 25.52 | 12 | 10 | 45 | 100 |  | 10 | 59.54
23J20547 | Boston Scientific Scimed | 90043460 | Tip, ILC | 2024-02-02 00:00:00 | 12 | 12 | 9.28 | 27.58 | 37.38 | 50 | 25 | 25 | 25 | 25.52 | 12 | 10 | 45 | 100 |  | 10 | 58.95
23J20546 | Boston Scientific Scimed | 90045903 | Sleeve/Helicoid | 2024-01-11 00:00:00 | 8 | 8 | 13.37 | 26.47 | 55.89 | 50 | 25 | 25 | 25 | 25.52 | 12 | 10 | 45 | 100 |  | 10 | 50.22
23J20534 | LGC Douglas Scientific | KBS-28-027 | KBS-28-027 BASKET MOUNT PLATE | 2024-01-05 00:00:00 | 6 | 6 | 4.12 | 3.83 | 159.35 | 50 | 25 | 25 | 25 | 25.52 | 12 | 10 | 45 | 100 |  | 10 | 8.07