Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Assignments 1. Develop an allocation and an allotment plan. To complete this exercise, use the file pro vided by your instructor entitled Budget Tools 2e

image text in transcribed
Assignments 1. Develop an allocation and an allotment plan. To complete this exercise, use the file pro vided by your instructor entitled Budget Tools 2e Module 22 Operating Plan. On the tab labeled Exercise in the spreadsheet is the proposed budget for a health care finance program. This bud. 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 allotment plan. To complete this exercise, use the file pro vided by your instructor entitled Budget Tools 2e Module 22 Operating Plan. On the tab labeled Exercise in the spreadsheet is the proposed budget for a health care finance program. This bud. 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Multinational Finance

Authors: Michael H. Moffett, Arthur I. Stonehill, David K. Eiteman

1st Edition

0201844842, 978-0201844849

More Books

Students also viewed these Finance questions