Lynitem Township is preparing their budget for their fiscal year ending September 31, 2022. The township has a Management Department, a Public Works Department, a Recreation Department, and a Public Safety Department. The Proposed budget calls for them to spend money on the items listed in the Table labeled as Raw Data (given in Excel format in a separate file). Based on the information in table, prepare a line item budget for the township. Group all types of supplies together as one line item. Additionally, create a line-item budget listing personnel and non-personnel expenditures.

Lynitem Township is preparing their budget for their fiscal year ending September 31, 2022. The township has a Management Department, a Public Works Department, a Recreation Department, and a Public Safety Department. The proposed budget calls for them to spend money on the items listed in Raw Data. Based on the information on in the table, prepare a responsibility center budget for the township, just showing departmental totals.

Amount Amount Line-Item Type Department Function Salaries Management Management Supplies: Office Management Management Rent Management Management Gas & Electric Management Management Telephone Management Management Fringe Benefits Management Management Interest Management Management Depreciation Exp. Management Management Salaries Public Works Garbage Supplies: Office Public Works Garbage Gas & Electric Public Works Garbage Telephone Public Works Garbage Fringe Benefits Public Works Garbage Depreciation Exp. Public Works Garbage Salaries Public Works Snow Supplies: Office Public Works Snow Supplies: Salt Public Works Snow Gas & Electric Public Works Snow Telephone Public Works Snow Fringe Benefits Public Works Snow Depreciation Exp. Public Works Snow Salaries Public Works Road Repair Supplies: Office Public Works Road Repair Supplies: Blacktop Public Works Road Repair Gas & Electric Public Works Road Repair Telephone Public Works Road Repair Fringe Benefits Public Works Road Repair Depreciation Exp. Public Works Road Repair Salaries Recreation Parks Supplies: Office Recreation Parks Supplies: Parks Recreation Parks Gas & Electric Recreation Parks Telephone Recreation Parks Fringe Benefits Recreation Parks Depreciation Exp. Recreation Parks Salaries Recreation Concerts Supplies: Office Recreation Concerts Supplies: Concerts Recreation Concerts Gas & Electric Recreation Concerts Telephone Recreation Concerts Fringe Benefits Recreation Concerts Depreciation Exp. Recreation Concerts Salaries Recreation Athletics Supplies: Office Recreation Athletics Supplies: Athletic Facilities Recreation Athletics Gas & Electric Recreation Athletics Telephone Recreation Athletics Fringe Benefits Recreation Athletics Depreciation Exp. Recreation Athletics Salaries Public Safety Police Supplies: Office Public Safety Police Supplies: Uniform Allowance Public Safety Gas & Electric Public Safety Police Telephone Public Safety Fringe Benefits Public Safety Police Depreciation Exp. Public Safety Police Salaries Public Safety Fire Supplies: Office Public Safety Fire Supplies: Fire Truck Public Safety Fire Gas & Electric Public Safety Fire Telephone Public Safety Fire Fringe Benefits Public Safety Fire Depreciation Exp. Public Safety Fire Total Note: Many of the above line items, such as salaries, are summaries of detailed information listing individual employees and their salaries. 651,832 12,520 66,998 16,991 7,413 136,885 22,138 7,412 125,848 956 1,245 956 26,428 20,880 44,232 434 19,182 9,519 664 9,289 10,507 32,172 1,651 22,435 1,053 535 6,756 15,109 16,472 223 2,233 274 322 3,459 4,329 7,472 326 1,535 137 323 1,569 1,432 31,947 2,031 14,325 4,217 1,659 6,709 61,983 162,046 Police Police 4,154 1,491 2,031 2,482 34,030 27,608 78,703 2,310 11,931 2,031 2,482 16,528 79,808 1,862,651