Chapter 12 Homework

.xlsx

School

University of Kentucky *

*We aren’t endorsed by this school

Course

628

Subject

Industrial Engineering

Date

Feb 20, 2024

Type

xlsx

Pages

9

Uploaded by MagistratePuppy18937

Report
#11 A Sq Feet Utilities Direct Costs Admin # test Laboratory Utilities Administration 5,000 28% Laboratory 3,000 17% $ 850,000 15.7% Day-op Suite 5,000 28% $ 3,500,000 64.5% 7000 56% Cystoscopy 3,000 17% $ 675,000 12.4% 3000 24% Endoscopy 2,000 11% $ 400,000 7.4% 2500 20% Total 18000 100% $ 5,425,000 100.0% 12500 100% Utilities Admin Laboratory Dept Costs Utilities Admin Utilities $500,000 $ (500,000) Administration 28% $800,000 $ 138,889 $ 938,889 Laboratory 17% 15.7% $850,000 $ 83,333 $ 147,406 Day-op Suite 28% 64.5% 56% $3,500,000 $ 138,889 $ 605,583 Cystoscopy 17% 12.4% 24% $675,000 $ 83,333 $ 116,422 Endoscopy 11% 7.4% 20% $400,000 $ 55,556 $ 69,478 Total 100% 100.0% 100% $6,725,000 $ 500,000 $ 1,877,778
Lab Total $ 1,080,739 $ 2,161,478 $ 605,214 $ 4,849,686 $ 259,377 $ 1,134,133 $ 216,148 $ 741,181 $ 2,161,478 $ 8,886,478
#11 B Sq Feet Utilities Direct Costs Admin # test Laboratory Utilities Administration 4,500 25% Laboratory 3,000 17% $ 850,000 15.7% Day-op Suite 5,000 28% $ 3,500,000 64.5% 7000 56% Cystoscopy 3,500 19% $ 675,000 12.4% 3000 24% Endoscopy 2,000 11% $ 400,000 7.4% 2500 20% Total 18000 100% $ 5,425,000 100.0% 12500 100% Utilities Admin Laboratory Dept Costs Utilities Admin Lab Utilities $500,000 $ (500,000) Administration 25% $800,000 $ 125,000 $ 925,000 Laboratory 17% 15.7% $850,000 $ 83,333 $ 145,225 $ 1,078,558 Day-op Suite 28% 64.5% 56% $3,500,000 $ 138,889 $ 596,625 $ 603,993 Cystoscopy 19% 12.4% 24% $675,000 $ 97,222 $ 114,700 $ 258,854 Endoscopy 11% 7.4% 20% $400,000 $ 55,556 $ 68,450 $ 215,712 Total 100% 100.0% 100% $6,725,000 $ 500,000 $ 1,850,000 $ 2,157,117
Total $ 2,157,117 $ 4,839,507 $ 1,145,776 $ 739,717 $ 8,882,117 Cost Decreased
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help