# #2 The number of cans of soda sold in a machine each week is recor...

## Question

#2
The number of cans of soda sold in a machine each week is recorded below:
338, 219, 278, 265, 314, 323, 299, 259, 287, 302
A. Develop forecasts using a three-period moving average (MSE).
B. How many cans are expected to be sold in time frame 11?

#3
The number of new contributors to a public radio station's annual fund drive over the last ten years is 63, 58, 61, 72, 98, 103, 121, 147, 163, 198.
Calculate the MSE for a 3 & 4 week moving average.
Which weighted moving average is better and why?
Predict next year's number of new contributors.
The probabilities for 3 year are .20, .35, .45 and for 4-year are .15, .35, .30, .20

#4
Compute MAE, MSE, MAPE using the most recent value calculation.
Compute the forecast value for day 13.
Use a 2-day weighted moving average.
Probabilities are .45 and .55.

Day      1   2   3   4   5   6    7   8   9   10   11   12
Value 20 32 45 63 27 94 47 40 55   38 28 33

## 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.

# 50% discount

Hours
Minutes
Seconds
\$45.00 \$22.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.