Need Help with Homework

profilejoesam
week_six_problem_sets.docx

Chapter 18 Exercise 2

 1.

value: 1.00 points

 

Listed below is the number of movie tickets sold at the Library Cinema-Complex, in thousands, for the period from 2001 to 2013. Compute a five-year weighted moving average using weights of 0.15, 0.15, 0.3, 0.16, and 0.24, respectively. Describe the trend in yield. (Round your answers to 3 decimal places.)

 

 

 

  2001

8.61  

  2002

8.14  

  2003

7.27  

  2004

6.59  

  2005

7.57  

  2006

6.98  

  2007

6.81  

  2008

6.41  

  2009

5.48  

  2010

5.77  

  2011

5.74  

  2012

5.39  

  2013

5.53  

 

The weighted moving averages are:

 

  

  

  

  

  

  

  

  

  

  

  There is a regular of approximately 0.2 per year.

Chapter 18 Exercise 2

2.

Listed below is the number of movie tickets sold at the Library Cinema-Complex, in thousands, for the period from 2001 to 2013. Compute a five-year weighted moving average using weights of .1, .1, .2, .3, and .3, respectively. Describe the trend in yield. (Round your answers to 3 decimal places.)

 

 

 

 

  2001

8.61

 

  2002

8.14

 

  2003

7.67

 

  2004

6.59

 

  2005

7.37

 

  2006

6.88

 

  2007

6.71

 

  2008

6.61

 

  2009

5.58

 

  2010

5.87

 

  2011

5.94

 

  2012

5.49

 

  2013

5.43

 

 

Picture Click here for the Excel Data File

 

  The weighted moving averages are:

 

 

  

  

  

  

  

  

  

  

  

  There is a regular of approximately 0.2 per year.

Chapter 18 Exercise 10

1.

Appliance Center sells a variety of electronic equipment and home appliances. For the last 4 years, 2010 through 2013, the following quarterly sales (in $ millions) were reported.

 

 

Quarter

 

Year

I

II

III

IV

2010

5.3

4.1

6.8

6.7

2011

4.8

3.8

5.6

6.8

2012

4.3

3.8

5.7

6.0

2013

5.6

4.6

6.4

5.9

 

Picture  Click here for the Excel Data File

 

Determine a typical seasonal index (adjusted) for each of the four quarters. (Round your answers to 4 decimal places.)

 

 

Seasonal

Quarter

Index

1

  

2

  

3

  

4

  

Bottom of Form

(Click to select)

-2-2

http://ezto.mhedu