For the following questions, use this information from Thompson Corporation’s an
ID: 2759797 • Letter: F
Question
For the following questions, use this information from Thompson Corporation’s annual reports:
Year
($million)
(000)
2004
134.3
305
2005
148.0
307
2006
163.4
316
2007
172.5
319
2008
182.5
323
2009
153.7
304
2010
148.9
287
2011
146.5
305
2012
146.7
307
2013
146.0
305
These data are included in the file Thompson Data.
1) Compute a simple index for the revenue of Thompson. Use 2004 as the base period. What can you conclude about the change in revenue over the period?
2) Compute a simple index for the revenue of Thompson using the period 2004–06 as the base. What can you conclude about the change in revenue over the period?
3) Compute a simple index for the number of employees for Thompson. Use 2004 as the base period. What can you conclude about the change in the number of employees over the period?
4) Compute a simple index for the number of employees for Thompson using the period 2004–06 as the base. What can you conclude about the change in the number of employees over the period?
Please do your work in Excel and screen shot the excel page, or attach. Please also include the excel formulas on how you found the answers as well!
Thank you so much!
For the following questions, use this information from Thompson Corporation’s annual reports:
Year
($million)
(000)
2004
134.3
305
2005
148.0
307
2006
163.4
316
2007
172.5
319
2008
182.5
323
2009
153.7
304
2010
148.9
287
2011
146.5
305
2012
146.7
307
2013
146.0
305
2014 147.2 309 2015 155.8 318These data are included in the file Thompson Data.
1) Compute a simple index for the revenue of Thompson. Use 2004 as the base period. What can you conclude about the change in revenue over the period?
2) Compute a simple index for the revenue of Thompson using the period 2004–06 as the base. What can you conclude about the change in revenue over the period?
3) Compute a simple index for the number of employees for Thompson. Use 2004 as the base period. What can you conclude about the change in the number of employees over the period?
4) Compute a simple index for the number of employees for Thompson using the period 2004–06 as the base. What can you conclude about the change in the number of employees over the period?
Please do your work in Excel and screen shot the excel page, or attach. Please also include the excel formulas on how you found the answers as well!
Thank you so much!
Explanation / Answer
Simple Index Number = (Current Value / Base Value) x 100
=> (155.8/148.57) x 100 = 104.87
The index here tells us that the revenue has increased by 4.87% from the base value.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.