Merchandise planning System based on historical analysis