2c:null 2d:["$","title",null,{"children":"Quanto custa contratar a Tetris 2.0? | Radio Tetris | Observable"}] 32:[] 30:{"id":"bc414a9fa6be9317","slug":null,"title":"Quanto custa contratar a Tetris 2.0?","thumbnail":"f5bf8031828e4e02b860ca34970c688bf92ef834e8b5412741693bf9c44b5feb","access_level":"public","create_time":"$D2023-04-06T09:02:43.310Z","update_time":"$D2023-11-29T14:57:07.638Z","view_time":null,"first_public_time":"$D2023-04-06T09:02:43.310Z","has_unpublished_edits":null,"fork":{"id":"95d8c5b531b8aaaa","slug":"estimativa","title":"Quanto custa contratar a Tetris?","owner":{"id":"ec9657e6453b918a","login":"radio-tetris","name":"Radio Tetris"}},"stars":0,"starred":false,"owner":{"type":"team","id":"ec9657e6453b918a","login":"radio-tetris","name":"Radio Tetris","avatar_url":"https://avatars-next.observableusercontent.com/3392d2d536afa0027ed98ab9158e60cff01d000cf69339702e1bb819bcf959c6","tier":"starter_2024"},"version":666,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"61e7ac5783b2cc17","login":"daviortega","name":"Davi Ortega","avatar_url":"https://avatars-next.observableusercontent.com/5a0983d94c9bb9e0c1cc49b659f092376349a9ed0fb1967a9c8d98d4ea67af61","tier":null}],"members":[{"type":"individual","id":"61e7ac5783b2cc17","login":"daviortega","name":"Davi Ortega","avatar_url":"https://avatars-next.observableusercontent.com/5a0983d94c9bb9e0c1cc49b659f092376349a9ed0fb1967a9c8d98d4ea67af61","tier":null,"role":"editor"},{"type":"team","id":"ec9657e6453b918a","login":"radio-tetris","name":"Radio Tetris","avatar_url":"https://avatars-next.observableusercontent.com/3392d2d536afa0027ed98ab9158e60cff01d000cf69339702e1bb819bcf959c6","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Quanto custa contratar a Tetris 2.0?","cells":[{"id":0,"value":"# Quanto custa contratar a Tetris 2.0?","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":463,"value":"htl.html`\n

${[viewof hours, viewof points]}

${[viewof complexity, viewof playlists]}

\n
\n

${[viewof months]}

${[viewof discount]}

\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":527,"value":"|Valores|\n|-|\n|**Criacao**| **Manutencao mensal** | **Mensalidades** | **Total Contrato** |\n|${toCurrency(summary.design)}| ${toCurrency(summary.maintenance)} | ${toCurrency(summary.monthly_fee)} | ${toCurrency(summary.total)}|\n\n\n***\n|Valores com desconto|\n|-|\n| **Mensalidades** | **Total** |\n| ${toCurrency(summary.monthly_fee_with_discount)} | ${toCurrency(summary.total_with_discount)} ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":621,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":603,"value":"#### Sazonal","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":614,"value":"htl.html`\n

${[viewof porcentagem]}

\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":587,"value":"|Valor|\n|-|\n|${toCurrency(summary_sazonal.design)}|","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":128,"value":"Margin: ${summary.margin * 100}\n***","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":324,"value":"## Code","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":543,"value":"summary = {\n const price_designed = price_design(hours, complexity, playlists)\n const price_subscribed = price_subscription(points, hours, complexity, playlists)\n const design = price_designed.total\n const maintenance = price_subscribed.price\n const monthly_fee = design/months + maintenance\n const monthly_fee_with_discount = design/months + maintenance * (1 - discount/100)\n const total = monthly_fee * months\n const total_with_discount = months * monthly_fee_with_discount\n const designCost = price_designed.total_cost\n const maintenanceCost = price_subscribed.costs.total\n const margin = (total - (maintenanceCost + designCost)) / total\n return {\n design,\n maintenance,\n monthly_fee,\n total,\n monthly_fee_with_discount,\n total_with_discount,\n margin\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":654,"value":"price_subscription(points, hours, complexity, playlists)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":591,"value":"summary_sazonal = {\n const p = porcentagem / 100\n const design = price_design(hours * p, 1, 1).total\n const maintenance = price_subscription(1, hours * p, 1, 1).price\n const monthly_fee = design/months + maintenance\n const monthly_fee_with_discount = design/months + maintenance * (1 - discount/100)\n return {\n design,\n maintenance,\n monthly_fee,\n monthly_fee_with_discount\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":351,"value":"$${tex `R = r_pn_h (1 + \\frac{c}{10})`}\n${tex `R = r_pn_h (1 + \\frac{c}{10})`}","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":338,"value":"price_design(hours, 1)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":333,"value":"price_design = (number_of_hours_per_week, complexity, playlists) => {\n const added_value = playlists < 7 ? 0 : (\n playlists < 15 ? 200 : (\n playlists < 23 ? 400 : 600\n )\n )\n const margin = 1.2\n const research_hours = 8\n const number_of_songs_per_hour = 17\n const number_of_songs = number_of_hours_per_week * number_of_songs_per_hour\n const number_of_songs_per_hour_of_build = 150 / 8\n const build_hours = number_of_songs / number_of_songs_per_hour_of_build\n const music_build_per_music_per_hour = 3\n const research = params.cost_per_hour.playlist.labor.research * 8 * complexity\n const build = params.cost_per_hour.playlist.labor.build * build_hours\n const total_cost = research + build + added_value\n const price = {\n total: total_cost * margin,\n total_cost,\n research,\n build,\n details: {\n songs: number_of_songs,\n build_hours,\n }\n }\n return price\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":410,"value":"price_subscription(5, 120, 1)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":405,"value":"price_subscription = (points, number_of_hours_per_week, complexity, playlists, percentage = 0.1, periods = 3) => {\n const margin = 10\n const player = 70\n const updateRaw = price_design(number_of_hours_per_week, complexity)\n const update = updateRaw.build * percentage / periods\n const timeToUpdate = updateRaw.details.build_hours * percentage / periods\n const costs = {\n timeToUpdate,\n player,\n update,\n total: player * points + update\n }\n return {\n costs,\n price: costs.total * margin,\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"params = {\n return {\n cost_per_hour: {\n playlist: {\n labor: {\n research: 100,\n build: 100\n }\n }\n },\n num_musics: 0,\n num_hours: 0,\n monthly_fee: 0,\n contract_length_in_months: 0,\n design_fee: 0,\n estimated_delivery: 0\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":308,"value":"workedHours = plans.map(x => 225 / (8 + (x.n/150 * 8)))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":29,"value":"rec = calc_recommended_plan_monthly_fee(hours, months, discount)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":52,"value":"closest = calc_closest_plan_monthly_fee(hours, months, discount)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":43,"value":"min = calc_minimum_plan_monthly_fee(hours, months, discount)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":12,"value":"plans = [\n {\n h: 30,\n n: 500,\n c: 150,\n i: 225,\n d: 5\n },\n {\n h: 50,\n n: 800,\n c: 180,\n i: 440,\n d: 8\n },\n {\n h: 65,\n n: 1100,\n c: 210,\n i: 605,\n d: 11\n },\n {\n h: 85,\n n: 1400,\n c: 240,\n i: 770,\n d: 14\n },\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":24,"value":"calc_recommended_plan_monthly_fee = (hours, length, discount = 0) => {\n const best_plan = plans.find(x => x.h >= hours)\n return { plan: best_plan, mf: (1 - discount/100) * best_plan.c + best_plan.i / length }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":37,"value":"calc_minimum_plan_monthly_fee = (hours, length, discount = 0) => {\n const best_plan_index = plans.findIndex(x => x.h >= hours)\n const minimum_plan = best_plan_index ? plans[best_plan_index - 1] : plans[best_plan_index]\n return { plan: minimum_plan, mf: (1 - discount/100) * minimum_plan.c + minimum_plan.i / length }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":45,"value":"calc_closest_plan_monthly_fee = (hours, length, discount = 0) => {\n const best_plan_index = plans.findIndex(x => x.h >= hours)\n const minimum_plan = best_plan_index ? plans[best_plan_index - 1] : plans[best_plan_index]\n const best_plan = plans[best_plan_index]\n const up = Math.abs(best_plan.h - hours) < Math.abs(minimum_plan.h - hours)\n const closest_plan = up ? best_plan : minimum_plan\n return { plan: closest_plan, mf: (1 - discount/100) * closest_plan.c + closest_plan.i / length }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":106,"value":"toCurrency = (item) => item.toLocaleString(\"pt-BR\", { style: \"currency\", currency: \"BRL\" })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":75,"value":"viewof hours = Inputs.text({label: \"Horas por semana\", width: 50, value: 30})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":460,"value":"viewof complexity = Inputs.text({label: \"Complexidade\", width: 50, value: 1})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":571,"value":"viewof playlists = Inputs.text({label: \"Subdivisões\", width: 50, value: 1})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":511,"value":"viewof points = Inputs.text({label: \"Pontos\", width: 50, value: 1})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":78,"value":"viewof months = Inputs.text({label: \"Meses contratados\", width: 50, value: 12})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":178,"value":"viewof discount = Inputs.text({label: \"Desconto nas mensalidades (%)\", width: 50, value: 0})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":609,"value":"viewof porcentagem = Inputs.text({label: \"Porcentagem da programação\", width: 50, value: 20})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":628,"value":"## Outros tipos de calculos de desconto","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":635,"value":"{\n const agreed = 550\n return 100 * (1 - agreed/summary.design)\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":82,"value":"|Sugestao | Plano | Meses | Mensalidade efetiva | Total contratado |\n|-|-|\n|Recomendado | ${rec.plan.h} | ${months} |${toCurrency(rec.mf)} | ${toCurrency(rec.mf * months)}\n|Mais proximo | ${closest.plan.h} | ${months} |${toCurrency(closest.mf)} | ${toCurrency(closest.mf * months)}\n|Minimo | ${min.plan.h} | ${months} |${toCurrency(min.mf)} | ${toCurrency(min.mf * months)}","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":200,"value":"| Items | Recomendado | Minimo |\n|-|-|-|\n| **Mais Proximo** | ${rec.plan.h === closest.plan.h ? \"✅\" : \"\"} | ${min.plan.h === closest.plan.h ? \"✅\" : \"\"} |\n|Plano | ${rec.plan.h} | ${min.plan.h}\n| Criacao | ${toCurrency(rec.plan.i)} | ${toCurrency(min.plan.i)}\n| Mensalidade | ${toCurrency(rec.plan.c)} | ${toCurrency(min.plan.c)}\n| Mensalidade Efetiva | ${toCurrency(rec.mf)} | ${toCurrency(min.mf)} |\n| Total Contratado | ${toCurrency(rec.mf * months)} | ${toCurrency(min.mf * months)}\n\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"}],"files":"$W32","stdlib":"1","titling":"auto"}} 31:"$30:body"