Develop the HIM department operations budget on a spreadsheet for the next FY. Allocate the funding...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Develop the HIM department operations budget on a spreadsheet for the next FY. Allocate the funding through- out the FY on a monthly basis. The FY at General Hospital begins July 1. First, create a spreadsheet folder with the salaries and wages information, and then create a spreadsheet folder with the operating expenses. Personnel Salaries and Wages-Calculate amounts for the following: 1. Salaries with fringe benefits 2. Allowed overtime Second, calculate total personnel budget. Use the information in Table 6-31, also available on the student companion website, to calculate the payroll costs for the new FY. New salaries include the following: 1. A new approved analyst/coder/abstractor position that will go into effect at the beginning of the new FY with a salary of $48,500.00. 2. Fringe benefits of 30% of monthly salaries. 3. A merit raise of 5% that will go into effect in December. 4. Overtime limits not to exceed $4,000.00 for the year. TABLE 6-31 Personnel Salary Information Classification Director Assistant director Coding supervisor Receptionist/clerk Transcription supervisor Transcriptionists Coders Chart completion supervisor HIM technicians *Analyst/coder/abstractor Salaries and fringe benefits Budgeted overtime Subtotal personnel *Denotes new approved position Personnel Salary Information Number of Employees Current Salaries Salaries for New FY 1 1 1 1 1 4 3 1 2 1 Operating Expenses Operations expenses are shown in Table 6-32 and should be allocated throughout the FY. $79,450.00 $67,478.00 $55,971.00 $31,502.00 $56,800.00 $46,000.00 $47,500.00 $50,000.00 $44,052.00 New position What would be the operations budget for the new FY, including line items given? TABLE 6-32 Operations Expenses for New FY Expense Telephone Supplies Scanner Equipment Copy Machine Education Total Operations Expenses for New FY Budget $1,000.00 $10,500.00 $10,000.00 $25,000.00 $8,000.00 $2,500.00 Develop the HIM department operations budget on a spreadsheet for the next FY. Allocate the funding through- out the FY on a monthly basis. The FY at General Hospital begins July 1. First, create a spreadsheet folder with the salaries and wages information, and then create a spreadsheet folder with the operating expenses. Personnel Salaries and Wages-Calculate amounts for the following: 1. Salaries with fringe benefits 2. Allowed overtime Second, calculate total personnel budget. Use the information in Table 6-31, also available on the student companion website, to calculate the payroll costs for the new FY. New salaries include the following: 1. A new approved analyst/coder/abstractor position that will go into effect at the beginning of the new FY with a salary of $48,500.00. 2. Fringe benefits of 30% of monthly salaries. 3. A merit raise of 5% that will go into effect in December. 4. Overtime limits not to exceed $4,000.00 for the year. TABLE 6-31 Personnel Salary Information Classification Director Assistant director Coding supervisor Receptionist/clerk Transcription supervisor Transcriptionists Coders Chart completion supervisor HIM technicians *Analyst/coder/abstractor Salaries and fringe benefits Budgeted overtime Subtotal personnel *Denotes new approved position Personnel Salary Information Number of Employees Current Salaries Salaries for New FY 1 1 1 1 1 4 3 1 2 1 Operating Expenses Operations expenses are shown in Table 6-32 and should be allocated throughout the FY. $79,450.00 $67,478.00 $55,971.00 $31,502.00 $56,800.00 $46,000.00 $47,500.00 $50,000.00 $44,052.00 New position What would be the operations budget for the new FY, including line items given? TABLE 6-32 Operations Expenses for New FY Expense Telephone Supplies Scanner Equipment Copy Machine Education Total Operations Expenses for New FY Budget $1,000.00 $10,500.00 $10,000.00 $25,000.00 $8,000.00 $2,500.00
Expert Answer:
Answer rating: 100% (QA)
ANSWER To create the HIM department operations budget for the next fiscal year FY we will first calculate the personnel salaries and wages including f... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Grouper Leasing Company agrees to lease equipment to Monty Corporation on January 1, 2020. The following information relates to the lease agreement. 1. The term of the lease is 7 years with no...
-
The city pool loses 1.0 inch of water every week due to evaporation. If the pool is 25 yards long and 12 yards wide, what is the energy required to keep the pool at 15C. If the cost of energy is...
-
A simple random sample of birth weights of 30 girls has a standard deviation of 829.5 hg. Use a 0.01 significance level to test the claim that birth weights of girls have the same standard deviation...
-
Through November, Cameron has received gross income of $131,000. For December, Cameron is considering whether to accept one more work engagement for the year. Engagement 1 will generate $9,860 of...
-
A 50-ft-long aluminum gutter (Manning coefficient \(n=0.011\) ) on a section of a roof is to handle a flowrate of \(0.15 \mathrm{ft}^{3} / \mathrm{s}\) during a heavy rainstorm. The cross section of...
-
1. Tell Carolyn Clark that employee volunteerism is important to the company and that while her performance evaluation will not be affected by her decision, she should consider helping Harris because...
-
Why are there no laws of psychology?
-
1. Rewrite the rational function g(x) = in the form g(x) = c+. where c and r are %3D constants. 2. The average cost (in dollars) per mile for riding x miles in a cab is cx) = 5: As x gets larger and...
-
Describe what a holdback is and how it works. When might it be useful to bring a breach of trust claim? Who may file a lien? On what property can a lien be filed? Will the amount in the claim for a...
-
if you have a contract and you are deciphering the terms of the contract, if you are paying $4000 for the removal of asbestos, disposal of the asbestos and removal of a certain distance into the...
-
Which requirements focus on organizational fit and tie the project to documented strategic, tactical, and operational goals? Functional Requirements Administrative Requirements Customer Requirements...
-
Again, looking back on the various proposals and recommendations you have provided to senior leadership, how would you recommend rolling them out ( e . g . , a grand launch of everything, everywhere,...
-
Suppose the clerk has received a request to issue a writ of delivery. The bailiff is unable to locate the specific property named in the writ and is getting no cooperation from the debtor. Is there...
-
Real Estate Principles to call regarding finding the Market Value of property using the information below by end of the day on Friday. REAL 4000E Real Estate Principles Summer 2016 Income Approach to...
-
The figure shows six containers, each of which is filled from the top. Assume that water is poured into the containers at a constant rate and each container is filled in 10 seconds. Assume also that...
-
What is the cost of equity financing?
-
QuantumTM manufactures electronic testing and measurement instruments. Many products are custom-designed with recent orders for function generators, harmonic analyzers, logic analyzers, temperature...
-
During the year, Xenoc produces 1,500 pairs of speakers and sells 1,200 pairs. Xenoc produces stereo speakers. The selling price per pair of speakers is $1,800. There is no beginning inventory. Costs...
-
A construction contract differs from contracts that we generally deal with that focus on an easily defined physical object because the physical object can be examined. How is the object of a...
-
What does the owner contribute to the project and what does the contractor contribute to the project?
-
The construction schedule is the only project document that fully communicates the contractor's intentions for delivering the contracted scope of services over the full course of the project...
Study smarter with the SolutionInn App