Logo
Home Study Material Contact Search
AI Chat FREE
  1. mathematics
  2. basic math
  3. please answer the following: united dairies, inc.,

Please answer the following: United Dairies, Inc., supplies milk to several independent grocers throughout Dade County,...

60.1K

Verified Solution

Question

Basic Math

Please answer the following: United Dairies, Inc., supplies milkto several independent grocers throughout Dade County, Florida.Managers at United Dairies want to develop a forecast of the numberof half gallons of milk sold per week. Sales data for the past 12weeks are:

Week

Sales

1

2,750

2

3,100

3

3,250

4

2,800

5

2,900

6

3,050

7

3,300

8

3,100

9

2,950

10

3,000

11

3,200

12

3,150

1. Compute four-week and five-weekmoving averages for the time series.

    1. Compute the MSE for the four-week and five-week moving averageforecasts.
    2. What appears to be the best number of weeks of past data(three, four, or five) to use in the moving average computation?The MSE for three weeks is 23527.78
  2. Show the exponential smoothing forecasts using ? = 0.1.
    1. Applying the MSE measure of forecast accuracy, would you prefera smoothing constant of ?=0.1 or ?= 0.2 for the United Dairiessales time series?
    2. Are the results the same if you apply MAE as the measure ofaccuracy?
    3. What are the results if MAPE is used?
  3. Use exponential smoothing with a ? = 0.4 to develop a forecastof demand for week 13. What is the resulting MSE?

PLEASE USE EXCEL AND ANSWER EACH PARTOF THE QUESTION. THANKS !

ANSWER- THAT'S WHAT I GOT SO FAR:

Average=>117.1919,238.283.8%101.4316300.003.21%
MAEMSEMAPEMAEMSEMAPE

Answer & Explanation Solved by verified expert
4.2 Ratings (846 Votes)
4 weeks moving the average5    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Basic Math
1.2K views

Workers in a large plant are expected to complete a particular task in 60 seconds or...

Medical Sciences
1.2K views

What are the factors and circumstances that make sure we do not over clot or under...

Medical Sciences
1.2K views

Andre the Giant had a somatotropinoma, which is a tumor that secretes too much hormone on...

Physics
1.2K views

A block is at the base of of a ramp of angle 35°. The ramp is...

Geometry
1.2K views

Geometry For 25 28 tell whether the figure can be folded in half so that...

Basic Math
1.2K views

Select the correct term for the symbol below sample standard deviation population size sample size...

Basic Math
1.2K views

The following rule describes the relationship between and y.Rule: To find y add 2 to...

Basic Math
1.2K views

Use the LCD to rewrite 1/6 and 3/8 with the same denominator.

Accounting
1.2K views

Caf Tropical is a local restaurant specializing in tropical cuisine. Among its various Hawaiian-themed menu...

Accounting
1.2K views

Tory Company sells a single product. Troy estimates demand and costs at various activity levels...

Finance
1.2K views

In 2018, Georges income from his consulting business is $180,000. He also has interest income...

Accounting
1.2K views

Metlock Corporation has the following trading portfolio of debt investments as of December 31, 2020....