I am confused on what the formulas would be for this excel speadsheet. Could you please help me understand how to create a formula for this? 

 

 

Jay's Bikes
Revenue Apparel & Shoes
Bike accessories
New Bikes
Used Bikes
Bike Repairs $1,250,000
$550,000
$2,650,000
$18,500.00
$33,000.00
$4,501,500 IT Expenditures Hardware
Software updates
Software liscenses
Software support
Employee training
Web site development
Internet access $15,000.00
$18,000.00
$4,500
$4,500
$5,000
$5,000
$1,200
$53,200 Employees
IT spending as percent of revenue
IT spending per employee Target spending as percent of revenue
Target spending per employee 12
1.18%
$4,433

 

Attachments:

• 1493956597-Jays Bikes.xlsx