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 ___________.
-
The balance in Happ, Inc.'s general ledger Cash account was $12,430 at September 30, before reconciliation. The September 30 balance shown in the bank statement was $11,130. Reconciling items...
-
Steel is coated with a thin layer of ceramic to help protect against corrosion. What do you expect to happen to the coating when the temperature of the steel is increased significantly? Explain.
-
( ____________ ) is the first step in the systems approach. (a) systems design (b) stating objectives (c) systems analysis (d) systems evaluation
-
Mordica Company identifies three activities in its manufacturing process: machine setups, machining, and inspections. Estimated annual overhead cost for each activity is $150,000, $325,000, and...
-
united blood seecices is a blood bank that serves more than 5 0 0 hospitals in 1 8
-
You are to develop a simple Binary Search Tree ADT and run it against a test program. Avoid the temptation of finding code online. I am aware of all the available solutions and will be looking...
-
Con base en el material consultado, elabora una infografa acerca de los conceptos de instruccin de trabajo, hojas de proceso y ayudas visuales, incluye los pasos que se requieren para la elaboracin...
-
A trout jumps, producing waves on the surface of a 0.8 -m-deep mountain stream. If it is observed that the waves do not travel upstream, what is the minimum velocity of the current?
-
What is the minimum water depth necessary for a 40 -ftwide stream to handle \(4000 \mathrm{ft}^{3} / \mathrm{s}\) if the flow is not supercritical?
-
An airplane is flying at a flight (or local) Mach number of 0.70 at \(10,000 \mathrm{~m}\) in the Standard Atmosphere. Find the ground speed (a) if the air is not moving relative to the ground (b) if...
-
A convergent-divergent nozzle has an exit throat area ratio of 3.0. It is to be supplied with air. Find: (a) The first, second, and third critical pressure ratios; (b) The exit plane Mach number in...
-
A light aircraft with a wing area of \(200 \mathrm{ft}^{2}\) and a weight of \(2000 \mathrm{lb}\) has a lift coefficient of 0.40 and a drag coefficient of 0.05. Determine the power required to...
-
3.1 Determine the reliability of the system below, given the following individual reliabilities. Forty hydro generators were subjected to 10 000 hours of accelerated testing. Out of the forty...
-
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?
-
A process costing system would most likely be used for all of the following except a. a manufacturer of plywood sheets. c. a tailor. b. a mens barbershop. d. a hay farmer.
-
A company with four production departments that had been using a plant-wide overhead rate based on direct labor hours changes to a departmental overhead rate. Product A's total allocated overhead...
-
Henry Manufacturing, which uses direct labor hours to apply overhead to its product line, undertook an extensive renovation and modernization program two years ago. Manufacturing processes were...
Study smarter with the SolutionInn App