json
{
"deal_id": "deal_john_tour_combined_001",
"name": "John Tour - Combined Venues",
"deal_type": "guarantee_vs_percentage_nbor",
"created_at": "2024-11-05T08:00:00Z",
"initialized_from_template": "tpl_john_tour_v1",
"versions": [
{
"version_id": "v_working_01",
"status": "working",
"static_variables": {
"v_artist_percentage": 90,
"v_bonus_per_ticket": 1.05
},
"clause_blocks": [
{
"clause_block_id": "cb_majestic_01",
"clause_block_ref": "CB_MAJESTIC_01",
"name": "Show - Majestic Theatre",
"static_variables": {
"v_guarantee": 36750,
"v_bonus_cap_tickets": 1621,
"v_merch_artist_percentage": 85
},
"inputs": [
{
"input_key": "SHOW_METADATA_INPUT",
"input_type": "object",
"name": "Show Details",
"status": "C",
"value": {
"date": "2024-01-26",
"venue": "Ryman Auditorium",
"city": "Nashville",
"state": "TN"
}
},
{
"input_key": "BOX_OFFICE_INPUT",
"input_type": "object",
"name": "Box Office Sales",
"status": "C",
"value": {
"total_gross": 89357.48,
"total_sold": 1621,
"tiers": [
{
"name": "Reserved 1",
"quantity": 564,
"price": 62.48,
"sold": 564
},
{
"name": "Reserved 2",
"quantity": 860,
"price": 51.98,
"sold": 860
},
{
"name": "Reserved 3",
"quantity": 247,
"price": 41.48,
"sold": 227
}
]
}
},
{
"input_key": "TAX_FEE_INPUT",
"input_type": "object",
"name": "Taxes and Fees",
"status": "C",
"value": {
"total_taxes": 6334.39,
"total_fees": 4255.13
}
},
{
"input_key": "EXPENSE_INPUT",
"input_type": "object",
"name": "Expenses",
"status": "C",
"value": {
"total_fixed": 25389,
"total_variable": 2332.03,
"support_cost": 1575,
"breakdown": [
{
"name": "Advertising",
"amount": 7875
},
{
"name": "Box Office Staff",
"amount": 525
},
{
"name": "Cleanup",
"amount": 399
},
{
"name": "Security",
"amount": 1050
},
{
"name": "S&L",
"amount": 1050
},
{
"name": "Limo/Ground Trans",
"amount": 1050
},
{
"name": "LN General Security",
"amount": 787.5
},
{
"name": "Catering",
"amount": 210
},
{
"name": "Police",
"amount": 787.5
},
{
"name": "Production Manager",
"amount": 787.5
},
{
"name": "Rent",
"amount": 3675
},
{
"name": "Runner",
"amount": 367.5
},
{
"name": "Stage Furniture",
"amount": 787.5
},
{
"name": "Stagehands",
"amount": 1837.5
},
{
"name": "Ushers",
"amount": 1050
},
{
"name": "Screen/Projector",
"amount": 3150
}
]
}
},
{
"input_key": "MERCH_INPUT",
"input_type": "object",
"name": "Merchandise Sales",
"status": "P",
"value": null
}
],
"states": [
{
"state_key": "SHOW_FINANCIALS",
"state_type": "object",
"name": "Show Financial Summary",
"status": "C",
"value": {
"gross_receipts": 89357.48,
"taxes": 6334.39,
"fees": 4255.13,
"net_receipts": 78767.96,
"total_expenses": 29296.03,
"adjusted_gross": 49471.93,
"artist_split_earnings": 44524.74,
"tickets_sold": 1621
},
"calculation": {
"type": "aggregate",
"fields": {
"gross_receipts": "BOX_OFFICE_INPUT.value.total_gross",
"taxes": "TAX_FEE_INPUT.value.total_taxes",
"fees": "TAX_FEE_INPUT.value.total_fees",
"net_receipts": "this.gross_receipts - this.taxes - this.fees",
"total_expenses": "EXPENSE_INPUT.value.total_fixed + EXPENSE_INPUT.value.total_variable + EXPENSE_INPUT.value.support_cost",
"adjusted_gross": "MAX(0, this.net_receipts - this.total_expenses)",
"artist_split_earnings": "this.adjusted_gross * v_artist_percentage / 100",
"tickets_sold": "BOX_OFFICE_INPUT.value.total_sold"
}
}
}
],
"financial_clauses": [
{
"clause_id": "clause_primary_deal",
"name": "Guarantee vs Settlement",
"trigger": "true",
"amount": 44524.74,
"calculation": "MAX(v_guarantee, SHOW_FINANCIALS.value.artist_split_earnings)",
"calculation_metadata": {
"guarantee_component": 36750,
"percentage_component": 44524.74,
"winning_path": "percentage",
"calculation_summary": "MAX($36,750.00, $44,524.74) = $44,524.74"
},
"payment_terms": [
{
"payment_term_id": "pt_balance",
"payment_term_name": "Balance Payment",
"payment_type": "lump_sum",
"amount": {
"type": "remaining_balance"
},
"due_date": {
"type": "relative",
"trigger": "settlement",
"offset_days": 0
}
}
]
},
{
"clause_id": "clause_ticket_bonus",
"name": "Ticket Bonus",
"trigger": "SHOW_FINANCIALS.value.tickets_sold > 0",
"amount": 1702.05,
"calculation": "MIN(SHOW_FINANCIALS.value.tickets_sold, v_bonus_cap_tickets) * v_bonus_per_ticket",
"calculation_metadata": {
"tickets_sold": 1621,
"bonus_cap": 1621,
"bonus_rate": 1.05,
"calculation_summary": "MIN(1621, 1621) * $1.05 = $1,702.05"
}
}
]
},
{
"clause_block_id": "cb_new_orleans_01",
"clause_block_ref": "CB_NEW_ORLEANS_01",
"name": "Show - Orpheum Theater",
"static_variables": {
"v_guarantee": 22575,
"v_bonus_cap_tickets": 1420,
"v_merch_artist_percentage": 80
},
"inputs": [
{
"input_key": "SHOW_METADATA_INPUT",
"input_type": "object",
"name": "Show Details",
"status": "C",
"value": {
"date": "2024-02-01",
"venue": "Orpheum Theatre - Memphis",
"city": "Memphis",
"state": "TN"
}
},
{
"input_key": "BOX_OFFICE_INPUT",
"input_type": "object",
"name": "Box Office Sales",
"status": "C",
"value": {
"total_gross": 79035.6,
"total_sold": 1470,
"tiers": [
{
"name": "Reserved 1",
"quantity": 350,
"price": 62.48,
"sold": 350
},
{
"name": "Reserved 2",
"quantity": 1020,
"price": 51.98,
"sold": 1020
},
{
"name": "Reserved 3",
"quantity": 100,
"price": 41.48,
"sold": 100
}
]
}
},
{
"input_key": "TAX_FEE_INPUT",
"input_type": "object",
"name": "Taxes and Fees",
"status": "C",
"value": {
"total_taxes": 0,
"total_fees": 5218.5
}
},
{
"input_key": "EXPENSE_INPUT",
"input_type": "object",
"name": "Expenses",
"status": "C",
"value": {
"total_fixed": 20086.5,
"total_variable": 6258.6,
"support_cost": 5250,
"breakdown": [
{
"name": "Advertising",
"amount": 7875
},
{
"name": "Auto/Street/Permit Parking",
"amount": 840
},
{
"name": "Box Office Staff",
"amount": 525
},
{
"name": "Cleanup",
"amount": 892.5
},
{
"name": "Electrician",
"amount": 451.5
},
{
"name": "Security",
"amount": 2100
},
{
"name": "Limo/Ground Trans",
"amount": 1050
},
{
"name": "LN General Security",
"amount": 787.5
},
{
"name": "Catering",
"amount": 210
},
{
"name": "Police",
"amount": 525
},
{
"name": "Runner",
"amount": 367.5
},
{
"name": "Stage Furniture",
"amount": 787.5
},
{
"name": "Stagehands",
"amount": 1575
},
{
"name": "House Expense",
"amount": 2100
},
{
"name": "Variable: ASCAP",
"amount": 355.01
},
{
"name": "Variable: BMI",
"amount": 355.01
},
{
"name": "Variable: GMR",
"amount": 106.5
},
{
"name": "Variable: Insurance",
"amount": 1219.37
},
{
"name": "Variable: Rent",
"amount": 4200
},
{
"name": "Variable: SESAC",
"amount": 22.72
}
]
}
},
{
"input_key": "MERCH_INPUT",
"input_type": "object",
"name": "Merchandise Sales",
"status": "P",
"value": null
}
],
"states": [
{
"state_key": "SHOW_FINANCIALS",
"state_type": "object",
"name": "Show Financial Summary",
"status": "C",
"value": {
"gross_receipts": 79035.6,
"taxes": 0,
"fees": 5218.5,
"net_receipts": 73817.1,
"total_expenses": 31595.1,
"adjusted_gross": 42222,
"artist_split_earnings": 37999.8,
"tickets_sold": 1470
},
"calculation": {
"type": "aggregate",
"fields": {
"gross_receipts": "BOX_OFFICE_INPUT.value.total_gross",
"taxes": "TAX_FEE_INPUT.value.total_taxes",
"fees": "TAX_FEE_INPUT.value.total_fees",
"net_receipts": "this.gross_receipts - this.taxes - this.fees",
"total_expenses": "EXPENSE_INPUT.value.total_fixed + EXPENSE_INPUT.value.total_variable + EXPENSE_INPUT.value.support_cost",
"adjusted_gross": "MAX(0, this.net_receipts - this.total_expenses)",
"artist_split_earnings": "this.adjusted_gross * v_artist_percentage / 100",
"tickets_sold": "BOX_OFFICE_INPUT.value.total_sold"
}
}
}
],
"financial_clauses": [
{
"clause_id": "clause_primary_deal",
"name": "Guarantee vs Settlement",
"trigger": "true",
"amount": 37999.8,
"calculation": "MAX(v_guarantee, SHOW_FINANCIALS.value.artist_split_earnings)",
"calculation_metadata": {
"guarantee_component": 22575,
"percentage_component": 37999.8,
"winning_path": "percentage",
"calculation_summary": "MAX($22,575.00, $37,999.80) = $37,999.80"
},
"payment_terms": [
{
"payment_term_id": "pt_balance",
"payment_term_name": "Balance Payment",
"payment_type": "lump_sum",
"amount": {
"type": "remaining_balance"
},
"due_date": {
"type": "relative",
"trigger": "settlement",
"offset_days": 0
}
}
]
},
{
"clause_id": "clause_ticket_bonus",
"name": "Ticket Bonus",
"trigger": "SHOW_FINANCIALS.value.tickets_sold > 0",
"amount": 1491,
"calculation": "MIN(SHOW_FINANCIALS.value.tickets_sold, v_bonus_cap_tickets) * v_bonus_per_ticket",
"calculation_metadata": {
"tickets_sold": 1470,
"bonus_cap": 1420,
"bonus_rate": 1.05,
"calculation_summary": "MIN(1470, 1420) * $1.05 = $1,491.00"
}
}
]
},
{
"clause_block_id": "cb_raising_canes_01",
"clause_block_ref": "CB_RAISING_CANES_01",
"name": "Show - Raising Canes River Center",
"static_variables": {
"v_guarantee": 22575,
"v_bonus_cap_tickets": 1676,
"v_merch_artist_percentage": 70
},
"inputs": [
{
"input_key": "SHOW_METADATA_INPUT",
"input_type": "object",
"name": "Show Details",
"status": "C",
"value": {
"date": "2024-01-28",
"venue": "Tennessee Theatre",
"city": "Knoxville",
"state": "TN"
}
},
{
"input_key": "BOX_OFFICE_INPUT",
"input_type": "object",
"name": "Box Office Sales",
"status": "C",
"value": {
"total_gross": 94137.98,
"total_sold": 1726,
"tiers": [
{
"name": "Reserved 1",
"quantity": 640,
"price": 62.48,
"sold": 640
},
{
"name": "Reserved 2",
"quantity": 867,
"price": 51.98,
"sold": 867
},
{
"name": "Reserved 3",
"quantity": 219,
"price": 41.48,
"sold": 219
}
]
}
},
{
"input_key": "TAX_FEE_INPUT",
"input_type": "object",
"name": "Taxes and Fees",
"status": "C",
"value": {
"total_taxes": 7757.81,
"total_fees": 9678.9
}
},
{
"input_key": "EXPENSE_INPUT",
"input_type": "object",
"name": "Expenses",
"status": "C",
"value": {
"total_fixed": 28665,
"total_variable": 2341.97,
"support_cost": 5250,
"breakdown": [
{
"name": "Advertising",
"amount": 5250
},
{
"name": "Security",
"amount": 1470
},
{
"name": "House Expense",
"amount": 5250
},
{
"name": "Limo/Ground Trans",
"amount": 1050
},
{
"name": "LN General Security",
"amount": 787.5
},
{
"name": "Catering",
"amount": 262.5
},
{
"name": "Rent",
"amount": 9187.5
},
{
"name": "Runner",
"amount": 420
},
{
"name": "Stage Furniture",
"amount": 787.5
},
{
"name": "Theater Crew-Piper",
"amount": 2100
},
{
"name": "Screen/Projector",
"amount": 2100
},
{
"name": "Variable: ASCAP",
"amount": 369.42
},
{
"name": "Variable: BMI",
"amount": 369.42
},
{
"name": "Variable: GMR",
"amount": 147.77
},
{
"name": "Variable: Insurance",
"amount": 1431.72
},
{
"name": "Variable: SESAC",
"amount": 23.65
}
]
}
},
{
"input_key": "MERCH_INPUT",
"input_type": "object",
"name": "Merchandise Sales",
"status": "P",
"value": null
}
],
"states": [
{
"state_key": "SHOW_FINANCIALS",
"state_type": "object",
"name": "Show Financial Summary",
"status": "C",
"value": {
"gross_receipts": 94137.98,
"taxes": 7757.81,
"fees": 9678.9,
"net_receipts": 76701.27,
"total_expenses": 36256.97,
"adjusted_gross": 40444.3,
"artist_split_earnings": 36399.87,
"tickets_sold": 1726
},
"calculation": {
"type": "aggregate",
"fields": {
"gross_receipts": "BOX_OFFICE_INPUT.value.total_gross",
"taxes": "TAX_FEE_INPUT.value.total_taxes",
"fees": "TAX_FEE_INPUT.value.total_fees",
"net_receipts": "this.gross_receipts - this.taxes - this.fees",
"total_expenses": "EXPENSE_INPUT.value.total_fixed + EXPENSE_INPUT.value.total_variable + EXPENSE_INPUT.value.support_cost",
"adjusted_gross": "MAX(0, this.net_receipts - this.total_expenses)",
"artist_split_earnings": "this.adjusted_gross * v_artist_percentage / 100",
"tickets_sold": "BOX_OFFICE_INPUT.value.total_sold"
}
}
}
],
"financial_clauses": [
{
"clause_id": "clause_primary_deal",
"name": "Guarantee vs Settlement",
"trigger": "true",
"amount": 36399.87,
"calculation": "MAX(v_guarantee, SHOW_FINANCIALS.value.artist_split_earnings)",
"calculation_metadata": {
"guarantee_component": 22575,
"percentage_component": 36399.87,
"winning_path": "percentage",
"calculation_summary": "MAX($22,575.00, $36,399.87) = $36,399.87"
},
"payment_terms": [
{
"payment_term_id": "pt_balance",
"payment_term_name": "Balance Payment",
"payment_type": "lump_sum",
"amount": {
"type": "remaining_balance"
},
"due_date": {
"type": "relative",
"trigger": "settlement",
"offset_days": 0
}
}
]
},
{
"clause_id": "clause_ticket_bonus",
"name": "Ticket Bonus",
"trigger": "SHOW_FINANCIALS.value.tickets_sold > 0",
"amount": 1759.8,
"calculation": "MIN(SHOW_FINANCIALS.value.tickets_sold, v_bonus_cap_tickets) * v_bonus_per_ticket",
"calculation_metadata": {
"tickets_sold": 1726,
"bonus_cap": 1676,
"bonus_rate": 1.05,
"calculation_summary": "MIN(1726, 1676) * $1.05 = $1,759.80"
}
}
]
}
]
}
]
}