Reference no: EM13734866
Problem 1
a) Complete the following problems. The Homework Problems Rubric is in Doc Sharing.
• Problem 4.2 a, b and c
• Problem 4.6 a, b and c
• Problem 4.9 a, b, c and d
b) Starting in year 4 and going to year 12, forecast demand using a 3-year moving average. Plot your forecast on the same graph as the original data.
c) Starting in year 4 and going to year 12, forecast demand using a 3-year moving average with weights of .1, .3, and .6, using .6 for the most recent year. Plot this forecast on the same graph.
Problem 2
The monthly sales for Telco Batteries, Inc., were as follows:
Month Sales
January 20
February 21
March 15
April 14
May 13
June 16
July 17
August 18
September 20
October 20
November 21
December 23
a) Plot the monthly sales data.
b) Forecast January sales using each of the following:
ii) A 3-month moving average.
iii) A 6-month weighted average using .1, .1, .1, .2, .2, and .3, with the heaviest weights applied to the most recent months.
iv) Exponential smoothing using an α = .3 and a September forecast of 18.
v)A trend projection.
c) With the data given, which method would allow you to forecast next March's sales?
Problem 3
Dell uses the CR5 chip in some of its laptop computers. The prices for the chip during the past 12 months were as follows:
Month Price Per Chip Month Price Per Chip
January $1.80 July 1.80
February 1.67 August 1.83
March 1.70 September 1.70
April 1.85 October 1.65
May 1.90 November 1.70
June 1.87 December 1.75
a) Use a 2-month moving average on all the data and plot the averages and the prices.
b) Use a 3-month moving average and add the 3-month plot to the graph created in part (a).
c) Which is better (using the mean absolute deviation): the 2-month average or the 3-month average?
d) Compute the forecasts for each month using exponential smoothing, with an initial forecast for January of $1.80. Use α = .1, then α = .3, and finally α = .5. Using MAD, which α is the best?
|
Purchase or lease the equipment
: Management has decided to acquire a new asset that costs $200.000. The estimated economic life of the asset is five years. but the firm wants the use of the asset only for three years If the firm purchases the asset.
|
|
Approach for conducting research
: Explain your proposed approach for conducting research necessary to develop quality deliverables and explain how the information gleaned will support your career development in management. Please review the approach proposed by other students, pro..
|
|
Explanation of the emerging concept
: Discuss in detail to include a definition or explanation of the emerging concept, the importance it plays in the TLM field (currently), a forecast of where you see this heading in the future, and its potential future impact within the TLM field.
|
|
Gianna angelopoulous-daskalaki
: This module's reading focused on Gianna Angelopoulous-Daskalaki and how she led the bidding organization that secured the 2004 Olympics for Athens and then later the preparations for those Games. After substantial planning problems threatened to c..
|
|
Compute the forecasts for each month using exponential
: Compute the forecasts for each month using exponential smoothing, with an initial forecast for January of $1.80. Use α = .1, then α = .3, and finally α = .5. Using MAD, which α is the best
|
|
What year the treasury of petra jordan built
: what year the Treasury of Petra Jordan built?
|
|
Do rosa parks and hal cone share similar creative processes
: Do Rosa Parks and Hal COne share similar creative processes and/or environments?
|
|
What did thomas jefferson base his argument on
: In the declaration of independence what did Thomas jefferson base his argument on?
|
|
Performance appraisal process as new district manager
: You have been the manager of a Dunkin Donuts store in the Midwest for the past two years. The store is owned by a Dunkin Donuts franchisee who owns 20 other Dunkin Donuts locations. Your employer took an employee inventory and examined all current..
|