Exponential smoothing to forecast equipment

Assignment Help Operation Management
Reference no: EM13746430

1. National scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows:

Month

Sales

 

(units)

Feb

19

Mar

18

Apr

17

May

20

Jun

19

Jul

22

Aug

20

  1. Forecast September sales volume using the naïve approach.
  2. Forecast September sales volume using a linear equation. a=17.43, b = 0.46.
  3. Forecast September sales volume using a five-month moving average
  4. Forecast September sales volume using a weighted average using .60 for August, .30 for July, and .10 for June.
  5. Forecast September sales volume using Exponential smoothing with a smoothing constant equal to .20, assuming a March forecast of 19.

2, A dry cleaner uses exponential smoothing to forecast equipment usage at its main plant. August usage was forecast to be 88 percent of capacity; actual usage was 89.6 percent of capacity. A smoothing constant (Alpha) of .2 is used.

a.Prepare a forecast for September.

b.  Assuming actual September usage of 92 percent, prepare a forecast for October usage.

3. A cosmetics manufacturer's marketing department has developed a linear trend equation that can be used to predict annual sales of its popular Hand & Foot Cream.

Ft  =80+14t

Where

Ft   Annual forecast in sales (bottles)

t= 0 corresponds to 1990

a.    Predict annual sales for the year 2006 using the equation.

4.The manager of travel agency has been using a seasonally adjusted forecast to predict demand for packaged tours. The actual and predicted values are as follows:

Period

Demand

Predicted

1

129

124

2

194

200

3

156

150

4

91

94

5

85

80

6

132

140

7

126

128

8

126

124

9

95

100

10

149

150

a.    Compute MAD for the 5th  period

b.    Compute MAPE for the 10th period

Reference no: EM13746430

Questions Cloud

Discuss the ethical dilemma faced by jim fielding : Horizon Corporation manufactures personal computers. The company began operations in 2002 and reported profits for the years 2004 through 2009. Due primarily to increased competition and price slashing in the industry, 2010's income statement reporte..
Support capital budgeting decisions : In your initial post, identify and recommend at least 1 credible Web site that discusses the process of calculating the models most commonly used to support capital budgeting decisions, and address at least 3 of the following topics:
Stockholders equity section : On April 21, 2014, Alligator Corporation received a charter granting the right to issue 100,000 shares of $100 par value, 6% cumulative and nonparticipating preferred stock, and 1,000,000 shares of $1 par value common stock. It then Apr. 28 Issued 10..
Product or period cost and direct or indirect cost : For each item shown below, indicate whether it is a product cost or a period cost, by placing an X in the appropriate column. For each item that is a product cost, also indicate whether it is a direct cost or an indirect cost with respect to a unit o..
Exponential smoothing to forecast equipment : A dry cleaner uses exponential smoothing to forecast equipment usage at its main plant. August usage was forecast to be 88 percent of capacity; actual usage was 89.6 percent of capacity. A smoothing constant (Alpha) of .2 is used.
Discuss the changing role of women in the family : Discuss the changing role of women in the family. In what ways did the role of women in society change during this period? Did the role of women in the family change at all? If so, how?
Question regarding the edelman engineering : Edelman Engineering is considering including two pieces of equipment, a truck and an overhead pulley system, in this year's capital budget.
Uses a job order cost accounting system : FACTS: Samer Corp. uses a job order cost accounting system. The following is selected information pertaining to costs applied to jobs during the year. Jobs still in process at the end of the year: $167,000, which includes $65,000 direct labor costs. ..
Produces and sells two produtcs-standard and deluxe : Lincoln Corporation produces and sells two produtcs : Standard and Deluxe. The info on the two products sold for the last month is given below. The common fixed cost is $15,000.

Reviews

Write a Review

Operation Management Questions & Answers

  Identify an industry-business which engage in this practice

In a one to two page paper identify an industry/ business which engage in this practice. Is this a logical business plan. Why or why not. Illustrate what are your thoughts.

  Determnine the uniqueness of their supply chain design as

write 400-600 words that respond to the following questions with your thoughts ideas and comments. this will be the

  Who are the stakeholders of your selected organization

Select an organization. Who are the stakeholders of your selected organization? How would the stakeholders be affected by the failure of the organization to keep up with new technologies to keep the organization competitive?

  What are the pros and cons of using expatriates

What are the pros and cons of using expatriates, host-country nationals, and third-country nationals to run overseas operations?

  Pick three of the eight-step change theory components

Leaders can improve the chances for a successful change outcome by following Kotter's eight-step change theory. Pick three of the eight-step change theory components and give an example for each step that explains how leaders can implement it to e..

  Estimate theoretical minimum number of workstations

An assembly line is to be designed to operate 7 1/2 hours per day and supply a steady demand of 300 units per day. Here are the tasks and their performance times:

  Prepare a roll-up estimate of your project costs

Using a spreadsheet, prepare a roll-up estimate of your project costs. To prepare your estimate, follow these guidelines- Use a completely decomposed WBS as your basis.

  In what way does the clinical approach to selection

In what way does the clinical approach to selection differ from the statistical approach? How do you account for the fact that one approach is superior to the other?

  Illustrate what is the efficiency of the process

Illustrate what is the possible daily output of this "process" if 8 hours of processing time is available each day. Given your output in part a, illustrate what is the efficiency of the process.

  What is the process capability index

Linda Boardman, Inc., an equipment manufacturer in Boston, has submitted a sample cutoff valve to improve your manufacturing process.

  Illustrate what are the annual prices of this network

If, at most, 10 consultants are to be assigned to a home office, where should the offices be setup. Explain how many consultants should be assigned to each office. Illustrate what are the annual prices of this network.

  Avoid recruiting among organizational members

Are there any personality types that leaders should avoid recruiting among organizational members? Please provide reference sources for information provided.

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