2c:null 2d:["$","title",null,{"children":"Simulateur de répartition de résultat pour une salariée CESA en CAE | Thomas Parisot | Observable"}] 32:[{"id":"111e70a2a4b16b9e7a0af120acb57d998afe7f64b21dfe147e2b29fee76c07f9b4c5005fdc650384b004c30d9ad4c581dddc5fab2acdc4752d75139b986d13f9","href":"https://static.observableusercontent.com/files/111e70a2a4b16b9e7a0af120acb57d998afe7f64b21dfe147e2b29fee76c07f9b4c5005fdc650384b004c30d9ad4c581dddc5fab2acdc4752d75139b986d13f9","name":"rapport-gestion-selection.png","type":"image/png","lastModified":1617994811602.992,"size":49932},{"id":"12e5edf557c969c464e82e2d45312a5afeb069db2803e6e164eac6411654eb2750ab2107791177a0bcf360f694259c5b1242152bf8c92e48a2a878ae5903398e","href":"https://static.observableusercontent.com/files/12e5edf557c969c464e82e2d45312a5afeb069db2803e6e164eac6411654eb2750ab2107791177a0bcf360f694259c5b1242152bf8c92e48a2a878ae5903398e","name":"rapport-gestion.png","type":"image/png","lastModified":1617994812551.153,"size":70037}] 30:{"id":"953736499c582918","slug":"cae-simulateur-repartition-resultat","title":"Simulateur de répartition de résultat pour une salariée CESA en CAE","thumbnail":"d552d3e522ca1cdce42f27b3f0d663fc60fbc72469cdfed2c6a4c5ecad622a96","access_level":"public","create_time":"$D2021-04-09T14:51:53.752Z","update_time":"$D2021-04-13T16:05:04.362Z","view_time":null,"first_public_time":"$D2021-04-09T19:16:42.696Z","has_unpublished_edits":null,"fork":false,"stars":1,"starred":false,"owner":{"type":"team","id":"2e47ffb87e7621ba","login":"thom4","name":"Thomas Parisot","avatar_url":"https://avatars-next.observableusercontent.com/20af6aecdac86e856fff9682815248802780c6d963ad6a7e70fe16aa6b8be2c3","tier":"starter_2024","bio":"I design web software, facilitate team work and bake sourdough bread • I believe in autonomy and kindness • @bbcrd alumnus"},"version":379,"publish_version":379,"role":null,"authored":false,"authors":[{"type":"individual","id":"b5360110032f691c","login":"thom4","name":"Thomas Parisot","avatar_url":"https://avatars-next.observableusercontent.com/20af6aecdac86e856fff9682815248802780c6d963ad6a7e70fe16aa6b8be2c3","tier":null,"bio":"I design web software, facilitate team work and bake sourdough bread • I believe in autonomy and kindness • @bbcrd alumnus"}],"members":[{"type":"individual","id":"b5360110032f691c","login":"thom4","name":"Thomas Parisot","avatar_url":"https://avatars-next.observableusercontent.com/20af6aecdac86e856fff9682815248802780c6d963ad6a7e70fe16aa6b8be2c3","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Simulateur de répartition de résultat pour une salariée CESA en CAE","cells":[{"id":0,"value":"md`# Simulateur de répartition de résultat pour une salariée CESA en CAE\n\nÀ la fin d'un exercice annuel, le résultat d'une activité revient à l'entrepreuneuse, sous forme de **salaire à répartir sur 6 mois** (côtisations + rémunération, et/ou sous forme d'**intéressement** (côtisations réduites + contribution à la coopérative + primes).`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":378,"value":"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"md`## Éléments de base`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":317,"value":"html`

Où trouver ces informations dans Louty ?

\n\n

Naviguer vers le rapport de gestion

\n\n

\n Naviguer vers Rapports gestion › Visualiser puis le Rapport à visualiser RES_U_Résultat d'Activité.
\n $\"\"$ \n\n

\n\n

Puis identifier les chiffres

\n\n

\n Ceux qui nous intéressent sont Rémunérations brutes, et RESULTAT. La ligne la plus récente de Rémunérations brutes correspond au Salaire brut mensuel.
\n\n $\"\"$ \n

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":13,"value":"viewof salaire_brut_annuel = Text({ label: \"Salaire brut annuel (en €)\", step: 1000, min: 0, type: \"number\", required: true })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":34,"value":"viewof resultat_annuel = Text({ label: \"Résultat annuel (en €)\", step: 1000, min: 0, type: \"number\", required: true })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":76,"value":"viewof salaire_brut_mensuel = Text({ label: \"Salaire brut mensuel (en €)\", step: 100, min: 0, type: \"number\", required: true })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":83,"value":"viewof taux_charges_patronales = Range([0, 100], { label: \"Taux de charges patronales (en %)\", step: 1, required: true, value: 43 })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":97,"value":"md`## Simulation de report de résultat en intéressement+salaire variable`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":104,"value":"viewof montant_report = Range([0, resultat_annuel], { label: \"Report de résultat souhaité en salaire (en €)\", step: 1, required: true, value: 0 })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":113,"value":"md`Soit une **prime d'intéressement** de ${EUR(prime_interessement)}, et une **contribution à la coopérative** (_mutualisation_) de ${EUR(mutualisation_coop)}.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":172,"value":"md`Il reste ensuite ${EUR(resultat_annuel_apres_interessement)} **à répartir** en salaire variable, de janvier à juin (cf. section suivante).`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":173,"value":"md`## Simulation de répartition en salaire variable, de janvier à juin\n\nLe report pour salaire et charges, intéressement et mutualisation déduits, doit être inférieur aux salaires chargés en part variable versés au cours du premier semestre de l'année.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":179,"value":"viewof part_variable_janvier = Text({ label: 'Janvier (en €, brut)', type: \"number\", required: true, min: 0, value: salaire_brut_mensuel })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":185,"value":"viewof part_variable_février = Text({ label: 'Février (en €, brut)', type: \"number\", required: true, min: 0, value: salaire_brut_mensuel })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":189,"value":"viewof part_variable_mars = Text({ label: 'Mars (en €, brut)', type: \"number\", required: true, min: 0, value: salaire_brut_mensuel })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":191,"value":"viewof part_variable_avril = Text({ label: 'Avril (en €, brut)', type: \"number\", required: true, min: 0, value: salaire_brut_mensuel })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":206,"value":"viewof part_variable_mai = Text({ label: 'Mai (en €, brut)', type: \"number\", required: true, min: 0, value: salaire_brut_mensuel })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":308,"value":"md`En juin, le salaire variable qui équilibrera la répartition sera de ${EUR(part_variable_juin)}.${prime_interessement ? ` La prime d'intéressement de ${EUR(prime_interessement)} sera également versée ce mois-là.` : ''}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":357,"value":"md`Dans ce scénario, la **contribution à la coopérative** est ${EUR(mutualisation_coop)}.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":19,"value":"md`# Annexes`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":123,"value":"resultat_annuel_pour_interessement = resultat_annuel - montant_report","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":168,"value":"resultat_annuel_apres_interessement = resultat_annuel - prime_interessement_brute - mutualisation_coop","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":117,"value":"prime_interessement_brute = Math.min(resultat_annuel_pour_interessement * 0.69, salaire_brut_annuel * 0.20)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":139,"value":"prime_interessement_collectif = prime_interessement_brute * 0.0435","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":135,"value":"prime_interessement_nette = prime_interessement_brute - ((prime_interessement_brute - prime_interessement_collectif) * 0.0970) - prime_interessement_collectif","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":351,"value":"prime_interessement = prime_interessement_nette + prime_interessement_collectif","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":130,"value":"mutualisation_coop = prime_interessement_brute * 0.44927","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":218,"value":"part_variable_total = Number(part_variable_janvier) + Number(part_variable_février) + Number(part_variable_mars) + Number(part_variable_avril) + Number(part_variable_mai)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":279,"value":"part_variable_chargée = part_variable_total + (part_variable_total * (taux_charges_patronales/100))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":215,"value":"part_variable_juin = part_variable_chargée > resultat_annuel_apres_interessement ? 0 : resultat_annuel_apres_interessement-part_variable_chargée","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":146,"value":"function EUR (amount) {\n return new Intl.NumberFormat('fr-FR', { style: 'currency', currency: 'EUR' }).format(amount)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":21,"value":"import {Button, Range, Select, Text, Textarea, html} from \"@observablehq/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W32","stdlib":"1"}} 31:"$30:body"