{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["經濟訂購量","圖表分析","巨集"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":16,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"圖表分析","index":1,"reason":"not_a_worksheet"},{"sheet":"巨集","index":2,"reason":"part_missing"}],"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":"經濟訂購量","index":0,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":false,"merged":[[0,0,0,6],[2,0,2,5],[3,1,3,5],[4,0,4,5],[5,1,5,5],[6,1,6,5],[9,0,9,5],[10,1,10,5],[7,0,7,5],[8,1,8,7],[37,1,37,10],[28,1,28,2],[19,1,19,5],[11,1,11,5],[12,1,12,5],[13,1,13,5],[18,0,18,5]]}
["經濟採購分析",null,null,null,null,null,null,null," "]
[]
["操作指引："]
[null,"您可按垂直捲軸，依序往下捲動各項內容，或依您所需選按各項按鈕。"]
["模式目的："]
[null,"(1).依據存貨基本資料，求算最適經濟訂購量水準。"]
[null,"(2).以圖表顯示各類成本變化。"]
["應用時機："]
[null,"企業機構進行最適存貨訂購決策分析。"]
["模式假設："]
[null,"根據存貨管理理論，本經濟訂購量模式具下列基本假設："]
[null,"(1).材料單價不變。"]
[null,"(2).材料使用十分平均。"]
[null,"(3).依據前項假設，經濟採購量之公式為："]
[]
[null,"    "]
[]
[null,"                            "]
["基本資料："]
[null,"請於下表儲存格(字形為紅色者)中，輸入各項實際之數值："]
[null,"基本資料："]
[null,"本期間估計之存貨需要量",null,null,null,12000]
[null,"存貨每單位成本",null,null,null,80]
[null,"每一訂單之訂購成本",null,null,null,1000]
[null,"存貨持有成本率(平均存貨投資之百分比 )",null,null,null,0.2]
[]
["運算解答："]
[null,"依據上列基本資料，可得出下列解答："]
[null,"解答"]
[null,"經濟訂購量",{"$f":"SQRT((2*需要量*每次訂購成本)/(每單位存貨成本*存貨投資百分比))","v":1224.744871391589}]
[null,"訂購成本",{"$f":"(需要量/經濟採購量)*每次訂購成本","v":9797.9589711327135}]
[null,"持有成本",{"$f":"(經濟採購量/2)*每單位存貨成本*存貨投資百分比","v":9797.9589711327117}]
[null,"總變動成本 ",{"$f":"C31+C32","v":19595.917942265427}]
[null,"總成本 ",{"$f":"總變動成本+經濟採購量*每單位存貨成本","v":117575.50765359255}]
[]
["繪圖資料："]
[null,"下列表格係用以繪製圖表之用，使用者勿需進行修改。"]
[null,"繪圖資料"]
[null,"訂購次數",{"$f":"2*G39","v":19.595917942265427},{"$f":"1.75*G39","v":17.146428199482248},{"$f":"1.5*G39","v":14.696938456699069},{"$f":"1.25*G39","v":12.247448713915892},{"$f":"需要量/經濟採購量","v":9.7979589711327133},{"$f":"7/8*G39","v":8.5732140997411239},{"$f":"6/8*G39","v":7.3484692283495345},{"$f":"5/8*G39","v":6.123724356957946},{"$f":"4/8*G39","v":4.8989794855663567}]
[null,"訂購量",{"$f":"需要量/訂購次數","v":612.37243569579448},699.8542122237651,816.49658092772597,979.79589711327117,1224.744871391589,1399.7084244475302,1632.9931618554519,1959.5917942265423,2449.4897427831779]
[null,"訂購成本",{"$f":"訂購次數*每次訂購成本","v":19595.917942265427},17146.428199482249,14696.938456699068,12247.448713915892,9797.9589711327135,8573.2140997411243,7348.4692283495342,6123.7243569579459,4898.9794855663567]
[null,"持有成本",{"$f":"訂購量/2*每單位存貨成本*存貨投資百分比","v":4898.9794855663558},5598.8336977901208,6531.9726474218078,7838.3671769061693,9797.9589711327117,11197.667395580242,13063.945294843616,15676.734353812339,19595.917942265423]
[null,"總變動成本",{"$f":"訂購成本_PC+持有成本_HC","v":24494.897427831784},22745.261897272369,21228.911104120874,20085.815890822061,19595.917942265427,19770.881495321366,20412.414523193151,21800.458710770283,24494.89742783178]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"`"]