Provide the ROI ratio for both spreadsheets Use and submit the two spreadsheets attached to determine the TCO and ROI for in-house and on-line (NOTE there are two tabs on each spreadsheet) Provide a line chart showing C-Cost & C-Benefits for both spreadsheets- 5pts Use to find Salary ranges for your personnel, calculate the hourly rate and add 50% to the rate for the burdened costs. Burdened costs are the overhead for each employee; vacation time, insurance, benefits, the cost of providing them a workspace, and equipment (desk, chair, computer, etc). Your Benefits for each year are: Year 1 $0 Year 2 $600,000 Year 3 1,274,000 Year 4 3,127,000
