MGT314.8

DEMAND FORECASTING, PRODUCTION OPTIMIZATION AND CAPACITY MANAGEMENT

FOR

PRAN FOOD PRODUCTS BANGLADESH LIMITED

Prepared By:
Abdullah Al Rafi 111 0129 530
SM Nabil Afroj 113 0818 030

Faculty: Dr. Kais Zaman

North South University

Table of Contents
Objectives 3

Brief Company Profile 4

Methodologies 5

Need for the forecasting 5

Forecasting Methods 8

Qualitative Analysis 10

Linear Programming 13

Conclusion 17

Objectives
The primary objective is to find the demand and supply management techniques and the tools that the company uses to predict the demand for their products. The project will also determine the appropriate changes the company makes in their production process and their capacity management with regard to their forecasted demands.

Many companies were and are still established to derive financial profit. In this regard the main aim of PRAN RFL Group is to maximize (optimize) profit. This report is on using Linear programming technique along with forecasting methods to derive the maximum profit from production of soft drink for PRAN RFL, Bangladesh Ltd. Linear Programming of the operations of the company was formulated and optimum results derived using Microsoft Excel. The result shows that two particular items should be produced even when the company should satisfy demands of the other - not - so profitable items in the surrounding of the plants.

Brief Company Profile
PRAN GROUP was born in 1980. PRAN stands for Programme for Rural Advancement Nationally. Keeping in view the corporate mission of the group they have over the years diversified their activities. Today PRAN is the largest processors of fruits & vegetables in Bangladesh. They encourage contract farmers and help them grow