BUS520 Module 2 Case Assignment V1 - Revised.xlsx

BUS520 Module 2 Case Assignment V1 - Revised.xlsx - New...

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

View Full Document Right Arrow Icon
New Star Grocery Company Year 1 Customers Sales ($000) Number Month January 185 $230 1 January 185 February 241 $301 2 February 241 March 374 $310 3 March 374 April 421 $389 4 April 421 May 425 $421 5 May 425 June 259 $300 6 June 259 July 298 $318 7 July 298 August 321 $298 8 August 321 September 215 $202 9 September 215 October 282 $265 10 October 282 November 235 $312 11 November 235 December 300 $298 12 December 300 Totals 3556 Mean 296 X-bar 0.6480 111.65 Y= b0+ b1x Customers (x) b 1 b 0 200 250 300 350 400 450 185 241 374 421 425 259 $230 $301 $310 $389 $421 $300 Customer Traffic and S
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
January February March April May June 0 50 100 150
Image of page 2
y Sales (y) XY Forecast F(t) Variance $230 42,550.0 34,225 52,900 231.52 -1.52 $301 72,541.0 58,081 90,601 267.81 33.19 $310 115,940.0 139,876 96,100 353.99 -43.99 $389 163,769.0 177,241 151,321 384.45 4.55 $421 178,925.0 180,625 177,241 387.04 33.96 $300 77,700.0 67,081 90,000 279.48 20.52 $318 94,764.0 88,804 101,124 304.75 13.25 $298 95,658.0 103,041 88,804 319.65 -21.65 $202 43,430.0 46,225 40,804 250.96 -48.96 $265 74,730.0 79,524 70,225 294.38 -29.38 $312 73,320.0 55,225 97,344 263.92 48.08 $298 89,400.0 90,000 88,804 306.04 -8.04 3644 1,122,727.0 1,119,948 1,145,268.00 303.67 (0.00) 303.67 Y-bar X 2 Y 2 298 321 215 282 235 300 $318 $298 $202 $265 $312 $298 Sales Year One
Image of page 3

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

View Full Document Right Arrow Icon
July August September October November December
Image of page 4
Insert chart here SUMMARY OUTPUT Regression Statistics Multiple R 0.8473464781 R Square 0.7179960539 Adjusted R Square 0.6897956593 Standard Error 33.038511983 Observations 12 ANOVA df SS MS F Significance F Regression 1 27791.23392593 27791.233926 25.460496699 0.0005023037 Residual 10 10915.43274073 1091.5432741 Total 11 38706.66666667 150 200 250 300 350
Image of page 5

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

View Full Document Right Arrow Icon
Image of page 6
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