Slide 1
Department of SCMS XXXXXXXXXXXiaowei XuRutgers
1
Project Guidelines
http:
images.google.com/imgres?imgurl=http:
www.geocities.com
uwomenshockey/Rutgers_R_-_1_in.jpg&imgrefurl=http:
www.geocities.com
uwomenshockey
oster.html&h=266&w=300&sz=34&tbnid=68URYnvhrxcJ:&tbnh=98&tbnw=111&hl=en&start=39&prev=/images%3Fq%3DR%2Brutgers%26start%3D20%26svnum%3D10%26hl%3Den%26lr%3D%26sa%3DN
http:
images.google.com/imgres?imgurl=http:
www.geocities.com
uwomenshockey/Rutgers_R_-_1_in.jpg&imgrefurl=http:
www.geocities.com
uwomenshockey
oster.html&h=266&w=300&sz=34&tbnid=68URYnvhrxcJ:&tbnh=98&tbnw=111&hl=en&start=39&prev=/images%3Fq%3DR%2Brutgers%26start%3D20%26svnum%3D10%26hl%3Den%26lr%3D%26sa%3DN
Department of SCMS XXXXXXXXXXXiaowei XuRutgers
2
What to do?
• Objective: Forecast ca
truck sales; balance sales with production and
inventory (S&OP) in the three NA countries; calculate days sales in
inventory
• Data Sources: Wards Auto
• Data Range: XXXXXXXXXXmonthly)
• Time Series Methods: MA(12) and exponential smoothing (Simple,
Holt’s and Winter’s)
• Make a presentation XXXXXXXXXXminutes, ~30 slides, Apr 19, 23, 26 or 30)
• Write a report (~ 20 pages) and follow the project format in Slides 5-
6.
http:
images.google.com/imgres?imgurl=http:
www.geocities.com
uwomenshockey/Rutgers_R_-_1_in.jpg&imgrefurl=http:
www.geocities.com
uwomenshockey
oster.html&h=266&w=300&sz=34&tbnid=68URYnvhrxcJ:&tbnh=98&tbnw=111&hl=en&start=39&prev=/images%3Fq%3DR%2Brutgers%26start%3D20%26svnum%3D10%26hl%3Den%26lr%3D%26sa%3DN
http:
images.google.com/imgres?imgurl=http:
www.geocities.com
uwomenshockey/Rutgers_R_-_1_in.jpg&imgrefurl=http:
www.geocities.com
uwomenshockey
oster.html&h=266&w=300&sz=34&tbnid=68URYnvhrxcJ:&tbnh=98&tbnw=111&hl=en&start=39&prev=/images%3Fq%3DR%2Brutgers%26start%3D20%26svnum%3D10%26hl%3Den%26lr%3D%26sa%3DN
Department of SCMS XXXXXXXXXXXiaowei XuRutgers
3
The Basic S&OP Grid
History is included to
highlight past plan-to-
actual performance
Inventory Plan = Planned
Opening Inventory + Planned
Production - Planned Sales
Actual Inventory = Opening
Inventory + Actual Production -
Actual Sales
http:
images.google.com/imgres?imgurl=http:
www.geocities.com
uwomenshockey/Rutgers_R_-_1_in.jpg&imgrefurl=http:
www.geocities.com
uwomenshockey
oster.html&h=266&w=300&sz=34&tbnid=68URYnvhrxcJ:&tbnh=98&tbnw=111&hl=en&start=39&prev=/images%3Fq%3DR%2Brutgers%26start%3D20%26svnum%3D10%26hl%3Den%26lr%3D%26sa%3DN
http:
images.google.com/imgres?imgurl=http:
www.geocities.com
uwomenshockey/Rutgers_R_-_1_in.jpg&imgrefurl=http:
www.geocities.com
uwomenshockey
oster.html&h=266&w=300&sz=34&tbnid=68URYnvhrxcJ:&tbnh=98&tbnw=111&hl=en&start=39&prev=/images%3Fq%3DR%2Brutgers%26start%3D20%26svnum%3D10%26hl%3Den%26lr%3D%26sa%3DN
Department of SCMS XXXXXXXXXXXiaowei XuRutgers
4
Inventory Turnove
Inventory turnover=
Cost of Goods Sold from Stock Sales during the Past 12 Months
Average Inventory Investment during the Past 12 Months
Days sales in inventory=365/Inventory turnove
http:
images.google.com/imgres?imgurl=http:
www.geocities.com
uwomenshockey/Rutgers_R_-_1_in.jpg&imgrefurl=http:
www.geocities.com
uwomenshockey
oster.html&h=266&w=300&sz=34&tbnid=68URYnvhrxcJ:&tbnh=98&tbnw=111&hl=en&start=39&prev=/images%3Fq%3DR%2Brutgers%26start%3D20%26svnum%3D10%26hl%3Den%26lr%3D%26sa%3DN
http:
images.google.com/imgres?imgurl=http:
www.geocities.com
uwomenshockey/Rutgers_R_-_1_in.jpg&imgrefurl=http:
www.geocities.com
uwomenshockey
oster.html&h=266&w=300&sz=34&tbnid=68URYnvhrxcJ:&tbnh=98&tbnw=111&hl=en&start=39&prev=/images%3Fq%3DR%2Brutgers%26start%3D20%26svnum%3D10%26hl%3Den%26lr%3D%26sa%3DN
Department of SCMS XXXXXXXXXXXiaowei XuRutgers
5
Team Project – Report Format
• Your project must be word-processed using a standard font
(e.g., TimesNewRoman 12) and double-spaced.
• All charts, data sheets and tables (if any) should be done on
the computer. Graphs and charts should have a title and
properly and clearly labeled.
• All pages must be numbered.
• Order of pages:
– COVER SHEET—The first page of your project must be a cover sheet
that includes your name(s), date, the title of your project and the
percentage contribution of each team member’s effort .
– EXECUTIVE SUMMARY - Briefly describe the problem, your time
series models, results and recommendation to managers.
– TABLE OF CONTENTS
http:
images.google.com/imgres?imgurl=http:
www.geocities.com
uwomenshockey/Rutgers_R_-_1_in.jpg&imgrefurl=http:
www.geocities.com
uwomenshockey
oster.html&h=266&w=300&sz=34&tbnid=68URYnvhrxcJ:&tbnh=98&tbnw=111&hl=en&start=39&prev=/images%3Fq%3DR%2Brutgers%26start%3D20%26svnum%3D10%26hl%3Den%26lr%3D%26sa%3DN
http:
images.google.com/imgres?imgurl=http:
www.geocities.com
uwomenshockey/Rutgers_R_-_1_in.jpg&imgrefurl=http:
www.geocities.com
uwomenshockey
oster.html&h=266&w=300&sz=34&tbnid=68URYnvhrxcJ:&tbnh=98&tbnw=111&hl=en&start=39&prev=/images%3Fq%3DR%2Brutgers%26start%3D20%26svnum%3D10%26hl%3Den%26lr%3D%26sa%3DN
Department of SCMS XXXXXXXXXXXiaowei XuRutgers
6
Team Project – Report Format
Order of pages:
• INTRODUCTION, PROBLEM, PURPOSE—This section should include the
statements of the project problem, goal and the data source.
• FINDINGS— Describe and visualize trends and seasonality. Calculate annual
sales growth and summarize the growth trend. Formulate quantitative models
and conduct quantitative analysis using Excel. Explain your findings and how
your findings could be helpful for managers.
• CONCLUSION—what can you conclude or not conclude from your research
and recommend the solution to production/sales managers.
• REFERENCE—citations and websites refe
ed if any.
• APPENDICES—attach anything technical or supplementary (e.g., spreadsheet
models and explanations).
Hand in a hard copy of your project and send me the electronic
version of your files, including excel spreadsheets (if any), the
project report and ppt presentation on May 3.
http:
images.google.com/imgres?imgurl=http:
www.geocities.com
uwomenshockey/Rutgers_R_-_1_in.jpg&imgrefurl=http:
www.geocities.com
uwomenshockey
oster.html&h=266&w=300&sz=34&tbnid=68URYnvhrxcJ:&tbnh=98&tbnw=111&hl=en&start=39&prev=/images%3Fq%3DR%2Brutgers%26start%3D20%26svnum%3D10%26hl%3Den%26lr%3D%26sa%3DN
http:
images.google.com/imgres?imgurl=http:
www.geocities.com
uwomenshockey/Rutgers_R_-_1_in.jpg&imgrefurl=http:
www.geocities.com
uwomenshockey
oster.html&h=266&w=300&sz=34&tbnid=68URYnvhrxcJ:&tbnh=98&tbnw=111&hl=en&start=39&prev=/images%3Fq%3DR%2Brutgers%26start%3D20%26svnum%3D10%26hl%3Den%26lr%3D%26sa%3DN
Department of SCMS XXXXXXXXXXXiaowei XuRutgers
7
Ca
Truck Models
• Car (15): Charger, Focus, Fusion, Mustang, Camaro, Impala,
Malibu, Accord, Civic, Elantra, Sonata, Altima, Sentra, Camry,
Corolla/Matrix
• Light Truck (21): Grand Cherokee, Ram Pickup Light-Duty,
Edge, Escape, Explorer, F-Series Pickup Light-Duty, Equinox,
Silverado, Tahoe, Traverse, Acadia, Sie
a, CR-V, Pilot, Santa
Fe, Sorento, Outback, Highlander, RAV4, Tacoma, Tundra
http:
images.google.com/imgres?imgurl=http:
www.geocities.com
uwomenshockey/Rutgers_R_-_1_in.jpg&imgrefurl=http:
www.geocities.com
uwomenshockey
oster.html&h=266&w=300&sz=34&tbnid=68URYnvhrxcJ:&tbnh=98&tbnw=111&hl=en&start=39&prev=/images%3Fq%3DR%2Brutgers%26start%3D20%26svnum%3D10%26hl%3Den%26lr%3D%26sa%3DN
http:
images.google.com/imgres?imgurl=http:
www.geocities.com
uwomenshockey/Rutgers_R_-_1_in.jpg&imgrefurl=http:
www.geocities.com
uwomenshockey
oster.html&h=266&w=300&sz=34&tbnid=68URYnvhrxcJ:&tbnh=98&tbnw=111&hl=en&start=39&prev=/images%3Fq%3DR%2Brutgers%26start%3D20%26svnum%3D10%26hl%3Den%26lr%3D%26sa%3DN
Department of SCMS XXXXXXXXXXXiaowei XuRutgers
8
http:
images.google.com/imgres?imgurl=http:
www.geocities.com
uwomenshockey/Rutgers_R_-_1_in.jpg&imgrefurl=http:
www.geocities.com
uwomenshockey
oster.html&h=266&w=300&sz=34&tbnid=68URYnvhrxcJ:&tbnh=98&tbnw=111&hl=en&start=39&prev=/images%3Fq%3DR%2Brutgers%26start%3D20%26svnum%3D10%26hl%3Den%26lr%3D%26sa%3DN
http:
images.google.com/imgres?imgurl=http:
www.geocities.com
uwomenshockey/Rutgers_R_-_1_in.jpg&imgrefurl=http:
www.geocities.com
uwomenshockey
oster.html&h=266&w=300&sz=34&tbnid=68URYnvhrxcJ:&tbnh=98&tbnw=111&hl=en&start=39&prev=/images%3Fq%3DR%2Brutgers%26start%3D20%26svnum%3D10%26hl%3Den%26lr%3D%26sa%3DN
Department of SCMS XXXXXXXXXXXiaowei XuRutgers
9
http:
images.google.com/imgres?imgurl=http:
www.geocities.com
uwomenshockey/Rutgers_R_-_1_in.jpg&imgrefurl=http:
www.geocities.com
uwomenshockey
oster.html&h=266&w=300&sz=34&tbnid=68URYnvhrxcJ:&tbnh=98&tbnw=111&hl=en&start=39&prev=/images%3Fq%3DR%2Brutgers%26start%3D20%26svnum%3D10%26hl%3Den%26lr%3D%26sa%3DN
http:
images.google.com/imgres?imgurl=http:
www.geocities.com
uwomenshockey/Rutgers_R_-_1_in.jpg&imgrefurl=http:
www.geocities.com
uwomenshockey
oster.html&h=266&w=300&sz=34&tbnid=68URYnvhrxcJ:&tbnh=98&tbnw=111&hl=en&start=39&prev=/images%3Fq%3DR%2Brutgers%26start%3D20%26svnum%3D10%26hl%3Den%26lr%3D%26sa%3DN
Department of SCMS XXXXXXXXXXXiaowei XuRutgers
10
http:
images.google.com/imgres?imgurl=http:
www.geocities.com
uwomenshockey/Rutgers_R_-_1_in.jpg&imgrefurl=http:
www.geocities.com
uwomenshockey
oster.html&h=266&w=300&sz=34&tbnid=68URYnvhrxcJ:&tbnh=98&tbnw=111&hl=en&start=39&prev=/images%3Fq%3DR%2Brutgers%26start%3D20%26svnum%3D10%26hl%3Den%26lr%3D%26sa%3DN
http:
images.google.com/imgres?imgurl=http:
www.geocities.com
uwomenshockey/Rutgers_R_-_1_in.jpg&imgrefurl=http:
www.geocities.com
uwomenshockey
oster.html&h=266&w=300&sz=34&tbnid=68URYnvhrxcJ:&tbnh=98&tbnw=111&hl=en&start=39&prev=/images%3Fq%3DR%2Brutgers%26start%3D20%26svnum%3D10%26hl%3Den%26lr%3D%26sa%3DN
Department of SCMS XXXXXXXXXXXiaowei XuRutgers
11
http:
images.google.com/imgres?imgurl=http:
www.geocities.com
uwomenshockey/Rutgers_R_-_1_in.jpg&imgrefurl=http:
www.geocities.com
uwomenshockey
oster.html&h=266&w=300&sz=34&tbnid=68URYnvhrxcJ:&tbnh=98&tbnw=111&hl=en&start=39&prev=/images%3Fq%3DR%2Brutgers%26start%3D20%26svnum%3D10%26hl%3Den%26lr%3D%26sa%3DN
http:
images.google.com/imgres?imgurl=http:
www.geocities.com
uwomenshockey/Rutgers_R_-_1_in.jpg&imgrefurl=http:
www.geocities.com
uwomenshockey
oster.html&h=266&w=300&sz=34&tbnid=68URYnvhrxcJ:&tbnh=98&tbnw=111&hl=en&start=39&prev=/images%3Fq%3DR%2Brutgers%26start%3D20%26svnum%3D10%26hl%3Den%26lr%3D%26sa%3DN
Department of SCMS XXXXXXXXXXXiaowei XuRutgers
12
Durable Goods
http:
images.google.com/imgres?imgurl=http:
www.geocities.com
uwomenshockey/Rutgers_R_-_1_in.jpg&imgrefurl=http:
www.geocities.com
uwomenshockey
oster.html&h=266&w=300&sz=34&tbnid=68URYnvhrxcJ:&tbnh=98&tbnw=111&hl=en&start=39&prev=/images%3Fq%3DR%2Brutgers%26start%3D20%26svnum%3D10%26hl%3Den%26lr%3D%26sa%3DN
http:
images.google.com/imgres?imgurl=http:
www.geocities.com
uwomenshockey/Rutgers_R_-_1_in.jpg&imgrefurl=http:
www.geocities.com
uwomenshockey
oster.html&h=266&w=300&sz=34&tbnid=68URYnvhrxcJ:&tbnh=98&tbnw=111&hl=en&start=39&prev=/images%3Fq%3DR%2Brutgers%26start%3D20%26svnum%3D10%26hl%3Den%26lr%3D%26sa%3DN
Department of SCMS XXXXXXXXXXXiaowei XuRutgers
13
http:
images.google.com/imgres?imgurl=http:
www.geocities.com
uwomenshockey/Rutgers_R_-_1_in.jpg&imgrefurl=http:
www.geocities.com
uwomenshockey
oster.html&h=266&w=300&sz=34&tbnid=68URYnvhrxcJ:&tbnh=98&tbnw=111&hl=en&start=39&prev=/images%3Fq%3DR%2Brutgers%26start%3D20%26svnum%3D10%26hl%3Den%26lr%3D%26sa%3DN
http:
images.google.com/imgres?imgurl=http:
www.geocities.com
uwomenshockey/Rutgers_R_-_1_in.jpg&imgrefurl=http:
www.geocities.com
uwomenshockey
oster.html&h=266&w=300&sz=34&tbnid=68URYnvhrxcJ:&tbnh=98&tbnw=111&hl=en&start=39&prev=/images%3Fq%3DR%2Brutgers%26start%3D20%26svnum%3D10%26hl%3Den%26lr%3D%26sa%3DN
Department of SCMS XXXXXXXXXXXiaowei XuRutgers
14
http:
images.google.com/imgres?imgurl=http:
www.geocities.com
uwomenshockey/Rutgers_R_-_1_in.jpg&imgrefurl=http:
www.geocities.com
uwomenshockey
oster.html&h=266&w=300&sz=34&tbnid=68URYnvhrxcJ:&tbnh=98&tbnw=111&hl=en&start=39&prev=/images%3Fq%3DR%2Brutgers%26start%3D20%26svnum%3D10%26hl%3Den%26lr%3D%26sa%3DN
http:
images.google.com/imgres?imgurl=http:
www.geocities.com
uwomenshockey/Rutgers_R_-_1_in.jpg&imgrefurl=http:
www.geocities.com
uwomenshockey
oster.html&h=266&w=300&sz=34&tbnid=68URYnvhrxcJ:&tbnh=98&tbnw=111&hl=en&start=39&prev=/images%3Fq%3DR%2Brutgers%26start%3D20%26svnum%3D10%26hl%3Den%26lr%3D%26sa%3DN