| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | HSBNE CAPEX TRACKER | FY22 | 01/04/2021 - 30/03/2022 | |||||||||||||||||||||||||
2 | Details | Priority | Money | Grants | ||||||||||||||||||||||||
3 | This spreadsheet tracks all CAPEX mandates produced by member meetings at HSBNE. The sheet for expenditure tracks (roughly) as money is spent on the budgets. This sheet indicates remaining or overage, and allows marking budgets as closed once deemed completed. Code is used to track expenditure, Tracking Category and Responsible person is just nominal extra data. Prioritisation helps give an indication of where money should be spent when cashflow requires prioritisation. As always its at the discretion of the exec and treasurer. Priority should be taken into consideration with timelines and overall costings. Nominated budgets can be given as Opportunity as well as New, so that we can put in low priority 'someday' items for preapproval, with a threshold amount for what constitutes a 'bargain' we should capitalise. | 11.55 | Months | Cashflow/M | $2,000.00 | |||||||||||||||||||||||
4 | Unspent | Spent | Proposed | Assigned | Financed | On Hold | On Grant | |||||||||||||||||||||
5 | $23,095.89 | $2,689.11 | Current | $25,785.00 | $0.00 | $0.00 | $6,400.00 | $15,000.00 | ||||||||||||||||||||
6 | $44,574.15 | $3,900.85 | Total | $48,475.00 | $0.00 | $0.00 | Hide On Holds | $30,000.00 | ||||||||||||||||||||
7 | Expenditure | Budget | State | |||||||||||||||||||||||||
8 | First Approval Date | Last Approval Date | Code | Files | Category | Responsible | Group | Description | Effort | Impact | Priority | Remaining | Subtotal | Opportunity | Nominal | Assigned | Closed | Financed | On Hold | Hold Reason | Active | Grant | Allocated | Applied | Submitted Date | Response Date | Success | |
9 | 07/09/2021 | 07/09/2021 | 210907SHEETRACKS | Infrastructure | Joshua Hogendorn | Forge | Cantilevered racking for sheet goods | 3 | 3 | 0 | $3,500.00 | $0.00 | $3,500.00 | Needs Revote | ||||||||||||||
11 | 16/11/2021 | 16/11/2021 | 211116LASERSPARES | Consumables | Cameron Payne | Digifab | CO2 laser parts as spares | 1 | 2 | 1 | $500.00 | $0.00 | $500.00 | |||||||||||||||
12 | 29/09/2020 | 11/01/2022 | 200929FUSION | Infrastructure | Joshua Hogendorn | Infrastructure | Fusion 360 Licenses x3 | 0 | 3 | 3 | $70.00 | $0.00 | $70.00 | |||||||||||||||
13 | 11/01/2022 | 11/01/2022 | 220111HARDAIR | Site Works | Joshua Hogendorn | Infrastructure | Upgrade the air system above green room, behind wood/metalshop | 4 | 3 | -1 | $1,246.28 | $753.72 | $2,000.00 | |||||||||||||||
14 | 11/01/2022 | 11/01/2022 | 220111AIRDESSICANT | Site Works | Ryan Marple | Infrastructure | Upgrade air system Desiccant Water Seperator for Air Lines | 2 | 3 | 1 | $600.00 | $0.00 | $600.00 | |||||||||||||||
16 | 29/09/2020 | 12/01/2022 | 200929ADOBECC | Infrastructure | Joshua Hogendorn | Infrastructure | Adobe Creative Cloud Subscription | 0 | 3 | 3 | $80.00 | $0.00 | $80.00 | |||||||||||||||
17 | 08/12/2020 | 13/01/2022 | 201208ELECTRICAL | Site Works | Joshua Hogendorn | Infrastructure | Electrical Upgrades | 0 | 5 | 5 | $4,000.00 | $0.00 | $4,000.00 | |||||||||||||||
19 | 09/02/2021 | 14/01/2022 | 210209DRYBOXES | Machine Improvements | Cameron Payne | Digifab | Dry boxes for filament storage | 1 | 1 | 0 | $775.00 | $0.00 | $775.00 | |||||||||||||||
20 | 09/03/2021 | 15/01/2022 | 210309LOUNGEREFIT | Site Works | Timothy Reichle | HSBNE | Refit of Hipster Lounge | 3 | 2 | -1 | $500.00 | $0.00 | $500.00 | Low Priority | ||||||||||||||
21 | 23/03/2021 | 16/01/2022 | 210323PPECABINETS | Safety | Joshua Hogendorn | HSBNE | Three new PPE cabinets | 1 | 3 | 5 | $750.00 | $0.00 | $750.00 | |||||||||||||||
22 | 23/03/2021 | 17/01/2022 | 210323SPILLKIT | Safety | Joshua Hogendorn | HSBNE | Wheelie bin spill kit | 1 | 3 | 5 | $500.00 | $0.00 | $500.00 | Low Priority | ||||||||||||||
23 | 06/04/2021 | 18/01/2022 | 210406WASHANDCURE | Machine Improvements | Cameron Payne | Digifab | Wash and Cure equipment for Digifab resin printing | 2 | 4 | 2 | $216.28 | $283.72 | $500.00 | |||||||||||||||
24 | 24/08/2021 | 19/01/2022 | 210824CONTAINERWALLS | Site Works | Joshua Hogendorn | HSBNE | Materials to put walls in the 40' container | 2 | 3 | 1 | $800.00 | $0.00 | $800.00 | Blocked | ||||||||||||||
25 | 24/08/2021 | 20/01/2022 | 210824BLASTCABINET |  | Machine Purchase | Joshua Hogendorn | Paintshop | Purchase of a high quality pressure blast cabinet | 2 | 4 | 2 | $15,000.00 | $0.00 | $5,000.00 | $15,000.00 | |||||||||||||
26 | 25/01/2022 | 25/01/2022 | 220125WINDOWSENSORS | Infrastructure | Joshua Hogendorn | Infrastructure | Zigbee window and door sensors | 0 | 0 | 0 | $150.00 | $0.00 | $150.00 | |||||||||||||||
27 | 25/01/2022 | 25/01/2022 | 220125ALEXA | Infrastructure | Joshua Hogendorn | Infrastructure | Amazon Alexa Echo Dots | 0 | 0 | 0 | $150.00 | $0.00 | $150.00 | |||||||||||||||
28 | 25/01/2022 | 25/01/2022 | 220125CNCPROBE | Machine Improvements | Dave Seff | MetalShop | CNC tool sensor probe | 0 | 0 | 0 | $160.00 | $0.00 | $160.00 | |||||||||||||||
29 | 25/01/2022 | 25/01/2022 | 220125SONOFFSV | Infrastructure | Joshua Hogendorn | Infrastructure | SonoffSV remote relay | 0 | 0 | 0 | $100.00 | $0.00 | $100.00 | |||||||||||||||
30 | 25/01/2022 | 25/01/2022 | 220125AIRAUTO | Infrastructure | Joshua Hogendorn | Infrastructure | Valves and automation to vent water out of compressor | 0 | 0 | 0 | $500.00 | $0.00 | $500.00 | |||||||||||||||
31 | 25/01/2022 | 25/01/2022 | 220125DESKPOWER | Infrastructure | Joshua Hogendorn | Infrastructure | USB Chargers for desks in green room | 0 | 0 | 0 | $500.00 | $0.00 | $500.00 | |||||||||||||||
32 | 08/02/2022 | 08/02/2022 | 220208SECURITYCAMERA | Infrastructure | Murray Wayper | Infrastructure | 3 | 2 | -1 | $700.00 | $0.00 | $700.00 | ||||||||||||||||
34 | 08/02/2022 | 08/02/2022 | 220208LIGHTBOXTABLE | Machine Purchase | CraftPunk | 1 | 4 | 3 | $0.00 | $450.00 | $450.00 | |||||||||||||||||
35 | 08/02/2022 | 08/02/2022 | 220208FORGETOOLING | Tool Purchase | Forge | 2 | 4 | 2 | $1,096.33 | $903.67 | $2,000.00 | |||||||||||||||||
36 | 08/02/2022 | 08/02/2022 | 220208MECHTEAMSTARTUPEQUIPMENT | Tool Purchase | Mechanical | 2 | 4 | 2 | $3,852.00 | $748.00 | $4,600.00 | |||||||||||||||||
37 | 08/02/2022 | 08/02/2022 | 220208CRAFTPUNKGLASSTOOLS | Tool Purchase | CraftPunk | 2 | 4 | 2 | $1,000.00 | $0.00 | $1,000.00 | |||||||||||||||||
38 | 22/02/2022 | 22/02/2022 | 220222GRANTWRITER | Site Works | HSBNE | 4 | 3 | -1 | $1,100.00 | $0.00 | $1,100.00 | Low Priority | ||||||||||||||||
39 | 22/02/2022 | 22/02/2022 | 220222KITCHENCABINETS | Site Works | HSBNE | 4 | 3 | -1 | $1,500.00 | $0.00 | $1,500.00 | |||||||||||||||||
40 | 22/02/2022 | 22/02/2022 | 220222WOODSHOPSHEETING | Consumables | WoodShop | 4 | 3 | -1 | $750.00 | $0.00 | $750.00 | |||||||||||||||||
41 | 22/02/2022 | 22/02/2022 | 220222WOODSHOPCNCTOOLHOLDERS | Machine Improvements | WoodShop | 1 | 4 | 3 | $150.00 | $0.00 | $150.00 | |||||||||||||||||
42 | 22/02/2022 | 22/02/2022 | 220222WOODSHOPCNCCOLLETS | Machine Improvements | WoodShop | 1 | 4 | 3 | $250.00 | $0.00 | $250.00 | |||||||||||||||||
43 | 22/02/2022 | 22/02/2022 | 220222WOODSHOPCNCBLEEDERBOARD | Consumables | WoodShop | 2 | 3 | 1 | $450.00 | $0.00 | $450.00 | |||||||||||||||||
44 | 19/04/2022 | 19/04/2022 | 220419WELDINGGASMONITOR | Machine Purchase | Ryan Marple | MetalShop | Welding Gas Monitoring & Control Hardware | 4 | 4 | 0 | $1,000.00 | $0.00 | $1,000.00 | |||||||||||||||
45 | 19/04/2022 | 19/04/2022 | 220419METALANGLEGRINDERS | Machine Purchase | Ryan Marple | MetalShop | New angle grinders for the metalshop | 1 | 4 | 3 | $550.00 | $0.00 | $550.00 | |||||||||||||||
46 | 17/03/2022 | 17/03/2022 | 20220322BIGREDLASERTUBE | Parts & Spares | Cameron Payne | Digifab | 30w laser tube for big red laser | 1 | 4 | 3 | $2,000.00 | $0.00 | $2,000.00 | |||||||||||||||
47 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
48 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
49 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
50 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
51 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
52 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
53 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
54 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
55 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
56 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
57 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
58 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
59 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
60 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
61 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
62 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
63 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
64 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
65 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
66 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
67 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
68 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
69 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
70 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
71 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
72 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
73 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
74 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
75 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
76 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
77 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
78 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
79 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
80 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
81 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
82 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
83 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
84 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
85 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
86 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
87 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
88 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
89 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
90 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
91 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
92 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
93 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
94 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
95 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
96 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
97 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
98 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
99 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
100 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
101 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
102 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
103 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||
104 | 0 | 0 | 0 | $0.00 | $0.00 | |||||||||||||||||||||||