# Marcello’s Bella Gelato is a manufacturer of gourmet ice crea...

## Question

Marcello’s Bella Gelato is a manufacturer of gourmet ice cream, sorbet, and other frozen desserts. People drive long distances to buy their ice cream and other assorted deserts. A new manager at one of the plants wants to develop a forecasting model so that he can plan the ice cream production operation and determine the number of employees that would be needed. The ice cream sales record for the past 12 quarters is provided in a table below. To assist him with his plans, develop forecasts using the following:

a) (3 points) a naïve model

b) (3 points) a moving average model (n = 4)

c) (3 points) a weighted moving average model (wt-1 = 0.25; wt-2 = 0.35; wt-3 = 0.25; wt-4 = 0.15)

d) (3 points) an exponential smoothing model (alpha= 0.50; F1 = A1)

e) (3 points) a simple linear trend model (not seasonally adjusted); and

f) (3 points) determine the seasonal indices and seasonal factors for each quarter

g) (3 points – bonus) use the solution in part (f) to determine a seasonally adjusted forecast.
For each of the models above, provide the following measures of forecast accuracy: Bias, MAD, MAPE. Which model do you recommend to him for this data set?

Quarter       Ice Cream Sales (000) (gal)
1                   385
2                   560
3                   825
4                   460
5                   410
6                   530
7                   945
8                   550
9                   495
10                  605
11                  905
12                  630

## Solution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

By purchasing this solution you'll be able to access the following files:
Solution.xlsx and Solution1.xlsx.

# 50% discount

Hours
Minutes
Seconds
\$35.00 \$17.50
for this solution

or FREE if you
register a new account!

PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

### Find A Tutor

View available Operations Management Tutors

Get College Homework Help.

Are you sure you don't want to upload any files?

Fast tutor response requires as much info as possible.