IS427[AY1314T2] TSM Budget

	B	C	D	E	F	G	H	I	J
1
2	TSM INCOME & EXPENDITURE			SUMMARY OF EXPENSES
3	Total Cost of Trip per Person (8 days)	$3,616.00		Total Contribution to TSM Fund (excluding Prof)		$3,800
4	Total Cost of Trip per Person (10 days)	$3,916.00		Contribution to TSM Fund per Person		$15,200
5	Amount Required to Pay	25%		Prof's Contribution to TSM Fund		$200
6	Head Count	19		Total Amount to be returned to Prof
7				Total Amount to be returned to each individual
8
9
10		No of Pax	Amount per Unit	Total Amount	Remarks
11	Total Amount in Hand	19	$1,200.00	$22,800.00
12	Amount Collected from Prof	1	$200.00	$200.00
13	Total Cost of Trip	19	-$1,000.00	-$19,000.00
14	Total Additional Cost for Trip	19		$0.00
15	Amount to be Returned			$0.00
16			Amount for Budget:	$4,000.00
17
27
28
29
30	TSM BUDGET
31	Item	Description	Cost per Unit	No. of Units	Total Estimated Expenses	Remarks	Contributed By (eg. Welfare)	Paid?	Last Year Budget
32	Souvenirs for Companies (Japan)	Nonya Kaya	$3.95	21	$82.95	3 bottles per Japanese company	Lee Jin	Paid	$171.20 (20 pieces of Acrylic Plaque @ $8 each)
33	Souvenirs for Companies (Korea)	Bee Cheng Hiang Bak Kwa	$19.00	6	$114.00	1 packet per Korean company Buy 6 get 1 free	Lee Jin	Paid
34	Banner	For official photo-taking	$40.00	1	$40.00	Cloth Banner (preferred) lighter banner.	Xiangrui	Paid	$40
35	Team Identity	For official photo-taking	$10.90	20	$218.00	Running Man t-shirt from Q0010 ($10.90/piece)	Rafael	Paid	$230
36	Interpreter (in Korea)	For translation during company visits	$240.00	1	$240.00	$80/day (3 days in Korea)			$80/day
37	Interpreter (in Japan)	For translation during company visits	$120.00	1	$120.00	$120/day (1 day in Japan) do not need interpreter.			$1150 (assumes it cost the same for interpreter in Japan)
38	Welfare & Entertainment		$60.00	20	$1,200.00
39	Tips for Driver and Tour Guide (in Korea)		$400.00	2	$800.00	$5 per person per day (4 days)			Did not give any tips eventually.
40	Tips for Driver and Tour Guide (in Japan)		$200.00	2	$400.00	$5 per person per day (2 days)			Did not give any tips eventually.
41	Lanyards	For company visit	$11.72	1	$11.72		Yun Xi	Paid
42	Wrapping Paper	For company visit	$13.50	1	$13.50		Lee Jin	Paid
43			Total Expected Budget:		$2,880.17
44
45	TSM ACTUAL EXPENDITURE
46	Item	Description	Amount Spent	Date	Remarks		Total Amount Spent	$486.97
47	Team Identity - Running Man Shirt	For official photo-taking	$224.80	4/1/2014	Paid		Expenses per Person	$24.35
48	Banner	For official photo-taking	$40.00	4/28/2014	Paid
49	Wrapping Paper	For company visit	$13.50	4/28/2014	Paid
50	Bak Kwa	For company visit	$114.00	4/28/2014	Paid
51	Kaya	For company visit	$82.95	4/28/2014	Paid
52	Lanyards	For company visit	$11.72	4/28/2014	Paid
53
54
55
56
57
58
59
60	TSM ACTUAL EXPENDITURE IN KRW
61	Beginning Amount in Won:	₩ 1,630,000.00
62
63	Item	Description	Amount Spent	Date	Remarks		Amount Spent in Won	₩ 1,610,000.00
64	Jump Ticket	Watched Jump performance (20 pax)	₩ 1,000,000.00	5/1/2014	50000 Won per pax.		Amount of Won remaining	₩ 20,000.00
65	Prof Ben Jacket	Team Gift to Prof	₩ 90,000.00	5/5/2014			Amount in SGD
66	Remaining Split up	Split remaining Won to everyone	₩ 520,000.00	5/5/2014	26000 Won per pax.		Rounded Amount
67							Exchange Rate
68
69
70							Note: Split the remaining Won to everyone. Rounded down the value and everyone got 26000 Won (from petty cash) back.
71							Remaining amount of Won: 700Won * 20 = 14000Won
72							Kept 96000Won as Prof Ben Jacket budget. Spent only 90000Won. Left 6000Won.
73							Total Won left: 14000 + 6000 = 20000Won
74
75
76
77
78
79
80
81
82
83
84
85	TSM ACTUAL EXPENDITURE IN JPY
86	Beginning Amount in Yen:	¥ 81,000.00
87
88	Item	Description	Amount Spent	Date	Remarks		Amount Spent in Yen	¥ 0.00
89							Amount of Yen remaining	¥ 81,000.00
90							Amount in SGD
91							Rounded Amount
92							Exchange Rate
93
94
95							Note: Did not use any Japanese Yen.
96
97
98
99
100
101
102
103
104
105
106
107
108
109