查詢結果分析
來源資料
頁籤選單縮合
題 名 | 以電子試算表建立配送車隊數量指派模式之研究=A Study of Establishing the Delivery Fleet Assignment Models by Using Spreadsheets |
---|---|
作 者 | 李宗儒; | 書刊名 | 農林學報 |
卷 期 | 48:4 1999.12[民88.12] |
頁 次 | 頁69-77 |
分類號 | 431.25 |
關鍵詞 | 電子試算表; 配送車隊; 指派模式; 數學規劃模式; 模擬; Spreadsheet; Delivery fleet; Assignment model; Mathematical model; Simulation; |
語 文 | 中文(Chinese) |
中文摘要 | 本研究建立二個數學模式,(u)及(v),來代表某生產合作社之配送車隊數量指 派模式。但由於模式(u)及(v)中皆有非線性函數在,因此,本研究以Excel之電子試算 表之RAND及VLOOKUP二函數功能作為求解此二模式之基礎。經由實例之測試,可得知 利用Excel之電子試算表來求解,如同進行模擬之過程,且不需與其它軟體配合,因此具有 易學、低成本之效果,實值在實務界上推廣。 |
英文摘要 | In this research, we establish two mathematical models, (u) and (v), to represent the delivery fleet assignment models for a cooperative in Taiwan. Since the objectives of models (u) and (v) are nonlinear, RAND and VLOOKUP functions of spreadsheets of Microsoft Excel are used to solve these two models. Based on our test, simulation process can be made by using spreadsheet of Excel in order to solve models (u) and (v). Spreadsheet of Excel is easy to learn at a low cost. Therefore, the procedure used in this paper can be promoted to use in the agricultural industry in order to determine the optimal number of vehicles in each route. |
本系統中英文摘要資訊取自各篇刊載內容。