DS412 Midterm–takehome: forecasting: 10 points + 5 bonus points (LP) Fall 2015
Print out your results and bring them with you to the midterm. There will be additional questions on the midterm related to this analysis. You must hand in your take-home by the beginning of the test on October 8th. Late take-homes will not be accepted. You make work in groups of up to 4 people. If there is evidence of collaboration beyond that, either in that your group is larger than 4, or that you gave answers to other teams, you will get a 0 on the entire test (not just the take-home) and be reported for cheating. You will not be graded any differently whether you work individually or in a group, no matter what the group size is (as long as it’s 4 or less. Only one take-home per team should be turned in (If you have team members from both sections, someone must turn in the take-home at 8:10)
|
StinkE-Cheez is based in Marin County and sells a variety of cheeses made from organic, hormone-free milk. They have been tracking the monthly sales (measured in cases) for their cream cheese spread for the past year, as they would like to better predict demand. Use Excel to do the following, and show all forecasts and MADS to 2 decimal places: case |
|
|
Month-YY |
sales |
|
Oct-14 |
89 |
|
Nov-14 |
91 |
|
Dec-14 |
91 |
|
Jan-15 |
93 |
|
Feb-15 |
89 |
|
Mar-15 |
83 |
|
Apr-15 |
89 |
|
May-15 |
93 |
|
Jun-15 |
91 |
|
Jul-15 |
99 |
|
Aug-15 |
93 |
|
Sep-15 |
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.
[order_calculator]