Question: Given the following history, develop a forecast for the 3rd quarter this year using a 3 quarter weighted moving average. Weight the most recent quarter

"Given the following history, develop a forecast for the 3rd quarter this year using a 3 quarter weighted moving average. Weight the most recent quarter .25, the second most recent .25, and the third .5. Solve the problem using quarters. Note: 1st quarter is Jan, Feb, Mar; 2nd quarter is April, May, June; 2rd quarter is July, August, September; 4th quarter is October, November, December. 2020: Jan 100, Feb 125, Mar 135, April, 175, May 185, June 200, July 150, August 140, Sept 130, Oct 200, Nov 200, Dec 300 - 2021: Jan 150, Feb 135, mar 115, April 290, May 200, June 150"

A. 595

B. 175

C. 100

D. 320

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

2 Here are the data for the past 21 months for actual sales of a particular product: LAST YEAR THIS YEAR January 300 275 February 400 375 March 425 350 April 450 425 400 400 May 400 June 460 June 350...

Given the following history, use a three- quarter moving average to forecast the demand for the third quarter of this year. Note, the 1st quarter is Jan, Feb, and Mar; 2nd quarter Apr, May, Jun; 3rd...

1 Given the following history, use a three-quarter moving average to forecast the demand for the third quarter of this year. Note, the 1st quarter is Jan, Feb, and Mar: 2nd quarter Apr. May, Jun; 3rd...

Given the following history, use a three-quarter moving average to forecast the demand for the third quarter of this year. Note, the 1st quarter is Jan, Feb, and Mar; 2nd quarter Apr, May, Jun; 3rd...

In Problems 5-17 and 5-18. three different forecasts were developed for the demand for fertilizer. These three forecasts are a 3-year moving average, a weighted moving average, and a trend line....

1. Even though independent gasoline stations have been having a difficult time, Susan Solomon has been thinking about starting her own independent gas station. Susans problem is to decide how large...

Holmes Corporation is a leading designer and manufacturer of material handling and processing equipment for heavy industry in the United States and abroad. Its sales have more than doubled, and its...

Global Touch Corporation (GTC) is one of Canada's largest public companies. GTC provides end users with networking capabilities through its system of copper and coaxial cable lines. GTC operates in...

At the end of 2002, Todd Pickett, CFO of Dell Mercosur, was faced with conflicting predictions of the value of the Brazilian currency, the real, and what to do to hedge Dells operation in Brazil....

Doug Brenhouse leaned back in his office chair and took a moment to himself away from the turmoil involved with the biggest decision of his professional life. Should he and his two cofounders, John...

The following figure shows a port address decoder interfaced to an 8086 CPU, (According to text book) Data Bun 01 02 CILSB) A2 74LS13 40 D7 Oin 06 07 Onta pu 14 What is the instruction that glows the...

Alpha Centauri, a star close to our solar system, is about 4.3 light-years away. Suppose a spaceship traveled this distance at a constant speed of 0.90c relative to Earth. (a) How long did the trip...

why would a company opt to sell to many countries

Oust the Turtle Company has the following balances on December 31, 2020: Cash on hand 4,500.00 Cash in bank A 33,000.00 Cash in bank X 50,000.00 Cash in bank C 822,999.72 Cash on hand includes $ 3....