Laporan Keuangan Kelompok 2a.xlsx

Jumlah Penjualan Uraian

Hari

Gorengan /pcs

Senin Selasa Rabu Kamis Jumat Sabtu Minggu

1

0 Senin Selasa Rabu Kamis Jumat Sabtu Minggu

15 15

Senin Selasa Rabu Kamis Jumat Sabtu Minggu

5 10 5 20

Total PxQ Total Keseluruhan /lembar Harga Jual /Lembar HP (Hitam Putih) Rp 500.00 Berwarna Rp 1,000.00

15

3

Berwarna 4

0 Minggu 2 HP Berwarna

1 HP

Jasa Print /lembar

6 10 5

Hari Senin Selasa Rabu Kamis Jumat Sabtu Minggu

35

3

Total

Uraian

120

20 15

6

Total

Jasa Setrika /baju

3 25 20 25 25 25

Total

Air Mineral /botol

Minggu 2

5

2

3 HP 2 3

8

12

4 3 8 20 2 5 8 Rp 4,000.00 Rp 20,000.00 Rp 1,000.00 Rp 5,000.00 Rp 4,000.00 28

7

19

Inflow Biaya Penjualan Uraian

Minggu 2

1

Inflow Gorengan Air Mineral Jasa Setrika Jasa Print JUMLAH

Rp Rp Rp Rp Rp

45,000.00 12,000.00 24,000.00 81,000.00

Rp Rp Rp Rp Rp

240,000.00 18,000.00 9,000.00 6,000.00 273,000.00

3 Rp Rp Rp Rp Rp

70,000.00 9,000.00 15,000.00 94,000.00

Biaya Tetap Uraian Bensin Transport

Jumlah Perminggu Biaya Satuan Biaya Perminggu 0.5 Rp 6,500.00 Rp 3,250.00 TOTAL Rp 3,250.00

Biaya Variabel Keterangan

Uraian

Gorengan

Modal JUMLAH

Air Mineral

Modal JUMLAH Kuota Parfum Bensin Listrik Lakban Plastik

Jasa Setrika 3 JUMLAH

Berwarna 5

Kuota Kertas Tinta

Jasa Print 6 JUMLAH

11 Rp 11,000.00

1 Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp

26,875.00 26,875.00 5,000.00 2,857.14 3,333.33 187.00 5,000.00 8,000.00 24,377.48 5,000.00 18,148.15 41,481.48 64,629.63

Minggu 2 Rp 120,000.00 Rp 120,000.00 Rp 10,750.00 Rp 10,750.00 Rp 5,000.00 Rp 2,142.86 Rp 3,333.33 Rp 187.00 Rp Rp Rp 10,663.19 Rp 5,000.00 Rp 4,537.04 Rp 10,370.37 Rp 19,907.41

Biaya Operasional Uraian Gorengan Air Mineral Jasa Setrika Jasa Print

nggu Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp

3 35,000.00 35,000.00 5,375.00 5,375.00 5,000.00 3,333.33 8,333.33 5,000.00 12,314.81 28,148.15 45,462.96

1 Rp Rp Rp Rp

30,125.00 27,627.48 67,879.63

Rp Rp Rp Rp

Minggu 2 123,250.00 10,750.00 13,913.19 23,157.41

Rp Rp Rp Rp

3 38,250.00 5,375.00 8,333.33 48,712.96

JUMLAH Rp Rp Rp Rp

161,500.00 46,250.00 49,874.00 139,750.00

HPP Uraian Gorengan Air Mineral Jasa Setrika Jasa Print

HPP Minggu ke 2 - Rp 1,027.08 Rp 2,008.33 Rp 1,791.67 Rp 1,381.37 Rp 927.55 Rp 2,424.27 Rp 3,308.20 Rp 1

Rp Rp Rp Rp

3 1,092.86 1,791.67 2,563.84

Uraian

1

Minggu 2

3

PENDAPATAN Gorengan Air Mineral Jasa Setrika Jasa Print Total

Rp Rp Rp Rp Rp

45,000.00 12,000.00 24,000.00 81,000.00

Rp Rp Rp Rp Rp

240,000.00 18,000.00 9,000.00 6,000.00 273,000.00

Rp 70,000.00 Rp 9,000.00 Rp Rp 15,000.00 Rp 94,000.00

BIAYA Biaya Tetap Biaya Variabel Total Biaya Margin

Rp Rp Rp Rp

3,250.00 115,882.11 119,132.11 (38,132.11)

Rp Rp Rp Rp

3,250.00 161,320.60 164,570.60 108,429.40

Rp 3,250.00 Rp 94,171.30 Rp 97,421.30 Rp (3,421.30)