Case study assignment question 2

Case Study

The president of a small manufacturing firm is concerned about the continual increase in manufacturing costs over the past several years. The following figures provide a time series of the cost per unit for the firm’s leading product over the past eight years.

Year

Cost/Unit ($)

1

2003

20

2

2004

24,5

3

2005

28,2

4

2006

27,5

5

2007

26,6

6

2008

30

7

2009

31

8

2010

36

Show a graph of this time series.

Find all simple index numbers for the base year 2003 and 2008.

Determine all chain base index numbers.

What is average growth rate of the cost in the years 2006-2010?

Develop the equation for the linear trend of the time series. What is the average cost increase that the firm has been realizing per year?

What cost can we predict for the year 2014 ? What is the error of this estimate?

Make a comprehensive analysis of time series below:

( ice-cream sales (tonnes) )

March

April

May

June

9,1

10,6

11,5

13,8

Using the least square criterion estimate the parameters of the proper trend function. What kind of ice-cream sales can we expect in July? Give the standard error of estimate. What kind of assumption must we use for a given estimation? Check the average growth rate of the variable between February and June if .

Case Study

Gasoline sales time series:

Week

Sales (1000s of gallons)

1

17

2

21

3

19

4

23

5

18

6

16

7

20

8

18

9

22

10

20

11

15

12

22

Make a comprehensive analysis of time series.

Choose the first, the fifth and last week as the base period.

The values of Alabama building contracts (in millions of dollars) for a 12month period (the year 2012) are as follow:

Month

Sales

Month

Sales

1

240

7

220

2

350

8

310

3

230

9

240

4

260

10

310

5

280

11

240

6

320

12

230

Compare values of the variable using to this aim the first period as a base.

Check the changes using the chain base index numbers.

Determine the average growth rate between March and July.

Case Study

The president of small manufacturing firm is concerned about the continual increase in manufacturing costs over the past several years. The following figures provide a time series of the cost per unit for the firm’s leading product over the past eight years.

year

Cost/unit ($)

year

Cost/unit ($)

2005

20,00

2009

26,60

2006

24,50

2010

30,00

2007

28,20

2011

31,00

2008

27,50

2012

36,00

Compare the cost in the year 2012 with the cost in the year 2010.

Compare the cost in the year 2011 with the cost in the year 2007.

Compare the cost in the year 2005 with the cost in the year 2010.

Determine all costs with the base unit cost 36,00($).

What is the average cost increase that the firm has been realizing per year?

Develop the equation for the linear trend components of the time series.

The following data show the percentage of rural, urban, and suburban Americans who have a high-speed Internet connection at home (Pew Internet Rural Broadband Internet Use, February 2006).

Year

Rural

Urban

Suburban

2001

3

9

9

2002

6

18

17

2003

9

21

23

2004

16

29

29

2005

24

38

40

For each group, develop a linear trend equation.

For each group check the average growth /decline/ rate.

For each group make a prediction for the year 2006 and determine standard error of estimate.

Case Study

The following data show the average monthly cellular telephone bill (The

New York Times, Atlanta, 2006)

year

1999

2000

2001

2002

2003

Amount

($)

41

45

47

48

50

Graph the time series.

Does the trend appear to be present?

Find the theoretical linear trend function.

Use the trend equation to estimate the average monthly bill for the year 2005 and 2007. Use standard error in your estimation.

Based on data below make a comprehensive analysis of price dynamics, quantity and value of all grocery products per capita in Poland in 2011 relative to the base year 2010.

product unit

price (PLN)

quantity

2010

2011

2010

2011

eggs

carton

5,5

6,0

60

50

butter

250 grams

3,9

3,9

70

65

meat

/pork/

kilogram

17

19

30

35

milk

litre

1,8

2,3

120

140

bread

loaf

2,2

2,0

150

150

Do not forget to make conclusions taking into account Fisher ideal index.

Case Study

Fresh fruit price and quantity data for the year 1988 and 2001 follow (Statistical Abstract of the United States, 2002).

Quantity data reflect per capita consumption in pounds and prices are per pound.

Fruit

1988

Per Capita

Consumption

(pounds)

1988

Price

($/pound)

2001

Price

($/pound)

bananas

24,3

0,41

0,51

apples

19,9

0,71

0,87

oranges

13,9

0,56

0,71

pears

3,2

0,64

0,98

Compute relative price for each product.

Compute a weighted aggregate price index for fruit products.

Comment on the change in fruit prices over the 13-year period.

Case Study

Starting faculty salaries (nine-month basis) for assistant professor of business administration at a major Midwestern university follow.

Comment on the trend in salaries in higher education as indicated by these data. What faculty salary can we expect in the year 2015 ?

Make a comprehensive analysis of dynamic.

year

Starting Salary ($)

1970

14 000

1975

17 500

1980

23 000

1985

37 000

1990

53 000

1995

65 000

2000

80 000

2005

110 000

Case Study

Boran Stockbrokers, Inc., selects four stocks for the purpose of developing its own index of stock market behavior. Prices per share for a 2004 base period, January 2006, and March 2006 follow.

Base-year quantities are set on the basis of historical volumes for stocks.

Price per Share

Stock

Industry

2004

Quantity

2004 base

January 2006

March 2006

A

Oil

100

31,50

22,75

22,50

B

Computer

150

65,00

49,00

47,50

C

Steel

75

40,00

32,00

29,50

D

Real Estate

50

18,00

6,50

3,75

Use the 2004 base period to compute the Boran index for January and March 2006. Compute the price relatives for the four stocks.

/Use the weighted aggregates of price to compute the January 2006 and March 2006 Boran indexes/

Comment on what the indexes tell us about what is happening in the stock market.

Case Study

The following table reports prices and usage quantities for two items in 2004 and 2006.

Item

Quantity

Unit price ($)

2004

2006

2004

2006

A

1 500

1800

7,5

7,75

B

2

1

630

1 500

Find price change for each item in 2006 using 2004 as the base period.

Find unweighted aggregate price index for the two items using the year 2004 as the base year.

Find weighted aggregate price index for the two items using Lasperyes and Paasche index.

Check the changes of quantities using appropriate aggregate index number.

Interpret Fisher ideal index.

What can you say about value change?

Case Study

A large manufacturer purchases an identical component from three independent suppliers that differ in unit price and quantity supplied. The relevant data for 2004 and 2006 are given here:

supplier

Unit price ($)

Quantity (2004)

2004

2006

A

5,45

6,0

150

B

5,6

5,95

200

C

5,5

6,2

120

Compute the price relatives for each of the component suppliers separately. Find all possible unweighted and weighted index numbers. What is the interpretation of these index numbers?

Case study assignment question

Case study assignment question 1

Case study assignment question 2

Case study assignment question 3

Case study assignment question 4