DESIGN AND IMPLEMENTATION OF A SALES FORECASTING SYSTEM

ABSTRACT

Sales forecasting is a common activity in most companies affecting operations, marketing and planning. Little is known about its practice. Mentzer and his colleagues have developed a research programme over twenty years aimed at rectifying the gap in knowledge most recently, in the mentzer et al (2002) paper they have demonstrated with supporting evidence the use of a sales forecasting audio to establish the dimensions of best practice. In this commentary on the paper, the methodology underlying their approach is examined from a number of different perspectives. The commentaries examine how convincing and complete has been the choice of audit dimensions as well as how this new research fits with evidence from other sources both commentators and respondents agree that the topic is important to organizational practice and more research is needed to gain a complete picture of the sales forecasting function and the systems that support it. Clarifying the audit function is particularly important since sales forecasting often has a low organizational profile until events turn sour with damaging consequences to organizational viability.
TABLE OF CONTENT

CHAPTER ONE
1.0 INTRODUCTION
1.1 STATEMENT OF THE PROBLEM
1.2 PURPOSE OF THE STUDY
1.3 AIMS AND OBJECTIVES
1.4 SCOPE OF THE STUDY
1.5 LIMITATION OF THE STUDY
1.6 ASSUMPTIONS
1.7 DEFINITION OF TERMS

CHAPTER TWO
2.0 LITERATURE REVIEW

CHAPTER THREE
3.0 DETAILED STUDY AND ANALYSIS OF OLD SYSTEM
3.1 FACT FINDING METHOD USED
3.2 ORGANISATION STRUCTURE
3.3 OBJECTIVE OF THE EXISTING SYSTEM
3.4 INPUT, PROCESS AND OUTPUT ANALYSIS
3.5 PROBLEM OF EXISTING SYSTEM
3.6 JUSTIFICATION OF THE NEW SYSTEM
3.7 INFORMATION FLOW DIAGRAM

CHAPTER FOUR
4.0 DESIGN OF THE NEW SYSTEM
4.1 OUTPUT DESIGN AND SPECIFICATION
4.2 INPUT DESIGN AND SPECIFICATION
4.3 FILE DESIGN
4.4 PROCEDURE CHART
4.5 SYSTEM FLOW CHART

CHAPTER FIVE
5.0 IMPLEMENTATION
5.2 PROGRAM FLOW CHART
5.3 PSEUDO CODE
5.4 SOURCE PROGRAM
5.5 TEST – RUN

CHAPTER SIX
6.0 DOCUMENTATION
6.1 SYSTEM DOCUMENTATION
6.2 PROGRAM DOCUMENTATION
6.3 PROGRAM DOCUMENTATION

CHAPTER SEVEN
7.0 CONCLUSION AND RECOMMENDATION
7.1 CONCLUSION
7.2 RECOMMENDATION
CHAPTER ONE
INTRODUCTION
Any visit to a company that relies on sales forecasting in its operations or marketing confirms that the most important aspect of forecasting for those with organizational forecasting responsibilities is not simply the choice of approach but something much more fundamental how the forecasting activities, the information system and the people who produce and use forecasts inter-relate. Increasingly I and other researchers have seen the gap between theory and practice in forecasting as an outcome primarily of organizational complexities and priorities (Mahmoud et al 1992) rather than a stubborn refused of practioners to recognize the superiority of the latest methods found in the forecasting literature the article submitted by mark moon, Tom Mentzer, and Carlo Smith on “Conducting a Sales Forecasting Audit”. It was rare contribution towards understanding just what goes right and wrong in the sales forecasting. Because it explored new ground in forecasting research (although others had visited particular questions earlier) I thought its influence on both forecasting practice and forecasting researchers would be more substantial if some key aspects of the arguments were held up to the light and picked apart. I therefore asked the referees of the article and other researchers who have argued for the importance of behavioural research in forecasting to comment on the assumptions and methods used by Moon, Mentzer and Smith, in particular highlighting areas where future research should prove most productive. What follows are comments by Stuart Bretschneider, Fred Collopy, Micheal Lawrence, Doug Steward and Heidi Wink – Ihofer together with a response from the authors themselves. I and the editors of the journal would welcome further research contributions that examine how organizations go about the task of improving the forecasting function.

1.1 STATEMENT OF PROBLEM
By studying the particulars of four NFP firms whose website implementations demonstrated a marketing orientation, it was believed that we could develop