It is an exam. I will send your all of my lecture notes.The mid-term exam has 4 questions all problem solving, any calculations done in Excel is acceptable just make sure you attach your excel file...

It is an exam. I will send your all of my lecture notes.The mid-term exam has 4 questions all problem solving, any calculations done in Excel is acceptable just make sure you attach your excel file along with your exam.


The following table shows the | 1 prices and quantities | consumed by a family of four | for selected food commodities for 1990 and 2006. Use 990 as the base period. a. Determine the simple index for steak for 2006. 1990 2006 | Price | Quantity | Price | Quantity 15139 30 $2.09 110 11.69] 100 2.75 120 | 1.29 95 2.59 100 1 a99 50 9.49 40 b. Determine the simple aggregate price index for 2006. ¢. Determine the Laspeyres price index for 2006. a. d. Determine the Paasche price index for 2006. 9. 10. A firm sold $50.000 of a particular product in 1995 and $120,000 in 2003. Using 1995 as the base, what is the index for 2001? a. $70,000 b. 240 percent c. 140 percent. d. 41.7 percent An index has 1980 as its base. The index reported in 1993 was 127.2 and in 2003 it was 186.7. The percent increase from 1993 to 2005 is a. 46.8 percent. b. 27.2 percent. c. 59.5 percent. d. none of the above. Which of the following price indexes uses current period quantities in its base? a. a value index b. a simple index c. Laspeyres Price Index d. Paasche Price Index Part II: Record your answer in the space provided. Show essential work. 11. The ecarnings per share for General Year | Earnings per share Index Electric from the 2002 Annual Reportare [190g $0.95 given at the right. Develop an index 1900 700 showing the change in earnings for the - given years. Use 1998 as the base period. | 2000 oo 1.29 2000 | 1.41 | 2002 1.51 [2003 | 1.52 2004 1.62 [2005 | 1.55 12. Professor Jim Martin had an annual income in the base period of $30,000. In YE 12 2005 his annual income was $75,100. During the same period the CPI rose from 100 to 184.6. What was his real income in 2005? | 14. e. Determine a value index for 2006. The table reports the net profit for Heban Tool and Die, Inc. for | Year the years 1996 and 2006. Also reported is the tool and die index [1996 for the same years (1985 = 100). 2006 a. What was the percent increase in the index from 1996 to 2006? b. Convert the index to a 1996 base. What is the new index for 2006? o Net profit | Index $45,380 | 136.3 65,035 | 150.2 a. b. c. Determine the net profit for 2006 in terms of the 1996 base. Comment on the change.