Find forecasts using three and five period moving average

Assignment Help Operation Management

Reference no: EM131911756

Question: 1. The ABC Floral Shop sold the following number of geraniums during the last two weeks:

Develop a spreadsheet for the following.

a. Calculate forecasts using a three- and five-period moving average.

b. Graph these forecasts and the original data using Excel. What does the graph show?

c. Which of the above forecasts is best? Why?

2. The Handy-Dandy Department Store had forecast sales of $110,000 for the previous week. The actual sales were $130,000.

a. What is the forecast for this week, using exponential smoothing and α = .1?

b. If sales this week turn out to be $120,000, what is the forecast for next week?

Reference no: EM131911756

Questions Cloud

Quantity of cartons per year need to supply to break even : Assuming that the price per carton is $17.20, find the quantity of cartons per year you need to supply to break even.

Bank standard terms for commercial mortgages : Assume that a seller is asking $30,000,000 for an office building. The following are the bank’s standard terms for commercial mortgages:

Which value of a gives the best forecast : Calculate the forecast using a = .2 and a = .3. Which value of a gives the best forecast, assuming actual demand is 95,000 gallons?

Calculate the expected rate on five-year treasury bond : Calculate the expected rate on a 5-year Treasury bond purchased five years from today, E(5r5).

Find forecasts using three and five period moving average : Calculate forecasts using a three- and five-period moving average. Graph these forecasts and the original data using Excel. What does the graph show?

According to unbiased expectations theory : According to the unbiased expectations theory, what is the 1-year forward rate for the period beginning one year from today, 2f1?

Assume that the maturity risk premium is zero : The Wall Street Journal reports that the current rate on 9-year Treasury bonds is 6.10 percent, Assume that the maturity risk premium is zero.

Prepare three-period moving-average forecasts for the data : The number of daily calls for the repair of Speedy copy machines has been recorded as follows: Prepare three-period moving-average forecasts for the data.

How cpfr can be used to reduce forecasting error : Explain how CPFR can be used to reduce forecasting error. Question 2? In the Stokely Company, marketing makes a sales forecast by developing a sales force.

User Account

All Pages