{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["GRASS_SU"],"not_rendered":{"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"GRASS_SU","index":0,"n_rows":73,"n_cols":8,"rows_kept":73,"flags":["formulas_cached_only"]}
[null,"SEMI-FINITION OU FINITION de boeuf -calcul",{"$nulls":3},"version 1.0"]
[]
[null,"Complétez les informations",null,"Prèt information"]
[null,"Prix d'achat/lb",{"v":1.5,"d":"$1.50"},"Investissement requis",{"v":87750,"d":"$87,750.00"},"Prix des animaux et coût total du gain"]
[null,"Poids d'achat",450]
[null,"Perte de poids\"Shrink\" (%)",{"v":0.05,"d":"5.0%"},"Argent investi",{"v":35000,"d":"$35,000.00"}]
[null,"Prix de vente (note 1)",{"v":1.3,"d":"$1.30"},"Montant emprunté",{"v":52750,"d":"$52,750.00"}]
[null,"Coût par lb de gain",{"v":0.5,"d":"$0.50"},"Taux d'intérêt",{"v":0.06,"d":"6.00%"}]
[null,"Gain visé",450,"Nombre de jours",150,"Gain par jour (lb)",3]
[null,"Poids de vente prévu",855,"Coût d'intérêt",{"v":1300.6849315068494,"d":"$1,300.68"}]
[null,"Gain moins perte de poids\"shrink\"",405]
[null,"Résultats"]
[null,"Prix d'achat/lb",{"v":675,"d":"$675.00"}]
[null,"Prix de vente",{"v":1111.5,"d":"$1,111.50"}]
[null,"Marge brute",{"v":436.5,"d":"$436.50"}]
[null,"Coût par lb de gain",{"v":202.5,"d":"$202.50"}]
[null,"Coûd'intérêt",{"v":13.006849315068493,"d":"$13.01"}]
[null,"Profit par  tête",{"v":220.9931506849315,"d":"$220.99"}]
[]
[null,"Nombre de têtes",100]
[]
[null,"Marge net",{"v":22099.31506849315,"d":"$22,099.32"}]
[]
[null,"Retour sur l'équité",{"v":0.6314090019569472,"d":"63.14%"}]
[null,"Retour sur l'investissement",{"v":0.26666666666666666,"d":"26.67%"}]
[]
[]
[]
[{"$nulls":3},"Achat - Vente"]
[null,"Prix d'achat",null,null,{"v":1.5,"d":"$1.50"}]
[null,"Poids d,achat lbs",null,null,450]
[null,"Poids de vente (lbs)",null,null,855]
[null,"Shrink",null,null,{"v":0.05,"d":"5.0%"}]
[]
[null,"Coût du",null,null,"Margin"]
[null,"Gain/lb",{"v":0,"d":"$0.00"},{"v":-0.05,"d":"($0.05)"},{"v":-0.1,"d":"($0.10)"},{"v":-0.15,"d":"($0.15)"},{"v":-0.2,"d":"($0.20)"},{"v":-0.25,"d":"($0.25)"}]
[]
[null,{"v":0.25,"d":"$0.25"},506.25,{"v":463.5,"d":"463.50"},420.75,{"v":378,"d":"378.00"},335.25,{"v":292.5,"d":"292.50"}]
[null,{"v":0.3,"d":"$0.30"},{"v":486,"d":"486.00"},443.25,{"v":400.5,"d":"400.50"},357.75,{"v":315,"d":"315.00"},272.25]
[null,{"v":0.35,"d":"$0.35"},465.75,{"v":423,"d":"423.00"},380.25,{"v":337.5,"d":"337.50"},294.75,{"v":252,"d":"252.00"}]
[null,{"v":0.4,"d":"$0.40"},{"v":445.5,"d":"445.50"},402.75,{"v":360,"d":"360.00"},317.25,{"v":274.5,"d":"274.50"},231.75]
[null,{"v":0.45,"d":"$0.45"},425.25,{"v":382.5,"d":"382.50"},339.75,{"v":297,"d":"297.00"},254.25,{"v":211.5,"d":"211.50"}]
[null,{"v":0.5,"d":"$0.50"},{"v":405,"d":"405.00"},362.25,{"v":319.5,"d":"319.50"},276.75,{"v":234,"d":"234.00"},191.25]
[null,{"v":0.55,"d":"$0.55"},384.75,{"v":342,"d":"342.00"},299.25,{"v":256.5,"d":"256.50"},{"v":213.74999999999997,"d":"213.75"},{"v":170.99999999999997,"d":"171.00"}]
[null,{"v":0.6,"d":"$0.60"},{"v":364.5,"d":"364.50"},321.75,{"v":279,"d":"279.00"},236.25,{"v":193.5,"d":"193.50"},150.75]
[null,{"v":0.65,"d":"$0.65"},344.25,{"v":301.5,"d":"301.50"},258.75,{"v":216,"d":"216.00"},173.25,{"v":130.5,"d":"130.50"}]
[null,{"v":0.7,"d":"$0.70"},{"v":324,"d":"324.00"},281.25,{"v":238.5,"d":"238.50"},195.75,{"v":153,"d":"153.00"},110.25]
[null,{"v":0.75,"d":"$0.75"},303.75,{"v":261,"d":"261.00"},218.25,{"v":175.5,"d":"175.50"},132.75,{"v":90,"d":"90.00"}]
[null,{"v":0.8,"d":"$0.80"},{"v":283.5,"d":"283.50"},240.75,{"v":198,"d":"198.00"},155.25,{"v":112.5,"d":"112.50"},69.75]
[null,{"v":0.85,"d":"$0.85"},263.25,{"v":220.5,"d":"220.50"},177.75,{"v":135,"d":"135.00"},92.25,{"v":49.5,"d":"49.50"}]
[null,{"v":0.9,"d":"$0.90"},{"v":243,"d":"243.00"},200.25,{"v":157.5,"d":"157.50"},114.75,{"v":72,"d":"72.00"},29.25]
[null,{"v":0.95,"d":"$0.95"},222.75,{"v":180,"d":"180.00"},137.25,{"v":94.5,"d":"94.50"},51.75,{"v":9,"d":"9.00"}]
[]
[]
[null,"Developed by Rob Gamble"]
[null,"Finance and Business Structures Program Lead"]
[null,"OMAFRA, Guelph"]
[null,"email: rob.gamble@omafra.gov.on.ca"]
[]
[null,"Original Design - Mark Leahy"]
[null,"Formerly with OMAFRA"]
[]
[]
[null,"Adapté en français par"]
[null,"Gaétan Bonneau agronome"]
[null,"Minstère de l'Agriculture et de l'Alimentation du Québec"]
[null,"gaetan.bonneau@agr.gouv.qc.ca"]
[null,"2001-10-29"]
[null,"Collaborateur Jocelyn Jacob dta"]
[null,"Mapaq St-Narcisse"]
[null,"jocelyn.jacob@agr.gouv.qc.ca"]
[]
[null,"Note 1: prix de vente et compensation nette s'il y a lieu"]