Forecasting the daily sales of perishable food to reduce spoilage in hypermarket

A phenomenon that is very common in supermarkets bulk orders of food materials are given which results in extra stocks of food materials than which is needed and finally leads to wastage. Many still make a profit from selling a few items of the product and throwing the left out . The belief is that, not caring about the customer feeling that their supermarket has an endless supply of goods is more valuable than predicting the order in advance, and possibly getting it wrong. Representing the hypermarket, the objective of our forecasting is to reduce the spoilage of perishable foods in the hypermarket by accurately forecasting sales on a daily basis by using historical data and Holt -Winter model, we have plan to forecast daily demand for 30 days for 'Vegetables' , 'Meat' , 'Fruits' and 'Milk Products' .This model includes two methods – additive method for finding seasonal variation and multiplicative method for proportional variation. The FEFO(First Expired First Out) principle including the calculation of shelf life is used to get the product consumed by the customer before the expiry date.The major benefit is that it gives consumers the chance to enjoy fresh products and reduce the reatailing cost. It highly focusses on hygiene of customers as well as it gives increased customer satisfaction.