Control+Shift+Enter
Array functions in excel are powerful tools sometimes refereed to as "CSE" functions because you have to press Control+Shift+Enter in order to enter them in your worksheet.
Answer: The statement "D) context, composition, and process factors" represents the three general categories into which the key components of effective teams are grouped.
Explanation: Context: obtaining adequate resources, effective leadership, a climate in which confidence abounds and performance control and rewards that demonstrate the contributions of the team are the factors of the context that are related to the operation of the team.
Composition: These are the variables that are taken into account when establishing the way in which the equipment should be integrated. The capacity and personality of the members, the size of the group, the roles and the flexibility of the working group are taken into account.
The factors of the process are the effectiveness of the team, conflicts at a manageable level, the commitment of each participant in the group for a common purpose and set goals for the team.
Answer:
The incremental manufacturing cost that the company will incur if it increases production from 10,500 to 10,501 units is closest to $11.40
Explanation:
It is important to note that the question requires The incremental manufacturing cost that the company will incur if it increases production from 10,500 to 10,501 units
From Production of 10500 units to 10501 units, there is an increment of 1 unit.
<u>Lets find the incremental cost of 1 unit.</u>
1.To do this we only consider variable manufacturing costs only.
2.Since increase is within the relevant range, the fixed manufacturing overheads do not change.
3.Also Ignore all non- manufacturing overhead as they do not form part of manufacturing costs.
Extra 1 Unit
Direct materials $6.70
Direct labor $3.50
Variable manufacturing overhead $1.20
Total Cost $11.40
Answer:
(A) Half-year and (D) Half-year
Explanation:
MACRS stands for Modified Accelerated Cost Recovery System and is the most commonly-used tax depreciation method .Without getting into too much detail, MACRS is accelerated depreciation that allows for a larger deduction while the asset is still new. By comparison, straight-line depreciation gives you the same deduction year after year over the asset's useful life. MACRS cannot be used for intangible property, nor can it be used to depreciate. MACRS convention determines the number of months for which you can claim depreciation during a partial year, either when you first placed the asset in service or when you disposed of it. The mid-month convention only applies to residential rental property, nonresidential real property, and railroad grading or tunnel bore. It simply means that you get a half month's worth of depreciation no matter when that asset was placed into (or taken from) service during that month, whether that was at the beginning, middle, or end of the month. The half-year convention works the same way but instead of the month it goes by the year. In other words, you'll get 6 months' depreciation if the asset was placed into service or disposed of during the year, no matter if it was in January or December.
Answer:
P0 = $77.397794 rounded off to $77.40
Explanation:
The two stage growth model of DDM will be used to calculate the price of the stock today. The DDM values a stock based on the present value of the expected future dividends from the stock. The formula for price today under this model is,
P0 = D0 * (1+g1) / (1+r) + D0 * (1+g1)^2 / (1+r)^2 + ... + D0 * (1+g1)^n / (1+r)^n + [(D0 * (1+g1)^n * (1+g2) / (r - g2)) / (1+r)^n]
Where,
- g1 is the initial growth rate
- g2 is the constant growth rate
- D0 is the dividend paid today or most recently
- r is the required rate of return
P0 = 1.89 * (1+0.23) / (1+0.15) + 1.89 * (1+0.23)^2 / (1+0.15)^2 +
1.89 * (1+0.23)^3 / (1+0.15)^3 +
1.89 * (1+0.23)^4 / (1+0.15)^4 +
1.89 * (1+0.23)^5 / (1+0.15)^5 + 1.89 * (1+0.23)^6 / (1+0.15)^6 +
1.89 * (1+0.23)^7 / (1+0.15)^7 + 1.89 * (1+0.23)^8 / (1+0.15)^8 +
1.89 * (1+0.23)^9 / (1+0.15)^9 + 1.89 * (1+0.23)^10 / (1+0.15)^10 +
[(1.89 * (1+0.23)^10 * (1+0.07) / (0.15- 0.07)) / (1+0.15)^10]
P0 = $77.397794 rounded off to $77.40
