Please show equations for the 14 blank cells in excell spreadsheet. Thanks BIG B

Question

Please show equations for the 14 blank cells in excell spreadsheet. Thanks BIG BEND MEDICAL CENTER COST ALLOCATION CONCEPTS 3 BIG BEND MEDICAL CENTER is a full-service, not-for-profit, acute care hospital with 325 beds located in Big Bend, Texas. The bulk of the hospital's facilities are devoted to inpatient care and emergency services. However, a 100,000-square-foot section of the hospital com- plex is devoted to outpatient services. Currently, this space has two primary uses. About 80 percent of the space is used by the Outpatient Clinic, which handles all routine outpatient services offered by the hospital. The remaining 20 percent is used by the Dialysis Center. The Dialysis Center performs hemodialysis and peritoneal dialysis, which are alternative processes that remove wastes and excess water from the blood for patients with end-stage renal (kidney) disease. In hemodialysis, blood is pumped from the patient's arm through a shunt into a dialysis machine, which uses a cleansing solution and an arti- ficial membrane to perform the functions of a healthy kidney. Then, the cleansed blood is pumped back into the patient through a second shunt. In peritoneal dialysis, the cleansing solution is inserted directly into the abdominal cavity through a catheter. The body naturally cleanses the blood through the peritoneum-a thin membrane that lines the abdominal cavity. Typically, hemodialysis patients require three dialyses a week, with each treatment lasting about four hours. Patients who use peritoneal dialysis change their own cleansing solutions at home, usually about six times per day. This procedure can be done manually when active or automatically by machine when sleeping. However, the patient's 27 CHAP, 2014. Reproduction without permission is prohibited.

Explanation / Answer

         Without Expansion              Initial Allocation               Final Allocation DC OC DC OC DC OC Total revenues $    2,700,000 $   16,000,000 $    2,700,000 $   20,000,000 $                   2,700,000 $   20,000,000 Direct expenses: 2,100,000 9,833,155 2,100,000 12,291,444 2,100,000 12,291,444 Contribution margin* $       600,000 $    6,166,845 $       600,000 $    7,708,556 $                      600,000 $    7,708,556 Percent of revenues 22.2% 38.5% 22.2% 38.5% 22.2% 38.5% Indirect costs Facilities costs $       300,000 $    1,200,000 $       400,000 $    1,500,000 $                      300,000 $    1,600,000 General overhead           270,000        1,600,000           270,000        2,000,000                         270,000        2,000,000 Total overhead $       570,000 $    2,800,000 $       670,000 $    3,500,000 $                      570,000 $    3,600,000 Net profit $         30,000 $    3,366,845 $        (70,000) $    4,208,556 $                       30,000 $    4,108,556 Percent of revenues 1.1% 21.0% -2.6% 21.0% 1.1% 20.5% Facilities Cost Allocation: Square footage             20,000             80,000 #             20,000           100,000                           20,000           100,000 Cost per square foot $           15.00 $           15.00 # $           20.00 $           15.00 $                         15.00 $           16.00 Other Overhead Allocation: General overhead as a percent of revenues 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% Dialysis Ctr Outpatient Ctr Total            Facilities allocation ($) $       300,000 $                   1,600,000 $    1,900,000                 Per square foot $           15.00 $                         16.00 $           15.83            Gen overhead alloc.           270,000                       2,000,000        2,270,000                 Per revenue $ 10.0% 10.0% 10.0%               Total indirect costs $       570,000 $                   3,600,000 $    4,170,000                 Net profit $         30,000 $                   4,108,556 $    4,138,556             Percent of rev 1.1% 20.5% 18.2%

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.