TRABAJO #1. ELECTIVA (EXCEL AVANZADO).xlsx

4

Click here to load reader

Transcript of TRABAJO #1. ELECTIVA (EXCEL AVANZADO).xlsx

Page 1: TRABAJO #1. ELECTIVA (EXCEL AVANZADO).xlsx

PRODUCTO VR. UNITARIO TOTAL VENTAS COSTO X UNID.

Televisor 21" 10 $ 655,000 $6,550,000 $300,000 Nevera 5 $ 885,000 $4,425,000 $425,000 Televisor 35" 6 $ 987,000 $5,922,000 $515,000 Lavadora 25 lbs 8 $ 756,000 $6,048,000 $350,000 Nevecom 3 $ 1,235,000 $3,705,000 $755,000 Portatil 18" 5 $ 821,000 $4,105,000 $468,000 Pc Mesa 21" 5 $ 1,250,000 $6,250,000 $800,000 Mini Portatil 10 $ 550,000 $5,500,000 $320,000 DVD mini 4 $ 125,000 $500,000 $70,000 DVD Grande 8 $ 185,000 $1,480,000 $95,000 Lavadora 40 lbs 2 $ 1,650,000 $3,300,000 $815,000 TOTAL 66 $ 9,099,000 $47,785,000 $4,913,000

VALOR MINIMO 2 $ 125,000 $ 500,000 $ 70,000 VALOR MAXIMO 10 $ 1,650,000 $ 6,550,000 $ 815,000 PROMEDIO 6 $ 827,182 $ 4,344,091 $ 446,636

UNID. VENDIDAS

Page 2: TRABAJO #1. ELECTIVA (EXCEL AVANZADO).xlsx
Page 3: TRABAJO #1. ELECTIVA (EXCEL AVANZADO).xlsx

TOTAL COSTO UTILIDAD

$3,000,000 $3,550,000 $2,125,000 $2,300,000 $3,090,000 $2,832,000 $2,800,000 $3,248,000 $2,265,000 $1,440,000 $2,340,000 $1,765,000 $4,000,000 $2,250,000 $3,200,000 $2,300,000

$280,000 $220,000 $760,000 $720,000

$1,630,000 $1,670,000 $25,490,000 $22,295,000

$ 280,000 $ 220,000 $ 4,000,000 $ 3,550,000 $ 2,317,273 $ 2,026,818

F1
Estudiantes:
Page 4: TRABAJO #1. ELECTIVA (EXCEL AVANZADO).xlsx