How do jay it expenditures compare to the industry averages

Assignment Help Management Information Sys

Reference no: EM13762321

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

Reference no: EM13762321

Questions Cloud

The natural growth rate of a population : The natural growth rate of a population is derived from the subtraction of the crude death rate from the crude birth rate.crude birth rate from the crude death rate.net death rate from the gross death rate.net birth rate from the gross birth rate.liv..

Grand nursing theory : The central values and beliefs set forth by the theorist.

Current or a future position : Determine two (2) ways to apply what you learned in this course in your current or a future position. Create a list of three (3) best practices to follow that would improve the quality of life in developing countries.

Describe and assess the evaluation method : Describe and assess the evaluation method being used by the testing company, i.e., nonvisual and verbal recording of browser activities and tester's vocal comments.

How do jay it expenditures compare to the industry averages : 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. How do Jay's IT expenditures compare to the industry averag..

The future of the nature of our society''s drug : Finally, given the way in which many forces have affected drug use in the past, develop your own projection twenty-five years into the future of the nature of our society's drug use problems, based on some of the social, political, economic, law enfo..

Examine how language is a form of social action : Examine how language is a form of social action that varies cross- and intra-culturally to explain power and other social differentials.

Content-related role of commercial web sites : Which of the following is NOT a content-related role of commercial Web sites?

An imaginary quantitative nursing : The independent and dependent variable, and state the research hypothesis for your study. The variables must be categorical variables.

User Account

All Pages