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 ___________.
-
Explain the importance of full disclosure in source of capital processes.
-
In your role as a consultant at a wealth management firm, you have been assigned a very powerful client who holds 1 million shares of Cisco Systems, Inc., purchased on January 4, 2007. In researching...
-
Re-estimate the profitability measures in Section 25.3 as the price of \(\mathrm{IC}_{50}\) assays varies. Use a spreadsheet to increase and decrease the price from \(\$ 0.05 / \mathrm{IC}_{50}\)...
-
In December 2010, Kent Computers management establishes the year 2011 predetermined overhead rate based on direct labor cost. The information used in setting this rate includes estimates that the...
-
At least two economic trends which are impacting the H&M ' s operations ( e . g . , could be trends in demand and supply of their products / services , unemployment rate, consumer confidence in the...
-
Pam Corporation purchased 75 percent of the outstanding voting stock of Sun Corporation for $4,800,000 on January 1, 2016. Sun's stockholders' equity on this date consisted of the following (in...
-
Provide a detailed and in - depth analysis of specific marketing activities in relation to the full marketing strategies and tactical elements ( airline industry offering services, you need to apply...
-
European policymakers object to the fact that some Asian shoe production is government-subsidized. But as an editorial in the Financial Times noted "If Beijing and Hanoi want to subsidize European...
-
Question 5 Not complete Shea Company reported raw material purchases of $1,400, paid $1,200 in factory labor, and incurred and applied $900 in factory overhead for March. The March 1 inventory...
-
Fraudulent misrepresentation is a business tort review this hypothetical to determine whether there was a fraudulent misrepresentation: You own the e-business "Best Products Ever;" you go around the...
-
Draw a diagram to describe and explain how you will apply value chain theory in resuscitating the township economy.
-
Organization is Qualfon Guyana Inc, Issue being addressed is Staff Retention. What organizational actions have been taken to address the issue? What recommendations do you have to addressing this...
-
Requirement 1. What is the opportunity cost of interest forgone from purchasing all 240,000 units at the start of the year instead of in 12 monthly purchases of 20,000 units per order? Let's begin...
-
Assume today is the 21st of February. Using the information below, FT Extract, answer the following questions (parts i and ii). You work for a US company that is due to receive 250 million in June...
-
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?
-
Explain, in a way that is understandable to a non-accountant, the following terms: a. asset b. liability c. income d. revenue e. expense f. equity.
-
Why is it necessary to define an expense in terms of changes in an asset (or vice versa) rather than defining the terms independently?
-
The historical cost convention looks backwards but the going concern convention looks forwards. a. Does traditional financial accounting, using the historical cost convention, make the going concern...
Study smarter with the SolutionInn App