{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Driftsbudsjett"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Driftsbudsjett","index":0,"n_rows":109,"n_cols":22,"rows_kept":109,"cut":false,"hidden":false,"merged":[]}
["bedriftsnavn"]
["sett årstallet her"]
[]
[]
["Periode","1","2","3","4","5","6","7","8","9","10","11","12","Budsjett (år)"]
[]
["Inntekter ",{"$f":"(B80*B91)+(B81*B92)+B82*B93+B83*B94+B84*B95+B85*B96+B86*B97+B87*B98","v":3000},{"$f":"(C80*C91)+(C81*C92)+C82*C93+C83*C94+C84*C95+C85*C96+C86*C97+C87*C98","v":3000},1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,{"$f":"SUM(B7:M7)","v":16000},"Når du fyller ut beregning av salgsinntekter  kommer tallene inn her automatisk"]
["Ev andre inntekter",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(B8:M8)","v":0}]
["Sum Driftsinntekter",{"$f":"SUM(B7:B8)","v":3000},3000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,{"$f":"SUM(N7:N8)","v":16000}]
["Variable kostnader:"]
["Produksjonskostnad",{"$f":"B80*B102+B81*B103+B82*B104+B83*B105+B84*B106+B85*B107+B86*B108+B87*B109","v":1500},{"$f":"C80*C102+C81*C103+C82*C104+C83*C105+C84*C106+C85*C107+C86*C108+C87*C109","v":1500},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(B11:M11)","v":3000},"Når du fyller utberegning av salgsinntekter feltene kommer disse tallene automatisk",null," "]
["Ev andre variable kostnader",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(B12:M12)","v":0}]
["Sum Variable kostnader",{"$f":"SUM(B11:B12)","v":1500},{"$f":"SUM(C11:C12)","v":1500},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(N11:N12)","v":3000}]
["Indirekte kostnader:"]
["Lønn - bruk denne linja dersom du starter enkeltpersonforetak",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B15:M15)","v":0}]
["Lønn - bruk denne linje dersom du starter et AS",0,0,0,10000,20000,20000,20000,20000,30000,30000,30000,30000,{"$f":"SUM(B16:M16)","v":210000}]
["Arbeidsgiveravgift",{"$f":"B16*0.141","v":0},{"$f":"C16*0.141","v":0},0,1409.9999999999998,2819.9999999999995,2819.9999999999995,2819.9999999999995,2819.9999999999995,4230,4230,4230,4230,{"$f":"SUM(B17:M17)","v":29610},"Disse regnes ut automatisk ut fra lønn i AS fra linja over"]
["Feriepenger",{"$f":"B16*0.12","v":0},{"$f":"C16*0.12","v":0},0,1200,2400,2400,2400,2400,3600,3600,3600,3600,{"$f":"SUM(B18:M18)","v":25200},null," "]
["Pensjonskostnader",{"$f":"B16*0.02","v":0},{"$f":"C16*0.02","v":0},0,200,400,400,400,400,600,600,600,600,{"$f":"SUM(B19:M19)","v":4200}]
["Internett",200,200,200,200,200,200,200,200,200,200,200,200,2400]
["Betalingsløsninger",200,200,200,200,200,200,200,200,200,200,200,200,2400]
["Kommunale avgifter",500,500,500,500,500,500,500,500,500,500,500,500,6000]
["Regnskap",1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,12000,null,null,null,null,null,null,null," "]
["Forsikringer",300,300,300,300,300,300,300,300,300,300,300,300,3600]
["Kontorutstyr/kontorrekvisita",1000,200,300,300,300,1000,300,200,200,200,500,500,5000]
["Telefon/elektronisk kommunikasjon",500,500,500,500,500,500,500,500,500,500,500,500,6000]
["Andre driftskostnader",100,100,100,100,100,100,100,100,100,100,100,100,1200]
["Reisekostnader",600,600,600,600,600,600,600,600,600,600,600,600,7200]
["Markedsføring",200,250,250,250,250,250,250,250,250,250,250,250,2950," "]
[null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0,0,0," "]
[null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0,0,0,0," "]
["Sum indirekte kostnader",{"$f":"SUM(B15:B37)","v":4600},{"$f":"SUM(C15:C37)","v":3850},3950,16760,29570,30270,29570,29470,42280,42280,42580,42580,317760]
[]
["DRIFTSRESULTAT",{"$f":"B9-B13-B38","v":-3100},-2350,-2950,-15760,-28570,-29270,-28570,-28470,-41280,-41280,-41580,-41580,-304760,null,null," "]
[]
["Fyll inn de hvite feltene med dine tall"]
[]
["Variable kostnader er kostnader som varierer med produksjon og salg. Materialkostnader er en typisk variabel kostnad som stiger når produksjonen stiger"]
[]
["Indirekte kostnader er kostnader som ikke knyttes direkte til produksjonen av en bestemt vare/tjeneste. Indirekte kostnader knytter seg til alle produktene dine. Lønn, strøm, husleie er eksemepl på slike kostnader"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Beregning av salgsinntekter"]
[]
[null,"Forklaring"]
[1,"Fyll inn de fargede feltene - La alle hvite felt stå urørt i fane 2"]
[2,"Bytt navn på varene i de blå feltene til dine varenavn. Dersom du har færre varer enn det er felter kan du bare la de andre stå urørt"]
[3,"Fyll inn antall forventede salg pr måned for hver vare. ",null,null," "," "," "]
[4,"Fyll inn salgsprisen for hver enhet uten mva"]
[5,"Fyll inn forventet produksjonskostnad for hver enhet"]
[]
["Varer (navn)"]
["Vare A"]
["Vare B"]
["Vare C"]
["Vare D"]
["Vare E"]
["Vare F"]
["Vare G",null,null,null," "]
["Vare H"]
[]
["Salg i antall"]
[{"$f":"A70","v":"Vare A"},10,10,10,10,10,10,10,10,10,10,10,10]
["Vare B",10,10]
["Vare C",10,10]
["Vare D"]
["Vare E"]
["Vare F"]
["Vare G"]
["Vare H"]
[" "]
[]
["Salgspris pr. stk uten mva"]
[{"$f":"A70","v":"Vare A"},100,100,100,100,100,100,100,100,100,100,100,100]
[{"$f":"A71","v":"Vare B"},100,100]
["Vare C",100,100]
["Vare D"]
["Vare E"]
["Vare F"]
["Vare G"]
["Vare H"]
[]
[]
["Produksjonskostnad pr. enhet"]
[{"$f":"A70","v":"Vare A"},50,50]
[{"$f":"A71","v":"Vare B"},50,50]
["Vare C",50,50]
["Vare D"]
["Vare E"]
["Vare F"]
["Vare G"]
["Vare H"]