0% found this document useful (0 votes)
84 views4 pages

Excel Practice File

The training expenses report outlines transportation, accommodation, meal, and training fee costs over 4 days of training, with a total spent of ₱3,483, which is under the ₱4,000 budget allotted. Daily costs varied with transportation on day 1 costing ₱240 while accommodation was consistently ₱250 per day, and total costs were highest for training fees at ₱1,050.
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
84 views4 pages

Excel Practice File

The training expenses report outlines transportation, accommodation, meal, and training fee costs over 4 days of training, with a total spent of ₱3,483, which is under the ₱4,000 budget allotted. Daily costs varied with transportation on day 1 costing ₱240 while accommodation was consistently ₱250 per day, and total costs were highest for training fees at ₱1,050.
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 4

Budget of Guest Speakers

Item September October November Annual


Research 20 20 10
Correspondence/Communication 30 30 15
Publicity 50 50 25
Honorariums 500 500 250
Travel 750 750 325
Lodging 300 300 150

expense (which the departmental


general fund provides):
TRAINING EXPENSES REPORT Amount
Expense Categories Day 1 Day 2 Day 3 Day 4 Spent /
Transportation ₱ 240 ₱ 55 ₱ 55 ₱ 240 Category
Accomodation ₱ 250 ₱ 250 ₱ 250
Breakfast ₱ 80 ₱ 105 ₱ 89
Lunch ₱ 115 ₱ 90 ₱ 125 ₱ 105
Dinner ₱ 79 ₱ 120 ₱ 90 ₱ 95
Training Fees
Registration Fee ₱ 750
Courseware fee ₱ 300
Daily Amount Spent
Average Daily Amount Spent

Expense Summary
Total Transportation ₱ 590
Total Accomodation ₱ 750
Total Breakfast ₱ 274
Total Lunch ₱ 435
Total Dinner ₱ 384
Total Training Fees ₱ 1,050
TOTAL SPENT ₱ 3,483
Budget ₱ 4,000
Amount Returned to Club
Description Cost Percentage
Office Supplies ₱ 449.00
Furniture & Fixtures ₱ 700.00
Office Equipment ₱ 1,935.00
Building Maintenance ₱ 280.00
Total: ₱ 3,364.00 0%
ID# Customer Last Name Item Description Item Type Loan Amount Deadline
1734 Hernandez Intro to Biochemistry Hardcover 3rd Ed. Books ₱ 15.00 12/9/2015
3856 Benner 1st Ed. World of Geometry Books ₱ 50.00 12/13/2015
3167 Huang 4th Ed. Hardcover Psychology 101 Books ₱ 35.00 3/5/2016
2876 Doan Astronomy: Study the Stars 10 Ct Series Books ₱ 20.00 11/2/2015
3056 Chang Michael Sparkler 3 Piece Suit Dark Grey Clothing ₱ 12.00 10/12/2015
1839 Oluwatoke Judy Boston Vintage Dress Red Clothing ₱ 38.00 2/25/2016
4732 Carter 50" LED Suzu Flat Screen TV Electronics ₱ 500.00 11/28/2015
2045 Smith 15" Suzu Laptop Electronics ₱ 150.00 1/24/2016
2975 Kokumi 7" 16 GB Sansei Tablet Electronics ₱ 75.00 9/13/2015
2345 Marquez-Jimenez Sansei Portable Gaming System Black Electronics ₱ 100.00 2/2/2016
2968 Smith 12" 1TB Hard Drive Sansei Laptop Electronics ₱ 250.00 8/16/2015
1648 Maxwell 8" 64 GB Sansei Tablet Electronics ₱ 175.00 7/6/2015
3890 Johnson Tech Elite Sansei Blue Ray Player Electronics ₱ 55.00 11/15/2015
4956 Gorecki 15.6" 500 GB Sansei Laptop Electronics ₱ 205.00 1/1/2016
4976 Plant Set of 10 DVDs Electronics ₱ 10.00 1/3/2016
2549 Bullock 1975 Phillip Electric Guitar Instrument ₱ 400.00 12/15/2015
1093 Assaf 5 Piece MDJS Metallic Drum Set Instrument ₱ 125.00 11/14/2015
2965 Haley Milano 4/4 Size Cello with Hard Case Instrument ₱ 200.00 1/18/2016
1056 Dwivedi 1950s Steel Lap Slide Guitar Instrument ₱ 175.00 4/26/2016
2376 Barnes 6 String Phillip Bass Guitar Instrument ₱ 500.00 9/16/2015
1945 Bullock .75 Ct Rose Gold and Diamond Earrings Jewelry ₱ 125.00 12/9/2015
1734 Flores Freshwater Pearl Earring/Necklace Set Jewelry ₱ 45.00 9/24/2015
3047 Grant 1.5 Ct Princess Cut Engagement Ring Jewelry ₱ 2,000.00 3/9/2016
1274 LoFrese 2.5 Ct Teardrop Ruby Necklace Jewelry ₱ 175.00 1/14/2016
1579 Krzywinksi 5.5" Platinum Tennis Bracelet Jewelry ₱ 35.00 9/15/2015
3075 Li Top Elite Complete Set Golf Clubs Sporting Goods ₱ 98.00 10/5/2015
2368 Jensen Fitness Stud Adjustable Kettlebell Sporting Goods ₱ 10.00 8/7/2015
2754 Naik Sansei Electronic Heart Monitor Sporting Goods ₱ 25.00 12/18/2015
4790 Fisher EDX Black Amber Pro Driver Sporting Goods ₱ 15.00 2/3/2016
1034 Lopes Ridgeback Luxe Mountain Bike Sporting Goods ₱ 165.00 2/24/2016
3487 Wilson 2014 BBCOR Bat Sporting Goods ₱ 20.00 2/14/2016

You might also like