Question

In: Math

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

Please answer the following: United Dairies, Inc., supplies milk to several independent grocers throughout Dade County, Florida. Managers at United Dairies want to develop a forecast of the number of half gallons of milk sold per week. Sales data for the past 12 weeks 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-week moving averages for the time series.

    1. Compute the MSE for the four-week and five-week moving average forecasts.
    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
  1. Show the exponential smoothing forecasts using α = 0.1.
    1. Applying the MSE measure of forecast accuracy, would you prefer a smoothing constant of α=0.1 or α= 0.2 for the United Dairies sales time series?
    2. Are the results the same if you apply MAE as the measure of accuracy?
    3. What are the results if MAPE is used?
  2. Use exponential smoothing with a α = 0.4 to develop a forecast of demand for week 13. What is the resulting MSE?

PLEASE USE EXCEL AND ANSWER EACH PART OF THE QUESTION. THANKS !

ANSWER- THAT'S WHAT I GOT SO FAR:

Average=> 117.19 19,238.28 3.8% 101.43 16300.00 3.21%
MAE MSE MAPE MAE MSE MAPE

Solutions

Expert Solution

4 weeks moving the average

5 weeks moving an average

Exponential smoothing with alpha = 0.01

Exponential smoothing with alpha = 0.02

Exponential smoothing with alpha = 0.04


Related Solutions

Please answer the following: United Dairies, Inc., supplies milk to several independent grocers throughout Dade County,...
Please answer the following: United Dairies, Inc., supplies milk to several independent grocers throughout Dade County, Florida. Managers at United Dairies want to develop a forecast of the number of half gallons of milk sold per week. Sales data for the past 12 weeks 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 . Show the exponential smoothing forecasts using α =...
Please answer the following: United Dairies, Inc., supplies milk to several independent grocers throughout Dade County,...
Please answer the following: United Dairies, Inc., supplies milk to several independent grocers throughout Dade County, Florida. Managers at United Dairies want to develop a forecast of the number of half gallons of milk sold per week. Sales data for the past 12 weeks 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-week moving averages for the...
Shamrock Burrito Inc. sells franchises to independent operators throughout the northwestern part of the United States....
Shamrock Burrito Inc. sells franchises to independent operators throughout the northwestern part of the United States. The contract with the franchisee includes the following provisions. 1. The franchisee is charged an initial fee of $120,000. Of this amount, $20,000 is payable when the agreement is signed, and a $100,000 zero-interest-bearing note is payable with a $20,000 payment at the end of each of the 5 subsequent years. The present value of an ordinary annuity of five annual receipts of $20,000,...
1. ABC Toy Store, Inc. operates several retail locations throughout the county. The data below represents...
1. ABC Toy Store, Inc. operates several retail locations throughout the county. The data below represents its labor cost for the first six months of 2019 at its store. Month Labor Cost Sales   ------------   -----------------------   ------------------ January $ 183,000 $ 570,000 February 190,000 600,000 March 178,000 550,000 April 187,000 590,000 May 140,000 400,000 June 167,000 510,000 a. Using the high-low method, estimate the fixed and variable components of labor cost .  Express the cost behavior in equation form. b. Draw a...
Sunland Enterprises, Inc. operates several stores throughout the western United States. As part of an operational...
Sunland Enterprises, Inc. operates several stores throughout the western United States. As part of an operational and financial reporting review in a response to a downturn in its markets, the company’s management has decided to perform an impairment test on five stores (combined). The five stores’ sales have declined due to aging facilities and competition from a rival that opened new stores in the same markets. Management has developed the following information concerning the five stores as of the end...
Please answer the following: How do the economic systems of Russia, the United States, the United...
Please answer the following: How do the economic systems of Russia, the United States, the United Kingdom vary? How do political policies, property rights, and public choice system in Russia, the United States, the United Kingdom relate or differ? Any help is appreciated, I always give a thumbs up too, thank you!
Please answer the following as detailed as possible: (1) A history of Taxation in the United...
Please answer the following as detailed as possible: (1) A history of Taxation in the United States including the recent IRC revision (2) Taxation in the European Union (3) Your opinion on the impact of the revision of the 2017 U.S. tax code (4) Current status of Global taxation considering the facts of the case study and other accounting literature.
Kindly answer the following questions in each of the following independent questions:a. Hess Inc. sells a...
Kindly answer the following questions in each of the following independent questions:a. Hess Inc. sells a single product with a contribution margin of P12 per unit and fixed costs of P74,400 and sales for the current year of P100,000. How much is the Hess‟ breakeven point? b. Hartley Inc. has one product with a selling price per unit of P200, the unit variable cost is P75, and the total monthly fixed costs are P300,000. How much is the Hartley‟s contribution...
In several paragraphs, please answer the following case study question to the best of your ability....
In several paragraphs, please answer the following case study question to the best of your ability. In answering these case study questions, students are reminded that they need to refer to ethical theories (Bentham, Mill, Kant, Rawls, and Aristotle) and inherent values (Life, Happiness, Equal Worth and Autonomy) to justify their answers. They may also refer to specific articles we have read and discussed in class. You work at a small tech company that is creating an app that would...
Please answer the following: How do the economic systems of the United States, China, and Russia...
Please answer the following: How do the economic systems of the United States, China, and Russia vary? How do political policies in the United States compare to China and Russia? (references would be much appreciated)
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT