Using the data below, create a worksheet clearly including all data and showing you work (display formulas).
calculations to answer the following the questions:
** What is your companys wrap rate?
** For each labor category, What is the bill rate with no fee?
**For each labor category, what is the bill rate with a 9.5% fee?
Company Staff
6 Network Engineers that make an average of $91,000 per year
6 Network Administrators that make an average of $55,580 per year
1 Office Manager that makes $55,550 per year
1 Corporate Recruiter that makes $65,000 per year
2 Business Analysts that make an average of $85,300 per year
1 CEO that makes $165,500 per year
1 Project Manager that makes $120,250 per year
Company Expenses:
Health Insurance $197,500
Employee Education Reimbursement $17,250
Accounting System Licenses $5,000
Employee Spot Awards (Bonuses) $6,250
Christmas Party Bar Tab $2,000
Office Space for Corporate Officers $15,000
Office Space for Engineer Team $50,000
Corporate Legal Services $10,000

Labor Category	Salary	# of Employees	Total Salary	Salary Per Hour	Direct Labor Cost	Fringe Cost	# of FTE	Total Direct Labor Cost	Total Fringe Cost
Network Engineer	$ 91,000.00	$ 6.00	$ 546,000.00	$ 262.50	$ 493,500.00	$ 52,500.00		$ -	$ -