Develop a forecast of demand

Assignment Help Business Management
Reference no: EM133045779

United Dairies, Inc., supplies milk to several independent grocers throughout Dade Country, 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 following. 

a) Construct a time series plot. What type of pattern exists in the data? 

b) Use exponential smoothing with alpha = 0.6 to develop a forecast of demand for 13 week. 

c) Use exponential smoothing with alpha = 0.4 to develop a forecast of demand for 13 week. 

d) Using MSE, which one provides the most accurate forecast for the data? Explain.

Please use Excel for the calculations

Week

Sales

1

2750

2

3100

3

3250

4

2800

5

2900

6

3050

7

3300

8

3100

9

2950

10

3000

11

3200

12

3150

Reference no: EM133045779

Questions Cloud

Determine the initial net cash outlfow for project : California Pellet Mill Company, a major manufacturer of pellet mills, has introduced a new pellet mill that is rated at 10.6 tons per hour. Based on the current
Develop plan proposal detailing leadership assessment : For a Transformational leadership style develop a plan proposal detailing the following leadership assessment and actions necessary for effective leading of the
Explain the concept of objectification : Explain the concept of objectification. How did it relate to the video you watched. (You may want to cite an outside source for this part of the reflection.)
Case study-five star development : Visit the website of a small software company, Five Star Development, and review their internal promotion of the reasons to join their organization.
Develop a forecast of demand : United Dairies, Inc., supplies milk to several independent grocers throughout Dade Country, Florida. Managers at United Dairies want to develop a forecast of th
Is conflict within organizations a good thing or a bad thing : Is conflict within organizations a good thing or a bad thing? Explain your answer and provide examples.
Explain systems decathlon has adopted : Describe and explain systems Decathlon has adopted or implemented (or lack of systems) as part of a more sustainable approach to business?
What is the reporting timeline : Describe and explain what has been captured in Decathlon under the EMS Reporting in terms of Waste, Water, Energy?
Evaluation of integration management concepts : Critical Analysis and Evaluation - Critical evaluation of integration management concepts and its impact on project success

Reviews

Write a Review

Business Management Questions & Answers

  General dividend valuation model

1. According to the general dividend valuation model, a firm that reinvests all its earnings and pays no cash dividends can still have a common stock value greater than zero. How is this possible?

  What is walt henderson attitude toward work

What is Walt Henderson's attitude toward work? What are the main components of Walt Henderson's attitude toward work?

  Describe how to plate the dessert with artistic flair

Describe how to plate the dessert with artistic flair. Include any garnishes or decorations. what can you add to add texture/colour etc

  Variety of foods and beverages around the world

PepsiCo Inc. is an American multinational corporation that offers a variety of foods and beverages around the world.

  Balanced scorecard approach to evaluate

The balanced scorecard as applied to an health industry or field. For instance, if you work in the healthcare fields, you may want to explore how physician

  Entire organization is focused on total quality

How internal politics and conflict can affect an organization as it completes a turn-around plan to ensure that entire organization is focused on Total Quality

  How are the decisions made about the levels of resources

Does cooperation/competition require equal resources from all partners? How are the decisions made about the levels of resources committed by each partner?

  Devise a retail promotion mix plan for the business

CASE 1: Choose a retail business (take away, restaurant, clothing, groceries, electronics etc ) that you want to start in Uzbekistan and answer the following qu

  Explain a discontinuous change in which you have

explain a discontinuous change in which you have participated or even championed. what might have gone differently if

  Steps in the typical buying process

List and describe in your own words the steps in the typical buying process. How does the type of buying situation affect these steps?

  What would you to detect and remove the threat

What would you to detect and remove the threat. This is a zero day attack, so there is no "commercial" solution. You are on your own.

  Profit entrepreneurship with-bleeding heart philanthropy

Do you remember the proverb declaring that if you give a mana a fish , you feed him for a day: if you teach him how to fish, you feed him for a lifetime

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd