/*! 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-15OQ Historical demand for a product ... [FREE SOLUTION] | 91Ó°ÊÓ

91Ó°ÊÓ

Historical demand for a product is:

Month

Demand

January

12

February

11

March

15

April

12

May

16

June

15

a. Using a weighted moving average with weights of 0.60, 0.30, and 0.10, find the July forecast.

b. Using a simple three-month moving average, find the July forecast.

c. Using single exponential smoothing witha= 0.2 and a June forecast =13, find the July forecast. Make whatever assumptions you wish.

d. using simple linear regression analysis, calculate the regression equation for the preceding demand data.

e. using the regression equation in d, calculate the forecast for July.

Short Answer

Expert verified

Demand forecasting is the process of using predictive analysis of historical data to estimate and predict customers' future demand for a product or service. Demand forecasting helps the business make better-informed supply decisions that estimate the overall sales and revenue for a future period of your time.

Step by step solution

01

a) Using a weighted moving average with weights of 0.60, 0.30, and 0.10, find the July forecast

The weighted moving average is an indicator that is accustomed generates trade directions and making a buy or sells decision. It assigns greater weighting to recent data and less weighting to past data. The weighted moving average is calculated by multiplying each observation within the information set by a predetermined weighting factor.

By using a weighted moving average with weights of 0.60, 0.30, and 0.10, the July forecast is as follows:

F (July) = .60(15) + .30(16) + .10(12)

= 15.0

02

b) Using a simple three-month moving average, find the July forecast

Amoving average could be a calculation to investigate data points by creating a series of averages of various subsets of the complete data set. It's also called a moving mean.

By using a simple three-month moving average, the July forecast is as follows:

July = (15 + 16 + 12) / 3 = 14.3

03

c) The July forecast (By Using single exponential smoothing with a= 0.2 and a June forecast =13)

Single exponential smoothing is the most employed in all forecasting techniques. It’s an integral part of all electronic forecasting programs, and it is widely employed in ordering inventory in retail businesses, manufacturing units, and repair agencies.

Using single exponential smoothing witha= 0.2 and a June forecast =13, the July forecast is:

F(July) = F(June) +a(A(June) – F(June)

F(July) = 13 + 0.2(15-13)

F(July) = 13.4

July forecast = 13.4

04

d) The regression equation (By using simple linear regression analysis)

Simple linear regression could be a tool of statistics accustomed help predict future values from past values. It’s commonly used as a quantitative way to find the underlying trend and when prices are overextended.

x¯=3.5y¯=13.5a=∑y-b∑xn=y¯-bx¯=10.8b=∑xy-nxy¯∑x-nx¯=297-47.25*691-12.25*6=0.77so,y=10.8+0.77x

05

(e) the forecast for July (By using the regression equation in d)

Theregression equation is the algebraic expression of the regression lines. It's accustomed predict the values of the variable quantity from the given values of independent variables.

By using regression equation y = 10.8+0.77x, the forecast for July is explained as below-

F(July) = a+bx

F(July) =10.8+0.77*7

F(July) =16.19

The forecast for july is 16.19

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

Palin’s Muffler Shop has one standard muffler that fits a large variety of cars. The shop wishes to establish a periodic review system to manage the inventory of this standard muffler. Use the information in the following table to determine the optimal inventory target level (or order-up-to level).

Annual demand

3,000 mufflers

Ordering cost

\(50 per order

The standard deviation of daily demand

6 mufflers per working day

Service probability

90%

Item cost

\)30 per muffler

Lead time

2 working days

Annual holding cost

25% of the item value

Working days

300 per year

Review period

15 working days

a. What is the optimal target level (order-up-to level)?

b. If the service probability requirement is 95 percent, the optimal target level [your answer in part (a)] will (select one):

I. Increase.

II. Decrease.

III. Stay the same.

From the choice of a simple moving average, weighted moving average, exponential smoothing, and linear regression analysis, which forecasting technique would you consider the most accurate? Why?

Lieutenant Commander Data is planning to make his monthly (every 30 days) trek to Gamma Hydra City to pick up a supply of isolines chips. The trip will take Data about two days. Before he leaves, he calls in the order to the GHC Supply Store. He uses chips at an average rate of five per day (seven days per week) with a standard deviation of demand of one per day. He needs a 98 percent service probability. If he currently has 35 chips in inventory, how many should he order? What are the most he will ever have to order?

Zeus Computer Chips, Inc., used to have major contracts to produce the Centrino-type chips. The market has been declining during the past three years because of the quad-core chips, which it cannot produce, so Zeus has the unpleasant task of forecasting next year. The task is unpleasant because the firm has not been able to find replacement chips for its product lines. Here is demand over the past 12 quarters:

Two

Yearsago

Last year

This year

I

4800

I

3500

I

3200

II

3500

II

2700

II

2100

III

4300

III

3500

III

2700

IV

3000

IV

2400

IV

1700

Use the decomposition technique to forecast demand for the next four quarters.

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

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.