At Biarri one of our biggest value drivers is being able to transform businesses through leveragingdata to help make better business decisions. At the core of turning that data into value is our team of Data Scientists. In a recent article published on abc.net, author Antonia O’Flaherty discusses the growing demand for data scientists and the ‘surge’ for Data Science degrees.
To read the full abc.net article click the following link.
The career for the future
Described as ‘The sexiest job in the 21st century’ by the Harvard Business Review, Queensland universities have seen a large increase in enrollments and popularity. Griffith University alone has seen an increase of 400percent and has since introduced Data Science into two double degrees.
The growing attraction has also seen a surge in enrollments at both Queensland University of Technology (QUT) and at the University of Queensland (UQ).
QUT has seen a steady increase in enrollments since launching its postgraduate Master of Data Analytics in 2019 with QUT students said to be ‘future-proofing’ their careers by Professor Troy Farrell, the executive dean of QUT Faculty of Science.
Since the introduction of the program at UQ, over 5 years approximately 700students have taken to the classroom, taking up several new degrees on offer at the University of Queensland.
Data Science and what it means for Biarri
Our very own Head of analytics, DrEvanShellshear is a guest lecturer at leading universities on the eastern border, and predicts that Australia alone will need an additional 30,000 data scientists come 2031.
“What we are seeing coming out of universities alone is that we are not going to meet that demand, so there will always be a gap.”
As a Tech-business based here in Brisbane, Biarri continues to provide a fun and exciting working environment for DataScientists and Mathematicians to be able to apply what they learnt in University and apply it solving real life problems across multiple industries. From Energy and Mining to Retail, data scientists are applying their skills to a multitude of different business problems and providing valuable real life solutions.
Full time Biarri employee and recent UQ graduate DillonSteyl, graduated with a Mathematics and Computer Science degree, is relishing working at Biarri and making a positive impact for businesses.
“I have always liked mathematics and statistics, and here at Biarri I get to use those fields to solve real world problems. That is the biggest appeal for me.”
Dillon adds “There are lots of really positive, passionate and friendly people here at Biarri, and we all focus on solving one problem together and making the world a betterplace. It is quite a special experience.”
Biarri is always on the lookout for promising and excited graduates. For more information or if you have any questions please reach out today!
Get in touch
https://biarri.com/wp-content/uploads/2021/10/Dillon-Steyl-Biarri-1-e1633478270713.jpg5431000Paulohttps://biarri.com/wp-content/uploads/2017/07/Biarri-Full-Colour-Logo-2.pngPaulo2021-10-06 11:32:492021-10-06 12:44:28The growing demand for data scientists and what it means for graduates at Biarri
Navigating through last-miledelivery offerings can be a daunting task, as you figure out which routeplanningsoftware tool is the most applicable for your team, your businessoperation needs and budget. When considering Scopta’s Run and Route planning software, there can be a range of important factors to consider, such as:
Finding the best tool to reduce your operational costs and improve your bottom line;
Purchasing the necessary functionality to streamline current business planning and supplychainmanagement,
Identifying gaps within your current operations that could benefit from an automated software solution, as you seek to make technological advancements,
Selecting the correctrouteplanningtool that has the capacity to deal with your business intricacies and complexities, such as delivery windows, drop off specifications and vehicle compatibility.
As you work through the finer details of other route planning software providers, understand Scopta’s Run and Route and take a look through our customer profiles to see which one best aligns with you and your business.
Customer Type Summary
Pain Points and Challenges
Reducing operational costs Managing day to day to operations
Vice President of Logistics and Planning
Meeting customer demand and ensuring a safe and smooth operation Supply chain management and refining processes
Digital Transformation Manager
Improving business processes through AI solutions Simplifying and streamlining procedures
Delivery Schedule Planner
Creating a efficient delivery schedule that meets customer demand
Are you a General Manager?
Scopta’s Run and Route’s first customer profile describes General Managers of medium to large sized LPG Gas Distributors (1000+ employees). They hold a management position within the organisation – and are charged with overseeing the day to day service and deliveries of their distribution centre. With broad industry experience and academic qualifications, this GM drives strategy and performance across his business in revenue growth, cost reduction, operational efficiency and customer experience.
As business and demand continues to grow so does the business’s costs; mindful of their bottom line and an eye into the future, they seek for alternative options that can aid the deliveryschedulingteam in being able to meet their customers’ needs by making deliveries on time and on demand, and reducing the man hours spent on creating schedules through old hand method ways like excel and google maps.
Does this sound familiar? If so, our Run and Route tool helps solve the above challenges by creating an optimal and efficient set of routes, reducing drivers’ travel distance and accelerating the delivery process.
Are you a Vice President of Logistics and Planning?
Aligned closely with the General Manager, Scopta’s Run and Route next profile holds an executive role within the company and leads the logistics and planningfunctions. Tasked with ensuring the quality, efficiency and scalability of the supply chain, the Vice President of Logistics and Planning is constantly looking for systems, processes and technical solutions to gain and maintain competitiveadvantage.
Overseeing the supply chain processes of a large distribution centre of a goods company, they take a great deal of interest in businessprocesses and deliveryoutcomes and performance, with a desire to stay at the forefront of the industry. Taking a measured approach to how best to improve the service and delivery of their goods, they are on the constant lookout for solutions that can streamline the planning of delivery schedules and achieve efficient and costeffectiveplanning.
Open to technology advancement, they see the implementation of a route planning software program as a great advantage for route planning for more efficient delivery schedules. Does this sound familiar? If so, our Run and Route tool helps solve the above challenges by being market leaders in route optimisation, and being a functional and agile tool that simplifies the way you plan and deal with last minute adjustments.
Are you a Digital Transformation Officer?
With an eye to the future and a strongunderstanding of current business operations, our next profile looks to advance the company through digitalisation and with the integration of artificialintelligence. As a key decision maker with a background in information technology, they are motivated by efficiency and productivity, constantly looking to refine and improve streamlining supply chain processes. With a view to automating and digitising where possible, the Digital Transformation Officer sees potential to improve the last-mile delivery planning process, which currently involves a mixture of data sources, manual processes, online mapping tools and excel spreadsheets. This results in labour intensive processes, a lack of optimisation, barriers to scalability and key personnel risk.
The Digital Transformation Officer plays a vitalrole in the continual refinement of these practices, looking to streamline their processes through optimisation as they look for the best route planning software for their business requirements.
Does this sound familiar? If so, our Run and Route tool helps solve the above challenges through automated route planning solutions. Streamline the way your team plan and organise their trucking fleet, with a single tool containing all the functionality your team needs to deal with your business requirements.
Are you a Delivery Scheduler Planner?
Last but not least, the Delivery Scheduler. They have the critical role of planning the routes and delivery schedules for their 20+ trucking fleet. Equipped with nothing more than a spreadsheet, an online map and vast experience (perhaps having been a delivery driver themselves), they spend the better part of their week organising delivery schedules.
Motivated by meeting customers’ demand and ensuring deliveries are completed, there are many variables and barriers that they face. Dealing with the complexities of considering delivery windows, driver availability, infrastructure and truck requirements and specific load types, all while making sure delivery schedules are ready by the first delivery is a time-consuming and extremely difficult task when completed by hand.
Perhaps a route planning software tool could help?
Does this sound familiar? If so, our Run and Route tool helps solve the above challenges through its powerful optimisation engine. Be enabled to do more with a centralised system that deals with complex scenarios and variables, ensuring that you produce not only an error free delivery schedule but an efficient and cost effective set of routes.
Speak to our team now based on your above persona
If any of the following profiles or challenges resonate with you and your business, please reach out to one of our team members to discuss how ScoptaRunandRoute can assist, using the below contact form.
With a strong understanding of the constraints and challenges last mile delivery and route planning entail, the team behind Scopta Run and Route are dedicated to working along side you to improve your business processes and route planning through automation and optimisation.
Run and Route Contact Form
https://biarri.com/wp-content/uploads/2021/08/Screen-Shot-2021-08-05-at-10.47.22-am.png18943360Paulohttps://biarri.com/wp-content/uploads/2017/07/Biarri-Full-Colour-Logo-2.pngPaulo2021-08-05 12:46:372021-08-05 12:50:46Lead the way with the right route planning tool for you and your business
With the end of the Financial year coming to close, and as Businesses continue to adjust to our new normal, the team behind Biarri Workforce continue our commitment to improve and simplify workforce rostering and planning. With our users in mind, our development team has updated and created additional functionality to equip you the user with the necessary tools to improve the way you:
View KPI’s and create reporting for exporting;
Manage your employees work schedules across multiple rosters
Improve visibility of rosters when planning with simplified user interface functionality and
The way employers manage employees fatigue and qualification compliance
Read on to see how BiarriWorkforcecontinues to simplify and prepare your workforce scheduler to create optimised workforce rosters and work schedules.
Roster Export Additional Employee Columns
Reduce confusion and assure your employees with the option to increase your employees visibility with additional ‘Employee Fields’. When downloading or exporting your roster, you have the choice to include or exclude the following employee details from your roster. Better manage your employees’ details with the new employee columns.
2. Include shifts from non-primary roster
Better manage individual employee rosters by being able to include shifts from non-primary rosters. When downloading rosters, include or exclude shifts from non-primary rosters with Biarri Workforce’s new toggle option. Perfect for employees who work across multiple departments and perform multiple functions, keep track and improve the way you plan and organise their roster.
3. Customisable report titles
Create clearer reports and configure ‘titles’ and ‘subtitles’ before downloading your roster. With the ‘Suggested Titles’ selector – correctly title and label your rosters based on intelligent suggestions.
4. Roster KPI’s – Paid hours/ total days sub totals
Make more informed decisions with Biarri Workforce’s improved ‘RosterKPI’s’. With the enhanced KPI functionality, users will have the option to view the sub-total paid working hours and total days. Helpful and useful when dealing and managing fatigue, increase your workforce planners and users visibility over working hours, ensuring employee hours do not exceedCBAregulations.
5. Powerful roster view filters
Improve your userexperience with the new Biarri Workforce filter options. By clicking on the following ‘filter’ icon dropdown in the ‘Rostering’tab, your user will now be able to organise and switch views by selecting the necessary filters, creating a more clearer and purposeful roster.
6. Fatigue and Qualification Compliance Reporting
Found in the ‘Admin’tab, users will now be able to export fatigue and qualification reports under the ‘Roster Validation’ sub header. Make compliance and safety a priority by ensuring you have the correct employee with the correct qualification, to perform the necessary tasks. With ‘Roster Validation’reporting, your WorkforcePlanners and users will be able to stay up to date with employees who do not satisfy the requirements to perform specific tasks and roles. From alcohol tests to site compliance, roster validation will highlight when employees are in breach of rule specifications outlined.
If you want to know more about any of the features mentioned above, we invite you to leave your contact details in the contact form below and one of our team members will get in touch with you. Or if you want to know more about Biarri Workforce follow this link.
Workforce Contact Form
https://biarri.com/wp-content/uploads/2018/01/rostering_side.png6671000Paulohttps://biarri.com/wp-content/uploads/2017/07/Biarri-Full-Colour-Logo-2.pngPaulo2021-07-22 11:45:312021-07-22 11:45:33Biarri Workforce New Feature Release: July Edition
On the 12th of June, the team at Biarri were invited to attend and support the ‘Raising the Roof’ Gala Ball held by the AEIOU Foundation at the Emporium Hotel in Southbank, Brisbane. The night was filled with great food and drink and fun as the team stood in solidarity with AEIOU’s efforts in raising funds for Australian children and families living with autism. Through a silent auction and many generous donations, AEIOU managed to raise over $100,000 dedicated towards the construction of their new learning centre.
AEIOU Foundation for children with autism was founded in 2005, with a mission to provide early intervention that enables children with autism to live their best lives. Since 2005 and the establishment of their first centre in Moorooka, the Foundation provides early intervention learning programs for children aged between two to six across Queensland and South Australia. Fast forward to the present and AEIOU continues to make a positive impact on Australian families with autistic children through their educational services.
Biarri and AEIOU partnered in 2019 and worked in tandem to change the landscape of how AEIOU delivered their learning programs. Challenged with managing their clinical data and limited staff, AEIOU approached Biarri to create a streamline application to digitally capture children’s data for clinical assessment and create a platform to deliver their learning programs. Through Biarri’s ‘Little Steps’ educational application, parents and carers are now supported with an intuitive application that:
Improves the efficiency of staff content delivery;
Streamlines generating reports;
Removes manual large paper folders and records and
A centralised data hub to be analysed for treatment and progress insights
Biarri would like to extend a warm thanks and congratulations to the team at AEIOU Foundation for their continual work in creating awareness and raising funds to assist children with autism. Biarri champions ‘Positive Impact’ as one of our core values and we take great satisfaction in being able to assist great causes. We look forward to continuing our partnership and are excited to see the positive changes the new learning centre will bring to children and families.
Get in touch
https://biarri.com/wp-content/uploads/2021/07/Header.png357558Paulohttps://biarri.com/wp-content/uploads/2017/07/Biarri-Full-Colour-Logo-2.pngPaulo2021-07-15 10:51:032021-07-15 10:51:04A night to ‘Raise the Roof’ with the AEIOU Foundation for children with autism
Getting from point A to point B is a simple enough task to be completed on most devices, through various different apps and software. But what happens when you have to get from point A to point B and now point C with consideration of other factors like availabilitywindows and route preference? Scopta have developed Run and Route a route optimisation software that deals with the complexities of vehicle and delivery routing.
Read on to discover Run and Route and how it is changing route optimisation and vehicle routing.
Barry is the Operations Manager at a warehouse depot for a biscuit company and is in charge of the planning and organising of the distribution of goods sold across Sydney. Barry is tasked with delivering 400 orders to be delivered between 20 trucks, exactly 20 orders per truck. For the last 10 years Barry has used a combination of Excel and Google Maps to figure out their delivery routes. He plans his delivery schedule a week in advance, and spends a large portion of the week carefully mapping out delivery routes. Barry is restricted by both time and cost, trying to figure out the fastest and most efficient route.
Planning out a delivery schedule by hand is notoriouslydifficult and timeconsuming, not to mention subject to humanerror. Manually working between Excel and Google Maps to find the best delivery order is inefficient and also raises challenges such as the TravellingSalesmanProblem or TSP, which is simply finding the best order in which to visit a set of locations. Through traditional methods of Excel and Google Maps it won’t tell you the best way to order those stops to give you the overall shortest or fastest route but instead show you the quickestroute from point A to point B. Now say you throw in point C and point D? An extra level of complexity is added with additional locations. How is Barry to know which location to begin with and the order to complete the rest of his deliveries?
With Run and Route, Barry will have a centralised solution that will allow him to input information about his locations and trucks, and automatically configure the fastest and most cost effective delivery routing schedule. Traditionally, Barry might have begun his route at point A, followed by point B, C and D in that order. By inputting this data in Run and Route, Run and Route will determine the optimaldeliveryschedule that would show that this particular truck should begin his delivery route at point C, then point A, then point D and finishing at point B.
Another challenge Barry and other OperationsManagers face is creating a schedule that considers delivery timewindows and customeravailability. Factoring customer availability and time windows is a crucial and important aspect of determining the optimal routes for a fleet of delivery vehicles. For example one shop in Bondi has a strict 2 hour delivery window between 5:00am and 7:00 am, while another customer in Redfern is a bit more flexible and is open for deliveries from 6:00 am to 12:00 am. Manually working through these intricacies one truck at a time not only requires an incredible amount of thought and time, the level of complexity dramatically increases with scale.
Run and Route is Scopta’s Vehicle Routing offering, designed to simplify the planning process for last-mile delivery. It is useful for businesses with multiple vehicles that each perform multiple deliveries per day. Run and Route can help your business cut variable costs and improve your customer service. Remain efficient and competitive with a quality Vehicle Routing Solver that simplifies the role of your Operations Manager and the way you plan and schedule your deliveries. Be confident and assured with the quality and accuracy of your schedules with Run and Routes powerful engine.
Want to know more? Speak to a team member today and find out how Scopta Run and Route can automate your vehicle routing.
Run and Route Contact Form
https://biarri.com/wp-content/uploads/2021/06/christian-chen-l44HV2wprrY-unsplash-scaled.jpg19202560Paulohttps://biarri.com/wp-content/uploads/2017/07/Biarri-Full-Colour-Logo-2.pngPaulo2021-06-22 13:38:202021-06-22 13:38:21Changing the landscape of Route Optimisation
The team behind Biarri Workforce are dedicated to helping your business get the most out of our rostering software. Whether it is simplifying the job of your workforce planners or creating a team friendly roster that increases your employees satisfaction and retention, Biarri Workforce is the solution to improve your workforce planning and rostering. Biarri Workforce is tried and tested across many industries including maintenance teams, healthcare and aviation.
Read on to learn about the 3 ways Biarri Workforce improved rostering and workforceplanning for the team at CQFMS and how Biarri Workforce can help your Workforce Planners and your Business.
1. Biarri Workforce Software
We’ve all heard it before:
“It is not the tools we use that make us good, but rather how we employ them”.
This saying doesn’t always hold true, sometimes simply not having the correct tool for the correct job restricts our ability to perform; so why not start with the right tools for the right job?
Like so many other businesses, CQFMS managed their workforce and planned their rosters using ever increasingly complex Excel spreadsheets. While Excel is a capable tool, rostering a growing team of people over a 24/7 period all while adhering to EBA and fatigueregulations can quickly become a nightmare of complexity. Through system drivenautomation and the powerful Biarri Workforce roster optimisation engine, the team at CQFMS were able to significantly reduce roster preparation time, more easily ensure compliance with EBA and fatigue requirements and manage changes to their rosters more effectively.
2. Onboarding New and Existing Employees
When managing a large fleet of workers, onboarding and assigning new employees to a roster can become a time consuming task. This was the case with CQFMS, with a growing workforce. Previously, onboarding was completed using another HR software system and new employee lists were manually transferred through to Excel to begin planning the roster. This was inefficient and not scalable so CQFMS requested a more streamlined approach to onboarding. Through Biarri Workforce, Workforce Planners are now able to onboard employees much easier, as well as manage their roster in the same system. Found in the Biarri Workforce ‘Employees’ tab, you are able to onboard new employees and upload documents such as certificates and other qualifications all in one simple and easy to use interface.
3. Creating a safe roster
CQFMS and Biarri valuesafety and understand that an implied safety culture goes beyond the job site and includes appropriate roster creation. It is critical when planning a roster to have the correctly trained and skilled people for the job and to ensure that employees have current certification suitable to be rostered to work on a site. Biarri Workforce has in-built validation rules which enforce training and skills compliance to enable workforce planners to plan and roster the correct workers to be deployed on site. Another crucial aspect of roster creation that Biarri Workforce automated for CQFMS was the time consuming process of checking and managing employee fatigue. Ensuring the safety of employees meant making a roster that was compliant with EBA regulations including workplace fatigue rules. Previously, it was difficult and time consuming for CQFMS to manually update and track overtime and employee hours for a large workforce. The Biarri Workforce rules engine and validation function will not generate a roster which breaks fatigue rules and when manual changes are made to the roster the rostering team is automatically notified if the planned roster breaches any fatigue rules. Rosters cannot be published without the Workforce Planner acknowledging and/or fixing these issues.
The right tool
CQFMS is one of many valued Biarri Workforce users. By stepping away from Excel spreadsheets and adopting Biarri Workforce, CQFMS have made noticeable improvements in how they plan and manage their rosters. Reducing time and effort to generate rosters while also automating the important task of skills and fatigue compliance.
If you would like to know more about how Biarri Workforce can improve your rostering and workforce planning or have any other further questions, feel free to leave your details below and a team member will get in touch with you.
Workforce Contact Form
https://biarri.com/wp-content/uploads/2021/05/shane-mclendon-EN1tF2EG-50-unsplash-scaled.jpg19192560Paulohttps://biarri.com/wp-content/uploads/2017/07/Biarri-Full-Colour-Logo-2.pngPaulo2021-05-13 11:52:202021-05-13 11:53:193 ways Biarri Workforce can improve rostering and workforce planning
Creating rosters can be a complex task. This is especially the case for difficult large workforces with a range of employee preferences, combinations of full time, part time and casual team members, the need to adhere with EBA rules, fatigue, skills and competence requirements , meeting or exceeding customer service levels while always operating efficiently and controlling costs. Clearly, producing a ‘good’ roster is more than making sure there is the right number of staff for the right amount of work.
So, on top of all of this what does ateam friendly roster look like and what are the benefits to employers and employees?
A Friendly Roster
An example of what makes a team friendly roster.
Sarah is the Workforce Planner for the local hospital Emergency Department. She is tasked with organising and preparing the Doctors rosters which she does a month in advance for a 2 week working period. The roster parameters require each Doctor to work a specific amount of ‘unsocial’ hours covering morning, afternoon and night shifts. Sarah always does her best to consider the Doctors preferences for specific days off some of which are always the case and some are new requests each period for example to get a mid week night away to see Hamilton in Sydney or an afternoon off for the school swimming carnival.
Sarah completes the roster by hand creating a compliant roster with all shifts covered and accommodating as many preferences as possible in as fair a manner as she can. However, is it always a ‘good’ roster from everyone’s perspective?
While a ‘good’ roster will vary from business to business and even with respect to each employee depending on their individual circumstance, one aspect of ‘good’ roster from an employee perspective can be defined as being fair and equitable – team friendly. For example, while Sarah may have created a functional roster that ensures the ED department meets the service level requirements, Dr Brown might have worked the past 4 Saturdays in some capacity impacting on his ability to watch his children’s sports while another team member may have worked an equal amount of hours but more night shifts than other team members. Although on the surface the roster was compliant and functional, it is not considered a team friendly roster given the unfairness and lack of equality amongst employees.
In addition, there may be team members who prefer to work weekends, others who prefer nights, some who only work 3 days a week and still others who might be spouses and who cannot work at the same times as their partners – so that someone is home with junior.
Further, the roster needs to consider patterns of work – moving from morning to afternoon and onto night shifts with then a number of days break.
This gets complex quickly!
A team friendly roster will consider all of these different preferences and requirements and provide shifts which are equitable and fair in providing each team member with the same proportion of night or weekend shifts (unless of course they prefer these) and evenly meets as many of their time off requests as possible.
Adopting a team friendly roster has many benefits to both employees and employers. These include:
Better work-life balance
Your workforce will be made up of a range of different people with different interests and commitments outside of work. Commitments such as family, study, and sport for example. A study conducted by Gallup Reports found that 53% of employees said that an improved work-life balance was important to them. With a fair and equitable roster these other commitments and interests will be accommodated to the fullest extent possible, making work rosters more manageable and providing employees enjoy an improved work-life balance.
Improve staff retention with a balanced roster that is considerate of staff preferences and importantly fair and equitable across the team. There are many factors that contribute to employees leaving, such as career advancement, pay and benefits but also the nature of the rosters they are repeatedly asked to work. Employees have shown to be happier when they are able to balance both work and life commitments and are treated fairly resulting in employees desire to stay in that job. This is especially important when retaining skilled staff or staff with experience that is hard to come by. By ensuring rosters are fair and equitable across all employees you will reduce conflict and ensure no employees feel stuck with the ‘unsocial’ shifts.
Biarri Workforce provides open and flexible rules and preference capture functionality so hard or soft constraints and preferences can be considered in the roster creation and the powerful roster optimisation engine in Biarri Workforce allows the Sarah the workforce planner to set the roster objectives and generate team friendly rosters automatically in a matter of minutes.
By using Biarri Workforce, you will be able to improve work-life balance for your team members and ensure your roster is fair and equitable.
Speak with a consultant today and see how Biarri Workforce can improve the way your business coordinates your human workforce. Whether you are currently rostering manually or looking for a more accommodating solution, the team behind Biarri Workforce are dedicated to making Biarri Workforce work for you.
Workforce Contact Form
https://biarri.com/wp-content/uploads/2021/04/pexels-fauxels-3184418-scaled.jpg17072560Ash Nelsonhttps://biarri.com/wp-content/uploads/2017/07/Biarri-Full-Colour-Logo-2.pngAsh Nelson2021-04-27 10:19:312021-04-27 15:20:21Creating team friendly rosters and the benefits for everyone
Throughout my career I’ve worked with salespeople, as a salesman, and in roles supporting sales activities. Sales is one of the most important functions of a business as without sales, you have no business, no matter how great your product or service is.
Sales is the fuel for any business to survive and thrive and this makes planning and forecasting sales one of the most important activities a business does.
That’s why running a business without effective and accurate sales forecasting is a bit like flying a plane without a fuel gauge. Of course, an accurate fuel gauge is not necessary or sufficient for generating or maintaining lift – the Wright brothers got away without one. But there’s a reason why modern planes have them – it gives pilots access to data to make the flight decisions to get from A to B.
So how are you flying your venture?
Probably the same as most other businesses.
You gather your sales team and ask them, ”how many sales will we have this year?”
In the best case scenario, they review last year’s sales and make a guess based on gut feeling and intuition (which is not always wrong).
Commonly enough though, a misalignment of incentives and company sales culture can manifest as a mismatch between targets (optimised for remuneration incentives) and forecasts (optimised for accuracy).
We can do better.
And to do this we need to use data. But why is data so important?
According to the Professor of Digital Practice at QUT, Mal Thatcher, the 21st century will be the century where,
“By the middle of the century the only tangible asset on an organisation’s balance sheet will be data”
and this is true for your sales too.
To give you and your business a competitive advantage, we at Biarri have developed a simple, easy-to-use Excel sales forecasting tool for you. So it is time to become data driven now and with Biarri’s new tool this is extremely easy.
Biarri has taken some basic AI techniques and put them into a spreadsheet that requires no macros, no plugins and nothing to install. The AI techniques in this Excel tool will help guide your sales team to make more accurate predictions for the coming year.
You don’t need to be an expert in AI to leverage the tool. It does all of the hard work for you and provides you with data driven monthly predictions for the coming year based on quarterly sales patterns. You don’t need to know cutting edge AI to use the tool, just how to copy and base a small amount of data.
You can download the tool below for free. There is no need to leave your email address or anything. Biarri’s mission is to make the world more efficient via better decisions powered with mathematics and we believe this tool has the potential to make a difference for your organisation.
Your New Sales Forecasting Tool
Before you download the tool, it is worthwhile telling you what it is, and how to use it.
It uses historic data to establish a pattern and then extrapolates this pattern to be able to predict the coming year’s sales.
Not only does the tool provide monthly predictions, it also takes into account quarterly sales cycles. Forecasting quarter-by-quarter aligns it with typical quarterly reporting and also captures the variance in quarterly sales. This quarter-by-quarter approach is designed for industries like retail which have some quarters with greater sales (e.g. Xmas).
There is also a “bad month flag”. This allows users to indicate if something bad has happened in the past during months (e.g. COVID) and if similar events are predicted to occur in the future (in the PREDICTIONS tab).
This spreadsheet comes prefilled with data to show you what it should look like. To use it for yourself, remove the data from the Monthly Sales column in the Data tab and replace it with your own data. The calculations and updates will be carried out automatically. All other cells are locked for your safety.
How do I use the sales forecasting tool?
The steps to using the sales forecasting tool are as follows:
1. Collect exactly 36 months of contiguous sales data leading up to the month you would like to predict from. E.g. if you want to predict the yearly sales from January 2022 until December 2022, then collect the 36 months of sales data from January 2019 until December 2021. The model is set up for exactly 36 months of data, not more or less.
2. Copy this sales data into the Monthly Sales column in the Data tab (in green). The top most entry should be the oldest (e.g. in the example in 1., January 2019) and the bottom most entry should be the newest (e.g. December 2021 in the example in 1.).
3. In the Data tab now enter the first month for the monthly sales data in the month tab by choosing from the drop down menu (this cell is green). Also choose the year in the year column from the drop down menu (this cell is also in green).
4. For each month, choose whether a bad event occurred (or not) by selecting Yes or No in the Bad Event column. If normal trading and fluctuations were occuring, then put No. Otherwise, if something truly unusual (e.g. COVID) occurred that significantly impacted your sales volumes, select Yes on the months which were affected by this (this column is coloured green).
5. Once this data has been entered, go to the Model Analysis tab to see the outputs of the model. In the Predictions tab, if you predict that there will be any bad months in the future, select Yes in the corresponding months in the Bad Event column (which is in green). For this to have effect, similar Bad Events need to have occurred in the past otherwise this will have no effect.
6. Finally, your predictions are shown in a graph in the Dashboard tab, with a table showing the cumulative results for each quarter.
Download the sales forecasting tool by clicking on the button below.
Most companies begin with Excel sheets like the one provided here to start making once off decisions on key parts of their business. It is like the first flight of a plane with an often inaccurate fuel gauge caused by data issues. At some point, organisations need to lift up from Excel to correct, secure, easy to use and more powerful tools and this is where Biarri helps.
Biarri’s main value proposition is to help clients realise operational excellence in the way they run their business via AI. The core of this is excellent, data driven decision making. Biarri catalyses AI driven business decisions by using its cloud based set of mathematical tools, the Workbench.
To discuss how you can leverage your data and turn it into value to reach new operational heights, reach out with the form below now.
Get in touch
https://biarri.com/wp-content/uploads/2020/10/isaac-smith-AT77Q0Njnt0-unsplash-scaled.jpg17072560Ash Nelsonhttps://biarri.com/wp-content/uploads/2017/07/Biarri-Full-Colour-Logo-2.pngAsh Nelson2020-10-06 10:18:092020-10-06 10:18:11Sales Forecasting Tool to Plan Accurately With Some Simple AI
As COVID descended upon the assisted care industry, many were unsure how they would survive. Providing education services for children with disabilities such as autism is not something that can be easily carried out remotely. As the healthcare crisis mushroomed into a potential years long drama, people were questioning whether the service providers could even survive.
This feeling of despair was facing most industries as they tried to desperately pivot their businesses to stay afloat. Organisations in sectors like e-commerce were well positioned to grow, others like the assisted care providers less so.
However, there have been some pioneers who have thrived. We can learn from their successes.
All businesses which have pivoted to digital have discovered one thing – a deluge of data. This deluge of data means that the next phase of growth out of COVID will be defined by two paradigms:
Businesses harnessing their digitally generated data to enter a new phase of growth defined by:
Cheaper and personalised marketing,
Extended flexibility in delivery of services and products
Better operating margins
Businesses who are unable to leverage their digital assets and will continue to struggle throughout the crisis praying for it to end unable to meet the challenge.
AEIOU is a provider of educational services to children with autism. Their mission is to provide early intervention that enables children with autism to live their best lives.
In early 2020, it became clear to their dedicated team that the year was going to be different. As the global economy grinded to a halt and social distancing became the norm, the staff began worrying that possible COVID outbreaks in their centres could shut them down.
However, they had a trick up their sleeve – the Little Steps educational platform.
Over the previous nine months, the AEIOU team had been working indefatigably with Biarri to bring a disruptive new technology to the industry which would:
Remove the need for large paper folders transported around in trolleys;
Improve the efficiency of staff content delivery;
Make home based delivery possible and
Create a treasure trove of digitally collected, consistent and high quality data to be analysed for deep treatment and progress insights
And it would be this final point which has the potential to not only revolutionise the disability care sector but all sectors.
But how? And why?
AI Driven Business Decisions
Like AEIOU, across the globe many businesses are in the final stages of a planned digital transformation or one brought on by COVID. Those businesses which have already completed this process are now looking for ways to leverage the data being collected by the new digital processes and turn it into value.
So what is the best way to do this?
By combining your data with intelligent analytical tools to help make better decisions.
Having good quality data in a consistent format, collected by digital channels, allows companies to apply powerful analytical tools to this information and use it to help understand:
What will the future look like? I.e. make reliable predictions
What is the best decision to make? I.e. optimise choices to maximise returns and organisational growth
The problem is that data driven, decision-making normally begins with the in-house development of low-tech tools to manually solve key business problems. As businesses grow, they must move their Excel sheets to the automation of core business processes via mathematical tools to enable better decision making. Why?
Replacing error prone, slow, manual and insecure processes with robust, fast, automated and secure AI tools enable new phases of growth.
By providing digital tools to make optimal decisions, front line staff can move from manual, repetitive and error prone tasks to high value scenario analysis and answer key questions for senior management around future states and optimal strategies. What does this achieve?
It increases the value output per employee via automation and outmaneuvers competitors with better decisions
By using AI to create value, companies can begin the AI driven digital transformation journey as shown in the below image.
But how can a company climb this curve? The details of this transformation are represented in the following diagram.
With the early learning platform, AEIOU have built the foundation of their digital strategy and the logical next step in their transformation is ground-breaking. By digitally capturing the data on learning outcome improvements for children with autism, they can discover new methods that can transform the journey for some of society’s disadvantaged.
Even greater for AEIOU was that their digital platform, Little Steps, was ready as Australia went into lock down. They were able to leverage it to continue the challenging remote learning regime required to not interrupt the learning process for their children.
This wasn’t the first app Biarri had built to enable companies to thrive during the COVID challenge. Biarri has built over a hundred apps to help companies all along the journey of turning data into value.
What role does Biarri play in this transformation?
Biarri’s main value proposition is to help clients realise operational excellence in the way they run their business. The core of this is excellent, data driven decision making.
How do we do this?
Biarri catalyses AI driven business decisions by employing its cutting edge Workbench platform. The Workbench platform empowers Biarri’s customer base in the form of value-creating production tools.
In the words of businesses we work with, the benefits of a data driven approach leveraging mathematics are that it:
Helps make better decisions
Improves efficiencies & saves time
Improves a business’ core product / service delivery
Is easier to use than alternatives (e.g. better than Excel)
Allows real time and scenario planning abilities
In AEIOU’s case we built a digital platform with plug and play analytical capabilities. This could tap into automated and optimised rostering tools and lead a true AI driven digital transformation. In the words of their CFO:
“The development process with Biarri has been a great success. The team went above and beyond to deliver on our requirements and were engaged, helpful and responsive in understanding the complex needs of our business. The challenge Biarri solved was complex, however, the entire process from development to operation was collaborative and professional and we look forward to continuing our partnership with them.“
Matthew Walsh, CFO, AEIOU
Does this apply to me?
Biarri delivers solutions to a wide range of industries. The mathematics which powers our AI knows no boundaries and one powerful model can underpin the efficiency gains in profoundly different industries, from aviation through to the healthcare.
To discuss how you can leverage your data and turn it into value, with AI Driven Business Decisions, reach out with the form below.
Get in touch
https://biarri.com/wp-content/uploads/2020/09/carlos-esteves-G8wvNzm_fK0-unsplash-scaled.jpg16952560Ash Nelsonhttps://biarri.com/wp-content/uploads/2017/07/Biarri-Full-Colour-Logo-2.pngAsh Nelson2020-09-17 14:20:432021-03-18 11:49:49AI Driven Business Decisions
Many Health and Hospital services around the world have introduced integrated care activities to coordinate Primary (Community and GPs) and Secondary (Hospitals) care levels in order to increase the effectiveness of care being provided at all levels.
Biarri delivered a predictive data analytics solution which successfully identified hospital patients in the community who were most likely to readmit to hospitals. Statistical analysis proved the Biarri Solution is able to identify the top 1% of the population at risk of hospitalisation with 90% accuracy.
In January 2018, Ron Calvert, the CEO of Gold Coast Health and Hospital Services (GCHHS) was in the news recognising Biarri’s predictive analytics in the form of a ‘Biarri Score’, which predicts an individual’s likelihood of readmission to hospital with ‘remarkable levels of accuracy’. Check out the article here.
The Biarri Score is now in place in the Gold Coast University Hospital emergency department. Also, patient criticality scores are integrated into local GP practices to provide intra-facility collaboration of healthcare services and prevent unnecessary admissions.
This application of Commercial Mathematics has resulted in increasingly better identification of patient who are likely to readmit, in order to improve the effectiveness of the Integrated Care activities and reduce demand on emergency departments.
Get in touch to learn more about Biarri’s Predictive Analytics capability or to learn more about applicaitons of Commercial Mathematics in other areas!
Click on the different category headings to find out more. You can also change some of your preferences. Note that blocking some types of cookies may impact your experience on our websites and the services we are able to offer.
Essential Website Cookies
These cookies are strictly necessary to provide you with services available through our website and to use some of its features.
Because these cookies are strictly necessary to deliver the website, you cannot refuse them without impacting how our site functions. You can block or delete them by changing your browser settings and force blocking all cookies on this website.
Google Analytics Cookies
These cookies collect information that is used either in aggregate form to help us understand how our website is being used or how effective our marketing campaigns are, or to help us customize our website and application for you in order to enhance your experience.
If you do not want that we track your visist to our site you can disable tracking in your browser here:
Other external services
We also use different external services like Google Webfonts, Google Maps and external Video providers. Since these providers may collect personal data like your IP address we allow you to block them here. Please be aware that this might heavily reduce the functionality and appearance of our site. Changes will take effect once you reload the page.
Google Webfont Settings:
Google Map Settings:
Vimeo and Youtube video embeds: