A SPREADSHEET APPROACH FOR INCORPORATING ACTUAL MOTOR CARRIER FREIGHT RATES AND EXTERNAL ENVIRONMENTAL COSTS IN A NEWSVENDOR MODEL

Andrew Manikas and Michael Godfrey

International Journal of Management and Marketing Research, 2018, vol. 11, issue 1, 55-72

Abstract: The purpose of this paper is to present a model for maximizing a retailer’s total expected profit using actual motor carrier freight rates and estimates of environmental costs associated with the transportation of a seasonal product. It is assumed that a single seasonal product is sold at a fixed price and demand for that product is normally distributed. Prior to the selling season, the retailer must determine how many units of the seasonal product to purchase from the supplier—therefore, the newsvendor model is appropriate for analyzing this problem. It is assumed that the retailer arranges and pays for transportation, i.e., the product is shipped free on board (FOB) Origin, Freight Collect from the supplier. Items unsold at the end of the season can be sold at a reduced price (salvaged). Actual freight rates are incorporated in the model by considering less-than-truckload discounts, fuel surcharges for both less-than-truckload (LTL) and truckload (TL) shipments, and over-declaring of shipments. All-units purchase quantity discounts are assumed also. Due to the nonlinear nature of motor carrier freight rates, this problem does not have a closed-form solution. Therefore, we present an Excel-based model for solving this problem. As demonstrated in the model solution, when environmental costs are considered, the buyer’s optimal purchase quantity decreases

Keywords: Newsvendor Model; Environmental Costs; Motor Career Freight Rates (search for similar items in EconPapers)
JEL-codes: C61 D21 L11 L81 (search for similar items in EconPapers)
Date: 2018
References: View references in EconPapers View complete reference list from CitEc
Citations:

Downloads: (external link)
http://www.theibfr2.com/RePEc/ibf/ijmmre/ijmmr-v11n1-2018/IJMMR-V11N1-2018-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:ijmmre:v:11:y:2018:i:1:p:55-72

Access Statistics for this article

International Journal of Management and Marketing Research is currently edited by Terrance Jalbert

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