HP Forecast.xlsx - Quarter 2013/1 2013/2 2013/3 2013/4...

Info icon This preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Quarter Sales Step 1 Average trend per period 2013/1 95 5.25 2013/2 125 Step 2 Seasonality Factor 2013/3 189 2013 2014 2015 2013/4 150 1 95 84 113 97.33333 2014/1 84 2 125 163 153 147 2014/2 163 3 189 190 203 194 2014/3 190 4 150 179 192 173.6667 2014/4 179 153 2015/1 113 Step 3 Last period sales without SF 2015/2 153 169.15163 2015/3 203 Step 4 Add trend component for the forecat horizon 2015/4 192 2016/1 174.40163 110.9483 2016/2 179.65163 172.6065 2016/3 184.90163 234.4504 2016/4 190.15163 215.8366 2017/1 195.40163 124.3078 2017/2 200.65163 192.7829 2017/3 205.90163 261.0779 2017/4 211.15163 239.6732
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
2016/1 234.4504 2016/2 215.8366 2016/3 124.3078 2016/4 192.7829 0.636166 0.960784 1.267974 Opening Stock
Image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern