Do Inventory and Gross Margin Data Improve Sales Forecasts for U.S. Public Retailers?

Saravanan  Kesavan; Vishal  Gaur; Ananth   Raman

Article | Management Science | September 2010

Do Inventory and Gross Margin Data Improve Sales Forecasts for U.S. Public Retailers?

by Saravanan Kesavan, Vishal Gaur and Ananth Raman

Abstract

Firm-level sales forecasts for retailers can be improved if we incorporate cost of goods sold, inventory, and gross margin (defined here as the ratio of sales to cost of goods sold) as three endogenous variables. We construct a simultaneous equations model, estimated using public financial and non-financial data, to provide joint forecasts of annual cost of goods sold, inventory, and gross margin for retailers using historical data. We show that sales forecasts from this model are more accurate than consensus forecasts from equity analysts. Further, the residuals from this model for one fiscal year are used to predict retailers for whom the relative advantage of model forecasts over consensus forecasts would be large in the next fiscal year. Our results show that historical inventory and gross margin contain information useful to forecast sales, and that equity analysts do not fully utilize this information in their sales forecasts.

Keywords: Sales; Forecasting and Prediction; Distribution; Goods and Commodities; Cost; Public Sector; Profit; Mathematical Methods; Data and Data Sets; Retail Industry; United States;

Format: Print

Find at Harvard

Citation:

Kesavan, Saravanan, Vishal Gaur, and Ananth Raman. "Do Inventory and Gross Margin Data Improve Sales Forecasts for U.S. Public Retailers?" Management Science 56, no. 9 (September 2010).

In 2016, David Hysong, at age 27, found out he had a rare, incurable cancer. Rather than wait around to die, Hysong, a recent graduate of Harvard Divinity School, decided to launch a biotechnology company called Shepherd Therapeutics to development treatments for his and other rare cancers. Two years later, the company had several drugs in promising stages of development but were at least 3 to 5 years away from commercialization, if they made it through clinical trials successfully. Only about 4% of drugs that enter clinical trials receive U.S. FDA approval. It is October 2018, and Shepherd is running out of money. Hysong needs to raise $5 million to fund operations for 2019 and at least $20 million for the following few years. But the company is too early to attract the type of venture capital he needs. Even if he got financing, Hysong worried that the company’s mission could be compromised by investors more interested in a return on their investment than saving lives, and he worried about the scaling challenges ahead.

This paper introduces methods for increasing the efficiency of retail store liquidation, which we define as the time-constrained divestment of retail outlets through an in-store sale of inventory. The retail industry depends extensively on liquidation, not only as a means for investors to recover capital from failed ventures, but also to allow managers of going concerns to divest stores in efforts to enhance performance and to change strategy. The operations literature has examined product liquidation, but retail store liquidation differs significantly. This paper augments the literature by introducing techniques for improving operating decisions during retail store liquidations and by demonstrating the performance of these methods in the field.

Faculty & Research

Do Inventory and Gross Margin Data Improve Sales Forecasts for U.S. Public Retailers?

Abstract

Citation:

About the Author

More from the Author