Changes between Version 1 and Version 2 of BudgetAnalysis

Timestamp:

05/13/26 21:40:31 (13 days ago)

Author:

193284

Comment:

--

BudgetAnalysis

@@ -326 +326 @@
 )
 VALUES (
-    'Michael',
-    'Richardson',
-    'michael.r@email.com',
-    '555-0101'
+    'Марко',
+    'Стојановски',
+    'marko.stojanovski@email.com',
+    '+38970111222'
 );
 
@@ -344 +344 @@
 
 INSERT INTO venue_type(type_name)
-VALUES ('Banquet Hall');
+VALUES ('Wedding Hall');
 
 INSERT INTO venue (
@@ -356 +356 @@
 )
 VALUES (
-    'Grand Vista',
-    '123 Oak Street',
-    'Springfield',
-    '123 Oak Street',
+    'Golden Palace',
+    'Centar',
+    'Skopje',
+    'Ilindenska 15',
     200,
     45.00,
     1
 );
+
+INSERT INTO venue_booking (
+    date,
+    start_time,
+    end_time,
+    status,
+    price,
+    venue_id,
+    wedding_id
+)
+VALUES (
+    '2024-06-15',
+    '17:00:00',
+    '23:00:00',
+    'CONFIRMED',
+    3600.00,
+    1,
+    1
+);
+
+INSERT INTO photographer (
+    name,
+    email,
+    phone_number,
+    price_per_hour
+)
+VALUES (
+    'Foto Studio Aurora',
+    'aurora@studio.mk',
+    '+38970222333',
+    150.00
+);
+
+INSERT INTO photographer_booking (
+    date,
+    start_time,
+    end_time,
+    status,
+    photographer_id,
+    wedding_id
+)
+VALUES (
+    '2024-06-15',
+    '16:00:00',
+    '22:00:00',
+    'CONFIRMED',
+    1,
+    1
+);
+
+INSERT INTO band (
+    band_name,
+    genre,
+    equipment,
+    phone_number,
+    price_per_hour
+)
+VALUES (
+    'Balkan Harmony',
+    'Pop/Folk',
+    'Full sound system',
+    '+38970333444',
+    200.00
+);
+
+INSERT INTO band_booking (
+    date,
+    start_time,
+    end_time,
+    status,
+    band_id,
+    wedding_id
+)
+VALUES (
+    '2024-06-15',
+    '17:30:00',
+    '23:00:00',
+    'CONFIRMED',
+    1,
+    1
+);
 }}}
 
@@ -369 +450 @@
 
 {{{
- wedding_id | organizer_name      | wedding_date | budgeted_amount
-------------+---------------------+--------------+-----------------
- 1          | Michael Richardson  | 2024-06-15   | 8500.00
+ wedding_id | organizer_name   | wedding_date | budgeted_amount | venue_cost | photographer_cost | band_cost | total_actual_cost | remaining_budget | budget_variance_percent
+------------+------------------+--------------+-----------------+------------+-------------------+-----------+-------------------+------------------+-------------------------
+ 1          | Марко Стојановски | 2024-06-15   | 8500.00         | 3600.00    | 900.00            | 1100.00   | 5600.00           | 2900.00          | 34.12
 }}}
 
 === Calculation Verification ===
 
-* Venue Cost: fixed venue booking price
-* Photographer Cost: calculated using hourly duration
-* Band Cost: calculated using hourly duration
-* Total Actual Cost: sum of all vendor costs
-* Remaining Budget: planned budget minus total actual cost
-* Variance Percentage: remaining budget percentage relative to total budget
+* Venue Cost: 3600.00
+* Photographer Cost: 6 hours × 150.00 = 900.00
+* Band Cost: 5.5 hours × 200.00 = 1100.00
+* Total Actual Cost: 3600.00 + 900.00 + 1100.00 = 5600.00
+* Remaining Budget: 8500.00 - 5600.00 = 2900.00
+* Variance Percentage: (2900.00 / 8500.00) × 100 = 34.12%
 
 == Summary ==