lunes, 24 de agosto de 2015

English Activity No. 2 - INVENTORIES

ENGLISH ACTIVITY NO. 2

INVENTORIES

1.      Determine el tipo de inventario a implementar en su proyecto de formación.

The type of inventory implemented in the company is:
Inventory of goods in existence
This inventory consist in the necessary elements to realize the installation of service of satellite television or internet of Directv
It is conformed for parts or elements to assemble an antenna of satellite television, decoders with yours respectives cables of audio and video, coaxial cable, routers in the cases of the installations of internet.

The elements stored in the stock are:
ELEMENT
MODEL
DESCRIPTION
Antenna to satellite television


Coaxial  Cable

White and black
Estándar decoder
L14
Digital sign
HD decoder
LH27-100
High definition sign
HD Plus decoder
LRHD-22
High definition sign and functions to record, pause, forward, backward
WIFI Router
MR7015AL
WIFI Router with four connections to Ethernet

2.      Establezca las políticas de inventario(s) para ordenar, organizar, programar y transportar según su proyecto de formación.

Policy of inventory

Ø  To realize orders all Tuesdays.

Ø  Review and count of elements in the unloading.

Ø  To request supply of elements in case of have a minimum required, its means 5 in existence.

Ø  Arranging of stock per model of decoders.

Ø  Rotate elements older.

Ø  Organize defective elements to return.

Ø  The inventory will be systematize to have a digital control in Excel for then to be compare with system of inventory HSP of Directv program.

Ø  Decoders will be serializing by means of bar code reader to agile arranging in stock.


3.      Realice una simulación pronostica de la demanda de los productos o servicios a ejecutar a través de los inventarios.

Forecast of installations not realized  of second quarter of 2015

X
Y
Month
Code
Installations not realized
Dicember -14
1
5
January  -15
2
4
February -15
3
7
March -15
4
7
April -15
5
4
May -15
6
6
June -15
7
6
July -15
8
6
August -15
9
6









jueves, 20 de agosto de 2015

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