Print Page E-mail Page Link

0 Customer Ratings
e2b Sales Forecasting & Master Production Scheduling (MPS)
Certified Solution
Click to view the help.

Prepare super-accurate product plans with Sales Forecasting and MPS

Compatible With: Sage 500 ERP [MAS 500], Versions 6.3 , 7.0 , 7.05 , 7.2 , 7.3 , 7.4
Created by:

Varies by User Contact E2B

DetailsProduct SpecificationReviewsAdditional Documents

Accurate sales forecasts are fundamental for wholesale distributors, discrete manufacturers and other companies who stock and sell products from inventory.


Forecasting helps companies predict what they plan to sell and when they plan to sell it. As such, an accurate sales forecast helps companies maintain adequate stock levels to avoid stock-outs, improve customer service, and to determine what raw materials and components are needed to meet current and future demand. Further, accurate forecasts help companies manage extended supply chains.


Forecasts can be maintained within the Sales Forecasting module or imported from built-in Microsoft Excel templates. Forecasting is organized by a forecast group which may contain any number of inventory items independent of purchase product line or buyer.



Forecasts are maintained in daily, weekly, quarterly, or yearly time periods for single inventory items or groups of items. When forecasting quantities for multiple products, utilities are provided to allocate a percentage of the forecast to each product. For example, companies may forecast sales of 100 units for their shovel product line and allocate 50% to spade shovels, 30% to snow shovels, and 20% to their specialty shovels. According to APICS, forecasting quantities for groups of products is more accurate than forecasting sales for unique items.


Discrete manufacturers can optionally utilize the Master Production Schedule module to push Sales Forecasts into the Sage MAS 500 IR/MRP module for material planning.



Key Features:


Single Item or Forecast Group

Forecast to individual items or allocate forecasted quantities to groups of products based on a percentage.


Forecast Criteria

Create multiple forecasts by item, forecast product group, salesperson, customer or any combination of these data elements. In most businesses, the Pareto principle suggests that 80% of revenue is generated by 20% of a company’s customers. As such, companies can use Sales Forecasting to maintain detailed forecasts for the top 20% of their customers but use a general forecast for the lower 80%.


What-If Analysis

Virtually unlimited forecasts are supported providing optimal flexibility to create master and alternative forecasts for “what-if” analysis. For example, a company may want to see what effect a promotion could have on product unit forecasts (and subsequent resources) for a given period.


Microsoft Excel Integration

Use built-in Microsoft Excel templates to input forecast data off-line. Forecasts created or edited in Excel can be imported into Sales Forecasting for manipulation.


Import From CRM/EDI

Import forecasts from Excel or ASCII delimited files from CRM systems or Electronic Data Interchange (EDI) applications.



Forecasts can be maintained by warehouse location per item, forecast product group, salesperson, or customer providing flexible and specific forecasts. Further, forecast versions allow for specific forecast periods for each physical location.


MRP Calculations

MAS 500 MRP can optionally use either historical demand from Inventory Replenishment or forecasted demand from MPS during material .Sales forecasts can be modified and maintained in the MPS module to drive demand for MAS 500 MRP calculations.


Time Periods

Items and forecast product groups may be forecasted daily, weekly, monthly, quarterly, yearly, or a combination of any of these time periods.


Demand Smoothing

Forecast quantities can be smoothed into differing demand periods. For example, the quantity forecast can be smoothed into yearly, quarterly, monthly, weekly, or daily periods. This is helpful since many companies may create annual forecasts by item or product group but they want to smooth the yearly forecast into quarterly or monthly periods for planning. In addition, forecast smoothing can be weighted on different periods. For example, a yearly item forecast for 450 units smoothed to quarters would be distributed at 112 units per period with 2 units remaining (112 x 4 = 448 + 2 remaining units = 450). The remaining two units would then be allocated to quarters based on the following smoothing methods.


Audit Trail

Original forecasts are saved automatically. In addition, a copy utility is provided to create new forecast revisions each time a major modification to the forecast is made.


Historical References

Actual sales history from Sage MAS 500 and previous forecasts are displayed on the forecast maintenance screen as a reference to assist planners when preparing new sales forecasts.


Product ID: SFCMPS

Industries: Apparel, Soft Goods, & Textiles, Furniture, Home Furnishings, & Decor Service, Home Goods & Services, Toys, Hobbies, & Leisure, Food & Beverage, Appliances & Electrical Equipment, Electronics & Computers, Scientific & Research Equipment, Chemicals, Industrial Equipment, Supply, &, Service, Rubber & Plastic Products, Wood Products & Components, Commercial Establishment Supply & Service, Equipment & Supply Rental, Non-Industry Specific

Business Needs: Forecasting, Replenishment/MRP/DRP