English Activity No. 1 - FORECASTING

English Activity No. 1

Forecasting

1.      Elabore una simulación pronostica de la demanda del producto o servicio según su proyecto de formación. Tenga en cuenta los siguientes elementos:

Name of the company	SIMRELBTV S.A.S.
Main business area	Marketing, Distribution and installation of satellite television and internet of DIRECTV area of Uraba
forecasting system
Uses	sales realized per month or Installation realized per month
Items	Sales of subscription of satellite television
Time horizons	medium-range forecast
Model	Regression lineal
Data gathering	Historical data, projection of sales.
Making	Corrections
Validation and implementation	Forecasts will be revise weekly to make correction, this correction will be utility to  know if is necessary to hire more technical

2.      Grafique el pronóstico y escriba las tendencias que tendrá su producto o servicio a corto, mediano y largo plazo.

Month	Code	Total sales
January	1	510
February	2	490
March	3	586
April	4	602
May	5	596
June	6	583
July	7	631
August	8	650
September	9	648
October	10	662
November	11	683
December	12	702

In short-range the sales are going to decrease in the month of February with relation of January but in March and it going to increase and in April increase a little.

In medium-range the sales are going to decrease some point in May and June but in the next month increase constantly.

In long-range the sales are going to increase after the 8th month keeping increase in the next months