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 following accounts, with the balances indicated, appear in the ledger of Bonnie's Gifts Co. on December 1 of the current year: The following transactions relating to payroll, payroll deductions,...
-
a. Under what conditions is the discharge of indebtedness not taxable? b. If a father forgives a daughters debt to him, is she required to include such amount in her gross income?
-
In 20x7, Michaud Company had current assets of $155,000 and current liabilities of $100,000, of which accounts payable were $65,000. Cost of goods sold was $425,000, merchandise inventory increased...
-
Central Pennsylvania Limestone Company produces thin limestone sheets used for cosmetic facing o n buildings. The following income statement represents the operating results for the year just ended....
-
Find a and b so that the function 823 - 6x3 +8, *
-
Use the following data to calculate the variances in the following questions. Standard Cost Profile Lab Treatment SU #12 Expected Treatments= 1,000 Standard Cost Profile Lab Treatment SU #12 Expected...
-
Under Investment and collaborative strategies, define or, just briefly describe, if no distinct definition (i) Foreign Direct Investment (FDI), (ii) Licensing (iii) Franchising (iv) Joint ventures...
-
1. What are the three perspectives on developing enterprise systems? 2. Kayak.com is an example of what type of B2C e-business model?
-
Everyone draws upon a variety of sources when formulating responses to ethical dilemmas, e.g.. religious beliefs, parents, life experiences, advice from friends, etc. In at least 100 words, share...
-
Amazon is creating a loyalty and rewards program, which vendor would be able to provide the best information system and why? how is this vendor different from its competitors? Choose between...
-
1. Explain the significance of creating a Resource Management plan in the project management. Provide examples of key component that should be included in this plan. 2. Describe the steps involved in...
-
Explain why each of these is critical for a successful supply chain operation: Integrated technology Information sharing Trust among trading partners Real-time information availability Event-response...
-
True or False? Global health programs are often developed as pragmatic approaches to real-world situations, and the emphasis on theory is not always as pronounced as it is for domestic health programs
-
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?
-
During its first year of operation, Krabna Company purchased 5,600 units of a product at $42 per unit. During the second year, it purchased 6,000 units of the same product at $48 per unit. During the...
-
In chronological order, the inventory, purchases, and sales of a single product for a recent month are as follows: Using the periodic inventory system, compute the cost of ending inventory, cost of...
-
Referring to the data provided in E 9 and using the perpetual inventory system, compute the cost of ending inventory, cost of goods sold, and gross margin. Use the average-cost, FIFO, and LIFO...
Study smarter with the SolutionInn App