Time series analysis of ice cream production

Reference no: EM1396231

The Bee line Café is well known for its popular homemade ice cream, which it makes in a small plant in back of the café. People drive long distance to buy the ice cream. The two ladies who own the café want to develop a forecasting model so they can plan their ice cream production and determine the number of employees they need to sell ice cream in the café. They have accumulated sales records for their ice cream for the past 12 quarters.

Develop:

a) an exponential smoothing model (= 0.50)

b) moving average model (k = 4)

c) a trend model; and

d) a seasonally adjusted model to forecast demand.

Assess the accuracies of the models by using Bias, MAD, MAPD.

Quarter Ice Cream Sales (gal)

1 350

2 510

3 750

4 420

5 370

6 480

7 860

8 500

9 450

10 550

11 820

12 570

Reference no: EM1396231

Questions Cloud

Explain the extent to which leader cares about subordinates : Explain the extent to which the leader cares about subordinates, respects their ideas and feelings, and establishes mutual trust.

Show the genotypes of the p, f1 and f2 generations : Wild-type fruit flies have brick-red eyes. A pure-breeding strain of wild-type flies was crossed with a pure-breeding strain with white eyes.

Logic of the ordinary least square : Explain the logic of the ordinary least Square (OLS) method? How are the least squares formulas for the slope and intercept derived?

What is the likely origin of the recombinants : In peas, the genes a, b, c, d, e and f are linked on chromosome V and in the order given and the map distances are RF(a-b)=7 cM, RF(b-c) = 17 cM, RF(c-d) = 12 cM, RF (d-e) = 14 cM RF(e-f)= 10 cM.

Time series analysis of ice cream production : The Bee line Café is well known for its popular homemade ice cream, which it makes in a small plant in back of the café. People drive long distance to buy the ice cream.

Proportion of viewers watching the channels : At the .05 significance level, is there a difference in the proportion of viewers watching the three channels?

Find primary determinant of the fate of pyruvic acid : Possible fates of pyruvic acid in a bactrium? What is the primary determinant of the fate of pyruvic acid? What is the fate of compounds to which pyruvic acid may be converted?

Develop a linear regression model : Carpet City wants to develops a means to forecast it carpet sale. The store manager believes that the store's sale are directly related to the number of new housing starts in town.

Describe sealed and unsealed tubes : All enterics are facultative anaerobes; that is, they have both respiratory and fermentative enzymes. What color results would you expect for organisms in O-F glucose media inoculated with an enteric.

User Account

All Pages