Category: Uncategorized

Forecasting for Hotels and Hospitality

The devil is in the detail

Forecasts and budgets are a normal part of managing any business and the Hospitality industry is no different.

The challenges the Hospitality industry faces are much like any other industry, identifying sources of business and the related dependencies. Once you have done this it’s important to assess the impact from both a macro and micro level such as unemployment levels, general health of the economy, inflation, employment laws, interest rates and special events taking place In their market (major sporting events, concerts, trade shows and exhibitions) and competitors entering the market.

At the forefront of the process is identifying any capital requirements of the establishment. It could include expenses that address guest safety issues, revenue optimisation opportunities such as a restaurant refurbishment, cost avoidance or investment in energy management planning as an example. Then you have to assess if any of these projects may disrupt the normal course of business, such as a guest room renovation in particular or anything that might constrict capacity. A critical component of this review is a calculation of a return on any investment and the source and cost of capital funding for such projects.

Once the capital plan and associated expenses have been established for a hotel, the revenue component of the hotel operational forecast can be determined. There are numerous factors and sources that come into consideration when determining the data inputs for volume projections, occupancy rates as well as the room rates and pricing of meals.

In the rooms division of a hotel, projections need to factor sources of business from group contracts, contracts with airline crews, online travel agency portal and offers on brand websites, each source of revenue will have to be weighted against the standard room rate after discounts and seller fees have been applied.

You then have to step change by dates the increased demand and increase in room rates that come with special event such as those listed above on the area in addition to previous year’s actuals to try to determine the supply and demand on any given day. Local market knowledge is important in this process, so the forecast needs to be broken down by hotel and potentially distributed to the local management for their input. Other factors that come into play regarding determining average rates are the length of stays and arrival patterns.

In the food and beverage area of the hotel, capture percentage rates come into play when determining how much business will be generated by hotel guests, catering for special events, versus business that comes in off the street to eat in the restaurant. Determining the revenue per guest is a derivative of menu pricing as well as meal period i.e. Breakfast, Lunch or Dinner.

Full-service hotel operators, those with restaurants, spas, retail, banqueting, catering and a large number of rooms need a more sophisticated tool to produce an effective budget and forecast. The operators of these facilities need the ability to modify labour expenses (the largest opex cost to any hotel operator) based on business volume, seasonality and productivity standards. They need the ability to adjust their variable operating expenses including labour based on volume of occupied rooms, arrivals and departures, customers in the restaurant, spa or golf facilities. They will need the software to drive a variety of expense drivers such as cost per occupied room, cost per customer and cost per available room as examples. Once the hotel determines the daily revenue and transactional activity (rooms, guests, etc), the expense component would fluctuate accordingly as business volumes change.

Labour projections are also critical to the profitability of the hotel. It is a delicate balance to try and contain labour costs without negatively impacting the guest experience. Productivity per head should be as an example, how much time it takes to clean a room in relation to the revenue and volume projections in order to determine how many individuals are needed in a particular position on any given day.

With ProForecast and our capacity yield model, we offer you the flexibility to plan your budgets and forecasts to the right level of granularity to ensure it is as close to the actual outcome for your business.

Doing less you might as well ask Siri or Alexa to come up with a plan.

Visit us at www.proforecast.com and book a demo to see the most powerful forecasting application on the market.

Mark Harrison

Chief Commercial Officer

09/10/2019

Forecasting for Retail in an Amazon World

The “Amazon effect” has already dramatically changed the landscape of retail but the disruption goes much deeper than just the convenience of 24/7 shopping and next day delivery. It has changed retail cycles as retailers are forced to change the timing of their typical end of season sales to align with the Amazon driven Black Friday and assorted Amazon Sale Days throughout the year.

As a result, forecasting for a retail business or one of the myriads of distributers in their supply chain is very different to what it was just a few years ago.

With e-commerce comes e-planning and if you are not already forecasting differently you will or should be.

Online shoppers don’t want the pre prescribed experience of the traditional department store, they expect an experience tailored to their likes and preferences. To exploit these differences, we need to plan and forecast more flexibly and take into account macro and micro changes in consumer behaviour.

Traditionally, forecasts were based on historical demand and performance and the assumption that largely history will repeat itself.

In principle these methods hold true but without the ability to build and test new scenarios into a forecast, these forecasts will struggle to keep up with a rapidly changing dynamic landscape.

In today’s landscape, changes in the marketplace are swift, sudden and don’t follow a historical trading trend or pattern. Just looking at historical trading will not give you the whole picture.

To have a credible forecast you need to make judgements based on multiple scenarios, such as changes in buying habits and peak sales times, introducing new products more frequently than has been done previously, flexing your work force around these new dynamics.

To predict demand people are turning to machine learning to try to understand the drivers for demand of what and when, Big Data gives us access to an almost infinite array of parameters to consider, however without analysis Big Data is just that, a lot of data without any credible output.

How to harness the power of the available data to produce an accurate and credible forecast for your business is one of the many challenges we’ve set ourselves at ProForecast. We work together with local Universities to harness the power of Machine Learning to improve the reliability of our output. In the meantime, we offer you the ability to customised and run multiple scenarios both micro and macro to come up with the best way of planning for demand and the associated costs moving forward.

Visit us at www.proforecast.com and book a demo to see the most powerful forecasting application on the market.

Mark Harrison

Chief Commercial Officer

04/10/2019

Why do Forecasts Fail?

Hubris and poor assumptions will do it every time.

Forecasts, in many cases are nothing more than an educated guess, someone’s gut feel. Sales projections and margins used to calculate outcomes are the starting point to make the model achieve the target goal, whether these are realistic or not is not the forecasters responsibility or goal.

I’ve run sales in major corporations and have frequently had sales and gross margin targets imposed upon me that bear no resemblance to the market we were operating in. The goal of such forecasts, that are doomed to failure, is usually to keep a hostile board at bay and hide the fact that things aren’t going as well as they should be or that the business isn’t being run as well as it could. You probably get to fire the sales guy twice before that argument doesn’t work anymore and questions are asked about how the business is run on a wider front.

To take them beyond this and make them more meaningful guides to drive your business its important to run multiple scenarios, in setting sales/revenue targets there should be a worst case, mean and stretch scenarios that can be used to see how far you can go with the business or what is the worst case you are going to have to survive.

If things look comfortable on your worst-case scenario then you probably have a mature business with predictable revenue from multiple long-established customers. Worst-case will show a small decline in revenue from your existing base plus very little growth from new ones. The mean forecast will be just steady as she goes projecting historic growth forward with potentially some tweaks for saturation of certain markets and growth in others. Stretch will be just that, if things go very well and the stars align for your business and your products then this is what it could be.

Start-ups tend to operate in permanent stretch as they have the unusual mix of no historic data, a combination of inexperience, optimism and hubris. I’ve never seen a start up that hit its forecast.

So, how to make your forecast more accurate and a real tool to manage the expectations for your business.

  1. Avoid inaccurate or false assumptions, easier said than done, but when preparing a forecast its easy to skim over this key part of the process.
  2. Focus on historic data and the forward extrapolation of that data.
  3. Be realistic and consider the effect, market changes or the wider economic impacts will have on your business, test these with thorough scenario planning.
  4. Don’t ignore fundamental changes to your market, there are many things out of your control, such as exchange rates as a very simplistic one or to be current perhaps you will have to pay duty and wait longer for your goods from a supplier in the near future and this needs to be factored in.
  5. Hubris, don’t get carried away because you had one good quarter its much better to over perform than over promise.

No forecast will ever be accurate, so the real test is the scenario planning, which should provide a wide range of realistic outcomes and understanding that as the forecasted period progresses how various events and circumstances will affect your business.

ProForecast allows the user to run multiple “what if” scenarios to allow them to stress test a forecast and produce a realistic set of outcomes for your business. This will assist you in solidifying your strategic planning for the future and allow you to react to events as the forecasting period unfurls.

If your like to learn more about how Proforecast can be a key tool in the development of your strategic plan then visit us at www.proforecast.com book a demo or give us a call.

Mark Harrison

Chief Commercial Officer – ProForecast

26/09/2019

Cash Flow Forecasting – Don’t take your hands off the wheel

I must admit, personally, the thought of autonomous cars driving themselves while we read books, watch Netfix or climb into the back seat to do what should be done at home or in a secluded place at night, fills me with horror. It might be because I’m not from Generation X who blindly believe in technology, but here’s why.

Evidentially, I’ve seen enough software hang up or misbehave over the years that I just couldn’t sit in a car with no one at the wheel and let some software package take my life and that of my fellow road users into its dispassionate hands and still sleep at night or more to the point in the car.

The trend to automation continues with Cash Flow forecasting. ProForecast, of course, has a cash flow forecasting function and will show you what your predicted sales volumes and margins do to your cashflow, this is essential for strategic planning.

There are so many variables in the real world of cash flow that its impossible to predict accurately in the real world for any meaningful length of time.

If you have a cash rich business, then you probably aren’t that worried about cash flow in the short term. If you are a small business with cash flow challenges, you should be managing this on a daily basis, there isn’t a piece of software anywhere that can help you here.

When cash is tight you have daily decisions to make based on when you get paid, who you pay and when. You might have an essential supplier that you just have to pay on time come what may or you will lose credit terms or priority on inventory. Who to pay and who not to pay is something you have to decide based on the size of your bank balance every single day.

If cash is an issue, you may defer rent payments or even VAT or PAYE as although HMRC and your landlord have the biggest sticks they are actually the easiest to deal with when you have a short-term cash flow issue. If you communicate with them, they will be helpful.

You really need to be on top of this minute by minute watching for cash coming in and then making a decision as where it goes out to based on who is most important. First should always be payroll but after that it’s a judgement call on your part. There is no software in the world that can replace a human and their ability to deal with creditors to help you through a tough period. Buyer beware if you have invested in one of the current crop of cash flow forecasting software that you plug into Xero and ride the sofa to continued solvency with automated alarms when an issue could potentially raise its head, prompting you to some pre-defined action. When it does so it’s almost certainly too late.

Forecasting is a strategic planning tool, that should be used to show how various scenarios will affect your business going forward. If you are planning on introducing a new product, raising debt, acquiring another company or need a valuation for a trade sale, if you want to manage your investors or produced informed board reports, forecasting is essential. Will forecasting ever be able to advise you on the gut feel of what and who to pay when, when things are tight, never.

Don’t drive your business into the back of a truck because you left the management of an essential function to a piece of off the shelf software. If you want to use forecasting as a powerful tool in your strategic planning cycle then talk to us at www.proforecast.com.

Mark Harrison

Chief Commercial Officer – ProForecast

24/09/2019

Welcome to the New ProForecast

In the state-of-the-art Sunderland Software Centre, you will find ProForecast. Led by Steven Katirai, the ideas behind the application, ProForecast have developed the most powerful Financial Forecasting and Business Strategy application on the market.

“We wanted to differentiate ourselves from the rest of the market” begins Katirai, “there are a lot of cash flow forecasting tools in the market targeted as small businesses who use Xero or Quickbooks and there are couple of players who have tried to religiously reproduce Sage WinForecast, a desktop application that hadn’t seen any new development for 22 years and has been off support for 5 years.

I felt that it was time that there was a forecasting and strategic planning tool that went beyond the capabilities of WinForecast and was targeted at the businesses that need such tools, Mid-Market and Enterprises. The result was ProForecast”

ProForecast as the name suggests is a professional cloud-based forecasting tool designed for mid-market companies and enterprises who have complex needs.

It includes well developed and comprehensive business templates that eliminate the need for formula building but gives users, the ability to account for unusual accounting scenarios, such as deferred revenues, R&D tax credits, foreign currency loans, mezzanine finance, multiple bank accounts, and many more options. These are coupled to a wide range of prebuilt revenue models, with specific functions for manufacturing, retail, wholesale, distribution, capacity constrained businesses, care homes, recruitment, licences, franchises, agency-based businesses, events and box office sales, the entertainment industry, and hospitality industry.

The unique inbuilt global and micro “What if” capabilities enables users to build forecasts and budgets that can be extensively stress tested and plans are automatically benchmarked against a database of 2.5m UK companies spread over 750 business categories.

This is all married to an impressive BI engine which provides users with the ability to dig deep into the data, to extract hidden insights and so make more informed business decisions.

Users can also build their own dashboards and reports in addition to the over 200 beautiful prebuilt graphs and reports.

The system features drill down capabilities to the underling data, multiple users can work on building budgets, forecasts and data can be imported from all accounting programmes, payroll packages and from internal excel models.

ProForecast is constantly adding new features to the package, many of which are driven by the users.

This is all packaged in an easy to use interface, extensive help facilities and an inexpensive monthly subscription.

If you’d like to learn about or try ProForecast go to our website, www.proforecast.com and book a demo with one of our support team and sign up for a 30 day free trial.