Chapter Six 178 Chapter 6 Homework Exercises Directions: Complete question I& 2 in a word t tions 3-7 in Excel. Do not round any numbers until the final lete the remaining questions in Excei and paste the answers cessing program rocessing program and q step. You can inito 1. The mayor for the City of Harriston has requested a cost short, she wants to know if the city can save money by usngly vendors for public events held at the city's convention center. T has appointed you, budget analyst, to conduct the analysis. Y provide three alternatives. The first one should provide the data st-benefit analysis. In outside secunity r analysis lice department and the latter two should be estimates from panies (Security One and First Line Security). Since private compan sidered in this example, the budget should be primarily limited to operating costs. Below is a list of information that you should u ducting your analysis. When you complete your analysis, make a rec tion to Mayor McClain. You are free to write your analysis in any fornm choose as long as you consider the information that is provided belo Cities vate com nies are con use when con- and form that you de . The city spent $740,000.00 in salary and benefits last year (police partment) in providing security at the convention center for 35 events The events averaged 25,000 people .A total of thirty five officers were used, on average, for each event l year The convention center has a main security office that requires three persons to be on duty at all times There are 8 points of entry that require an armed security guard. The events averaged five hours in length Security One has contracted with the city in the past (four years) with fairly good evaluation scores on customer service. They have 40 securi- ty officers who are trained in CPR and paramedic skills, with an aver age tenure of 6 years. Thirty five of the officers are registered to carry weapons. They have four staff members with at least one person on du- ty at all times. The main office is not in the downtown area First Line Security is a new company that was started by the previous police chief. They have 50 security officers with an average tenure of 10 years of experience and five staff members. They also have an office . . . wn near the areas where events tend to occur (open 24 hours per day). They have managed two large events thus far with few problems They received high evaluation scores on both events. In addition, their fees tend to be slightly less than the competition for the same services Budgeting Technique and Analytical Models 179 consider in the "Benefits" section of your analysis could include: edu- ms to al levels of security officers, certifications (diversity training. CPR, etc), mits (handgun, etc), age; age of company, clientele list, story of company, number and type of security vehicles; and expected of the security contract. Also, note that the contractors are completely s and any incidents that may occur (i.e. employee insurance; contractor must be bonded, etc). In addition to the above items, you should consider speaking with a security or police office to see what additional items should be included in your proposal. It is not necessary to ir- clude every possible detail in your cost, but try to be holistic in your categories le ngth of experience, per responsible and liable for their employee so as to keep your budget succinct. Chapter Six 178 Chapter 6 Homework Exercises Directions: Complete question I& 2 in a word t tions 3-7 in Excel. Do not round any numbers until the final lete the remaining questions in Excei and paste the answers cessing program rocessing program and q step. You can inito 1. The mayor for the City of Harriston has requested a cost short, she wants to know if the city can save money by usngly vendors for public events held at the city's convention center. T has appointed you, budget analyst, to conduct the analysis. Y provide three alternatives. The first one should provide the data st-benefit analysis. In outside secunity r analysis lice department and the latter two should be estimates from panies (Security One and First Line Security). Since private compan sidered in this example, the budget should be primarily limited to operating costs. Below is a list of information that you should u ducting your analysis. When you complete your analysis, make a rec tion to Mayor McClain. You are free to write your analysis in any fornm choose as long as you consider the information that is provided belo Cities vate com nies are con use when con- and form that you de . The city spent $740,000.00 in salary and benefits last year (police partment) in providing security at the convention center for 35 events The events averaged 25,000 people .A total of thirty five officers were used, on average, for each event l year The convention center has a main security office that requires three persons to be on duty at all times There are 8 points of entry that require an armed security guard. The events averaged five hours in length Security One has contracted with the city in the past (four years) with fairly good evaluation scores on customer service. They have 40 securi- ty officers who are trained in CPR and paramedic skills, with an aver age tenure of 6 years. Thirty five of the officers are registered to carry weapons. They have four staff members with at least one person on du- ty at all times. The main office is not in the downtown area First Line Security is a new company that was started by the previous police chief. They have 50 security officers with an average tenure of 10 years of experience and five staff members. They also have an office . . . wn near the areas where events tend to occur (open 24 hours per day). They have managed two large events thus far with few problems They received high evaluation scores on both events. In addition, their fees tend to be slightly less than the competition for the same services Budgeting Technique and Analytical Models 179 consider in the "Benefits" section of your analysis could include: edu- ms to al levels of security officers, certifications (diversity training. CPR, etc), mits (handgun, etc), age; age of company, clientele list, story of company, number and type of security vehicles; and expected of the security contract. Also, note that the contractors are completely s and any incidents that may occur (i.e. employee insurance; contractor must be bonded, etc). In addition to the above items, you should consider speaking with a security or police office to see what additional items should be included in your proposal. It is not necessary to ir- clude every possible detail in your cost, but try to be holistic in your categories le ngth of experience, per responsible and liable for their employee so as to keep your budget succinct