/*! This file is auto-generated */ .wp-block-button__link{color:#fff;background-color:#32373c;border-radius:9999px;box-shadow:none;text-decoration:none;padding:calc(.667em + 2px) calc(1.333em + 2px);font-size:1.125em}.wp-block-file__button{background:#32373c;color:#fff;text-decoration:none} Q10OQ The number of cases of merlot wi... [FREE SOLUTION] | 91影视

91影视

Log out

Learning Materials

Features

Discover

Chapter 4: Q10OQ (page 476)

The number of cases of merlot wine sold by the Connor Owen winery in eight years is as follows:

Using an exponential smoothing model with an alpha value of 0.20, estimate the smoothed value calculated as of the end of 2012. Use the average demand for 2005 through 2007 as your initial forecast, and then smooth the forecast forward to 2012.

Short Answer

Expert verified

Answer

The smoothed value calculated at the end of 2012 is shown in step 2.

Step by step solution

01

Definition of exponential smoothing model

Exponential smoothing could be a rule of thumb technique for smoothing time series data using the exponential window function.

02

Explanation

Forecasts have been rounded to integer values, which may result in minor rounding differences. F (4) is calculated as average demand from years 1-3. Later forecasts are based on a simple exponential smoothing model with alpha = .20.

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with 91影视!

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

Dunstreet鈥檚 Department Store would like to develop an inventory ordering policy with a 95 percent probability of not stocking out. To illustrate your recommended procedure, use as an example the ordering policy for white percale sheets. The demand for white percale sheets is 5,000 per year. The store is open 365 days per year. Every two weeks (14 days) inventory is counted and a new order is placed. It takes 10 days for the sheets to be delivered. The standard deviation of demand for the sheets is five per day. There are currently 150 sheets on hand. How many sheets should you order?

Question: Which qualitative forecasting technique was developed to ensure that the input from every participant in the process is weighted equally?

Questions: How many steps are there in collaborative planning, forecasting, and replenishment (CPFR)?

Charlie鈥檚 Pizza orders all of its pepperoni, olives, anchovies, and mozzarella cheese to be shipped directly from Italy. An American distributor stops by every four weeks to take orders. Because the orders are shipped directly from Italy, they take three weeks to arrive. Charlie鈥檚 Pizza uses an average of 150 pounds of pepperoni each week, with a standard deviation of 30 pounds. Charlie鈥檚 prides itself on offering only the best quality ingredients and a high level of service, so it wants to ensure a 98 percent probability of not stocking out on pepperoni. Assume that the sales representative just walked in the door and there are currently 500 pounds of pepperoni in the walk-in cooler. How many pounds of pepperoni would you order?

Consider using a simple moving average model. Experiment with models using five weeks鈥� and three weeks鈥� past data. The past data in each region are given below (week 21 is the week before week 1 in the table, 22 is two weeks before week 1, etc.). Evaluate the forecasts that would have been made over the 13 weeks using the overall (at the end of the 13 weeks) mean absolute deviation, mean absolute percent error, and tracking signal as criteria.

WEEK

-5

-4

-3

-2

-1

Atlanta

45

38

30

58

37

Boston

62

18

48

40

35

Chicago

62

22

72

44

48

Dallas

42

35

40

64

48

LA

43

40

54

46

35

Total

254

153

244

252

198
See all solutions

Recommended explanations on Business Studies Textbooks

Intermediate Accounting

Read Explanation

Operational Management

Read Explanation

Human 91影视

Read Explanation

Project Planning & Management

Read Explanation

Financial Performance

Read Explanation

Business Operations

Read Explanation
View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.