29:null 2a:["$","title",null,{"children":"BIDA Band Pay Scenario Calculator | Harris Lapiroff | Observable"}] 2f:T487,Plot.plot({ width: Math.max(width, 1000), x: { grid: true, ticks: 10, label: 'Attendees' }, y: { grid: true, tickFormat: '$d', domain: [-200, 600], ticks: 10 }, fx: { label: 'Band Size' }, marks: [ // Bida Profit Plot.line(scenarios, { filter: d => d.system === 'proposed', stroke: PROFIT_COLOR, y: 'bidaProfit', x: 'attendees', fx: 'musicians', strokeWidth: 3, }), Plot.line(scenarios, { filter: d => d.system === 'current', stroke: PROFIT_COLOR, y: 'bidaProfit', x: 'attendees', fx: 'musicians', strokeWidth: 3, strokeDasharray: '2 10', }), // Musician Pay Plot.line(scenarios, { filter: d => d.system === 'proposed', stroke: PAY_COLOR, y: 'musicianPay', x: 'attendees', fx: 'musicians', strokeWidth: 3, }), Plot.line(scenarios, { filter: d => d.system === 'current', stroke: PAY_COLOR, y: 'musicianPay', x: 'attendees', fx: 'musicians', strokeWidth: 3, strokeDasharray: '2 10', }), // Break Even Line Plot.tickY([0]), Plot.frame(), ] })30:T522,currentSystemStats = (attendees, avgTicket, npExpenses, musicians) => { const income = attendees * avgTicket const afterNpExpenses = income - npExpenses // Callers always get the full guarantee const callerGuarantee = PERFORMER_GUARANTEE // If there are more musicians than our limit, we divide the maximum guarantee by the number of musicians const musicianGuarantee = musicians <= MUSICIAN_LIMIT ? PERFORMER_GUARANTEE: PERFORMER_GUARANTEE * MUSICIAN_LIMIT / musicians const rawProfit = afterNpExpenses - callerGuarantee - musicianGuarantee * musicians // BIDA takes $100 if there's more than $100 raw profit, no profit if there's a loss const bida100 = Math.max(Math.min(100, rawProfit), 0) const profitToSplit = Math.max(rawProfit - bida100, 0) // BIDA additionally takes half of the remaining profit const performerProfit = profitToSplit / 2 // The performers split evenly what remains const performerProfitPer = Math.floor(performerProfit / (musicians + 1)) const musicianPay = musicianGuarantee + performerProfitPer const callerPay = callerGuarantee + performerProfitPer const bidaProfit = afterNpExpenses - musicianPay * musicians - callerPay return { attendees, musicians, income, musicianPay, callerPay, bidaProfit, system: 'current', } }31:[] 2d:{"id":"58bde3d66a6f3878","slug":null,"title":"BIDA Band Pay Scenario Calculator","thumbnail":"e7c539476ddbbb1aa495972a4a8e48b86425ca68d82d10fb99280a292e02f330","access_level":"unlisted","create_time":"$D2023-05-09T17:47:10.900Z","update_time":"$D2023-11-18T15:28:33.990Z","view_time":null,"first_public_time":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"3587ecfe3e28cf64","login":"harrislapiroff","name":"Harris Lapiroff","avatar_url":"https://avatars-next.observableusercontent.com/9777c782bd50f7d54c128b6ac9313f8731fb712666730d9e662539eb3f5a5f07","tier":"starter_2024"},"version":500,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"666e3ebbff9b41a2","login":"harrislapiroff","name":"Harris Lapiroff","avatar_url":"https://avatars-next.observableusercontent.com/9777c782bd50f7d54c128b6ac9313f8731fb712666730d9e662539eb3f5a5f07","tier":null}],"members":[{"type":"individual","id":"666e3ebbff9b41a2","login":"harrislapiroff","name":"Harris Lapiroff","avatar_url":"https://avatars-next.observableusercontent.com/9777c782bd50f7d54c128b6ac9313f8731fb712666730d9e662539eb3f5a5f07","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"BIDA Band Pay Scenario Calculator","cells":[{"id":0,"value":"# BIDA Band Pay Scenario Calculator","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":439,"value":"Assumptions:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":93,"value":"viewof nonPerformerExpenses = Inputs.range([0, 2000], { label: 'Non-Performer Expenses ($)', value: 800 })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":107,"value":"viewof avgTicket = Inputs.range([5, 20], { label: 'Average Ticket ($)', value: 11, step: 0.01 })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":441,"value":"Bonus Policy Parameters:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":443,"value":"viewof bonusThreshold = Inputs.range([100, 200], { label: 'Bonus Threshold (dancers)', value: 120, step: 1 })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":446,"value":"viewof bonusRate = Inputs.range([0, 5], { label: 'Bonus Rate ($/dancer)', value: 1.25, step: 0.01 })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":472,"value":"Chart settings:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":386,"value":"viewof attendeeDomain = view`

Attendee domain:

${['min', Inputs.number({ value: 100, step: 1, width: 1 })]}

${['max', Inputs.number({ value: 200, step: 1, width: 1 })]}

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":223,"value":"$2f","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":352,"value":"

\n Musician Pay (per individual)\n

\n BIDA Profit\n

\n Current Profit-Sharing System\n

\n Proposed Bonus System\n

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined"},{"id":416,"value":"***\n\n\n## System Formulas\n\nThe two functions below calculate significant stats for the current profit sharing system and the proposed one:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":483,"value":"currentSystemStats(10, 100, 1200, 2)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":212,"value":"$30","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":202,"value":"newSystemStats = (attendees, avgTicket, npExpenses, musicians) => {\n const income = attendees * avgTicket\n const afterNpExpenses = income - npExpenses\n // Callers always get the full guarantee\n const callerGuarantee = PERFORMER_GUARANTEE\n // If there are more musicians than our limit, we divide the maximum guarantee by the number of musicians\n const musicianGuarantee = musicians <= MUSICIAN_LIMIT ? PERFORMER_GUARANTEE: PERFORMER_GUARANTEE * MUSICIAN_LIMIT / musicians\n // Each performer gets $bonusRate/attendee above the threshold.\n // If there are fewer than bonusThreshold attendees this amount will be 0\n const performerBonus = Math.max(attendees - bonusThreshold, 0) * bonusRate\n const musicianPay = musicianGuarantee + performerBonus\n const callerPay = callerGuarantee + performerBonus\n const bidaProfit = afterNpExpenses - musicianPay * musicians - callerPay\n\n return {\n attendees,\n musicians,\n income,\n musicianPay,\n callerPay,\n bidaProfit,\n system: 'proposed',\n }\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":419,"value":"## Calculations","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":187,"value":"bandSizes = d3.range(2, 6)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":191,"value":"attendeeCounts = d3.range(attendeeDomain.min, attendeeDomain.max)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":194,"value":"scenarios = d3.cross(attendeeCounts, bandSizes)\n .map(([attendees, musicians]) => [\n newSystemStats(\n attendees,\n avgTicket,\n nonPerformerExpenses, \n musicians\n ),\n currentSystemStats(\n attendees,\n avgTicket,\n nonPerformerExpenses, \n musicians \n )\n ])\n .flat()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":102,"value":"## Fixed Parameters","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":26,"value":"PERFORMER_GUARANTEE = 125","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":28,"value":"MUSICIAN_LIMIT = 4","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":455,"value":"PAY_COLOR = '#058'","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":457,"value":"PROFIT_COLOR = '#4C2'","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":422,"value":"## Imports","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":377,"value":"import { view } from '@tomlarkworthy/view'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"}],"files":"$W31","stdlib":"1","titling":"auto"}} 2e:"$2d:body"