Reference no: EM131893707

The legislative body of Brookville has completely approved your proposed budget of $400,000 for the fiscal year starting July 1, with no reductions. Prepare your annual budget by object code and month using the following guidance: a. Salaries are $23,000 per month, and benefits total 15% of salaries each month. b. General supplies are purchased at the beginning of each quarter and total $400 per quarter. c. There are two service contracts. One is for your website’s host and development and is paid in two parts: $15,000 in December and $25,000 in June. The second contract is for data analysis by an outside vendor. Payment on this contract is due every January, for a total of $2,000. d. The director of your department attends a national conference every October. Their training (which includes travel) budget is $3,000 for the conference. e. This year, your department will be outfitted with new technology equipment, including PCs, laptops, a phone system, and a new server. The cost is expected to be $36,000, and the transition should happen in February. (PLEASE show work in Excel)