Should be done in Excel.

Using the data below, create a worksheet clearly including all data and showing you work / calculations to answer the following the questions: What is your company's 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 Amount Expense Item Health Insurance Employee Education Reimbursement Accounting System Licenses Employee Spot Awards (Bonuses) Christmas Party Bar Tab Office Space for Corporate Officers Office Space for Engineer Team Corporate Legal Services $197,500 $17,250 $5,000 $6,250 $2,000 $15,000 $50,000 $10,000 Using the data below, create a worksheet clearly including all data and showing you work / calculations to answer the following the questions: What is your company's 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 Amount Expense Item Health Insurance Employee Education Reimbursement Accounting System Licenses Employee Spot Awards (Bonuses) Christmas Party Bar Tab Office Space for Corporate Officers Office Space for Engineer Team Corporate Legal Services $197,500 $17,250 $5,000 $6,250 $2,000 $15,000 $50,000 $10,000