DESIGN AND IMPLEMENTATION OF A COMPUTERIZED
SALES FORECASTING SYSTEM. (CASE OF STUDY OF NBL 9TH MILE CORNER ENUGU)

ABSTRACT

Sale manager have some specially develops managerial tools with they should be familiar within order to comprehend completely the managerial environment which goven selling activities. Sales forecasting is one and very essential of management in any business.

Forecasting is an integral part of planning and good planning require management to explicitly consider the company’s future, it is goals, environment competition and strategy. It can serve as a vehicle for management to express what the company is going to make happen out of market opportunities available to it.

The major purpose of this paper is to provide the sales person or student some insight in to the managerial framework, rather sale management environment, understanding its problem the designing a computerized sales forecasting system.

 

 

 

 

TABLE OF CONTENTS

Cover page

Title page

Certification

Dedication

Acknowledgement

Abstracts

Table of contents

CHAPTER ONE

• Introduction

1.1     Background of the study

• Arm and objectives of study

1.2.1  Purpose of study

• Justification
• Scope
• Modern
• Project diagram
• Project organization

CHAPTER TWO

• Literature review

CHAPTER THREE

• Overview of the existing system

3.1     Description and analysis of the existing system

• Method of data collection

3.2.1  Interview method

3.2.2  Reference to written text

• Process analysis
• Input analysis
• Output analysis
• Problem of existing system
• Justification for the new system

CHAPTER FOUR

• Design of the new system

4.1     Output specification and design

• Input specification and design
• File design
• Procedure chart
• System flow chart
• System requirements

CHAPTER FIVE

• Implementation

5.1     Program Design

• Program flowchart
• Pseudocodes
• Source listing
• Test run

CHAPTER SIX

• Documentation

CHAPTER SEVEN

• Recommendation and conclusion

 

 

CHAPTER ONE

• INTRODUCTION

A sales forecast is a prediction of a firm’s sales (dollas or units) during a given period of time in the future. The forecast considers the expected impact of uncontrollable environmental factors and conditions within the firm. If management is displaced with the forecasted the sales volume for the forth-coming year, certain actions may be taken which will call for a readjustment of the forecast. This, forecasting compels – management to think carefully and systematically about future periods, especially about the present actions designed to have a favorable impact upon future results.

The sales forecast is a tools that assists planning in all functional areas of the firm. The firm uses the forecast to plan us production schedule and inventory levels. To accurate forecast will lessen the problems of both stockouts and excessive inventories. Pessimistic forecasts may result in stockouts and in turn may result in both the temporary loss of sales and the permanent loss of customer. Also, in some companies, sales members are continuously distributed by the companies, inability to deliver orders placed by customers. On the other hand, when forecast are too obsolescence, carrying show moving inventory, orunde utilized resources.

The sales forecast affects the accounting and financial area of the firm in terms of anticipating rates of revenues, expenses, and cash flows. If the firm engages heavily in leasing or installment sales, the forecast is an important instrument in determing accounts receivable levels, credit and collection needs and required periodic borrowings.

Forecast and the personnel managers is planning for the hiring, training, supervision and termination of workers. They are important in planning purchases, transportation and warehousing system, advertising and other promotional efforts, preparative of the annual report and other activities by to management.

Is a sale forecasting usually the direct responsibility of the general sales manager rather than this field sales managers? The answer is a vague “sometimes” or partially” or “It depends on the size type, needs or responsibility for sales forecasting is assigned to the sales planning and analysis manager who reports to the chief marketing executive through the marketing research manager.

These short – run fluction such as increased stocking prior to a price increase affect (sales stability and possibly long run trends.

Some variable such as selling efforts and advertising have a significant effect yet is very difficult to measure. This leads to quantifying subjectivity and often-spurious accuracy. New products are always likely to be a special case.

 

1.1     BACKGROUND OF THE STUDY

The Nigerian Berrwell limited is a pioneer soft drink company in Nigeria. The company has it headquarters in Apapa, Lagos state. In the word of the plant personnel manage of Enugu branch.

“The company is the largest soft drink producer ion West Africa”. The company was incorporated on the 22^nd of November 1953 and currently operating up to nineteen soft drinks throughout Nigeria.

The company is facing an uphill task in the determination of sales forecasting of its production and dates. Some of the raw materials that are needed for smooth production processes like sugar and concentrate are gotten from abroad. This is effect has come untold consequences of not given adequate attention.

It was against this background that this project topic was chosen.

 

• AIMS AND OBJECTIVES

The expectation of the improved sales forecasting system are enumerated below:

To minimize short-run fluctuations in