TEACHING SUPPLY CHAIN MANAGEMENT STUDENTS ABOUT USING ACTUAL MOTOR CARRIER FREIGHT RATES IN PURCHASE LOTSIZING MODELS

Michael Godfrey and Andrew Manikas

Business Education and Accreditation, 2012, vol. 4, issue 2, 49-59

Abstract: In this paper, we analyze a purchase lot-sizing decision that includes transport cost using actual motor carrier freight rates. Lot-sizing models in the literature either estimate motor carrier freight rates with a continuous function or simplify less-than-truckload freight rates unrealistically by using too few weightbreak ranges. We present an Excel Solver model that we use in a supply chain management class to teach students the following principles: how to look up less-than-truckload freight rates using a carrier’s software, how to calculate less-than-truckload and truckload freight rates, to decide whether to overdeclare (artificially inflate) the weight of a less-than-truckload shipment to lower the freight charge, and how to find the purchase lot size that minimizes annual logistics cost. We assume that all-units purchase quantity discounts are offered by the supplier and the product is shipped Free On Board (FOB) Origin, Freight Collect. We discuss how to solve this model with Excel’s GRG Nonlinear Solver.

Keywords: Excel Solver; linear programming; logistics; purchase lot-sizing (search for similar items in EconPapers)
JEL-codes: A22 C61 C88 N72 (search for similar items in EconPapers)
Date: 2012
References: View references in EconPapers View complete reference list from CitEc
Citations:

Downloads: (external link)
http://www.theibfr2.com/RePEc/ibf/beaccr/bea-v4n2-2012/BEA-V4N2-2012-5.pdf (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:ibf:beaccr:v:4:y:2012:i:2:p:49-59

Access Statistics for this article

Business Education and Accreditation is currently edited by Terrance Jalbert

More articles in Business Education and Accreditation from The Institute for Business and Finance Research
Bibliographic data for series maintained by Mercedes Jalbert ( this e-mail address is bad, please contact ).