{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["예산 요약","손익 계산서 차트","잔액 차트"],"not_rendered":{"charts":2,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"예산 요약","index":0,"n_rows":42,"n_cols":9,"rows_kept":42}
[]
[null,"예산 요약 보고서",{"$nulls":6},{"$f":"YEAR(TODAY())","v":2019}]
[null,"회사 이름"]
[null,"회색 셀은 자동으로 계산되며 일반적으로 변경할 수 없습니다."]
[null,"손익 요약","5월 실제","5월 목표","월별 분산","YTD 실제","YTD 목표","YTD 분산","메모"]
[null,"매출",{"v":1200000,"d":"₩1,200,000.00"},{"v":1100000,"d":"₩1,100,000.00"},{"$f":"C6-D6","v":{"v":100000,"d":"₩100,000.00"}},{"v":6200000,"d":"₩6,200,000.00"},{"v":6000000,"d":"₩6,000,000.00"},{"$f":"F6-G6","v":{"v":200000,"d":"₩200,000.00"}},"서부 지역에서 활동 강화를 통해 5월 수익 목표를 9% 초과했습니다."]
[null,"매출 총 이익",{"v":150000,"d":"₩150,000.00"},{"v":160000,"d":"₩160,000.00"},{"$f":"C7-D7","v":{"v":-10000,"d":"(₩10,000.00)"}},{"v":640000,"d":"₩640,000.00"},{"v":750000,"d":"₩750,000.00"},{"$f":"F7-G7","v":{"v":-110000,"d":"(₩110,000.00)"}}]
[null,"매출 총 이익 백분율",{"$f":"IF(C6=0,0,C7/C6)","v":{"v":0.125,"d":"12.5%"}},{"$f":"IF(D6=0,0,D7/D6)","v":{"v":0.14545454545454545,"d":"14.5%"}},{"$f":"C8-D8","v":{"v":-0.020454545454545447,"d":"-2.0%"}},{"$f":"IF(F6=0,0,F7/F6)","v":{"v":0.1032258064516129,"d":"10.3%"}},{"$f":"IF(G6=0,0,G7/G6)","v":{"v":0.125,"d":"12.5%"}},{"$f":"F8-G8","v":{"v":-0.021774193548387097,"d":"-2.2%"}}]
[null,"새 제품 판매액",{"v":200000,"d":"₩200,000.00"},{"v":150000,"d":"₩150,000.00"},{"$f":"C9-D9","v":{"v":50000,"d":"₩50,000.00"}},{"v":900000,"d":"₩900,000.00"},{"v":750000,"d":"₩750,000.00"},{"$f":"F9-G9","v":{"v":150000,"d":"₩150,000.00"}}]
[null,"지역별 판매 분석 결과"]
[null,"북동부 지역",{"v":400000,"d":"₩400,000.00"},{"v":400000,"d":"₩400,000.00"},{"$f":"C11-D11","v":{"v":0,"d":"₩0.00"}},{"v":2200000,"d":"₩2,200,000.00"},{"v":2000000,"d":"₩2,000,000.00"},{"$f":"F11-G11","v":{"v":200000,"d":"₩200,000.00"}}]
[null,"중앙 지역",{"v":400000,"d":"₩400,000.00"},{"v":400000,"d":"₩400,000.00"},{"$f":"C12-D12","v":{"v":0,"d":"₩0.00"}},{"v":2400000,"d":"₩2,400,000.00"},{"v":2000000,"d":"₩2,000,000.00"},{"$f":"F12-G12","v":{"v":400000,"d":"₩400,000.00"}}]
[null,"서부 지역",{"v":400000,"d":"₩400,000.00"},{"v":300000,"d":"₩300,000.00"},{"$f":"C13-D13","v":{"v":100000,"d":"₩100,000.00"}},{"v":1600000,"d":"₩1,600,000.00"},{"v":2000000,"d":"₩2,000,000.00"},{"$f":"F13-G13","v":{"v":-400000,"d":"(₩400,000.00)"}}]
[null,"비용 및 이익:"]
[null,"SG&A 비용",{"v":100000,"d":"₩100,000.00"},{"v":120000,"d":"₩120,000.00"},{"$f":"D15-C15","v":{"v":20000,"d":"₩20,000.00"}},{"v":500000,"d":"₩500,000.00"},{"v":600000,"d":"₩600,000.00"},{"$f":"G15-F15","v":{"v":100000,"d":"₩100,000.00"}}]
[null,"세전 영업 이익(손실)",{"v":50000,"d":"₩50,000.00"},{"v":40000,"d":"₩40,000.00"},{"$f":"C16-D16","v":{"v":10000,"d":"₩10,000.00"}},{"v":140000,"d":"₩140,000.00"},{"v":150000,"d":"₩150,000.00"},{"$f":"F16-G16","v":{"v":-10000,"d":"(₩10,000.00)"}}]
[null,"영업 이익",{"$f":"IF(C6=0,0,C16/C6)","v":{"v":0.041666666666666664,"d":"4%"}},{"$f":"IF(D6=0,0,D16/D6)","v":{"v":0.03636363636363636,"d":"4%"}},{"$f":"C17-D17","v":{"v":5.3030303030303025E-3,"d":"1%"}},{"$f":"IF(F6=0,0,F16/F6)","v":{"v":0.02258064516129032,"d":"2%"}},{"$f":"IF(G6=0,0,G16/G6)","v":{"v":0.025,"d":"3%"}},{"$f":"F17-G17","v":{"v":-0.00241935483870968,"d":"-0%"}}]
[]
[null,"잔액 시트 요약","5월 실제","5월 목표","월별 분산","YTD 실제","YTD 목표","YTD 분산","메모"]
[null,"기간말 현금 흐름",{"v":35000,"d":"₩35,000.00"},{"v":50000,"d":"₩50,000.00"},{"$f":"C20-D20","v":{"v":-15000,"d":"(₩15,000.00)"}},{"v":35000,"d":"₩35,000.00"},{"v":50000,"d":"₩50,000.00"},{"$f":"F20-G20","v":{"v":-15000,"d":"(₩15,000.00)"}},"현금 흐름 차이가 발생한 이유는 5월 8일에 발생한 회사 이름 관련 법적 분쟁에 대한 현금 지불 때문입니다."]
[null,"매출채권",{"v":20000,"d":"₩20,000.00"},{"v":22000,"d":"₩22,000.00"},{"v":-2000,"d":"(₩2,000.00)"},{"v":20000,"d":"₩20,000.00"},{"v":22000,"d":"₩22,000.00"},{"v":-2000,"d":"(₩2,000.00)"}]
[null,"재고",{"v":25000,"d":"₩25,000.00"},{"v":30000,"d":"₩30,000.00"},{"v":-5000,"d":"(₩5,000.00)"},{"v":25000,"d":"₩25,000.00"},{"v":30000,"d":"₩30,000.00"},{"v":-5000,"d":"(₩5,000.00)"}]
[null,"총 유동 자산",{"v":75000,"d":"₩75,000.00"},{"v":90000,"d":"₩90,000.00"},{"v":-15000,"d":"(₩15,000.00)"},{"v":75000,"d":"₩75,000.00"},{"v":90000,"d":"₩90,000.00"},{"v":-15000,"d":"(₩15,000.00)"}]
[null,"채무 상환에 필요한 자산",{"v":25000,"d":"₩25,000.00"},{"v":25000,"d":"₩25,000.00"},{"v":0,"d":"₩0.00"},{"v":25000,"d":"₩25,000.00"},{"v":25000,"d":"₩25,000.00"},{"v":0,"d":"₩0.00"}]
[null,"채무 상환 버퍼",{"$f":"C23-C24","v":{"v":50000,"d":"₩50,000.00"}},{"$f":"D23-D24","v":{"v":65000,"d":"₩65,000.00"}},{"v":-15000,"d":"(₩15,000.00)"},{"$f":"F23-F24","v":{"v":50000,"d":"₩50,000.00"}},{"$f":"G23-G24","v":{"v":65000,"d":"₩65,000.00"}},{"v":-15000,"d":"(₩15,000.00)"}]
[null,"기타 잔액 시트 항목:"]
[null,"재산, 설비 및 장비",{"v":80000,"d":"₩80,000.00"},{"v":78000,"d":"₩78,000.00"},{"$f":"C27-D27","v":{"v":2000,"d":"₩2,000.00"}},{"v":80000,"d":"₩80,000.00"},{"v":78000,"d":"₩78,000.00"},{"$f":"F27-G27","v":{"v":2000,"d":"₩2,000.00"}},"공장 B에서의 신규 버스팅 기계 구입으로 인한 차이"]
[null,"매입채무",{"v":60000,"d":"₩60,000.00"},{"v":60000,"d":"₩60,000.00"},{"$f":"D28-C28","v":{"v":0,"d":"₩0.00"}},{"v":60000,"d":"₩60,000.00"},{"v":60000,"d":"₩60,000.00"},{"$f":"F28-G28","v":{"v":0,"d":"₩0.00"}}]
[null,"장기 부채",{"v":30000,"d":"₩30,000.00"},{"v":31000,"d":"₩31,000.00"},{"$f":"D29-C29","v":{"v":1000,"d":"₩1,000.00"}},{"v":30000,"d":"₩30,000.00"},{"v":31000,"d":"₩31,000.00"},{"$f":"G29-F29","v":{"v":1000,"d":"₩1,000.00"}}]
[null,"자기 자본",{"v":300000,"d":"₩300,000.00"},{"v":297500,"d":"₩297,500.00"},{"$f":"C30-D30","v":{"v":2500,"d":"₩2,500.00"}},{"v":300000,"d":"₩300,000.00"},{"v":297500,"d":"₩297,500.00"},{"$f":"F30-G30","v":{"v":2500,"d":"₩2,500.00"}}]
[]
[null,"영업 메트릭 요약","5월 실제","5월 목표","월별 분산","YTD 실제","YTD 목표","YTD 분산","메모"]
[null,"1, 000 위젯당 오류 수 생산된",2.3,{"v":1,"d":"1.0"},{"$f":"D33-C33","v":{"v":-1.2999999999999998,"d":"(1.3)"}},{"v":1.46,"d":"1.5"},{"v":1,"d":"1.0"},{"$f":"F33-G33","v":{"v":0.45999999999999996,"d":"0.5"}},"생산 라인 3에 적용된 잘못된 페인트로 인해 품질 문제가 발생했습니다. 관리자는 새로운 감지 제어 작업을 실행했습니다."]
[null,"생산 용량 - 월 단위",{"v":200000,"d":"200,000"},{"v":220000,"d":"220,000"},{"$f":"C34-D34","v":{"v":-20000,"d":"(20,000)"}},{"v":1100000,"d":"1,100,000"},{"v":1150000,"d":"1,150,000"},{"$f":"F34-G34","v":{"v":-50000,"d":"(50,000)"}}]
[null,"미결 판매일",35,25,{"$f":"D35-C35","v":{"v":-10,"d":"(10)"}},33,25,{"$f":"G35-F35","v":{"v":-8,"d":"(8)"}}]
[null,"신규 주문 건수",19,15,{"$f":"C36-D36","v":4},83,75,{"$f":"F36-G36","v":8}]
[]
[null,"경쟁 서비스","회사 프로필","경쟁사 1","경쟁사 2","경쟁사 3","경쟁사 4","기타","메모"]
[null,"시장 점유율",{"v":0.2,"d":"20.00%"},{"v":0.25,"d":"25.00%"},{"v":0.15,"d":"15.00%"},{"v":0.05,"d":"5.00%"},{"v":0.15,"d":"15.00%"},{"v":0.2,"d":"20.00%"},"새 제품 판매액의 강세로 시장 점유율이 향상되었습니다."]
[null,"매출(YTD)",{"$f":"F6","v":{"v":6200000,"d":"₩6,200,000.00"}},{"v":7000000,"d":"₩7,000,000.00"},{"v":4000000,"d":"₩4,000,000.00"},{"v":1500000,"d":"₩1,500,000.00"},{"v":4000000,"d":"₩4,000,000.00"},{"v":6000000,"d":"₩6,000,000.00"}]
[null,"새 제품 소개 (YTD)",{"v":900000,"d":"₩900,000.00"},{"v":500000,"d":"₩500,000.00"},{"v":0,"d":"₩0.00"},{"v":100000,"d":"₩100,000.00"},{"v":500000,"d":"₩500,000.00"},{"v":0,"d":"₩0.00"}]
[null,"(예상) 현장 판매원 수",15,20,15,10,15,"N/A"]

{"sheet":"손익 계산서 차트","index":1,"n_rows":5,"n_cols":9,"rows_kept":5,"merged":[[4,1,4,8]]}
[]
[null,"손익 요약 차트",{"$nulls":6},{"$f":"'예산 요약'!I2","v":2019}]
[null,{"$f":"'예산 요약'!B3","v":"회사 이름"}]
[]
[null,"월 및 연도별 실제 데이터와 목표 데이터를 보여주는 막대형 차트가 이 셀에 나타납니다."]

{"sheet":"잔액 차트","index":2,"n_rows":5,"n_cols":9,"rows_kept":5,"merged":[[4,1,4,8]]}
[]
[null,"잔액 시트 요약 차트",{"$nulls":6},{"$f":"'예산 요약'!I2","v":2019}]
[null,{"$f":"'예산 요약'!B3","v":"회사 이름"}]
[]
[null,"월간 실제 데이터와 목표 데이터를 보여주는 막대형 차트가 이 셀에 나타납니다."]