Assignments 1. Develop an allocation and an allotments Perm Coucem lote this exercise, use the file pro Exercise in the spreadsheet is the proposed budget for a health care finance program. This bud. vided by your instructor entitled Budget Tools 24 Module 22 Operating Plan. On the tab labeled get spends a lot of money on health care claims in object code 2241 and pays a lot of money for claims processing in object code 2501. The legislature has provided $30 million for new health care claims benefits but no money for the estimated $25,000 in processing costs for new claims these costs are to be met through administrative savings. The legislature has also demanded other administrative efficiencies, but little guidance has been given for achieving them. Based on past payroll patterns, you may want to anticipate that 48% of the expenses will be incurred in the first half of the year and 52% will be incurred in the second half. Benefit ratios are provided in the spreadsheet. There are no special purchases. The building lease for the departmental office is $125,000 per month. Net legislative adjustments are $28.75 million. As a new analyst, you are not sure what some of the expenditures are for, so your initial proposal will likely be revised, but you have been tasked with making an initial proposal. Complete this assignment using the provided spreadsheet. Assignments 1. Develop an allocation and an allotments Perm Coucem lote this exercise, use the file pro Exercise in the spreadsheet is the proposed budget for a health care finance program. This bud. vided by your instructor entitled Budget Tools 24 Module 22 Operating Plan. On the tab labeled get spends a lot of money on health care claims in object code 2241 and pays a lot of money for claims processing in object code 2501. The legislature has provided $30 million for new health care claims benefits but no money for the estimated $25,000 in processing costs for new claims these costs are to be met through administrative savings. The legislature has also demanded other administrative efficiencies, but little guidance has been given for achieving them. Based on past payroll patterns, you may want to anticipate that 48% of the expenses will be incurred in the first half of the year and 52% will be incurred in the second half. Benefit ratios are provided in the spreadsheet. There are no special purchases. The building lease for the departmental office is $125,000 per month. Net legislative adjustments are $28.75 million. As a new analyst, you are not sure what some of the expenditures are for, so your initial proposal will likely be revised, but you have been tasked with making an initial proposal. Complete this assignment using the provided spreadsheet