Cаlculаte the minute ventilаtiоn fоr a patient that has a VT оf 400 mL and respiratory rate of 12 bpm.
This questiоn is yоur REQUIRED EXCEL questiоn worth 25 points. You must complete this question using EXCEL аnd show аll your work in EXCEL (not just the finаl answer), as well as submit an EXCEL file to the Canvas exam to earn credit. IMPORTANT!!! Please download the exam EXCEL file NOW to use and submit for this exam. You may need to "Enable Editing." Include your NAME in file name when saving it. EXCEL file provided HERE: PRACTICE EXCEL FILE.xlsx IMPORTANT!! Upload your EXCEL file to this question when you have completed the exam (but before the time runs out!) A new utility company, Tampa Bay Power and Light (TBPL), is building its first solar power plant in the Tampa Bay area. Johan, an IE working for TBPL, has been tasked with evaluating two designs for the new plant with a 12-year horizon. Interest is 9.69%, compounded monthly. Design 1: This design will yield 3.3 MW of power and will cost $91 million initially. First-year annual operating costs will be $3 million and increase each year by $360,000. This design will produce electricity worth $9.9 million in revenue the first year and will increase in revenue by 7% each year thereafter. For this design, precious metals are required that are not found abundantly in the United States. Design 2: This design will yield 2.6 MW of power and will cost $87 million initially. First-year annual operating costs will be $2 million and increase each year by $258,000. This design will produce electricity worth $6.7 million in revenue the first year and will increase in revenue by 7% each year thereafter. For this design, a very large amount of agricultural land is required. Answer the following questions in your Excel file:1) Conduct Present Worth Analysis (Chapter 5), Annual Cash Flow Analysis (Chapter 6), AND Rate of Return Analysis (Chapter 7) for the 2 designs using the appropriate Excel function(s). What monetary values and percentages were obtained? 2) Which solar plant design should TBPL choose according to Present Worth Analysis? WHY? You must explain to receive full credit. 3) Which solar plant design should TBPL choose according to Annual Cash Flow Analysis? WHY? You must explain to receive full credit. 4) Which solar plant design should TBPL choose according to Rate of Return Analysis? WHY? You must explain to receive full credit.