Question: PROBLEM #3: The quarterly sales data for a gift item over the past three years are as follows. Calculate the Quarterly Centered Moving Average and

PROBLEM #3: The quarterly sales data for a gift item over the past three years are as follows.

Calculate the Quarterly Centered Moving Average and the average seasonal index for each quarter.

			Centered	Unadjusted
			Moving	Seasonal
	Period	Sales	Average	Index		Average
Year 1	Quarter 1	7320				Seasonal
	Quarter 2	5230			Period	Index
	Quarter 3	3380			Quarter 1
	Quarter 4	1280			Quarter 2
Year 2	Quarter 1	7640			Quarter 3
	Quarter 2	6230			Quarter 4
	Quarter 3	3230
	Quarter 4	1340
Year 3	Quarter 1	7380
	Quarter 2	4720
	Quarter 3	3700
	Quarter 4	1650

What isthe Centered Moving Average for Quarter 4 of Year 1?

QUESTION 27

What isthe Centered Moving Average for Quarter 2 of Year 2?

QUESTION 28

Whatisthe Centered Moving Average for Quarter 3 of Year 2?

QUESTION 29

What isthe Centered Moving Average for Quarter 4 of Year 2?

QUESTION 30

What is the Centered Moving Average for Quarter 1 of Year 3?

QUESTION 31

What isthe Centered Moving Average for Quarter 2 of Year 3?

QUESTION 32

What isthe average seasonal index for Quarter 1 is (round-off to 3 decimal places)?

QUESTION 33

What is the average seasonal index for Quarter 2 is (round-off to 3 decimal places)?

QUESTION 34

What is the average seasonal index for Quarter 3 is (round-off to 3 decimal places)?

QUESTION 35

What is the average seasonal index for Quarter 4 is (round-off to 3 decimal places)?

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 Mathematics Questions!

10) considering the experiment above You roll a fair 3-sided die (labelled 1, 2, and 3; pictured below) 3 times. Two possible outcomes are 122 and 321, rolling a 1 followed by two 2s and rolling a 3...

Question 8 Researchers watched dolphin groups off the coast of Ireland in 1998 to determine what activities the dolphin groups partake in at certain times of the day. The numbers in table below...

Suppose Gwen found the following summary statistics from two different, independent, approximately normally distributed populations, both with variances equal to sigma : Population 1: x1 = 126.77, s1...

PROBLEM #3: The quarterly sales data for a gift item over the past three years are as follows. Calculate the Quarterly Centered Moving Average and the average seasonal index for each quarter....

help please PROBLEM #3: The quarterly sales data for a gift item over the past three years are as follows. Calculate the Quarterly Centered Moving Average and the average seasonal index for each...

please i need the solution for problem iii thus, 11 through 14. thank you PROBLEM III. The quarterly sales data for a gift item over the past three years are as follows. year 1 year 2 year 3 3...

please explain answers solve the equation, using rhe graph provided with the questions below the chart PROBLEM 1: In an assembly line, there are 7 workstations, as shown below. In row 1, you are...

PROBLEM III. The quarterly sales data for a gift item over the past three years are as follows. year 1 year 2 year 3 Quarter 1 Quarter 2 Quarter 3 Quarter 4 1690 940 2625 2500 1800 900 2900 2360 1850...

Consider the distribution of Trypanosoma lengths shown by the density curve in Exercise 3.4.3. Suppose we take a sample of two trypanosomes. What is the probability that (a) Both trypanosomes will be...

Consider the reaction: 2Mg + O2 2MgO HRxn = -1204 kJ/mol. Suppose you react 2.43 g of Mg powder with 1.6 g of O2 in a calorimeter. It contains 500 ml of water and is equilibrated to a starting...

A firm's ROE is above the industry average but its profit margin and debt ratio are both below the industry average. Which of the following could explain that? Select one: a . Its asser turnover must...

Suppose the electric potential due to a certain charge distribution can be written in Cartesian Coordinates as V(xy,z)=2 x z$y4 . What is the magnitude of the electric field at the point (1,1,1)?...

An electric dipole consists of two charges +10C and -10 C separated by a distance 2 cm. Its center is on the x axis at x = 0 and it points along the x axis in the positive x direction. The dipole is...

An insulated solid sphere of radius R=1m has a uniform charge density. (total net charge 5 nC). Compute the electric potential inside the sphere at 0.271 m. (Take Coulomb's constant 9x10Nm?c?). Write...

Consider a metallic spherical shell of radius 26.23 mm and charge 6.94 nC, as shown in Figure. Find the electric potential energy of the system. (Take Coulomb's constant 9x10Nm?c2).Write your answer...

You are given the following information: Name UK Govt bonds 5 %, maturing 20 Oct 2018 |: Annual coupons Settlement date: 20 Oct 2014 Denomination: 1000 Yield to 7% Maturity (a) Calculate the Macaulay...

Determine if the overhead allocated to the product relates to a single plantwide overhead rate method, multiple production department factory overhead rate method, or activity-based costing...

The accompanying data resulted from a flammability study in which specimens of five different fabrics were tested to determine burn times. 17.8 16.2 15.9 15.5 213.2 10.4 11.3 Fabric 311.8 11.0 9.2...

The paper referenced in Exercise 15.5 described an experiment to determine if restrictive age labeling on video games increased the attractiveness of the game for boys age 12 to 13. In that exercise,...

Suppose that in a certain metropolitan area, 9 out of 10 households have cable television. Let x denote the number among four randomly selected households that have cable television, so x is a...