Advertisement

Forecasting in the Supply Chain Environment

  • David Frederick Ross

Abstract

Much of the success of enterprise planning and decision-making processes depends on the formulation of accurate forecasts. Although it has often been said that nothing happens until a company receives a customer order, unless the enterprise has developed sound plans that enable it to purchase the proper inventory, establish the necessary supply channels, and deliver goods on a competitive basis, the business cannot possibly hope to achieve corporate objectives. In addition, forecasting permits firms to establish performance measurements for customer service, plan the level of total inventory investment, choose between alternative operating strategies, and develop assumptions about the ability of the business to respond to the future needs of the marketplace.

Supplementary material

978-1-4899-7578-2_5_MOESM1_ESM.docx (3.3 mb)
Discussion Questions – Answers (DOCX 3331 kb)
978-1-4899-7578-2_5_MOESM2_ESM.xlsx (10 kb)
Problem 5.1 (XLSX 9 kb)
978-1-4899-7578-2_5_MOESM3_ESM.xlsx (10 kb)
Problem 5.2 (XLSX 10 kb)
978-1-4899-7578-2_5_MOESM4_ESM.xlsx (10 kb)
Problem 5.3 (XLSX 9 kb)
978-1-4899-7578-2_5_MOESM5_ESM.xlsx (10 kb)
Problem 5.4 (XLSX 10 kb)
978-1-4899-7578-2_5_MOESM6_ESM.xlsx (10 kb)
Problem 5.5 (XLSX 10 kb)
978-1-4899-7578-2_5_MOESM7_ESM.xlsx (10 kb)
Problem 5.6 (XLSX 10 kb)
978-1-4899-7578-2_5_MOESM8_ESM.xlsx (10 kb)
Problem 5.7 (XLSX 10 kb)
978-1-4899-7578-2_5_MOESM9_ESM.xlsx (9 kb)
Problem 5.8 (XLSX 9 kb)
978-1-4899-7578-2_5_MOESM10_ESM.xlsx (10 kb)
Problem 5.9 (XLSX 9 kb)
978-1-4899-7578-2_5_MOESM11_ESM.xlsx (10 kb)
Problem 5.10 (XLSX 10 kb)
978-1-4899-7578-2_5_MOESM12_ESM.xlsx (10 kb)
Problem 5.11 (XLSX 10 kb)
978-1-4899-7578-2_5_MOESM13_ESM.xlsx (11 kb)
Problem 5.12 (XLSX 10 kb)
978-1-4899-7578-2_5_MOESM14_ESM.xlsx (20 kb)
Exercises 5.1, 5.2 (XLSX 20 kb)
978-1-4899-7578-2_5_MOESM15_ESM.xlsx (17 kb)
Exercise 5.3 (XLSX 17 kb)
978-1-4899-7578-2_5_MOESM16_ESM.xlsx (17 kb)
Exercise 5.4 (XLSX 16 kb)
978-1-4899-7578-2_5_MOESM17_ESM.xlsx (18 kb)
Exercise 5.5 (XLSX 17 kb)
978-1-4899-7578-2_5_MOESM18_ESM.xlsx (15 kb)
Exercise 5.6 (XLSX 15 kb)
978-1-4899-7578-2_5_MOESM19_ESM.xlsx (15 kb)
Exercise 5.7 (XLSX 14 kb)
978-1-4899-7578-2_5_MOESM20_ESM.xlsx (16 kb)
Exercise 5.8 (XLSX 15 kb)
978-1-4899-7578-2_5_MOESM21_ESM.xlsx (14 kb)
Exercise 5.9 (XLSX 14 kb)
978-1-4899-7578-2_5_MOESM22_ESM.xlsx (16 kb)
Exercise 5.10 (XLSX 15 kb)
978-1-4899-7578-2_5_MOESM23_ESM.xlsx (161 kb)
Forecast Excel (XLSX 160 kb)
978-1-4899-7578-2_5_MOESM24_ESM.docx (3.6 mb)
Test Database (DOCX 3726 kb)
978-1-4899-7578-2_5_MOESM25_ESM.xlsx (12 kb)
Chapter 5: Case Study – Solution (XLSX 11 kb)
978-1-4899-7578-2_5_MOESM26_ESM.pptx (2 mb)
Chapter 5 (PPTX 2056 kb)

References

  1. 1.
    All references to the APICS Dictionary in this chapter are from the 14th edition (2013).Google Scholar
  2. 2.
    Some of these characteristics are identified in Makridakis, Spyros, and Steven Wheelwright. 1989. Forecasting methods for management, 26–28. New York: John Wiley & Sons.Google Scholar
  3. 3.
    The descriptions of qualitative methods are summarized from Makridakis and Wheelwright, 240–275 and DeLurgio, Stephen A., and Carl D. Bhame. 1991. Forecasting systems for inventory management, 201–204. Homewood: Business One Irwin.Google Scholar
  4. 4.
    Key references used in the writing of this section are Makridakis and Wheelwright, 170–191; DeLurgio and Bhame, 261–286; Jacobs, F. Robert, William L. Berry, D. Clay Whybark, and Thomas E. Vollmann. 2011. Manufacturing planning and control for supply chain management: APICS/CPIM certification edition, 79–91. New York: McGraw-Hill; Heizer, Jay, and Barry Render. 2004. Principles of operations management, 5th ed, 25–136. Upper Saddle River: Pearson-Prentice Hall; and Lind, Douglas A., William G. Marchal, and Samuel A. Wathen. 2010. Statistical techniques in business and economics, 14th ed, 454–563. Boston: McGraw-Hill Irwin.Google Scholar
  5. 5.
    DeLurgio and Bhame, 244–245.Google Scholar
  6. 6.
    Reference Jacobs, et al., 86–90 and Lind, et al., 612–622.Google Scholar
  7. 7.
    Reference DeLurgio and Bhame, 198–201; Makridakis and Wheelwright, 52–53; and Lind, et al., 455–491.Google Scholar
  8. 8.
    See the discussion in Plossl, George W. 1967. Production and inventory control, 2nd ed, 106–108. Upper Saddle River: Prentice Hall and Heizer and Render, 130–131.Google Scholar

Copyright information

© Springer Science+Business Media New York 2015

Authors and Affiliations

  • David Frederick Ross
    • 1
  1. 1.APICSChicagoUSA

Personalised recommendations