Project Budget Minimum new Beds Required 9 Minimum new Private Rooms Required 10 Construction Cost per...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Project Budget Minimum new Beds Required 9 Minimum new Private Rooms Required 10 Construction Cost per Private Room 11 Construction Cost per Double Room 12 Equipment requirements considerations: 13 Overbed table 14 Bedside rails 15 Patient lift 16 Patient monitor 17 Vital sign monitor 18 Television 7 D 1 Hospital Expansion Project 2 A hospital is planning an expansion of its facilities, and has set some goals and gathered some information. 3 The following criteria must be considered in arriving at more detailed project equipment acquisition: 4 The hope is to add at least 50 new beds, AND add at least new 5 private rooms. 5 The quantities of equipment required per room or, per bed, is also provided below. 6 Basic Assumptions: 8 per bed or room per bed minimum, for every 2 beds per room minimum, for every 2 beds minimum, for every 5 beds per bed minimum, for every 5 beds per room S 19 Blood pressure device 20 Therapeutic ultrasound 21 Required: 22 A project budgeting model has been created that calculates the total estimated project cost given any hosptial expansion H Basic data, as well as constraints.... required per bed....or per room.... A D G 23 number of private and double rooms to be added, along with the quantities purchased of room equipment. 24 Set Solver up to help you determine how to minimize the project total costs in light of all of the constraints 25 and objectives, using the project budgeting model below. Keep the Solver Answer Report. 26 Hospital Expansion Project 27 Project Cost Summary: 28 Total Private Room Construction Cost 29 Total Double Room Construction Cost 30 Total Equipment 31 Total Cost 32 Equipment Order list, based on Number of Private and Double rooms to be added: Units to Product Category Order 33 34 Bed 35 Overbed table 36 Bedside rails 37 Patient lift 38 Patient monitor 39 Vital sign monitor 40 Television 41 Blood pressure device 42 Therapeutic ultrasound 43 Total Equipment cost Ready hosptial expansion No. Private Rooms No. Double Rooms Total Added 1 S 1 S 1 S 1 S 1 S 1 S 1 S 1 S 15 $ Total 605.00 99.00 90.00 620.00 3,500.00 260.40 500.00 1,700.00 1,300.00 8,674.40 H K L M Cells highlighted in yellow are the "changing cells". To become familiar with how the numbers/caclulations/model "works", try entering different quantities in some of these cells and notice that various result cells' amounts will change. N As quantities of rooms added and items ordered increase, the costs in the "cost summary" area increase. The grand total project cost amount is found in cell B41. Project Budget Minimum new Beds Required 9 Minimum new Private Rooms Required 10 Construction Cost per Private Room 11 Construction Cost per Double Room 12 Equipment requirements considerations: 13 Overbed table 14 Bedside rails 15 Patient lift 16 Patient monitor 17 Vital sign monitor 18 Television 7 D 1 Hospital Expansion Project 2 A hospital is planning an expansion of its facilities, and has set some goals and gathered some information. 3 The following criteria must be considered in arriving at more detailed project equipment acquisition: 4 The hope is to add at least 50 new beds, AND add at least new 5 private rooms. 5 The quantities of equipment required per room or, per bed, is also provided below. 6 Basic Assumptions: 8 per bed or room per bed minimum, for every 2 beds per room minimum, for every 2 beds minimum, for every 5 beds per bed minimum, for every 5 beds per room S 19 Blood pressure device 20 Therapeutic ultrasound 21 Required: 22 A project budgeting model has been created that calculates the total estimated project cost given any hosptial expansion H Basic data, as well as constraints.... required per bed....or per room.... A D G 23 number of private and double rooms to be added, along with the quantities purchased of room equipment. 24 Set Solver up to help you determine how to minimize the project total costs in light of all of the constraints 25 and objectives, using the project budgeting model below. Keep the Solver Answer Report. 26 Hospital Expansion Project 27 Project Cost Summary: 28 Total Private Room Construction Cost 29 Total Double Room Construction Cost 30 Total Equipment 31 Total Cost 32 Equipment Order list, based on Number of Private and Double rooms to be added: Units to Product Category Order 33 34 Bed 35 Overbed table 36 Bedside rails 37 Patient lift 38 Patient monitor 39 Vital sign monitor 40 Television 41 Blood pressure device 42 Therapeutic ultrasound 43 Total Equipment cost Ready hosptial expansion No. Private Rooms No. Double Rooms Total Added 1 S 1 S 1 S 1 S 1 S 1 S 1 S 1 S 15 $ Total 605.00 99.00 90.00 620.00 3,500.00 260.40 500.00 1,700.00 1,300.00 8,674.40 H K L M Cells highlighted in yellow are the "changing cells". To become familiar with how the numbers/caclulations/model "works", try entering different quantities in some of these cells and notice that various result cells' amounts will change. N As quantities of rooms added and items ordered increase, the costs in the "cost summary" area increase. The grand total project cost amount is found in cell B41.
Expert Answer:
Related Book For
Core Concepts Of Accounting Information Systems
ISBN: 9780470507025
11th Edition
Authors: Nancy A. Bagranoff, Mark G. Simkin, Carolyn Strand Norman
Posted Date:
Students also viewed these accounting questions
-
The adequacy of a product must be considered in relation to the general environment within which it will be operated rather than solely on the basis of technical efficiency. Discuss the implications...
-
A company is planning an investment of 5,000,000 today. The investment is depreciated on a straight-line basis over the life of 5 years and the residual value at the end of the project is assumed to...
-
A hospital is planning an $8 million addition to its existing facility. The architect has been asked to consider the following design parameters: (1) There should be at least 10 and no more than 20...
-
To eliminate service inconsistencies, companies rely on ___________ and ___________.
-
A sport for Kids (SFK) is a not-for-profit organization that provides sporting equipment for inner-city children who cannot otherwise afford it. SFK has been in operation since 20X1 and operated on a...
-
Transform the following ERD into a set of relations in 3NF; list all foreign key constraints 1. Transform the following ERD into a set of relations in 3NF: list all foreign key constraints. (40...
-
A circular loop of radius \(100 \mathrm{~mm}\) is placed in a magnetic field of magnitude \(0.030 \mathrm{~T}\). If the magnetic flux through the loop is \(3.00 \times 10^{-4} \mathrm{~T} \cdot...
-
Tommy John is going to receive $1,000,000 in three years. The current market rate of interest is 10%. a. Using the present value of $1 table in Exhibit 4, determine the present value of this amount...
-
1. The above image shows a thin lens of focal length 5m. (i) What is the kind of lens shown in the above figure? (ii) If a real inverted image is to be formed by this lens at a distance of 7m from...
-
How could B/C analysis be used to help determine the level of subsidy to be paid to the operator of public transportation services in a congested urban area?
-
Par inventory systems do not work well for perishable foods Thus, items such as fresh pastries and dairy products are typically purchased in quantities that relate more to forecasted occupancy levels...
-
TAP purchased land on January 1 , 2 0 1 3 for $ 2 5 0 million. As of January 1 , 2 0 1 8 , the fair value was estimated to be $ 2 9 0 million. TAP purchased a trademark on January 1 , 2 0 1 6 for $ 1...
-
Use an Internet search on the acquirer involved in your merger to answer the following: What information is available about merger activity for the acquirer last 5 years not including the merger you...
-
Solve for x. log2()+log2(x-4)=5 x = (Separate answers by a comma.) If the answer is radical use sqrt(5) to denote 5 (use the correct radicand in the problem!) If the answer is a fraction then write...
-
What is Chem - Med s average accounts receivable collection period for 2 0 1 5 , 2 0 1 6 , 2 0 1 7 , 2 0 1 8 ? Is the period getting longer or shorter? What are the consequences?
-
A start-up software company hires Kiera as its first human resource manager. Whenever a new position needs to be filled, Kiera sits down with the supervisor to gather facts that will be included in a...
-
Burleigh Brews Pty Ltd disposed of a delivery vehicle on 31 October 2022 receiving cash proceeds from the sale of $5,500 (GST Inclusive). The delivery vehicle had been purchased on 1 January 2018 for...
-
Which of the following statements is false? a. Capital leases are not commonly reported in a Capital Projects Fund. b. A governmental entity may report a Capital Project Fund in one year but not the...
-
Identify one or more control procedures (either general or application controls, or both) that would guard against each of the following errors or problems. a. A bank deposit transaction was...
-
Use the Customers table in the BSN database that accompanies this book and the Report Wizard to create the report in Figure. Note that you will have to reformat and perhaps reposition several labels,...
-
How would you define ethics? What types of ethical issues are involved in computerized accounting information systems? How can organizations encourage their employees to act ethically?
-
In a recent study of how mice negotiate turns, the mice ran around a circular 90 turn on a track with a radius of 0.15 m. The maximum speed measured for a mouse (mass = 18.5 g) running around this...
-
It is well known that runners run more slowly around a curved track than a straight one. One hypothesis to explain this is that the total force from the track on a runners feet the magnitude of the...
-
Biologists have studied the running ability of the northern quoll, a marsupial indigenous to Australia. In one set of experiments, they studied the maximum speed that quolls could run around a curved...
Study smarter with the SolutionInn App