Am i doing this correct?

What formulas would I use to calculate average employees, benefit rate, sq foot cost?

Make or Buy Analysis The Management at Foster, Inc. has decided to implement a new production control software package. The implementation project is scheduled to begin November 1 and last 12 months. But Foster Management is tom over the question: Should we develop the software ourselves and handle the implementation with internal resources or should we contract out the entire project (buying an existing package and using consultants to handle implementation)? Management has asked you to prepare an EXCEL economic analysis to aid in the decision process, You know the following facts: If you outsource the project you would incur a $170,000 software acquisition charge with 25% in month 3, 50% in month 6, and 25% in month 9 Foster would need to borrow money through a line prcredit to purchase the software at an annual rate of 10.5% In the first three months of the project, 2 consultants would work full time on-site In months four and five, 3 consultants would work full time on-site. For the balance of the project 4 consultants would work full time on-site. (Standard # hours/month = 160) The consultants would require 10 hours support from Foster employees for every 40 hours of consultant time. Consultants bill their time at S110 per hour. There is always one project lead on-site. She bills her time at $150 per hour. If Foster handles the implementation internally Six employees would work on the project full time in the first 2 months. Staffing would triple for the next 6 months. In the remaining months, 13 employees would work on the project Average annual salary is $40,000. Your company has a benefit rate of 15% and Workers' Comp taxes of $9.50 per hundred. Each of these numbers might change at the last moment. You pay FICA charges on your employee salarios. Each enployee is assigned an 8X10 foot cubicle. Accountants apply a standard cost of $6.00 per square foot (annually) Utility charges are approximately $1.75 per square foot per month in summer and spring However, charges increase by 33% in fall and winter months IN ws Ft M M- 000 Bay Aega og AR Meas Follo Com Leal OCE 08 1.30 35.200 14000 120 30 35200 2000 40 130 52100 24.00 100 TO 24600 2.300 2000 10 1.00 IN 40 24 000 79200 JO 311 DEN DO i 005 0 20 ON 20 200 Faste Maatiya Any HD 091 10 Compass Chile FC 30 42 13 1111 1 ur