Revenue forecasting is about estimating future sales by analysing past data, market trends, and customer behaviour. For Malaysian F&B businesses, this is vital to stay ahead in a growing and competitive market.
Here’s why it matters and how you can do it effectively:
- Why It’s Important: Helps plan inventory, staffing, and finances. For example, during festive periods like Hari Raya or Chinese New Year, sales often spike, and accurate forecasts can reduce waste and optimise staffing.
- Malaysian F&B Trends: The industry is growing rapidly, with revenue expected to reach RM288 billion by 2032. Key regions like Selangor, KL, and Penang dominate the market, while food delivery and cloud kitchens are on the rise.
- Key Metrics to Track: Gross revenue, profit margins, and COGS (Cost of Goods Sold) are essential for understanding financial health and predicting future performance.
- Steps for Accurate Forecasting:
- Analyse past sales data for patterns.
- Account for seasonal trends like tourism peaks or monsoon impacts.
- Use formulas like Revenue = Estimated Income – Expenses.
- Regularly refine forecasts based on updated data.
- Digital Tools: Platforms like Maynuu provide real-time data and dashboards, making forecasting faster and more precise.
With the Malaysian F&B market projected to grow at 13.66% CAGR, businesses that use data-driven forecasting can better manage costs, improve profitability, and stay competitive.
Key Metrics and Concepts in Revenue Forecasting
When it comes to forecasting revenue, understanding key financial metrics is crucial. These numbers offer a clear picture of your restaurant's financial health and serve as the backbone for predicting future performance.
"Restaurant metrics help restaurant operators gauge the health of their organization relative to financial, operational, performance and customer experience objectives." – Rebecca Bichachi
By mastering these metrics, you can make smarter decisions about staffing, inventory, pricing, and planning for growth. Here’s a breakdown of the essential metrics for Malaysian restaurants.
Gross Revenue, Net Income, and Profit Margins
Gross revenue represents the total income from all sales before any deductions. This includes earnings from food, drinks, and additional services. On the other hand, net income is what’s left after deducting all expenses, returns, allowances, and discounts from gross revenue.
"Gross revenue shows your business's income potential, while Net Revenue reveals your real profitability after expenses. Together, they provide a holistic view of your financial situation."
Gross revenue reflects your sales performance and market demand, while net income reveals your actual earnings and is key for forecasting.
Profit margins measure how efficiently your restaurant operates. The gross profit margin focuses on profitability before operating expenses. For example, if a fine-dining restaurant earns RM600,000 in net sales and spends RM400,000 on the cost of goods sold (COGS), it has a gross profit of RM200,000, resulting in a gross profit margin of 33%.
Meanwhile, the net profit margin highlights your overall profitability after covering all expenses. For instance, if a restaurant generates RM50,000 in revenue but spends RM38,000 on expenses, its net profit margin stands at 24%. This metric is especially useful for estimating profits from future sales. With reports like KPMG's showing that 41% of consumers plan to cut back on dining out in 2024, keeping a close eye on these numbers is vital for adjusting forecasts effectively.
Understanding your cost structure - fixed versus variable costs - is equally important for accurate predictions.
Fixed Costs vs Variable Costs
Breaking down your expenses into fixed costs and variable costs is a fundamental step in revenue forecasting. Fixed costs remain the same regardless of sales, while variable costs fluctuate with your business activity.
Fixed costs include rent, insurance, base salaries, equipment leases, and loan repayments. These expenses provide stability for your forecasting models but can be tough to adjust when business conditions shift.
"Rent is often the largest fixed cost for restaurants, accounting for about 6-10% of total revenue." - Hudson Riehle, Senior Vice President of Research at the National Restaurant Association
Variable costs, on the other hand, cover items like ingredients, hourly wages, utilities, delivery fees, and credit card processing charges. Industry data indicates that food and labour together make up about 66% of every sales ringgit, while fixed costs account for roughly 29%. Fixed costs set a baseline for expenses, while variable costs help calculate incremental profit. For example, if variable costs account for 60% of revenue, each additional ringgit in sales contributes about 40 sen toward fixed costs and profit.
Leveraging technology to monitor these costs in real-time can significantly improve forecasting accuracy. As Stephen Burns, Group Operations Manager at Rocksalt, notes: "Because all the ordering and invoices are updated daily, we can catch a price increase from a supplier pretty much instantly. As soon as we spot it, we can react to it immediately."
Cost of Goods Sold (COGS)
Another essential metric is Cost of Goods Sold (COGS), which represents the direct costs of producing the food and drinks you sell. This includes ingredients, packaging, and direct labour costs. Since COGS directly impacts your gross profit margin, tracking it is critical for accurate forecasting.
In well-run restaurants, COGS typically accounts for 30-35% of revenue, with prime costs (labour and food combined) hovering around 60%. To calculate COGS, use this formula: Beginning Inventory + Purchases - Ending Inventory = COGS.
COGS is particularly useful for understanding how menu changes affect profitability. Using inventory management methods like First-In, First-Out (FIFO) can help reduce spoilage and improve accuracy in COGS calculations. This is especially important in Malaysia’s tropical climate, where fresh ingredients can spoil quickly.
Seasonal price fluctuations also play a role in COGS. Local produce costs can vary due to weather, festive seasons, or supply chain issues. Staying on top of these trends allows you to adjust menu prices or promotions accordingly. With 85% of restaurants reporting lower profitability compared to pre-pandemic levels, keeping COGS under control is more important than ever for maintaining both accurate forecasts and sustainable operations.
Step-by-Step Process for Revenue Forecasting
Building accurate revenue forecasts requires a structured approach that considers your restaurant's specific circumstances and Malaysia's dynamic F&B environment. By focusing on key metrics like gross revenue and COGS, you can turn raw data into actionable insights. Here's how to create reliable forecasts that guide smarter decisions and improve profitability.
Gathering and Analysing Historical Sales Data
The starting point for any forecast is understanding your past sales performance. Historical data can reveal patterns that help predict future trends and identify areas for growth. Collect at least 12 months' worth of sales records, including daily, weekly, and monthly figures, along with transaction counts and average order values. This ensures you account for seasonal fluctuations and recurring trends.
Once you’ve gathered the data, calculate your daily, weekly, and monthly averages to establish a baseline. Look for patterns like weekend spikes, lunch rushes, or specific days with higher sales. For example, The Daily Grind Cafe analysed their sales data and found weekday breakfast and lunch hours were their busiest, with additional boosts during school holidays and summer months when outdoor seating became popular. Beyond these patterns, factor in other influences like promotions, weather, or local events that may have impacted performance. Incorporate these insights to refine your forecasts.
Considering Seasonal Trends and Local Influences
Malaysia’s cultural calendar and climate significantly shape dining habits throughout the year. By accounting for these factors in your forecasts, you can prepare for busy periods and adapt to slower seasons. For instance, Malaysia typically sees peak tourist seasons from December to February and June to August, while quieter months fall between March to May and September to November. In 2024, Malaysia welcomed 25.02 million international tourists during peak months, contributing over RM106.8 billion in spending.
The monsoon seasons also play a role. The Northeast Monsoon (November to March) aligns with major holidays like Christmas and Chinese New Year, while the Southwest Monsoon (May to September) coincides with mid-year breaks and celebrations like Hari Raya Puasa. Major festivals such as Eid often bring increased foot traffic to cities like Kuala Lumpur and Penang, as well as popular destinations like Genting Highlands and Langkawi, where visitors enjoy local events, shopping, and cuisine.
During peak periods, you might consider strategies like adjusting menu prices, highlighting higher-margin items, or offering special packages to maximise revenue. In slower months, focus on attracting local diners with tailored promotions or community events. Aligning your staffing and inventory with these cycles can also help optimise operations.
Using Basic Forecasting Formulas
Once you’ve analysed your historical data and seasonal trends, you can apply basic formulas to forecast revenue. A simple starting point is:
Revenue Forecast = Estimated Income – Estimated Expenses.
To use this formula, estimate the number of customers you expect to serve and determine your average transaction value for the forecast period. Multiply these figures to calculate projected income, then subtract estimated expenses - including COGS, labour, and overhead - to determine your net revenue. For example, you can calculate daily income by multiplying expected covers by average spend and then subtracting expenses.
Break-even analysis is another useful tool to identify when your sales will cover all operating costs. Calculate your fixed costs (like rent and salaries) and variable costs per transaction to determine the sales volume needed to break even. Keep in mind that the average restaurant profit margin in Malaysia ranges from 5% to 8%, while retail and hospitality sectors typically see net margins of just 2%–3%. These benchmarks can help validate your projections.
Organising your forecasts in spreadsheets can make the process more manageable. Create optimistic, realistic, and conservative scenarios to prepare for uncertainties. Remember, forecasting is not static - regularly compare actual performance to your projections and adjust based on new data or changes in economic, seasonal, or local conditions.
Using Digital Tools for Accurate Forecasting
Digital tools have revolutionised how Malaysian restaurants handle revenue forecasting, moving away from traditional spreadsheets to advanced platforms that provide real-time insights. These tools integrate effortlessly into daily operations, automating data collection and analysis. This not only saves time but also makes forecasts more precise. Platforms like Maynuu are at the forefront, simplifying and improving forecasting processes for the F&B industry.
How Maynuu Supports Revenue Forecasting
Maynuu's ecommerce platform equips Malaysian F&B businesses with a suite of tools designed for accurate revenue forecasting. Its integrated sales analytics and operational dashboard automatically track orders across various channels, providing a unified view of performance.
For instance, the platform captures critical transaction data - such as order values, customer frequency, and peak ordering times. This data feeds directly into forecasting models, eliminating manual entry and reducing errors. With these insights, you can easily pinpoint which menu items yield the highest margins and incorporate that information into revenue projections.
For restaurant chains, Maynuu's multi-outlet support is a game-changer. It consolidates data from multiple locations, enabling comparisons and trend analysis across outlets. This helps identify patterns that may influence future revenue. Additionally, live order tracking offers real-time visibility into daily sales, allowing businesses to adjust forecasts on the fly.
Another helpful feature is its automated receipt and invoice generation, which creates a reliable record of transactions. This ensures your historical data remains complete and accurate, forming a solid foundation for analysis.
Benefits of Real-Time Data Integration
Real-time data integration has greatly improved forecasting accuracy. AI-powered tools, for example, can boost prediction accuracy to 63%, compared to 39% for traditional methods. This is because they process up-to-date information rather than relying on outdated data. By connecting directly with CRM systems, billing platforms, and other data sources, these tools eliminate manual delays and errors, ensuring forecasts reflect the current state of your business.
Unified system integration also streamlines communication and data sharing. Restaurants using AI or machine learning tools report spending 16% more time on high-value tasks, such as strategic planning, rather than being bogged down by manual data compilation - a crucial advantage, especially during peak periods.
| Feature | Impact | Result |
|---|---|---|
| Real-time data | Removes manual updates | More accurate, up-to-date forecasts |
| Collaboration tools | Gathers input from all departments | Aligns team expectations |
| Scenario modelling | Simulates business conditions | Prepares for potential changes |
| System integration | Links existing tools seamlessly | Ensures consistent data |
Using Dashboards to Monitor and Refine Forecasts
Dashboards take real-time data one step further by visually presenting key metrics in a way that's easy to understand and act upon. These tools transform raw data into actionable visuals, making it easier to spot trends, risks, and opportunities. For example, dashboards can help restaurants model different scenarios to prepare for seasonal changes or shifts in customer preferences.
A well-designed dashboard might display metrics like daily sales trends, average transaction values, and customer counts in a format that's easy to interpret. This visual clarity can reveal patterns that spreadsheets might obscure, such as gradual changes in customer preferences or emerging trends in popular menu items.
Collaborative planning is another benefit of digital dashboards. By encouraging input from various departments, these tools help break down silos and create more accurate forecasts. When choosing a digital tool for your restaurant, prioritise those that integrate smoothly with your existing systems, have transparent pricing, and offer training resources to simplify implementation.
It's also crucial to prioritise data security when adopting digital forecasting tools. Ensure compliance with Malaysia's Personal Data Protection Act, particularly if your business handles sensitive customer information.
Finally, refine your dashboard regularly by comparing forecasted outcomes with actual sales data. This will help identify the key factors influencing your revenue, allowing you to fine-tune your forecasting models for even better accuracy.
Simplify Your F&B Business Operations
Create your own online ordering platform with Maynuu. Manage menus, orders, payments, and deliveries seamlessly while keeping your profit margins.
Best Practices for Improving Forecast Accuracy
Getting revenue forecasts right isn’t a one-and-done task - it’s an ongoing process of refinement and updates. For many Malaysian restaurants, this means staying on top of their data and adapting their forecasting models to match changing market dynamics and customer preferences. By combining the right practices with the tools we’ve already discussed, restaurants can turn forecasting into a reliable decision-making tool.
Regular Data Reviews and Scenario Planning
Successful restaurants don’t rely on outdated assumptions. They revisit and update their forecasts regularly, often monthly or quarterly. This ensures that decisions are based on the latest data, making it easier to identify trends and adjust models when needed.
A popular approach is using rolling forecasts, which continuously update to reflect real-time conditions. Melissa Howatson, CFO, highlights the importance of this method:
"The current environment gives a little less time to sit and reflect. [You] need to be constantly leveraging that agile rolling forecasting and planning. You're also starting to focus on some shorter time horizons and needing to pivot accordingly more rapidly." – Jonathan Paul
Scenario planning is another crucial practice. It helps restaurants prepare for unexpected events like ingredient price hikes, supply chain issues, or shifts in customer preferences. For example, you might create action plans for reduced foot traffic during monsoon season or a surge in delivery orders over festive holidays. These scenarios should be updated at least once a year or after major market shifts.
Regularly comparing your actual sales to your forecast estimates is also key. If you notice recurring discrepancies, dig deeper - are you underestimating demand or overestimating your capacity? This kind of analysis helps you identify the factors that have the biggest impact on your revenue.
To make these reviews even more effective, integrate data from systems like POS, inventory management, and CRM tools. Automating this integration ensures your forecasts stay fresh and accurate.
Including Marketing Data and Customer Feedback
Marketing efforts and customer feedback are treasure troves of information for refining forecasts. In Malaysia, where 84.2% of people have internet access and 78.5% are active on social media, these insights can be a game-changer.
Track how your marketing campaigns affect sales. For instance, note the impact of food delivery app promotions, social media contests, or loyalty programme launches. This helps you anticipate revenue spikes during future campaigns and plan accordingly. With 57% of Malaysia's urban population dining out regularly, monitoring these activities is essential.
Customer feedback is equally valuable. Complaints about slow service might flag potential revenue dips, while praise for new menu items could signal a sales boost. If social media posts are buzzing about your weekend brunch special, you might need to adjust staffing and ingredient orders for the following weekend.
Once you have this data, decide whether to stick with manual methods or invest in automation to refine your forecasting process.
Manual vs Automated Forecasting Methods
The choice between manual and automated forecasting often comes down to your restaurant’s size, budget, and accuracy needs. Each method has its pros and cons.
Manual forecasting involves using spreadsheets and analysing trends based on experience. While this works for smaller restaurants, it’s labour-intensive - managers typically spend around 4 hours a week on manual forecasting - and prone to errors. As your business grows, scaling up with manual methods becomes increasingly difficult.
Automated systems, on the other hand, integrate real-time data from POS, inventory, and other tools. These systems can reduce forecasting errors by 30–50% compared to manual methods. They also offer features like predictive ordering, demand forecasting, and automated alerts, freeing up your time to focus on strategic decisions rather than data entry.
| Feature | Manual Forecasting | Automated Forecasting |
|---|---|---|
| Accuracy | Lower, prone to human error | Higher with real-time data |
| Time Efficiency | Time-consuming (approx. 4 hours/week) | Saves time with automation |
| Initial Cost | Low (spreadsheets) | Higher (software and training) |
| Scalability | Limited to single locations | Scales easily across outlets |
| Analysis Type | Subjective, experience-based | Objective, data-driven |
| Ideal For | Small, single-location restaurants | Medium to large operations |
If you’re running a small restaurant with tight resources, starting with manual methods might make sense. But as your business grows, transitioning to automated systems will help you handle the added complexity more efficiently. Interestingly, despite the benefits of automation, 28% of business leaders still rely on tools like Excel for forecasting.
Conclusion: Sustaining Growth Through Data-Driven Forecasting
Malaysia's food and beverage (F&B) industry is on an upward trajectory, with the foodservice market projected to hit US$27.5 billion by 2030, growing at a compound annual growth rate (CAGR) of 13.26%. This growth presents exciting opportunities but also challenges for restaurant owners navigating an increasingly digital environment. To thrive, businesses need to embrace precise, data-driven forecasting.
By leveraging historical data, restaurants can move beyond basic predictions to achieve sustainable growth. Analysing past sales patterns allows operators to optimise staffing schedules, manage inventory effectively, and adjust menus to maximise revenue during peak periods. This proactive approach not only captures higher earnings during busy times but also helps cut costs during slower periods.
For instance, managing stock efficiently can significantly reduce food waste. Malaysian restaurants currently discard around 3,000 metric tonnes of food daily. Minimising such waste not only improves profit margins but also aligns with sustainability goals.
As Tan Sri Jamaludin Ibrahim aptly noted:
"It's obvious now that technology and data science have and will continue to change the way we run our business and the nature of it. Hence, the key to our future success is how much and how fast we embrace, adapt and integrate new technologies, including data analytics and artificial intelligence, into our business. That is the marching order for QSR Brands."
The results speak for themselves. QSR Brands has seen online sales for KFC and Pizza Hut soar, achieving double-digit growth in the first half of 2023. This demonstrates how digital transformation and data-driven strategies can translate into tangible business success.
Key Points to Consider
Starting with data-driven forecasting doesn't have to be overwhelming. Begin by gathering and analysing your historical sales data to identify trends and high-demand periods. Consider factors such as seasonality, local events, and tourist activities that influence sales and costs. Use these insights to align staffing and stock levels with projected demand.
The Malaysian food market's annual growth rate of 6.59% through 2030 signals abundant opportunities for restaurants ready to adapt to shifting consumer preferences. With 52% of operators citing high operating costs as a major challenge, accurate forecasting becomes essential for maintaining profitability.
Tools like Maynuu can simplify this process by integrating real-time data from online orders, payment systems, and delivery services. This unified view of operations enables more precise forecasting and better-informed decisions.
It's important to remember that forecasting is an ongoing process. Regularly reviewing and updating your predictions ensures they remain relevant as market conditions and customer behaviours evolve. With Malaysia's increasing internet and social media usage, consumer preferences are shifting faster than ever.
Success stories from the local market highlight the benefits of this approach. For example, a leading retail chain in Malaysia reduced stock wastage by 30% and improved sales forecasting accuracy using predictive analytics. Similarly, an SME in the F&B sector boosted ROI by 50% by leveraging social media analytics to track customer engagement and optimise ad spending.
The message is clear: embracing data-driven forecasting can help you make smarter decisions, streamline operations, improve customer satisfaction, and stay ahead of the competition. With the global F&B industry expected to reach US$8.9 trillion by 2026, now is the perfect time to invest in the tools and strategies that will secure your restaurant's future growth.
FAQs
How can restaurants in Malaysia adjust revenue forecasts for festive seasons like Hari Raya or Chinese New Year?
To fine-tune revenue forecasts for festive seasons like Hari Raya or Chinese New Year, Malaysian restaurants should start by diving into past sales data. This helps uncover trends such as spikes in spending, best-selling dishes, or the busiest dining hours during these celebrations.
It's also important to factor in cultural habits that influence dining patterns, like large family gatherings or the tradition of gifting. To stay ahead, consider rolling out seasonal promotions or creating special festive menus that resonate with these occasions.
Using these insights, restaurants can better plan their resources, ensure sufficient staffing, and fine-tune marketing strategies to maximise opportunities during these high-demand periods.
What are the benefits of using digital tools like Maynuu for revenue forecasting in Malaysia's F&B industry?
Digital tools such as Maynuu offer valuable support for revenue forecasting in Malaysia's F&B industry. By providing real-time tracking of sales and demand, these tools help businesses predict revenue with greater accuracy. This leads to improved inventory management, cutting down on wastage and keeping costs under control.
Maynuu also allows businesses to make data-driven decisions by analysing trends and customer behaviour. This means you can plan more precisely and adapt quickly to shifts in the market. In a fast-paced and competitive industry, tools like these can help maximise profits while keeping operations efficient and manageable.
How do fixed and variable costs affect restaurant revenue forecasting in Malaysia?
Fixed costs, such as rent and staff salaries, stay the same no matter how much you sell. While they provide stability, they can distort revenue projections during slower periods. On the flip side, variable costs - like ingredients and utilities - fluctuate with sales volume. This makes forecasts more flexible but also harder to pin down.
In Malaysia, getting revenue forecasts right means factoring in both fixed and variable costs. This approach gives a more accurate view of your restaurant's profitability and cash flow, especially when dealing with local challenges like changing ingredient prices or seasonal shifts in demand.
---
We use the term 'restaurant' throughout the article for consistency. However this guide can be generally applied to any type of food shop, including but not limited to: bakeries, bars, bistrots, boulangeries, butcheries, cafés, cantinas, caterers, coffeeshops, delis, diners, eateries, food trucks, grocers, patisseries, pubs, and more.
Maynuu
❇️ Enable online ordering for your restaurant today - it's FREE, no credit card required.
