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

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 

LOGISTICS STRATEGIES

HEIRARCHIC DIAGRAM

COMPANY´S MEMBERS

Manager: He is who to lead the company, He coordinates all personal and creating strategies to reach the goal of de mission a vision of company.

He´s the administrative area

Administrative head: the person who is in front of all relationate with administration of company how the legal factor, to contract personals, to supervise the accountability of company.

He´s the administrative area

Supervisor: he is the coordinate of all advisers, he update constantly all adviser through of capacitation’s, and to go with adviser to sell de service in the zone.

He´s the production and commercialization area

Sales manager: the person who receive the sales of advisers and digit of subscriptions in the system to create the order to installation of service and to create the relation of contracts to legalize sales.

 He´s the production and commercialization area

Control tower: the person who agenda the service of installation, create the route the installation, delivery the elements necessary of installation of service of satellite television, he is the activate service when the installer technician to the installation, and to receive and organize the inventory of elements of installation.

He´s the supplying, production, and distribution area

Installer technician: is the person who has to do the installation of service in the house of costumer.

He´s the distribution area

Commercial adviser: the person who sell the service of satellite television

He´s the production and commercialization area

MISION

Take the interactive television to all Urabá, letting have the better service o satellite television of world, with a diverse programming of entertainment in sports, series, movies and much other, with the best technology and service of the hand of Directv