Is there a strong linear trend in sales over time

Assignment Help Operation Management

Reference no: EM131353380

Storrs Cycles has just started selling the new Cyclone mountain bike, with monthly sales as shown in the table. First, co-owner Bob Day wants to forecast by exponential smoothing by initially setting February's forecast equal to January's sales with a = .1. Co-owner Sherry Snyder wants to use a three-period moving average.

	SALES	BOB	SHERRY	BOB'S ERROR	SHERRY'S ERROR
JANUARY	400	-
FEBEAURY	380	400
MARCH	410
APRIL	375
MAY

a) Is there a strong linear trend in sales over time?

b) Fill in the table with what Bob and Sherry each forecast for May and the earlier months, as relevant.

c) Assume that May's actual sales figure turns out to be 405. Complete the table's columns and then calculate the mean absolute deviation for both Bob's and Sherry's methods.

d) Based on these calculations, which method seems more accurate?

Reference no: EM131353380

Questions Cloud

Where might jefferson have fought against his successors : Other than ceasefire, what do you feel is the most significant cultural result of the War of 1812 on today? Why?Did Madison, Monroe, and John Quincy Adams successfully represent the Party as Jefferson intended when he founded it? Where might Jeffers..

Calculate the change of melting temperature : If the change in specific volume on melting is -9.05 x 10-5 m3 Ikg, then calculate the change of melting temperature due to change of pressure.

Using an after tax ROR analysis : Your real-estate company is considering buying a $5 million dollar hotel. The company already pays taxes at the highest scale. The hotel is expected to earn $20 million dollars (in today’s dollars) every year and have expenses of $17 million dollars ..

Find the angular velocity of the bar in position 2 when the : A thin, homogeneous bar having a mass of M and length L is pinned to ground at its mass center G. Particle B, having a mass of m, is rigidly attached to the right end of the bar. When the bar is horizontal (Position 1 shown below), the spring is uns..

Is there a strong linear trend in sales over time : Storrs Cycles has just started selling the new Cyclone mountain bike, with monthly sales as shown in the table. Is there a strong linear trend in sales over time? Fill in the table with what Bob and Sherry each forecast for May and the earlier months..

Obtain the cost of the equity capital : If the RTY Corp. follows CAPM and has a beta of 2.0, and the market ans risk-free rate of return are 14 and 8 percent, respectively. Obtain the cost of the equity capital for the RTY Corporation.

Calculate the activation energy : Rate constants, in s^-1, for a reaction were determined over the temperature range of 700.0 to 1000.0 K. A linear fit of In K vs. 1/T yielded a slope of -13500.0 K and intercept of 15.7. Calculate the activation energy (Ea) and frequency factor (A..

What would the chromaticity diagram look like : Suppose instead that the domains overlapped so that red was defined on [500, 600], green on [450, 550], and blue on [400, 500]. What would the chromaticity diagram look like? How many primaries would be needed to faithfully reproduce every color p..

User Account

All Pages