How will your Decemeber 4, 1995 plan change if the target is an average

I need the full solutions with calculation for Operations Management Beau Ties Vermont case study.
There are total of 4 questions that needs to be answered.
1. Assuming that Kenerson's has a target of an average wait of less than 1 min, develop a telephone staffing plan for Monday, Dec 4 , 1995 assuming that the distribution of phone calls throughout the day follows the hourly distribution in Exhibit 5.

2. How will your Decemeber 4, 1995 plan change if the target is an average wait of less than 30 seconds?

3. Compare the variable costs of the staffing plans from Qn 1 and 2 with the charges from AIDC

4. How should Kenerson evaluate the decision to bring the telephone order-entry system in house?

It will be good if can provide a spreadsheet model in Excel for the analysis.