SIP Build UK are the leading provider of Kingspan TEK SIPs (Structural Insulated Panel Solutions) within the UK. SIPs are a high performance building system for residential and commercial construction.
The team at SIP Build UK have been using a purpose built tool for their pre sale process, which is effective and efficient for their needs. However, they were experiencing problems once the orders came through to the Design and Manufacturing departments.
The orders were being tracked and maintained in silos with multiple MS Excel sheets, which were being manually updated across the departments. The need to duplicate data was time consuming, and date changes in one department weren’t showing the cascading effect they have across other areas of the business. Ultimately there was a lack of visibility across the organisation on the status of all the jobs.
SBP were asked to provide a project tracking solution where;
- Visibility of all projects was possible across the relevant teams.
- The impact of date changes showed immediately.
- Dates were planned from the Estimated Project Date but then superseded by the actual dates of tasks.
SBP created a project tracking solution with an intake sheet and multiple job sheets. The way the jobs needed to plan and report dates meant that inbuilt dependencies were unable to be used, therefore with extensive formulae the cascading required for date data flow was created. Separate manufacturing sheets monitoring build elements were linked through to the job sheets too. This was delivered with a detailed portfolio dashboard, tailored specifically for their requirements.
SBP also streamlined the intake → job sheet creation process using an API program.