Lat Excel.xlsx

  • Uploaded by: ruaida
  • 0
  • 0
  • November 2019
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Lat Excel.xlsx as PDF for free.

More details

  • Words: 227
  • Pages: 2
KODE KELAS W X Y

EKONOMI BISINIS EKSKLUSIF

NAMA PENUMPANG ANI LIA ARI NISA MILA FATMA ARYO

A B C D

KELAS KERETA

KODE KELAS W X W Y Y X Y

TABEL NAMA KERETA KODE KERETA NAMA KERETA ARGO BROMO KEMANDIRIAN ARGO ANGGREK KERETA SENJA

TABEL TARIF KERETA TARIF KERETA ARGO BROMO KEMANDIRIAN ARGO ANGGREK Rp 115,000 Rp 150,000 Rp 120,000 Rp 125,000 Rp 175,000 Rp 200,000 Rp 200,000 Rp 225,000 Rp 215,000

KERETA SENJA Rp 95,000 Rp 100,000 Rp 250,000

TABEL LAPORAN DATA PENUMPANG JUMLAH TIKET KELAS KERETA NAMA KERETA 3 EKONOMI ARGO BROMO 4 BISINIS KEMANDIRIAN 2 EKONOMI KEMANDIRIAN 3 EKSKLUSIF ARGO BROMO 4 EKSKLUSIF ARGO ANGGREK 1 BISINIS KEMANDIRIAN 8 EKSKLUSIF KERETA SENJA MAXIMUM MINIMUM RATA RATA

KODE KERETA A B B A C B D

TIKET TERJUAL 6 7 4 8

PENJUALAN TIKET Rp Rp Rp

645,000 875,000 645,000

Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp

TARIF 115,000 175,000 150,000 200,000 215,000 175,000 250,000 250,000 115,000 182,857

PANG Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp

BAYAR 345,000 700,000 300,000 600,000 860,000 175,000 2,000,000 2,000,000 175,000 711,429

DISCOUNT Rp Rp 17,500 Rp Rp Rp 21,500 Rp Rp 100,000 Rp 100,000 Rp Rp 19,857

TOTAL BAYAR Rp 345,000 Rp 682,500 Rp 300,000 Rp 600,000 Rp 838,500 Rp 175,000 Rp 1,900,000 Rp 1,900,000 Rp 175,000 Rp 691,571

8,625

17250

Related Documents

Lat
November 2019 52
Lat Iut.docx
October 2019 59
Lat Excel.xlsx
November 2019 35
Lat 4
October 2019 30
Lat 5
October 2019 32
Lat Un
May 2020 28

More Documents from "superstring"