/*! 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} Q18-6OQ Question: The following tabulati... [FREE SOLUTION] | 91Ó°ÊÓ

91Ó°ÊÓ

Question: The following tabulations are actual sales of units for six months and a starting forecast in January.


ACTUAL
FORECAST
January
100
80
February
94

March
106

April
80

May
68

June
94

a. Calculate forecasts for the remaining five months using simple exponential smoothing with α= 0.2.

b. Calculate MAD for the forecasts.

Short Answer

Expert verified

Answer

(a) Forecasts for the remaining five months = 80, 84, 86, 90, 88, 84

(b) MAD = 15

Step by step solution

01

Step-by-Step Solution Step 1: (a) Calculate forecasts for the remaining five months using simple exponential smoothing

The formula shown below is used for the calculation of the forecasts for the remaining five months by using simple exponential smoothing with α= 0.2.

Ft+1=Ft+αAt-Ft,α=.20

02

(b) Formula for calculating MAD for the forecasts

The formula for calculating MAD for the forecasts is shown below:


MAD=SumofabsolutevalueofeachdeviationNoofdeviationMAD=20+10+20+10+20+106=906=15

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

Charlie’s 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’s Pizza uses an average of 150 pounds of pepperoni each week, with a standard deviation of 30 pounds. Charlie’s 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?

Questions: What is the first step in CPFR?

Sally’s Silk Screening produces specialty T-shirts that are primarily sold at special events. She is trying to decide how many to produce for an upcoming event. During the event, Sally can sell T-shirts for \(20 apiece. However, when the event ends, any unsold T-shirts are sold for \)4 apiece. It costs Sally $8 to make a specialty T-shirt. Sally’s estimate of demand is the following:

Demand

Probability

300

.05

400

.10

500

.40

600

.30

700

.10

800

.05

a. What is the service rate (or optimal fractile)?

Annual demand for a product is 13,000 units; weekly demand is 250 units with a standard deviation of 40 units. The cost of placing an order is \(100, and the time from ordering to receipt is four weeks. The annual inventory carrying cost is \)0.65 per unit. To provide a 98 percent service probability, what must the reorder point be? Suppose the production manager is told to reduce the safety stock of this item by 100 units. If this is done, what will the new service probability be?

These are the six major components of demand?

See all solutions

Recommended explanations on Business Studies Textbooks

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.