c2m

profileTiti
excel.xlsx
Home>Business & Finance homework help>Management homework help>c2m

Mod 2 Case - LR - Year 1

New Star Grocery Company Insert chart here
Year 1 Customers Sales ($000) Number Month Customers (x) Sales (y) XY X2 Y2
January 185 230 1 January
February 241 301 2 February
March 374 310 3 March
April 421 389 4 April
May 425 421 5 May
June 259 300 6 June
July 298 318 7 July
August 321 298 8 August
September 215 202 9 September
October 282 265 10 October
November 235 312 11 November
December 300 298 12 December
Totals 0 0 - 0 - 0 - 0
Mean 0 0.00
X-bar Y-bar
b1 ERROR:#DIV/0!
b0 ERROR:#DIV/0!
Y= b0+ b1x

Year 2 Forecast

New Star Grocery Company
Sales
b1 ERROR:#DIV/0! Year 2 Customers (x) Actual Y(t) Forecast F(t) Variance
b0 ERROR:#DIV/0! January 215 ERROR:#DIV/0! ERROR:#DIV/0!
February 259 ERROR:#DIV/0! ERROR:#DIV/0!
Y= b0+ b1x March 325 ERROR:#DIV/0! ERROR:#DIV/0!
April 354 ERROR:#DIV/0! ERROR:#DIV/0!
May 258 ERROR:#DIV/0! ERROR:#DIV/0!
June 199 ERROR:#DIV/0! ERROR:#DIV/0!
July 254 ERROR:#DIV/0! ERROR:#DIV/0!
August 299 ERROR:#DIV/0! ERROR:#DIV/0!
September 264 ERROR:#DIV/0! ERROR:#DIV/0!
October 198 ERROR:#DIV/0! ERROR:#DIV/0!
November 223 ERROR:#DIV/0! ERROR:#DIV/0!
December 261 ERROR:#DIV/0! ERROR:#DIV/0!
Totals 259.08 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!