PROJECT
Project ID Project Name Location Start Date End date Budget
1 Residential House Makati 3/20/2024 9/15/2024 ₱ 2,000,000.00
2 Tunnel Excavation Manila 8/15/2024 2/30/2026 ₱ 700,000,000.00
3 Super Health Center Pangasinan 11/10/2024 11/15/2025 ₱ 15,000,000.00
EMPLOYEES
Name Role Contract Project ID
Unang Angara Civil Engineer 555-9223 2
Allona Villareal Project Manager 555-9196 1
Tin Llamas Site Worker 555-0113 3
Josh Cuevas Structural Engineer 555-2115 1
Rube Andres Supervisor 555-9687 3
SUPPLIERS
Supplier Name Contact Project ID
Maramba Supply 09922123115 1
Corbel Builders 09928184556 2
Globalit Supplies Trading 09987174664 3
MATERIALS
Material Unit Price Stock Qty. Supplier ID Total Cost
Sand 200 800 3 160,000
Concrete 4500 500 1 2,250,000
Steel 250 1000 2 250,000
EQUIPMENT
Equipment Rental Cost/Day Condition Project ID
Excavator ₱ 25,000.00 Good 3
Crane ₱ 20,000.00 Operational 2
Bulldozer ₱ 5,000.00 Excellent 1
Concrete Mixer ₱ 2,000.00 Needs Repair 2
Workforce
Workforce ID Project ID Workers Daily Wage Total Wage Cost
1 1 15 ₱ 900.00 ₱ 3,880,000.00
2 2 20 ₱ 800.00 ₱ 2,950,000.00
3 3 40 ₱ 650.00 ₱ 2,300,000.00
Cost Details
Project ID Total Labor Cost Total Material Cost Total Equipment Cost Total Cost
2 ₱ 2,950,000.00 ₱ 250,000.00 ₱ 22,000.00 ₱ 3,222,000.00
1 ₱ 3,880,000.00 ₱ 2,250,000.00 ₱ 5,000.00 ₱ 6,135,000.00
3 ₱ 2,300,000.00 ₱ 160,000.00 ₱ 25,000.00 ₱ 2,485,000.00