EXCEL APPLICATION: IT Benchmarks
Jay's Bikes is a family-owned and -operated business that stocks a wide range of bikes designed to fit the needs of professional riders, your child's first bike, and everything in between. The business has 12 full-time employees. Jay has asked you to create a spreadsheet from the data in Figure 2-19 to calculate average IT spending so that it can be compared to the retail industry average. What is the average IT spending in the retail industry? What is the average IT spending per employee in the retail industry? How do Jay's IT expenditures compare to the industry averages? How much would Jay need to increase spending in order to match the retail industry average?
Jay's Bikes Revenue and IT expenditures.
|
|
A
|
B
|
C
|
|
1
|
Revenue
|
Apparel & shoes
|
$ 1,250,000
|
|
2
|
|
Bike accessories
|
$ 550,000
|
|
3
|
|
New bikes
|
2,650,000
|
|
4
|
|
Used bikes
|
$ 18,500
|
|
S
|
|
Bike repairs
|
$ 33,000
|
|
6
|
|
|
|
|
7
|
IT expenditures
|
Hardware
|
$ 15,000
|
|
8
|
|
Software updates
|
18,000
|
|
9
|
|
Software licenses
|
$ 4,500
|
|
10
|
|
Software support
|
4,500
|
|
11
|
|
Employee training
|
$ 5,000
|
|
12
|
|
Website development
|
$ 5,000
|
|
13
|
|
Internet access
|
$ 1,200
|