2. The Cahora Bassa dam, located in Mozambique, is the highest dam in Africa. The hydroelectric facility within the dam generates an average 1,925 MWe. Nearly all of this electricity is exported to South Africa. The power station is linked to Pretoria, 1,420 km away, by a 533.0 kV high-voltage DC (HVDC) transmission line. a. The transmission line consists of eight cables made of aluminum with a steel core for strength and structural support. The total cross-sectional diameter of each cable is 28 mm, while the cross-sectional diameter of the steel core is 14 mm (consider the cross-sectional area as a steel circle in the middle of an an aluminum circle). Treat each cable as if it consisted of one steel and one aluminum resistor arranged in parallel, while the cables themselves are arranged in parallel with each other. What is the total resistance of the transmission line? Material resistivities:

ρ_steel=7.2〖*10〗^(-7) Ω•m

ρ_alum=2.7*10^(-8) Ω•m.

(15 points)

b. On average, how much current flows through the transmission lines? What is the power loss in the line? What is the percentage of power loss relative to the average power generated? (10 points)

c. If the power were transmitted at 333.0 kV over the same cables, what would the power loss percentage be? (10 points)

d. If the dam’s power is sold wholesale to South Africa for US$90.00/MWh, how much revenue would be lost per year, transmitting at 333.0 kV instead of 533.0 kV? (note: the 1,920 MW average production already accounts for the dam’s capacity factor) (5 points)

e. Say you are interested in doing a life cycle assessment to estimate the amount of energy used to build the Cahora Bassa power system, from dam to end user (not the amount energy produced by the system itself). Consider the major parts of the Cahora Bassa power system, from the dam, to the power lines, to the electrical equipment, and everything that was required to manufacture and build them. List ten energy-consuming materials or processes that would be used as inputs in a life-cycle assessment of the construction of this system. (10 points)

In the table below, there are test scores from a dozen students. The test was worth 200 points. The scores in the table are the # of points out of 200. Letter grades will be assigned using the standard grade boundaries given below.

You will need to create a new Excel file for this assignment.

1. Create a worksheet with the columns of student names and scores as shown above.
2. Add a column to the right of Test Score labeled “Percentage”
3. Add a column to the right of Percentage labeled “Letter grade”
4. Using absolute addressing, calculate the corresponding percentage score for each student. You must utilize absolute addressing in this formula. (hint – put the total possible score in one separate cell someplace in your worksheet and use it for the first student, then copy and paste).
5. Use the AVERAGE function to calculate the average percentage and display with a label of “Average Percentage”.
6. Use the MAX function to calculate the highest percentage score and display with a label of “Maximum Percentage.”
7. Using VLOOKUP, determine and display the letter grade for each student.

In the table below, there are test scores from a dozen students. The test was worth 200 points. The scores in the table are the # of points out of 200. Letter grades will be assigned using the standard grade boundaries given below.

You will need to create a new Excel file for this assignment.

1. Create a worksheet with the columns of student names and scores as shown above.
2. Add a column to the right of Test Score labeled “Percentage”
3. Add a column to the right of Percentage labeled “Letter grade”
4. Using absolute addressing, calculate the corresponding percentage score for each student. You must utilize absolute addressing in this formula. (hint – put the total possible score in one separate cell someplace in your worksheet and use it for the first student, then copy and paste).
5. Use the AVERAGE function to calculate the average percentage and display with a label of “Average Percentage”.
6. Use the MAX function to calculate the highest percentage score and display with a label of “Maximum Percentage.”
7. Using VLOOKUP, determine and display the letter grade for each student.
8. PLEASE SHOW FORMULAS FOR EACH ENTRY

Azure has a job order and the following data have been recorded on its job cost sheet: Direct material $50,000 Direct labour hours 1,000 Direct labour wage rate $25 Machine hours 750 hours Number of units completed 800 The company applies manufacturing overhead on the basis of machine hours and the predetermined overhead rate is $20 per machine hour. Management is now considering whether this job order is profitable or not and how does this job order fare compared to the industry benchmark. Required a) Compute the unit product cost that would appear on the job cost sheet for this job. b) Using a mark-up percentage of 20% of the full product cost, how much profit/loss would this job make? c) Considering the industry benchmark for manufacturing overhead for similar jobs is 50% of direct labour, identify whether this job has a manufacturing overhead lower or higher than a similar job using the industry benchmark. Briefly explain what could cause a difference. ?

NPVs and IRRs for Mutually Exclusive Projects

Davis Industries must choose between a gas-powered and an electric-powered forklift truck for moving materials in its factory. Because both forklifts perform the same function, the firm will choose only one. (They are mutually exclusive investments.) The electric-powered truck will cost more, but it will be less expensive to operate; it will cost $22,000, whereas the gas-powered truck will cost $17,500. The cost of capital that applies to both investments is 12%. The life for both types of truck is estimated to be 6 years, during which time the net cash flows for the electric-powered truck will be $6,290 per year, and those for the gas-powered truck will be $5,000 per year. Annual net cash flows include depreciation expenses. Calculate the NPV and IRR for each type of truck, and decide which to recommend. Do not round intermediate calculations. Round the monetary values to the nearest dollar and percentage values to two decimal places.

​After-tax cost of debt- Personal Finance Problem  

Bella Wans is interested in buying a new motorcycle. She has decided to borrow the money to pay the $20,000 purchase price of the bike. She is in the 33% income tax bracket. She can either borrow the money at an interest rate of 4​% from the motorcycle​ dealer, or she could take out a second mortgage on her home. That mortgage would come with an interest rate of 8​%. Interest payments on the mortgage would be tax deductible for​ Bella, but interest payments on the loan from the motorcycle dealer could not be deducted on​ Bella's federal tax return.

a.  Calculate the ​after-tax cost of borrowing from the motorcycle dealership.

b. Calculate the ​after-tax cost of borrowing through a second mortgage on​ Bella's home.

c.  Which source of borrowing is less costly for​ Bella?

d.  Should Bella consider any other factors when deciding which loan to take​ out?

a. The​ after-tax cost of borrowing from the motorcycle dealership is _____%. ​(Round to the nearest whole​ percentage.)

1. A shortcoming of return on investment (ROI) is that it may not lead managers to accept good investment opportunities if

   2.   Which of the following statements is true concerning economic value added (EVA)?

   3.   Which of the following defines Economic value added (EVA)?

NPVs and IRRs for Mutually Exclusive Projects

Davis Industries must choose between a gas-powered and an electric-powered forklift truck for moving materials in its factory. Because both forklifts perform the same function, the firm will choose only one. (They are mutually exclusive investments.) The electric-powered truck will cost more, but it will be less expensive to operate; it will cost $23,000, whereas the gas-powered truck will cost $17,100. The cost of capital that applies to both investments is 11%. The life for both types of truck is estimated to be 6 years, during which time the net cash flows for the electric-powered truck will be $6,500 per year, and those for the gas-powered truck will be $4,750 per year. Annual net cash flows include depreciation expenses. Calculate the NPV and IRR for each type of truck, and decide which to recommend. Do not round intermediate calculations. Round the monetary values to the nearest dollar and percentage values to two decimal places.

Examine your last pay check. Determine the percentage of your gross pay that is taken for deductions (including taxes, social security, health care, retirement, etc.). Total these deductions and then divide by your gross pay to determine the percentage. You do not have to disclose the amount of your gross pay or your deductions, but you may share the percentage of your pay that went for these deductions. Does this surprise you? Are there things you could change about this?