A STUDY OF USING SPREADSHEET MODELLING AS IDEAL TOOL FOR SYNERGIES MANAGERIAL KNOWLEDGE WITH UNCERTAIN MARKETING INFORMATION TO SUPPORT PRODUCTION MANAGEMENT CASE STUDY IN AL- AMEEN FOR TRADE IN FOOD COMPANY- BASRAH

Abstract

Spreadsheet modelling is an tool for synergies managerial knowledge with uncertain marketing information to support,to support the activity of the production department responsible for implementing the production program according to what is determined by the marketing research and Managerial knowledge possessed by the higher management that makes the decision.It is particular spreadsheet models as in the form of tables by using a set of quantitative methods and the aim of this models is to learn how to develop quantitative data and spreadsheet models and use to support analysis and decision making for business problems .In the light of that research aims to explain the role of spreadsheet in analysis and decision making in marketing function to forecast the expected sales volume in the business environment and outline the steps necessary to ensure professional and spreadsheet models that used to prepare the forecast seals volume in Excel system and that the best practise the managers as decision support systems and or management systems.

In light of the results of the research, recommendations can be made, which are solutions and proposals for the research problem:

1. Using statistical methods in the actual sales spreadsheets to conduct the forecasting process, which is the basic tool for work and learning on how to use these applications and move away from random estimates and work on developing those models and using them appropriately to support the analysis and appropriate decision-making to solve business problems. Among these methods are the following Mentioned in this paper.
2. Choose an efficient employee with educational attainment in order to prepare studies on the volume of sales in the target markets and to identify the volume of competition and competitors' activity in the field of using various promotional means.
3. Adopting strategies to deal with economic market variables and paying attention to activating the role of marketing activity in the serious contribution by preparing the necessary studies to reach an accurate forecast of the expected sales volume that avoids the company’s random purchases.